Cash Flow Forecast

This report shows the details of a 30-day cash flow forecast. You do not navigate to a report form and run this report; the report is opened from the Cash Flow Forecast (CA401000) form and is generated based on the settings selected on the inquiry form. To open the Cash Flow Forecast report, you click View as a Report on the form toolbar of the Cash Flow Forecast form.

The forecast shows the following information for each day of a 30-day period for each of the accounts:

• The projected balance of the cash account in the Cash Summary section
• The total amount of customer payments to be received this day in the Cash Receipts section
• The total amount of outgoing payments to be sent this day in the Cash Paid Out section

In the current report and on the Cash Flow Forecast form, the amount of a credit memo with credit terms is shown in the column whose date is the same as the due date of the credit memo. (A credit memo without credit terms has a due date that is the same as the document date.) If the due date is earlier than the Start Date specified in the Selection area of the Cash Flow Forecast form (from which this report is generated), the credit memo’s amount is included in the column whose date is the same as the Start Date.

The Cash Summary section provides the following information:

• Cash On Hand: The cash position at the beginning of the day; namely, a forecast balance carried forward from the previous day
• Cash Available: The sum of the projected receipts and the cash position at the beginning of the day (Cash On Hand + total of Cash Receipts)
• Cash Position: The cash position at the end of the day; namely, the difference between the available cash and the total amount of the projected outgoing payments (Cash Available – total of Cash Paid Out)