Audit trail

I'll share some insights about how the Audit Trail report works in QuickBooks, marjmccann2.

This report tracks all the additions, deletions, and modifications made to transactions in your data file. Please take note that the Audit Trail is a transaction-based report. We're unable to track the changes made to your items and transactions that do not impact their accounting integrity.

When a transaction is modified or deleted, the change displays directly under the transaction heading. If a transaction is modified more than once, a prior entry for each change displays under the same transaction heading.

Although the report is sorted within the heading group by the date the original transaction was created, multiple changes to the same transaction are sorted by date of occurrence.
 

The information about a transaction that is tracked to determine whether it should be included in this report is:

• Transaction Date

• Document Number

• Payment Terms

• Sales Rep

• Shipping Date

• Modifying User

• Account

• Class

• Associated name

• Amount

• Quantity

• Unit Price

• Item

• Payment Method

• Due Date

• Whether the line item represents a discount or not

• Reconciliation status

• Posting status

• Billed Date

• Transaction Type

With QuickBooks Desktop, we can also design and personalize your reports to fit your business needs using the Customize feature.

If there's anything else that I can help you with, please don't hesitate to insert a comment below. Stay safe and have a pleasant day ahead.

Understood - but the entry when an item is deleted says ONLY that it was deleted - I need to know the date that deletion was performed.  Nothing in the Customization list of filters includes the date of the action in the audit trail - the date the action took place.  The list of filters includes transaction type, but not transaction date - 

How do you sort by entered its like you guys created an audit function trail and left it with the least functions in the 2020 desktop version with was left unchanged from the 2018 one

Hello @JonathanLin,

As of the moment, there isn't an integrated way to sort your Audit Trail report by the user who entered the transaction.

In the meantime, you can export your report so you can sort your transactions base on the user who entered it in your company. Let me show you how:

1. Go to Reports.
2. Select Accountant & Taxes.
3. Click Audit Trail.
4. Select Customize report.
5. Under COLUMNS, select Entered/Last Modified.
6. Click OK.
7. On the Excel menu, select Create New Worksheet.
8. Select in a new workbook.
9. Click Export.

Additionally, I've got you this helpful article for the steps in changing the names or column display in any of your reports: Learn how to get the most out of your financial reports.

If you have any other concerns, please let me know by leaving any comments below. I'll be here to assist you. Stay safe!