How to Save a Copy of Your QuickBooks General Journal for Audit Purposes

Ask a bookkeeper which single report to save before closing the books for good, and many will name the Journal. It comes closest to being the company's complete accounting record in one file: every posting transaction the business recorded, listed in the order it happened, with each one broken into the debits and credits that moved money between accounts. Where a profit and loss statement or a balance sheet gives you a summary, the Journal shows the underlying entries themselves. That is why accountants and auditors reach for it, and why it is worth exporting carefully before a QuickBooks Online subscription lapses.

Why the Journal is the report to keep

An audit, or any later question about your books, almost always comes down to one transaction: what was recorded, when, and against which accounts. The Journal answers that directly. It lists each transaction in chronological order and shows the full double-entry detail, so a single export gives you the raw material to trace any figure back to the entry that produced it.

The direction only runs one way. Summary reports are built up from these entries, which means you can rebuild a profit and loss figure or an account balance from the Journal. You cannot go the other way and pull individual entries back out of a summary. For a business that is winding down, that makes the Journal the backbone of an archive: the one report that captures the accounting substance of every transaction rather than a rolled-up total.

How to run and export the Journal in QuickBooks Online

QuickBooks Online includes the Journal as a standard report. To capture it for the full life of the company:

1. Open Reports from the left menu and search for Journal.
2. Set the report period to cover the company's entire history, from the earliest date the business recorded a transaction through today. If you are unsure of the start date, set it well before the company began; an early start date simply captures everything.
3. Run the report, then use Export to save it as Excel, and again as PDF. The spreadsheet stays workable and the PDF gives you a fixed copy you can open and read without QuickBooks.

A Journal covering several years of an active business can be very large, and very large report exports sometimes stall or produce a file that will not open cleanly. If that happens, break the date range into chunks (one fiscal year at a time is a natural split) and export each separately. You end up with a set of annual Journal files that together cover the full history, which is often easier to store and open than one enormous file.

Journal versus General Ledger

The Journal and the General Ledger hold the same underlying entries arranged two different ways. The Journal is chronological. It lists transactions in the order they occurred, which is how you read the sequence of what happened and when. The General Ledger is organized by account. It groups every entry under the account it touched, which is how you see the activity and running balance for a single bank account or expense category.

An archive really wants both. The Journal is the timeline, and the General Ledger is the account-by-account view an examiner uses to check a specific balance. Export each of them for the company's full history. If the business ever filed taxes on a different basis than it kept its books, run both reports twice, once in cash basis and once in accrual, using the accounting-method toggle at the top of the report. The basis you filed on is the one an examiner will reconcile against, so it is worth having both versions saved.

What the Journal does not capture

Thorough as it is, the Journal is still a report of entries, and a complete archive needs two things it does not contain.

The first is your attachments. Receipts, bills, and signed documents live attached to individual transactions in QuickBooks, and no report includes the files themselves. You export them separately, and Intuit's own documentation notes that a bulk receipt export separates the files from the transactions they were attached to. The standard Export to Excel tool leaves attachments out as well, along with estimates, purchase orders, and customer statements. That leaves the connection between a receipt and its Journal entry as something you have to preserve on purpose. Our guide on exporting attachments linked to their transactions covers how.

The second is the audit log, the record of who created, edited, or deleted each transaction and when. It is not part of any financial report and has to be pulled on its own. QuickBooks exports the audit log only as a CSV, 150 rows at a time, and keeps it for just two years, so a complete copy means working through the log in date batches before the older history ages out. There is a full walkthrough in our audit log export guide, and the complete export guide covers every surface in one place.

Tie the totals to the trial balance

Before you trust an exported Journal, confirm it is complete. The simplest check is to reconcile it against a trial balance for the same period. Run a trial balance for each fiscal year, then confirm that the account balances built from your Journal entries agree with it. When the debits and credits line up, you have evidence the Journal captured every entry rather than a truncated slice of them.

This check matters most with a chunked export, where it is easy to leave a gap between two date ranges without noticing. Running the reconciliation is what confirms nothing dropped out at the seams, and it is the step that turns a set of exported files into a record you can rely on later.

The clock you are working against

All of this assumes you can still log in and run reports, which is only true for a limited time after you cancel. When you cancel a paid QuickBooks Online subscription, Intuit holds the company in read-only mode for 12 months and then deletes it permanently, and a cancelled trial gets only 90 days. Support cannot restore a company once it is deleted. During the window the Journal, the General Ledger, and your attachments are all there to export. After it, they are not. Our guide on what happens to your data when you cancel lays out the full timeline.

The reason to save the Journal in the first place is that the record can be needed long after the subscription ends. The IRS expects you to keep supporting records for at least three years, and longer in specific situations, which can run well past the one year QuickBooks gives you. The Journal, the General Ledger, the attachments, and the audit log together are what has to cover that gap.

If you would rather not assemble and verify all of that by hand, that is the archive we build: the full Journal and General Ledger in both cash and accrual basis, every report, each attachment linked back to its transaction, and the audit log, all checked against your live books before you cancel.