Reports, Deposit Reports, Deposit Cash Flow Report
|

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

Report

DescriptionThe Deposit Cash Flow Report displays the forecasted Deposit Cash movements for a specified date range in the future.
PurposeBy grouping and summarising Accounts into Account Types or Dealers, you can use the report to analyse when major cash flow movements will occur and provide key management reports.


Reports, Deposit Reports, Deposit Cash Flow Report

Select the Order By and Accounts to show

Order By

Select the order in which the report is to appear, by Code, Name, Date Opened, Date Quoted, Balance or Maturity Date.

Descending

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

Accounts

Select specific accounts to be included or leave blank for all deposit accounts.

Alternatively use F6 to look up the Deposit Accounts.

Date As At

Enter the date the report will be calculated "to"; used when calculating values such as Balance.

Frequency

Select the period type for the report: 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.

The frequency is not limited to the list shown, it can be any valid date cycle. 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.

Rounding

The level of rounding required either Normal, Whole, or Thousands.

Include an Interest Transfers Column?

Tick to include Interest Transfers Column

Include an 'On Call' Balance Column?

Tick to include On Call Balance Column

Include an Total Column?

Tick to include a Total column, calculating the actual total of all columns.

Basis

Select from Investor Payments or Withholding Tax. Selecting "Withholding Tax will limit other options available within the report.

TBA Option

Select from Payout or Reinvest.

Withdrawals (including Standard Transactions)?

Tick to include Withdrawals in the report.

Interest Payments?

Tick to include Interest Payments in the report.

Maturity Payments?

Tick to include Maturity Payments in the report.

Investments (including Standard Transactions)?

Tick to include Investments in the report.

See Topics, for more information about Account Filters, Ranges, Grouping, Printer, Data Export, Add to Queue and Settings.