How to Use the Audit Trail in QuickBooks Desktop

To use the audit trail in QuickBooks Desktop, go to Reports > Accountant & Taxes > Audit Trail. It shows every transaction that was created, modified, or deleted — along with who did it and when. Use filters to narrow the report by date, user, or transaction type.

Picture this: you reconcile your bank account on Friday and everything balances. Monday morning, the same account is off by $340 and nobody can explain why.

Someone edited something. Or deleted something. And without a way to see what changed, you're left playing detective with no clues — reopening transactions one by one, hoping you'll spot the difference.

That's exactly the problem the audit trail solves. Think of it as a security camera for your books: it quietly records every transaction that's added, changed, or deleted, along with who made the change and when. And here's the thing most people don't realize — it's already on. You've been recording this whole time. You just need to know where to look.

Table of Contents

What is the audit trail in QuickBooks Desktop?

The Audit Trail is a report that lists every transaction in your company file that was created, modified, or deleted during a given period. Each entry shows:

The transaction type (invoice, bill, journal entry, and so on)
The date the change happened
The user who made the change
The original version and the revised version of the transaction

For changed or deleted transactions, QuickBooks shows both versions — the old one underneath, the new one on top — so you can compare exactly what was different. Did the amount change? Was a date moved? Was the whole transaction deleted? It's all right there.

One thing to know upfront: the audit trail doesn't log every single thing. Simple list changes (like editing a customer name or account name) don't always appear here. But every financial transaction change does, and that's where discrepancies almost always come from.

How to open the audit trail, step by step

Step 1: Open the report

Go to the Reports menu at the top.
Select Accountant & Taxes.
Click Audit Trail.

That's it — the report opens with the default date range.

Step 2: Set the right date range

At the top of the report, set the From and To dates to the period you want to investigate.
If your reconciliation broke between Friday and Monday, cover that window (plus a little margin on each side — changes sometimes sneak in earlier than you'd think).
Click Refresh.

Step 3: Read what it’s telling you

Scan the transaction types. Look for entries marked as modified or deleted — new entries are normal day-to-day work.
For each modified transaction, compare the old and new versions. QuickBooks stacks the latest version on top.
Note the User column. If multiple people touch the books, this tells you exactly whose login made each change.
Double-click any transaction to open it and see the full details.

Step 4: Customize it when the list is too long

Click Customize Report at the top of the audit trail window.
On the Filters tab, narrow things down — by transaction type, account, or user.
Chasing a deleted invoice? Filter by transaction type "Invoice" and look for deleted entries.
Wondering what your bookkeeper did last week? Filter by their username.
On the Display tab, you can add or remove columns to keep the report readable.
Click OK to apply.

Step 5: Save it for later

If this is something you review regularly, memorize the report: click Memorize at the top.
You can also export it to Excel for a deeper dig or to send to your accountant.

Practical ways to use the audit trail

So you've got the report open. When does it actually earn its keep?

When a reconciliation suddenly won't balance. Before you start re-reconciling everything, run the audit trail for the period since the last clean reconciliation. Deleted or modified transactions jump right out.

When you're not sure who did what. Multi-user office? The user column settles it. This isn't about blame — it's about knowing who to ask for context on a change.

Before year-end or an accountant review. A quick scan of the audit trail for the year tells you (and your accountant) whether the books have been stable or constantly reworked. Heavy modification activity is worth a conversation, not a panic.

When money looks off. Vendor says you short-paid them? Client says their invoice changed? The audit trail shows whether the transaction was edited after the fact — and by whom.

Common mistakes to avoid

Assuming deletions are the only problem. Edits cause more headaches than deletions. A changed date or amount on an old transaction can ripple through reconciliations and reports. Read the modified entries too, not just the deleted ones.
Checking too narrow a date range. If you only look at last week, you'll miss the edit someone made three weeks ago that only just surfaced. Pad the range.
Forgetting that users matter. If everyone shares one login, the audit trail can't tell you who did what. Give each person their own QuickBooks user login — it's free and it makes the audit trail ten times more useful.
Never looking at it at all. The audit trail is passive; it records whether you check it or not. A five-minute monthly review catches small problems while they're still small.

Conclusion!

That brings us to the end of this guide on using the audit trail in QuickBooks Desktop. We hope the steps explained above helped you find your way around this underused report and start tracking changes in your books with confidence. If you run into any difficulty while following the steps, consider consulting a qualified and experienced QuickBooks professional for further assistance.

FAQs

Can I turn the audit trail off in QuickBooks Desktop?

No — and that's by design. The audit trail in QuickBooks Desktop is always on and can't be disabled. It protects the integrity of your financial data by keeping a permanent record of transaction changes.

Does the audit trail show who logged in?

It shows which user made each transaction change, which amounts to the same thing for tracking purposes. If you need login history specifically, that's a different report — but for "who changed what," the audit trail has you covered.

Can I see transactions deleted a long time ago?

Yes, as long as they're within the date range you select and the company file hasn't been condensed or rebuilt in a way that purged history. The audit trail reaches back as far as your file's data does.

Will the audit trail slow down QuickBooks?

Not noticeably. It's a built-in feature that records lightweight entries as transactions change. Running the report itself on a very large date range in a very large file can take a moment — filter it down and it'll be quick.