4 Primary Modules
3. Treasury Worksheets (Cash Position/History Recommended Transfers/Forecast/Estimate)
The GTreasury Treasury Worksheet is the focus of daily cash management activities. All daily functions can be accessed from the worksheet: Balance Reporting, Deposit Reporting, Account Reconcilement, Cash Position, Cash Forecasting, Target Balance, Fund Transfers (Wires, ACH, EDI, etc.), Borrowings and Investments, Account Analysis, Foreign Exchange Transactions, Trade Finance, Accounting, and many other functions.
The worksheet 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 copy data.
In addition to organizing and presenting information, the GTreasury Treasury Worksheet performs decision support functions and present recommended actions to the user. The fully integrated Target Balance Module produces recommended transfers to achieve specific Adjustments and Account Analysis results which are factored into the decision process.
The worksheet can portray historical data, 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. Specific features include:
- Unlimited Levels. Worksheets can be created to roll-up unlimited number of real or virtual accounts. Roll up of unlimited transaction types is also included. Operators can literally construct a simple summary worksheet for the entire company and then drill down to the lowest possible elements.
- All Elements can belong to Unlimited Worksheets. Real and Virtual Accounts or Entities can belong to any worksheet to provide different views. This is very important in complex corporate structures as well as in companies that support partnerships and outside partial ownerships.
- Actual, Estimate and Forecast. All elements can be viewed in three different databases. Forecast is typically longer term, Estimate is normally very short term and may combine elements of Forecast, Same-day Actual and current activities, such as Current Maturities and Funds Transfer initiated. Actual is reported by the banks. Variances are available on all combinations.
- Summaries by Week, Month, Quarter, Years. Summaries are created on-the-fly by manipulating easy-to-use checkboxes.
- Graphics. Worksheets incorporate useful graphs for any view selected showing all trends.
- Target Balance and Recommended Transfers. Transfers are generated automatically from the worksheets and are queued for approval and/or delivery to the banks. GTreasury can generate Wires, ACH, Book or any other transfer type based on the size and timelines of the request.
- Data Entry on Worksheets. Now available at three different levels: Top Level = Fast Entry, Middle Level = List Entry, Lowest Level = Full Screen Entry. Operators can literally stay in the worksheet to conduct all of their daily activities.
- Excel Worksheet Duplication. The GTreasury worksheets are the most likely to be able to duplicate the Excel worksheets clients may be familiar with and may wish to continue using. A workstation should not just be a means to feed Excel, but it should stand on its own.
- Print and Excel. In any case, Reports and Extracts to Excel are available at all worksheet levels.
