Audit Trail Report

This report prints an audit trail for the customer, which assists with month-end reconciliations when you reconcile 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, if the Foreign Currency module is in use.

Currency summaries display separately at the end of the report.

Parameters

You can set these parameters for the report:

Branch Code From

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

Branch Code To

Enter the code for the last branch in the range of branches to include in the report. To report on a single branch, leave this field empty.

Leaving the Branch Code From field empty and entering zzzzzz in this field includes all branches in the report.

Date From

Select the first date in the range that the report covers. 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 covers. 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 to include in the report.

Calendar To

Enter the name of the last working calendar in the range of calendars to include in the report. To report on a single working calendar, enter a name in the Calendar From field and leave this field empty.

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