Audit Trail Report

This report prints an audit trail for the customer. This provides you with transaction detail that will assist with month-end reconciliations when you are reconciling the aged balances to the general ledger.

Header Details

Report process date and time
Page number
Date range selected

Line Details

This information displays, grouped by transaction type Invoices, Credit Notes, Receipts, Journals, Refunds):

Transaction Reference
Batch
Branch
Customer name
Transaction value, inclusive of tax
Tax value
Tax rate
Tax period end date
Currency code (if in use)
Foreign currency value (if in use)
Foreign currency rate (if in use)
Original value (if FC is in use)
Variance (if FC is in use)

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

The report displays sub-totals by Individual Customer, Transaction Type, and All Customers. A grand total displays, along with summary totals by Currency, where the Foreign Currency module is in use.

Currency summaries display separately at the end of the report.

Parameters

These parameters are available when you run the report:

Branch Code From

Enter the code for the first branch in the range of branches that you want to include in the report.

Branch Code To

Enter the code for the last branch in the range of branches you want to include in the report. If you want to report on a single branch, leave this field blank.

Leaving the Branch Code From field empty and entering zzzzzz in this field will include all branches in 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.

Print Credit Notes

Select this option to include credit notes in the report.

Print Invoices

Select this option to include a list of invoices and their values in the report.

Print Receipts

Select this option to include details of receipts in the report.

Print Journals

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

Print Refunds

Select this option to include details about any refunds in the report.

Print Summary

Select this option to include a summary of transactions, broken down by currency, in the report.

Calendar From

Enter the name of the first working calendar in the range of calendars that you want to include in the report.

Calendar To

Enter the name of the last working calendar in the range of calendars that you want include in the report. If you want to report on a single working calendar, enter a name in the Calendar From field and leave this field blank.

Leaving the Calendar From field empty and entering zzzzzzzzzzzzzzzzzzzzzz in this field will include all working calendars in the report.