Skip to content
Outrich Data

Export guide · Checked against QuickBooks Online documentation 2026-11-17

How to export all your data from QuickBooks Online

In QuickBooks Online, go to Settings > Export data, pick a date range, switch reports and lists on or off, and select Export to Excel. You get one .zip file of Excel files. Estimates, purchase orders, statements, attachments and a few lists are not in that bundle and are exported from their own pages.

Who can export from QuickBooks Online

The export is run by someone signed in to the company file. Intuit's export articles do not say which user role is required, so if Export data is missing from the Settings menu, ask whoever manages users in your company file to check your access.

Intuit's article on exporting a report to Excel lists the QuickBooks Online plans it applies to, including Advanced, Plus and Essentials. One feature is tied to a plan: at the time of checking, Intuit says QuickBooks Online Advanced users can build custom reports with Custom Report Builder, which matters when the standard reports do not hold the columns you need.

Menu names depend on which interface the account is on. Intuit notes that reports can look different in the classic view than in the new experience, and its own articles place some items under All apps and others under the Settings gear. Follow the labels on your screen where they differ from the steps below.

How to export, step by step

Route 1 of 5

Export reports and lists in one zip

User with access to Settings > Export data

  1. 01Go to Settings and, in the Tools column, select Export data.
  2. 02Choose your reason for exporting, then select Continue.
  3. 03On the Reports tab, pick a date range from the pre-selected date ranges dropdown.
  4. 04On the Reports and Lists tabs, turn items on or off to control what is included.
  5. 05Select Export to Excel.
  6. 06Select OK to confirm the export is complete.

This is the main route. Intuit says it covers the transactions that affect account balances, such as invoices, receipts and bills.

Route 2 of 5

Export a single report to Excel

User who can run reports

  1. 01Open the Reports menu, then choose Standard reports.
  2. 02Search for and select the report you want.
  3. 03Select the Export/Print dropdown, then select Export to Excel.
  4. 04Save the file to a location you can find again.

Use this for the chart of accounts (the Account List report) and for recurring templates (the Recurring Template List report), neither of which is in the Export data bundle.

Route 3 of 5

Export estimates and purchase orders

User with access to sales and expense transactions

  1. 01For estimates, go to All apps > Sales & Get Paid > Sales transactions.
  2. 02Set the Type dropdown to Estimates, set a date range and any filters, then select Export to Excel.
  3. 03For purchase orders, go to All apps > Expenses & Bills > Expense transactions.
  4. 04Set the transaction type to Purchase order, select the Filter icon, set the date range and filters, and select Apply.
  5. 05Select Export to Excel.

Intuit exports these separately because they are non-posting transactions that do not affect your reports.

Route 4 of 5

Export customers

User with access to customers and reports

  1. 01Go to All apps, select Customer Hub, then select Customers & leads.
  2. 02Select the Export to Excel icon next to the Print icon.
  3. 03For a custom set of columns, go to Reports > Standard reports and select Customer Contact List under Sales and Customers.
  4. 04Select Customize, open the Rows/Columns dropdown, select Change columns, add the columns you want and select Run report.
  5. 05Select the Export icon next to the Print icon, then choose Export to Excel.

The Customers page export has a fixed set of fields and cannot be customized. The report route is the one to use when you need to choose columns.

Route 5 of 5

Export attachments, statements and products

User with access to the Lists column in Settings

  1. 01For attachments, go to Settings and, in the Lists column, select Attachments.
  2. 02Select the files, open Batch actions and choose Export.
  3. 03For customer statements, go to All apps > Customer Hub > Customers & leads and select the customer.
  4. 04On the Statements tab, choose the statement, select Print, then use the Download icon and save the file.
  5. 05For products and services, go to All apps > Sales & Get Paid > Products & services, open the More dropdown, select Run reports, then use Export/Print to choose Export to Excel.

Statements are downloaded for one selected customer at a time. If a statement does not appear, change the date range.

What comes out

The Export data route produces a single .zip file, and inside it your reports and lists as Excel files. The date range is chosen once, on the Reports tab. What goes in is decided by the switches on the Reports and Lists tabs, so two exports from the same company can contain different files.

Everything else arrives piecemeal. Each standard report, the estimates list, the purchase orders list and the products and services report is its own Excel file. Attachments export as a zip file of the documents you select on the Attachments list. Customer statements are saved one at a time through Print and Download. Intuit's articles do not describe a shared ID across these files, so plan to match records by the names, dates and numbers that appear in the reports.

The Customers page export has a known shape. Intuit lists its fields as name, company, address, phone number, email address, customer type, sales tax, attachment, balance and notes. If a workbook looks empty or cut short when opened, Excel has probably opened it in Protected View, and selecting Enable Editing shows the full report.

In the exportWhat it contains
Export data .zipExcel files for each report and list switched on, all for the chosen date range.
Standard report workbookOne report, such as Account List for the chart of accounts or Recurring Template List.
Customers workbookName, company, address, phone number, email address, customer type, sales tax, attachment, balance and notes.
Estimates workbookEstimates for the date range and filters set on the Sales transactions page.
Purchase orders workbookPurchase orders for the date range and filters set on the Expense transactions page.
Attachments .zipThe files selected on the Attachments list and exported through Batch actions.
Customer statementA statement for one customer, saved through Print and the Download icon.

Before you rely on it

Limits and gotchas.

  • Export data does not include non-posting transactions. Estimates and purchase orders have to be exported from their own transaction pages.
  • Customer statements, attachments, recurring templates, the chart of accounts, and products and services are also outside the Export data bundle.
  • The Intuit articles opened for this guide state no row limit, file size limit or role requirement for these exports. Run a short date range first and check the result before relying on a multi-year export.
  • The articles describe Excel output only. They do not describe a CSV or database export from these screens.
  • The Customers page export cannot be customized. To pick columns, use the Customer Contact List report.
  • Intuit lists third-party apps in its App Center as a further option for backing up company data.

Handle with care

Personal data inside a QuickBooks Online export.

  • These exports hold customer and payment-related personal data, and should be handled as such.
  • Customer names, company names, addresses, phone numbers and email addresses.
  • Each customer's balance and the notes staff have written about them.
  • Invoices, receipts and bills, which tie amounts and dates to named customers and suppliers.
  • Customer statements, which lay out one person's or one company's account history.
  • Attachments, which can be scanned receipts, contracts or identity documents, depending on what staff uploaded.

An export is a copy outside the access controls of QuickBooks Online. Store it encrypted, limit who can open it and delete working copies when you are done. The personal data scrubber removes common identifiers in your browser before a file is shared.

What the export can be worth

Outrich Data is a direct buyer of de-identified company data for AI training, from companies with 50 or more employees. We never connect to your QuickBooks Online account: your team runs the export above and removes what is out of scope. Not every export qualifies, and a rights review comes before any offer.

Questions

Exporting from QuickBooks Online: common questions.

Can I export all my QuickBooks Online data at once?
Most of it. Settings > Export data puts the reports and lists you select into one .zip of Excel files. Estimates, purchase orders, customer statements, attachments, recurring templates, the chart of accounts, and products and services each need their own export.
Why is data missing when I open a QuickBooks report in Excel?
Excel has likely opened the file in Protected View. Intuit's fix is to select Enable Editing in Excel, after which the full report is visible.
How do I export estimates from QuickBooks Online?
Go to All apps > Sales & Get Paid > Sales transactions, set the Type dropdown to Estimates, choose a date range and any filters, then select Export to Excel. Estimates are not part of the Export data bundle because they are non-posting transactions.
How do I export my customer list from QuickBooks Online?
Go to All apps > Customer Hub > Customers & leads and select the Export to Excel icon next to Print. For your own choice of columns, run the Customer Contact List report under Reports > Standard reports, customize it, and export that to Excel.

Steps were checked against QuickBooks Online documentation on 2026-11-17. Vendors change menus, plans and limits, so confirm against the linked pages. QuickBooks Online is a trademark of its owner. Outrich Data is not affiliated with QuickBooks Online.

Find out if your data qualifies.

Eleven questions, about five minutes, no call required. You get an answer on screen and a written follow-up.

esc