What QuickBooks Online's Export to Excel Actually Leaves Behind

A lot of business owners assume that QuickBooks Online's Export to Excel, or the broader Export Data tool, pulls everything out of their books. It pulls a lot. It also leaves specific things behind, and Intuit documents most of them in its own help articles. Two of the omissions happen to be exactly what an auditor or a buyer asks for later, which is why a do-it-yourself export can look complete and still fall short.

What Export to Excel does give you

The Export Data tool 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 reports to an accountant it works fine. One detail to know going in: QuickBooks won't export a profit and loss report to CSV, so that report comes out as an Excel file only.

What it silently leaves out

The same Intuit article lists items the export does not include. Export to Excel omits estimates, purchase orders, customer statements, attachments, and recurring templates. If your business runs on estimates or purchase orders, those don't come out through the standard export at all, and you have to save each one on its own. Recurring templates, the memorized transactions that automate your billing, are left behind too, so the automation you set up over years doesn't carry across.

For someone moving to different accounting software, those gaps are mostly an inconvenience. For someone trying to keep a permanent record before cancelling, two of the omissions are the whole point.

The two omissions that matter for an audit

Attachments and their transaction links

QuickBooks stores receipts, bills, and signed contracts as attachments on the transactions they support. Export to Excel doesn't include them, and the dedicated receipt export has a problem of its own: Intuit's guidance notes that a bulk export separates the receipt files from the transactions they were attached to. You end up with a folder of images and a spreadsheet of transactions and nothing that connects the two. An auditor who wants the receipt behind a specific expense expects you to produce that exact file, not a pile of unlabeled PDFs. We cover why that linkage breaks and how to preserve it separately. 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 can't extract them in a single pass anyway.

The audit log

The audit log shows who entered or edited each transaction and when. It isn't part of the Excel export, 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. Once activity ages past that two-year mark, or the company is deleted, the history is gone. In a dispute over who changed a figure, or during an ownership handoff, the audit log is often the first thing requested. See our guide to exporting the audit log before it is deleted.

Why the gaps exist

None of this means the export tool is broken. Export to Excel was built to help you move your books to another accounting product. In that context, dropping attachments and the audit log is reasonable, because your new software rebuilds those records as you enter transactions. The gaps only become a problem when the goal changes to keeping a fixed, verifiable copy of a company you are about to stop paying for.

That is the situation most people are in when they cancel. The IRS can ask for supporting records three years as a baseline, and six or seven in specific situations, while QuickBooks keeps a cancelled paid company for only one year before deleting it, 90 days for trials,. Our guide on the QuickBooks Online read-only year covers how that window works. Export to Excel was never designed to bridge that gap, so treating it as a complete archive is where the trouble starts.

What a complete exit copy needs instead

A copy you can hand to an auditor or a buyer needs more than the Excel export produces:

• The full general ledger, in cash and accrual basis if you ever filed on a basis different from how you kept the books.
• Year-end profit and loss, balance sheet, and trial balance for every fiscal year, saved as fixed files.
• Every attachment, exported with a record of which transaction each file belongs to.
• The audit log, pulled before it ages out or the company is deleted.

You can assemble all of this yourself if you have the time, and the attachment linkage is the slow part. If you would rather hand it off, that's the archive we build: the full ledger, every report in both bases, each attachment linked back to its transaction, and the audit log, verified against your live books and delivered as one download before you cancel. For the retention side of the decision, our guide on how long to keep business records after closing covers the IRS windows in more detail.