How to export your QuickBooks Online data before you cancel

Exactly what to download from QuickBooks Online before you leave, where each export lives, and how long you can still get to your data after you cancel. Everything below comes from Intuit's own help articles, checked October 30, 2026. Steps we added ourselves are labeled as our suggestions.

Independent and unaffiliated. BookSwitcher has no relationship with Intuit or any conversion service. None of the links on this page are affiliate links. See our disclosure.

The short version

Export before you cancel. Intuit's own advice is to "export or print your data before you cancel".
Paid subscribers get one year of read-only access after canceling, and can still export to Excel or to QuickBooks Desktop during that year. On a free trial, you only have 90 days.
The built-in Export data tool (Settings, then Export data) downloads your reports and lists as Excel files in one .zip file. It covers posting transactions such as invoices, receipts and bills.
Some things need separate exports: estimates, purchase orders, customer statements, attachments, recurring templates, and your chart of accounts and products list.
Payroll has its own, shorter clock. After you cancel QuickBooks Online Payroll, Intuit says you keep access to payroll data for 6 months, or until June 1 of the following year if Intuit files your year-end forms.

How long you can still get to your data

QuickBooks Online data access after canceling, from Intuit's help articles (checked October 30, 2026)
Situation	What Intuit says
Paid subscription, canceled	Read-only access for one year. You can export to Excel or to a desktop version of QuickBooks during that year.
Free trial canceled or expired	Data available for 90 days. Export within that window.
Card declined	14 days of full access to update billing. After that the account is suspended, and you have to re-subscribe to reach your data.
Payroll canceled, you file your own taxes	Access to payroll data for 6 months after you cancel.
Payroll canceled, Intuit files year-end forms	Access to your payroll account until June 1 of the following year.

Our note: read-only access is a safety net, not a plan. Do your exports while the subscription is still active, so you can fix anything that looks wrong before you lose editing rights.

Step 1: the one-click export of reports and lists

This is Intuit's main export. It saves your reports and lists as Excel files bundled in a single .zip file:

Go to Settings ⚙ and, in the Tools column, select Export data.
Select your reason for exporting, then select Continue.
On the Reports tab, pick a date range from the pre-selected date ranges dropdown.
Turn reports and lists on or off on the Reports and Lists tabs.
Select Export to Excel, then OK.

Our suggestion: choose the widest date range on offer (the life of the business if you can), and run a second export for just your last full financial year so your accountant has a smaller file to work with. If you're on QuickBooks Online Advanced, Intuit points to its Custom Report Builder for more specific exports.

Step 2: what the bulk export misses, and how to get it

Intuit's export article lists these as separate exports, because they're "non-posting" transactions or other data that don't affect your reports. Menu names follow Intuit's help center as of October 30, 2026.

Separate exports in QuickBooks Online, per Intuit's "Export your QuickBooks Online data" article
Data	Where to export it
Estimates	All apps → Sales & Get Paid → Sales transactions. Set Type to Estimates, pick the date range, then Export to Excel.
Purchase orders	All apps → Expenses & Bills → Expense transactions. Set Transaction Type to Purchase order, set the date range with the Filter icon, then Export to Excel.
Customer statements	All apps → Customer Hub → Customers & leads. Open a customer, pick the statement on the Statements tab, select Print, then the Download icon. This is one customer at a time.
Attachments (receipts, documents)	Settings ⚙ → Lists → Attachments. Select them, then Batch actions → Export. They download as a .zip file.
Recurring templates	Reports → Standard reports → Recurring Template List → Export to Excel.
Chart of accounts	Reports → Standard reports → Account List → Export/Print → Export to Excel.
Products and services	All apps → Sales & Get Paid → Products & services → More → Run reports → Export/Print → Export to Excel.

Every new accounting system asks for these. Xero, Zoho Books, FreshBooks and Wave all rebuild your chart of accounts, customers and products from lists like these, and none of them pull your QuickBooks attachments across automatically. See our switching guides for what each one imports.

Step 3: reports worth saving on their own

To export any single report, Intuit's steps are: Reports → Standard reports, open the report, then Export/Print → Export to Excel. Customized reports can also be exported to Google Sheets, PDF or CSV, depending on the report.

Our suggestion for a set to save as of your cutover date. These are the reports a new system, your accountant or a tax preparer usually asks for:

Trial balance (for opening balances in the new system)
Balance sheet and profit and loss, for each year you have
Accounts receivable aging and accounts payable aging (detail versions list each open invoice and bill)
General ledger or transaction detail by account, for a full audit trail
Customer and vendor contact lists
Sales tax liability, if you collect sales tax

If a PDF export fails, stalls or comes out incomplete, Intuit says the report has probably hit its 50,000-cell limit for PDF. Export it to Excel instead, or split it into shorter date ranges. Excel files can also open in "protected view" with data missing; select Enable Editing in Excel to see the full report.

Step 4: payroll records

If you run payroll in QuickBooks, treat it as a separate job with an earlier deadline. Intuit's help articles say:

Before canceling payroll, complete and process your final payroll and print the payroll reports you need. If you pay or file your own payroll taxes, pay any outstanding deposits and file any outstanding quarterly or annual forms first.
Keep copies of payroll reports, tax forms, tax payments and other employment records for at least 4 years.
After you cancel, access to payroll data lasts 6 months, or until June 1 of the following year if Intuit is completing your annual filings.

Our note: payroll history doesn't carry into Xero, Zoho Books, FreshBooks or Wave through their QuickBooks switching tools, so these files may be your only copy. Mid-year payroll switches also affect W-2s; ask your new payroll provider how it handles year-to-date figures.

Option: move to QuickBooks Desktop instead

Intuit also offers a migration tool that exports your QuickBooks Online company to QuickBooks Desktop. In short: QuickBooks Desktop must be installed and open; you download the tool from the Export Overview page in QuickBooks Online, choose either "All financial data" or "All financial data without transactions", wait for an email confirmation, download a QBXML file, and import it in Desktop from the No Company Open screen. Intuit notes that inventory isn't exported for products and services, and that large migrations can take hours. Afterwards, Intuit says to compare profit and loss reports in both, on an accrual basis.

Our note: this is mainly useful if you want a full working copy of your books on your own Windows PC. It needs a QuickBooks Desktop license, so it isn't a free archive.

Export checklist before you cancel

Reconcile your bank and card accounts up to your cutover date.
Run the bulk export: Settings → Export data, widest date range, all reports and lists on.
Export estimates, purchase orders, recurring templates, chart of accounts, and products and services.
Batch-export attachments from Settings → Attachments.
Save the key reports as of your cutover date: trial balance, balance sheet, profit and loss, A/R and A/P aging, general ledger.
Download customer statements for any customer with an open balance.
Save payroll reports and filed tax forms, and finish final payroll tasks before canceling payroll.
Our suggestion: open every exported file once to make sure it isn't empty or cut off, and keep two copies (for example, your computer and a cloud drive).
Set up the new system, check its opening balances against your QuickBooks trial balance, then cancel QuickBooks.
Put a reminder in your calendar a few weeks before your one-year read-only access ends, in case you need anything else.

Still choosing where to go? Compare options in QuickBooks alternatives by business type, then follow our guides for Xero, Zoho Books, FreshBooks or Wave.

Sources

We used only official vendor documentation. Menus and policies change, so confirm anything important on the vendor's page.

Intuit QuickBooks Help: Export your QuickBooks Online data (checked October 30, 2026)
Intuit QuickBooks Help: What happens to my QuickBooks Online data after I cancel? (checked October 30, 2026)
Intuit QuickBooks Help: Export reports to Excel (checked October 30, 2026)
Intuit QuickBooks Help: Can't export a report to PDF (checked October 30, 2026)
Intuit QuickBooks Help: Save a customized report (checked October 30, 2026)
Intuit QuickBooks Help: Cancel your payroll subscription (checked October 30, 2026)
Intuit QuickBooks Help: Close business and finish payroll tasks in QuickBooks Online Payroll (checked October 30, 2026)
Intuit QuickBooks Help: Using the migration tool to move data from QuickBooks Online to QuickBooks Desktop (checked October 30, 2026)

Last checked: October 30, 2026. Not tax, legal or accounting advice.

QuickBooks is a registered trademark of Intuit Inc. Xero, Zoho Books, FreshBooks, Wave and Aplos are trademarks of their respective owners. BookSwitcher is an independent site and is not affiliated with, endorsed by, or sponsored by Intuit or any vendor listed.