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
- 01Go to Settings and, in the Tools column, select Export data.
- 02Choose your reason for exporting, then select Continue.
- 03On the Reports tab, pick a date range from the pre-selected date ranges dropdown.
- 04On the Reports and Lists tabs, turn items on or off to control what is included.
- 05Select Export to Excel.
- 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
- 01Open the Reports menu, then choose Standard reports.
- 02Search for and select the report you want.
- 03Select the Export/Print dropdown, then select Export to Excel.
- 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
- 01For estimates, go to All apps > Sales & Get Paid > Sales transactions.
- 02Set the Type dropdown to Estimates, set a date range and any filters, then select Export to Excel.
- 03For purchase orders, go to All apps > Expenses & Bills > Expense transactions.
- 04Set the transaction type to Purchase order, select the Filter icon, set the date range and filters, and select Apply.
- 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
- 01Go to All apps, select Customer Hub, then select Customers & leads.
- 02Select the Export to Excel icon next to the Print icon.
- 03For a custom set of columns, go to Reports > Standard reports and select Customer Contact List under Sales and Customers.
- 04Select Customize, open the Rows/Columns dropdown, select Change columns, add the columns you want and select Run report.
- 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
- 01For attachments, go to Settings and, in the Lists column, select Attachments.
- 02Select the files, open Batch actions and choose Export.
- 03For customer statements, go to All apps > Customer Hub > Customers & leads and select the customer.
- 04On the Statements tab, choose the statement, select Print, then use the Download icon and save the file.
- 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 export | What it contains |
|---|---|
| Export data .zip | Excel files for each report and list switched on, all for the chosen date range. |
| Standard report workbook | One report, such as Account List for the chart of accounts or Recurring Template List. |
| Customers workbook | Name, company, address, phone number, email address, customer type, sales tax, attachment, balance and notes. |
| Estimates workbook | Estimates for the date range and filters set on the Sales transactions page. |
| Purchase orders workbook | Purchase orders for the date range and filters set on the Expense transactions page. |
| Attachments .zip | The files selected on the Attachments list and exported through Batch actions. |
| Customer statement | A 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?
Why is data missing when I open a QuickBooks report in Excel?
How do I export estimates from QuickBooks Online?
How do I export my customer list from QuickBooks Online?
Sources
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.