Historical Cash Flow Report

Use this report to view historical balances for each cash analysis code. If you have set up analysis code budgets using the Analysis Code Budget Maintenance form, you can also select an option to view the budget balances by code, so that you can compare actual and budget values, as well as variances, for historical periods.

Header Details

Report process date and time
Page number

Line Details

This information displays for the budget code and bank combination specified in the report parameters:

Budget code and bank code.
A list of all analysis codes, each one displaying this detail:
- Actual balance at six period end dates, commencing with the end of the period entered into the report parameters, and going back five periods.
- Budget balance at six period end dates, commencing with the end of the period entered into the report parameters, and going back five periods.
- Actual and budget total balance for all six periods.
- Variance total (the difference between the and budget total balance).

The analysis codes are grouped by Inwards (income codes) and Outwards (expense codes) Cash, and are summarised at a group level.

Parameters

You can set these parameters for the report:

Print Budgets?

Select this option to include budget codes and budget balances in the report. The budget codes appear in the header of the report, and the budget balances appear in the body along with the actuals for each line item.

Budget Code

Enter the budget code to include in the report.

Bank Account

Enter the number of the bank account to include in the report.

Round to Thousands of Dollars

Select this option to round figures in the report to the nearest thousand dollars.

Start Report Date

Enter the date on from which to generate the report. The report displays balances for six periods before the Start Report Date.