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
- Go to Reports, All reports.
- Choose Audit Trail.
- Select the time period from the dropdown list.
- If you select Customer, use the From and To boxes to enter the required date range.
- Select Calculate.
- 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:
- Select More.
- From the Transaction Type drop list, choose the relevant type.
- 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:
- Select More.
- From the Status drop list, choose to exclude deleted transactions or deleted only.
- Select Calculate.
To configure columns
- Select the Configure Columns
button. - Select the columns you want to display. You can also drag columns up and down to reorder them in the table.
- Configure the audit trail to include the following extra columns:
Deleted Tax Reconciled Bank Reconciled Created by
- Select Save.
Export the report
- Run the audit trail report to show the transactions you want.
- Select Export.
- Choose CSV or PDF.
- When ready, the report will show in notifications on the top bar.