The Audit Log in QuickBooks Online

The audit log is the record of who did what in your QuickBooks Online company: who created, changed, or deleted each transaction, and when. It does not show what your books say; it shows what happened to them. Relevant activity is recorded automatically, each event stamped with a name or identifier and a time, so it reads as a running history of the account rather than a snapshot of the current numbers. It is also one of the easiest records to lose, because it has its own retention limit even while the company is active, which makes it worth capturing before you close the books.

What the audit log records

The log captures who created, edited, or deleted each transaction, the before and after values of a changed entry, when users signed in, and changes to settings and connected apps. Each event carries a timestamp and is attributed to a user, system process, or connected app. The reports you export show the current state of the books; the audit log shows the sequence of changes that produced them. Because it is a chronological record of activity rather than a financial statement, it does not vary with cash or accrual basis. It captures the same events either way. Our guide to exporting the QuickBooks Online audit log walks through the process in full.

It is not part of the standard export

This is the fact that catches people. The audit log is not included in QuickBooks' Export Data tool. That tool covers reports and lists but leaves the audit log out, so pulling the log is a separate, manual job you have to remember to do. It also has a retention limit that applies even while you are paying: Intuit keeps the audit log for two years, so history older than that has already aged out inside a live, active company. A business that has been on QuickBooks for a decade has the last two years of audit history, not ten.

Why a CPA or auditor asks for it

For an active business the log is a background utility, useful mainly for catching a bookkeeping mistake or confirming who entered something. It matters more in the situations where someone questions the books: a dispute with a former bookkeeper or partner over what was changed and when, a suspected case of fraud or embezzlement where the pattern of edits and deletions is often the evidence, an exam that raises whether entries were altered after the fact, or a sale where a buyer wants assurance the books were not quietly rewritten. In each of these the totals in a report are not enough on their own. What people want to see is the history of changes, and that history lives only in the audit log.

How to capture the audit log in QuickBooks Online

1. Open Settings (the gear icon) and choose Audit Log.
2. Use the Filter controls to narrow by user, date, and event type. Filtering by date is the step that makes a complete export possible.
3. Review the results, then use the export option to download them.
4. QuickBooks exports the audit log as a CSV file, 150 rows at a time, with no PDF or Excel option and no single click for the whole history. Work backward through date ranges, a month or quarter at a time, name each file by its range, and continue until you reach the two-year edge of the log.

Because a single busy month can exceed 150 rows, budget real time for this on an active company, and confirm the last batch actually reaches back the full two years.

Keeping the audit log after you cancel

The audit log is part of your Books Backup archive, captured before you cancel so it does not age out or get deleted with the account. It matters because a cancelled paid QuickBooks Online company stays read-only for 12 months and is then permanently deleted, a trial only 90 days, and the log goes with it, on top of the two-year retention that is already dropping the oldest history. Since the IRS generally expects business records to be kept for at least three years, and the audit log is the native QuickBooks record of who changed what, the version you can export today is the most complete one you will ever have.

Frequently asked questions

Is the audit log included when I export my reports?

No. QuickBooks' Export Data tool covers reports and lists but not the audit log, so it has to be captured separately as its own step. Our audit log export guide covers the manual, batched process in detail.

How far back does the audit log go?

Intuit keeps the audit log for two years, so anything older than roughly that window has already aged out, even in a fully paid company. After you cancel, deletion of the company removes what remains, which is why exporting it early matters.

Does the audit log change with cash or accrual basis?

No. The audit log is a record of actions taken in the account, not a financial statement, so it does not toggle by accounting method. It captures the same history of who created, changed, or deleted each transaction regardless of the basis you report on.