To open the Loan Cash Flow Report, from the Report menu, click Report Explorer and select the Loan Reports group.

Report

Description	The Loan Cash Flow Report displays the forecasted Account Cash movements for a specified date range in the future.
Purpose	By grouping and summarising Accounts into Account Types or Dealers, the report can be used to analyse cash flow movements and provide key management reports.

Select the Order By and Accounts to show

Order By

Select the order in which the report is to appear, by Code, Name, Overdue, Overdue Days, Balance, Next Payment Date, Last Payment Date or Maturity Date.

Descending

Tick to display in a descending order or leave blank to display in an ascending order.

Accounts

Select the Accounts to be included or leave blank to include all.

Alternatively use F6 to look up Accounts.

Date As At

Enter the date the report will be calculated "to". The 'As At' Date is used when calculating values such as Monitor Categories, Balance and Overdues.

Frequency

Select Frequency for the report, by Daily, Weekly, Fortnightly, 4 Weekly, 30 Days, Monthly, EOM (End of Month), 2 Months, Quarterly, 6 Months or Yearly. The frequency is not limited to the list shown, it can be any valid date cycle, e.g. M20 for 20th of the month.
Alternatively click here for more examples of Date Expressions.

Columns

Select the number of "Columns" for the report, e.g. 1 to 99. Any number of columns selected over 12 will not display well on a Preview and is instead designed for the report to be exported.