How Do I Get ALL My Data Off QuickBooks Online? A Complete Export Guide

If you have gone looking for a way to pull everything out of QuickBooks Online in one move, you have probably noticed there is no button that does it. QuickBooks spreads its exports across several separate tools, and each one covers part of your company while leaving other parts behind. Getting a genuinely complete copy means visiting each of those surfaces in turn, knowing what it does and does not include, then checking the result before you trust it. This guide walks through every export QuickBooks offers, what each pulls, where it falls short, and how to fit the pieces together into one copy you can rely on after you cancel.

Why there is no single "export everything" button

QuickBooks Online is not the old desktop product, where a company file downloads as one restorable file. The online version keeps your books on Intuit's servers and hands them back to you in pieces: reports and lists through one tool, attachments through another, the audit log through a third. Nothing bundles all of it together, and a couple of things do not come out at all. That is fine while you are paying and the live company is always available. It becomes a problem the moment you cancel, which is where the rest of this guide comes in.

1. The Export Data tool (reports and lists to Excel)

The Export Data tool is the closest thing to a bulk export. It sends your reports and lists to Excel: the customer, vendor, and product lists, the chart of accounts, and most standard reports. Intuit documents this path, and for handing an accountant a package of reports it works well.

It also leaves specific things out, and Intuit lists them. Export to Excel omits estimates, purchase orders, customer statements, attachments, and recurring templates, and it will not export a profit and loss report to CSV, so that report comes out as Excel only. If your business runs on estimates or purchase orders, those do not come through the standard export, and you save each one on its own. We cover everything the Excel export leaves behind in more detail.

2. Individual report exports (the ledger and your year-end statements)

The reports that matter most for a permanent record are worth running and exporting one at a time, so you control the date range and the accounting basis. Start with the general ledger for the company's entire history, from the earliest possible start date through today. If you ever filed taxes on a different basis than you kept your books, run it twice, once in cash basis and once in accrual, using the accounting-method toggle at the top of the report. The general ledger is the one report that lets you rebuild almost any other figure later, and the Journal report deserves the same treatment: it is the chronological, double-entry view bookkeepers ask for by name.

Then, for each fiscal year the company operated, export a profit and loss statement, a balance sheet, and a trial balance dated to that year. Keep each as both an Excel file and a PDF, so you always have a fixed copy you can open and read without QuickBooks.

3. The Attachments page (your receipts and documents)

QuickBooks stores receipts, bills, and signed documents as attachments on the transactions they support. You can export them in bulk, but Intuit's own guidance notes that a bulk receipt export separates the files from the transactions they were attached to. You end up with a folder of images and PDFs and a spreadsheet of transactions, and nothing connecting the two. Community threads add that the batch export is capped around 10 MB and fails on large files, so a company with years of receipts often cannot get them out in a single pass. If your exports keep crashing or failing partway through, the fix is almost always smaller batches. Our step-by-step bulk download guide covers the process, and a separate guide explains why the transaction link breaks and how to preserve it.

4. The audit log screen

The audit log records who created, edited, or deleted each transaction and when. It is not part of the Export Data tool, and it comes with two hard limits. QuickBooks exports the audit log only as a CSV, 150 rows at a time, and keeps the log for just two years. For any real company, 150 rows covers a short stretch of activity, so a full export means working through date ranges in batches. There is a full walkthrough in our audit log export guide.

5. Payroll reports (if you ran payroll)

If you paid employees through QuickBooks, export your payroll summary reports and copies of the filed tax forms (W-2s, the W-3, and your quarterly and annual returns) before you cancel. Employment tax records carry their own retention expectation: the IRS asks you to keep them for at least four years, per its record-keeping guidance. If you used a separate payroll provider, log in there and pull the same documents, since it keeps its own deletion schedule.

6. What QuickBooks will not export at all

A few things have no clean export, and it helps to know them going in:

• Recurring templates, the memorized transactions that automate your billing, are on Intuit's list of items the Excel export leaves out, so the automation you built up over years does not carry across.
• The link between an attachment and its transaction. You can export the files, and you can export a list of transactions, but never the connection between them as a usable set.
• Audit history older than two years, which has already aged out of the log even in a live, paid account.
• A single restorable company file. The online product does not hand you a desktop-style backup file you can reload later.

Assembling a complete copy

Work through the surfaces in an order that makes verification possible. Export the general ledger and the year-end reports first, then the master lists, then the attachments in batches with your own note of which transaction each file belongs to, then the audit log in date batches, then payroll. Save everything as fixed files (Excel plus PDF), organized by year, and keep a copy on more than one device.

Then confirm the result is actually complete before you rely on it:

• Count the files you exported against the number shown on the Attachments page. If the counts do not match, some receipts did not come out.
• Tie each year's general ledger ending balances to that year's trial balance. When they agree, the ledger is internally consistent.
• Open a random sample of receipts to confirm they are not blank or corrupted, and open every file on a second device.

Skipping the check is how people find a gap months later, when the company is already deleted and re-exporting is no longer an option.

The clock you are working against

Once you cancel, the company switches to read-only. A cancelled paid company stays that way for 12 months before Intuit permanently deletes it, a trial gets only 90 days, and support cannot restore a company once it is deleted. Our guide on what happens to your QuickBooks Online data when you cancel walks through that timeline. Meanwhile the IRS can ask for supporting records three years as a baseline, and longer in specific situations, which our guide to how long to keep business records after closing breaks down. The exports above are what has to bridge that gap.

You can do all of this yourself, and the attachment linkage is the slow part. If you would rather hand it off, that is the archive we build: the full ledger in both bases, the key reports for every year, each attachment linked back to its transaction, the available audit log, and payroll, verified against your live books and delivered as one download before you cancel.