What's Actually in an Audit-Ready QuickBooks Archive

What's Actually in an Audit-Ready QuickBooks Archive

An audit-ready QuickBooks archive is a complete, verified, self-contained copy of your company's books: everything an examiner or a buyer could reasonably ask for, saved as files you can open without logging in to QuickBooks. A folder of CSVs exported in a hurry is not that. What separates the two is not how much data you pulled but whether the copy is complete, whether the source documents are still connected to the transactions they support, and whether anyone has actually checked that it ties out. Here is what belongs in one, and why each piece is there.

The full general ledger, for the whole life of the company

The general ledger is the spine of the archive. Not the last year and not a summary, but the full transaction-level detail from the company's first entry to its last, so any figure on any report can be traced back to the entries behind it. Where the business ever reported on a different basis than it kept its books, the ledger belongs in both cash and accrual, because the two can tell different stories and an archive should be able to answer for both.

Year-end financial statements, in both bases

For every fiscal year the company operated, an audit-ready archive holds a profit and loss statement, a balance sheet, and a trial balance, again in cash and accrual wherever that applies. These are the reports people ask for by name. Pulling them cleanly is more work than it looks, because QuickBooks will not export a profit and loss report to CSV, and its standard Export Data tool leaves out several record types such as estimates, purchase orders, and customer statements. That is why the statements are saved one at a time rather than trusting a single bulk export to produce the whole set.

Every attachment, still linked to its transaction

Receipts, bills, signed agreements, and other source documents are what turn a number into something you can defend. An audit-ready archive keeps every attachment, and keeps each one tied to the transaction it supports. This is the single biggest gap in a do-it-yourself export. Intuit's own documentation notes that a bulk receipt export separates the files from the transactions they were attached to, so you end up with a folder of images and no record of which bill or expense each one backs. The fix is an index that maps each file to its transaction with the date, amount, payee, and account, built while the transactions can still be opened to see what each file was for. Our guide on exporting attachments linked to their transactions covers how that linkage breaks and what it takes to rebuild.

The audit log

The audit log is the record of who created or changed each transaction and when. It is the piece most often missing from a homemade copy, for a straightforward reason: it is not part of the standard Export Data tool. You save it from its own screen, and QuickBooks exports it only as a CSV, 150 rows at a time, and makes the log available for only two years. That two-year cap runs regardless of the read-only window, so on a company with real history the oldest entries are already gone, and more fall off the back edge every day. An audit-ready archive captures what remains early. Our audit log export guide walks through the process.

Payroll reports, where they apply

If the company ran payroll through QuickBooks, an audit-ready archive includes the payroll summary reports and copies of the filed tax forms, since employment records carry their own retention expectations. If payroll ran through a separate service, those documents are pulled from there and kept alongside the rest.

A cover page, and verification you can point to

The contents above are the material. What makes the copy audit-ready rather than merely large is that someone verified it against the live company and wrote down how. That means tying the archive's attachment count to the number QuickBooks shows on its Attachments list, reconciling the general ledger to the trial balance so the copy demonstrably ties out, and opening a sample of receipts to confirm each one matches the entry it is indexed to. The finished archive then leads with a short cover page: what it contains, the period it covers, the basis of each report, the date it was pulled, and how it was checked, so someone can trust the file a year later without re-deriving it.

Why "audit-ready" is the bar

The reason to hold this standard is that you are rarely the person who opens the archive. It gets opened when a buyer's diligence team has a question, a lender wants the workpapers behind a figure, or the IRS opens a return for examination and asks for the records behind it. By then the live QuickBooks company may be gone. A cancelled paid company stays read-only for 12 months and is then permanently deleted, while a cancelled trial is held only 90 days, and after deletion there is no reactivation. An archive built to this standard answers those questions on its own, which a loose CSV dump cannot. This piece is the owner-facing counterpart to the version accountants assemble for departing clients; if you are the accountant doing the work, the accountant's version covers the same ground from your side.

Assembling all of this by hand, across years of books and inside a read-only window that is already counting down, is the slow part. That is the archive we build for you: the full general ledger in both bases, every year-end report, every attachment still linked to its transaction, the audit log, and payroll where it applies, verified against your live company and delivered as one download with the cover page already written. For a closer look at what an examiner tends to request, our guide on what records the IRS asks for in a small-business audit goes deeper.

Closing a business that runs on QuickBooks Online? We build one complete, audit-ready archive of your company so you can cancel the subscription without losing a single record or receipt.

For general information only. Not tax, legal, or accounting advice. Consult your CPA or attorney for guidance on your situation.

References

  1. Export reports, lists, and other data from QuickBooks Online
  2. Export receipts from QuickBooks Online
  3. Use the audit log in QuickBooks Online
  4. IRS: Audits
  5. What happens to my QuickBooks Online data after I cancel?