How to create the Audit Trail report
Description

The audit trail shows when and who entered transactions. View details like transaction date, type, category, and value to trace transactions during an audit. The summary shows income details and net, tax, and total values. The detailed breakdown shows 'double-entry' values on categories like income, bank account, and tax on sales as debits or credits.

Cause
Resolution

Run the Audit trail report

  1. Go to ReportsAll reports.
  2. Choose Audit Trail.
  3. Select the time period you want using the drop-down list.
  4. If you select Customer, use the From and To boxes to enter the required date range.
  5. Select Calculate.

    TIP:

    Select Calculate every time you change any filter.

  6. Choose the Summary or Detailed view.

     

Summary  Shows the transaction total.
Detailed  Shows the ledger accounts, the Debits and Credits.

Filter the list by transaction type

To show specific transaction types:

  1. Select More.
  2. From the Transaction Type drop list, choose the relevant type.
  3. Select Calculate.

Filter the list to exclude deleted transactions

Deleted transactions are automatically included and show with a line through them. To exclude these or view deleted transactions only:

  1. Select More.
  2. From the Status drop list, choose to exclude deleted transactions or deleted only.
  3. Select Calculate.

To configure columns

  1. Select the Configure Columns button.
  2. Select the columns you want to display. You can also drag columns up and down to reorder them in the table.
  3. Configure the audit trail to include the following extra columns:
    Deleted
    Tax Reconciled
    Bank Reconciled

    Created by

  4. Select Save.

Export the report

  1. Run the audit trail report to show the transactions you want. 
  2. Select Export.
  3. Choose CSV or PDF.
  4. When ready, the report will show in notifications on the top bar.
Steps to duplicate
Related Solutions