Cash Movement Report

Cash Movement report

Navigation path: Reporting > Transactions > Bank > Cash Movement.

Report synopsis: This is a transactions based report that can be used to endorse the figures shown on any of the individual financial summaries, provided they are set to the report figures inclusive of VAT. The following transactions are captured on this report (the transaction types being shown in brackets):

• Income (INC)
• Income Correction (I/C)
• Expenditure (ESP)
• Expenditure Correction/Credit Notes (ESC)
• Journal Transfers (JNL)

Searching & sorting options: Several selection fields are available to the end user when generating this report:

• Income sources/suppliers range filter.
• Transaction period range filter, i.e. the period number associated with each transaction.
• Transaction date range filter, i.e. the date recorded against the transaction (not the system date on which the transaction was posted).
• The financial fund - The list will be governed by the number of bank accounts in operation.

Note: By using the tick boxes provided, it's possible to display, on the report, the selection criteria applied and include any additional free text notes that will be useful to the recipients (both are displayed in the report header).

By using the SORT button, you can also specify both a primary and secondary sort for the report, e.g. sort the report first by field A and then by field B. The list of available sort fields are as follows:

• Voucher (Audit no.)
• Fund (Bank account)
• Reference (Cheque no.)
• Transaction type
• Date
• Period
• Supplier/Income source
• Analysis
• Invoice no.

Note: By using the tick box provided, it is possible to insert a separate subtotal each time the sort changes.

For information: The totals displayed at the end of the report are the summation of all transaction values inclusive of VAT.