The worksheet is not representative of a file but rather it reads the live database and is continually updated by any activity that takes place within the system or the network. All users on a LAN or WAN can access the same records without conflict and without the need to re-key or copying data. The worksheet can be organized in Actual and Estimated columns, plus a Variance column.
Users have great flexibility in designing their own worksheets.
Each account can belong to multiple worksheets, and can be part of groups and parent-child relationships as needed. Arbitrary codes can be assigned to further summarize transactions to meet internal cash management or accounting needs. The worksheet can portray historical as well as forecast information for unlimited, user-defined periods. Calculations can be performed to estimate future transactions, such as Anticipatory Deposits for weekend receipts. The system looks at historical data to determine the amount of forecasted deposits and then recommends an amount to be transferred which is then initiated upon approval.