Export a full list of transactions from the Audit Trail
To export a list of all transactions all transaction entered in Accounting, use the Export option from the Audit Trail report.
The Audit Trail shows the date of each transaction, who entered it, the transaction type and relevant values.
Run the Audit trail report
- From Reports, choose Audit Trail.
- From the Period drop-down list, select Custom.
-
Use the From and To boxes to enter the required date range, then select Calculate.
Make sure you re-select Calculate every time you change the date range or other criteria.
- Choose the Summary or Detailed view.
- Summary - shows the transaction total.
- Detailed - shows theledger accounts, and the debits and credits.
- Select Export and then whether you want the report as PDF or CSV ( spreadsheet) file.
- When the report is ready, open it from the main menu bar.
Filter the list by transaction type
To export a list of a single type of transaction such as sales invoices or customer receipts
-
Select More.
-
From the Transaction Type drop list, choose the relevant type.
- Select Calculate, then Export.
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
-
Select More.
-
From the Status drop list, choose to exclude deleted transactions or deleted only.
- Select Calculate, then Export.
Related content