Forecasting

Cashbook Forecasting is a solution developed specifically for companies using ERP Financial solutions.

Cashbook Forecasting reviews all open invoices on your ERP’s Accounts Receivable and Accounts Payable systems. We use purchase order information and enable one-time payments and receipts to be manually entered that occur externally to the ERP system. We upload payroll information and capital expenditure data to completely summarize all cash in and cash out transactions.

AR Receivables and AP Payables will provide a primary indication of projected cash flow, and this information is retrieved from the Invoice Files on the ERP system. However, relying on the data simply per the ERP system will not give an accurate reflection of expected inflow and outflow of cash. Other factors influence this data, affecting the actual timing of settlement as well as the actual amounts received or paid.

For example, a company might generate an Electronic Payment file on the 13th and 27th of every month in settlement of payables up to the 16th and 31st of every month, respectively. A Cash Flow Report based on the AP Invoices file would indicate the payables daily based on the AP Invoice Due Dates, rather than on the 16th and 31st (allowing for clearing days) of every month. The same scenario could apply to Receivables collected electronically. Our solution allows for manipulation of data based upon known clearing rules of electronic payments and checks and previous customer behaviour.

Features

Within SAI’s Cash Forecasting we enable the following:

Benefits

The primary objective of Cash Flow Forecasting is to indicate expected Cash Receipts and Cash Payments over a defined period of time so that Cash may be efficiently managed and optimum benefits obtained from Cash Funds available at any particular time.

Benefits of using this module include:

• More accurate forecasting data
• Includes all the information you need and reduces time required to modify parameters in manual solutions
• Avoids timely updating of Excel spreadsheets
• Provides comparison with historical as a reality check on current forecast
• Better decision making across the Finance department as a result
• Timely information reduces risk of excess or insufficient funds

Consolidated, supported tool avoids reliance on individuals in the organization who are the only ones “who know all the rules”