Audit Trail Report

This report prints a bank account audit trail. This will provide you will transaction detail that will assist with the reconciliation process when you are reconciling the bank account balance to the general ledger.

Header Details

Report process date and time
Page number
Date range

Line Details

This information displays for each bank:

Transaction reference
Transaction date
Batch number
Transaction type
Narration
Transaction value, inclusive of tax

If you only want to display transactions of a particular type, specify this in the parameters before running the report.

The report displays a sub-total by bank if more than one is selected in the parameters. The report also displays sub-totals by batch and transaction type. A summary prints for each bank selected in the parameters, in this format:

Opening Balance (relating to the Date From selected in the Parameters)

Plus Current Transactions:

Deposits/Receipts
Less: Cheques/Payments
Plus: Cancelled Cheques

+/- GL Journals

Sub-total
Closing Cash Management Ledger Balance
A total of held cheques is also displayed.

Parameters

These parameters are available when you run the report:

Date From

Select the first date in the range that the report will cover. The date defaults to the date of the earliest transaction in the system.

Date To

Select the last date in the range that the report will cover. The date defaults to the current date.

Bank From

Enter the name or code of the first bank in the range of banks on which to run the report.

Bank To

Enter the name or code of the last bank in the range of banks on which to run the report.

Leave the Bank From field empty and enter zzzz in this field to include all banks in the report.

Print Deposits/Receipts?

Select this option to include detail about deposits and receipts in the report.

Print Cheques/Payments?

Select this option to include details about cheques and payments in the report.

Print Held Cheques?

Select this option to include details about held cheques in the report.

Print Cancelled?

Select this option to include details about cancelled cheques in reports.

Print Journals

Select this option to include general ledger journals in the report.