How to create the Audit Trail report

Summary

How to view and configure the audit trail report in Sage Accounting.

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.

Resolution

Run the Audit trail report

  1. Go to Reports, All reports.
  2. Choose Audit Trail.
  3. Select the time period from the dropdown 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

The system automatically includes deleted transactions and displays them with a strikethrough. 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 Gearwheel icon. 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.

Solution Properties

Solution ID
240304191729580
Last Modified Date
Fri Apr 17 20:04:39 UTC 2026
Views
0