How to export everything from QuickBooks Online (2026)

How to export from QuickBooks Online: a checklist of the list, report, invoice and attachment exports, what has no documented export, and how to cancel.

Updated November 10, 2026 · 17 min read

Workspace369 publishes this guide and sells a client-work platform with its own invoicing and accounting, so it competes with QuickBooks for part of your work. Every QuickBooks step below comes from a help article on quickbooks.intuit.com, in its United States edition unless we name another one. On November 10, 2026 we read the full text of each article cited here, and each one is linked where it is used. Intuit's articles word two things differently (how long your data is kept after you cancel, and what the export control is called), and we say so where that happens. This guide covers QuickBooks Online, not QuickBooks Desktop. Intuit can change its help center, so check each article in your account before you rely on it.

If you are leaving QuickBooks Online, export first and cancel last. This guide is a checklist of what Intuit's own help articles say you can take with you, how to do each export, and what the exports leave out. Where there is a gap, I say so and give a generic workaround, labelled as one.

Every step links to the Intuit article it comes from. I read each of them on November 10, 2026, in the United States edition of QuickBooks Help. Where a detail comes from another country's edition, I name it. This guide covers QuickBooks Online, not QuickBooks Desktop. Intuit can change its menus, and some reports depend on your plan, so compare each step with what you see on screen.

Key takeaways

  • QuickBooks Online has no single export. The Export data tool, under Settings in the Tools column, exports your reports and lists as Excel files in one .zip file. Intuit says this saves info from posting transactions, including invoices, receipts or bills.
  • Estimates, purchase orders, customer statements, attachments, recurring templates, the chart of accounts and products and services each have their own export steps in the same Intuit article.
  • Any report exports from its Export/Print dropdown, to Excel or CSV, or saves as a PDF. Which reports you have depends on your plan: Intuit shows some from Essentials, and the time activity reports under Plus.
  • Intuit says you have read-only access to your data for one year after you cancel a subscription, and that data from a trial is available for 90 days. It recommends that you export or print your data before you cancel.
  • QuickBooks data moves over in two steps, export then import. Your customer list and your products and services come in as CSV or XLSX through AI Import, which maps the columns and shows the AI usage estimate before it writes anything. Reports, attachments and statements stay as your records, and you can keep QuickBooks for the books.
What's inside?Quick answerBefore you startChecklist at a glance1. Run the Export data tool2. Export your customer, vendor and product lists3. Export your invoices4. Export your estimates and purchase orders5. Export your bills, expenses and time through reports6. Export the reports your accountant needs7. Save your attachments and customer statements8. Save your recurring templates, payroll and payments records9. Write down what has no exportBring it into Workspace369What happens when you cancelFinal check before you cancel
A paper abacus stands behind a row of file folders and a document tray holding a checked page, with a rubber stamp beside it.

Quick answer

QuickBooks Online has no single export. The main route is the Export data tool, under Settings in the Tools column. Intuit says it exports your reports and lists as Excel files in one .zip file. Estimates, purchase orders, customer statements, attachments and recurring templates each have their own steps. Any report exports to Excel or CSV, or saves as a PDF. For bills, expenses and time, I found no written steps for exporting from their own pages, so those come out through reports. After you cancel a subscription, Intuit says you have read-only access to your data for one year.

You do not have to leave QuickBooks to move your client work. You can keep it for the books. Either way, the move to Workspace369 takes two steps. You export from QuickBooks, then bring your customers, products and services in with AI Import. More on that below. If you want the short version of the whole move, start with switching from QuickBooks.

Before you start

Also readSwitch from QuickBooks to Workspace369
  • Sign in as an admin. Intuit's steps for exporting your lists start with signing in as a primary or company admin. I found no article that says who can run the Export data tool, so use an admin login for all of it.
  • Know which reports your plan has. Intuit's report list says QuickBooks Online Free and QuickBooks Online Lite only have the Profit and Loss, Balance Sheet and Account list standard reports. On the other plans, it shows some reports only from Essentials, and the time activity reports only under Plus. It says QuickBooks Advanced can run all of them.
  • Split big reports by date. Intuit gives limits for a report exported to Excel: 1,024 columns, 400K cells with data and 10 MB. A report that reaches 50,000 cells cannot export to PDF. For large books, export one year or one quarter at a time.
  • Ask your accountant what they need. Get the list of reports and the years before you start, so you export each one once.
  • Do not cancel yet. Keep the subscription active until the last step.

Checklist at a glance

WhatQuickBooks gives youFormat
Reports and lists in one downloadExport data, under SettingsExcel files in one .zip file
Customer, vendor and product listsList reports, under Standard reportsExcel or CSV
InvoicesExport data, plus the Invoice List and Open Invoices reportsExcel or CSV
Printed invoice copiesBatch actions, on Sales transactionsPrint
EstimatesSales transactions, filtered to EstimatesExcel
Purchase ordersExpense transactions, filtered to Purchase orderExcel
Bills, expenses and timeReports; no written steps for their own pagesExcel or CSV
Accounting reportsExport/Print dropdown on each reportExcel, CSV or PDF
Chart of accountsAccount List reportExcel
AttachmentsBatch actions, on the Attachments listZip file
Customer statementsStatements tab, one customer at a timeNot stated in the US article
Recurring templatesRecurring Template List reportExcel
Payroll reportsShare dropdown on each payroll reportExcel or printer friendly
QuickBooks Payments recordsMerchant Service CenterReports, statements and tax forms
Custom form styles, bank connectionsNo documented exportNot documented

1. Run the Export data tool

Per Intuit's export article:

  1. Go to Settings and, in the Tools column, select Export data.
  2. Select the reason for exporting, then select Continue.
  3. On the Reports tab, set the date in the Pre-selected date ranges dropdown.
  4. Add or remove items on the Reports and Lists tabs by turning each switch on or off.
  5. Select Export to Excel.
  6. Select OK.

Intuit says the result is Excel files in one .zip file, and that it saves info from posting transactions that affect your account balances, including invoices, receipts or bills.

The United States article does not list what the two tabs hold, so read each switch before you export. For reference, the United Kingdom edition of the same article lists Profit and Loss, Balance Sheet, Trial Balance, General Ledger, the customer list, the supplier list and the employee list, and describes the download as a single Excel file. Your account may differ. Open the download and check each file.

Intuit adds that QuickBooks Online Advanced has a Custom Report Builder if you want to be more specific about the data you export.

2. Export your customer, vendor and product lists

Intuit's article on moving your lists has a section for exporting them from a QuickBooks Online company:

  1. Sign in to QuickBooks Online as a primary or company admin.
  2. Go to Reports, then Standard reports.
  3. Find and open the report you need: Customer Contact List, Vendor Contact List, Product/Service List or Account List.
  4. Select Customize, then the Columns dropdown.
  5. Check or uncheck column headers to add or remove columns.
  6. Select Apply changes, then Save As.
  7. Select the Export icon, then Export to Excel or Export as CSV. On a Mac, Intuit says to choose Windows CSV format.
  8. Open the file and remove the header rows (company name and report title) so your column headers sit on row 1, then save.

Intuit's recommended columns for the customer list are Customer, Company, Email, Phone, Website, Bill Street, Bill City, Bill State, Bill Zip and Bill Country. For vendors: Vendor, Company Name, Email, Phone, Website, Street, City, State, Zip and Country. For products and services: Product/Service, Type, Memo/Description, Sales Price, Purchase Price, Cost and Qty on hand. That list was written for moving into another QuickBooks company, so add any other column you want to keep.

There is a shorter route. Intuit's article on moving lists to QuickBooks Desktop says to go to Customers & leads or Vendors and select the Export to Excel icon, and to do the same on Products & services. It uses that file for the Open Balance column. I found no United States article that lists that file's columns. The Canada edition says the customer page export includes name, company, address, phone number, email address, customer type, sales tax, attachment, balance and notes. Check your own file.

The export article has one more route for products and services: on the Products & services page, select the More dropdown, then Run reports, then the Export/Print dropdown and Export to Excel.

For the employee list, I found no export steps in the United States articles I read. Intuit's report list shows an Employee Contact List report under Plus.

Two people at a table, one holding a clipboard and the other gesturing over an open folder of records, with envelopes, a speech bubble and documents above them.

3. Export your invoices

Invoices are posting transactions, so Intuit says the Export data tool in step 1 saves their info. For a list you control, use a report. Intuit's report list shows the Invoice List and Open Invoices reports on Simple Start, Essentials and Plus. Run each one for the dates you need and export it the way step 6 describes.

I found no written steps for exporting the invoice list from the Sales transactions page. On that page, the export article gives steps only for estimates.

To keep a copy of each invoice as your client saw it, Intuit's article on emailing or printing multiple sales forms says:

  1. Go to All apps, then Sales & Get Paid, then Sales transactions.
  2. Select the checkboxes for the sales forms you want. The Filter dropdown narrows the list by type, status, date or customer.
  3. From the Batch actions dropdown, select Print.

The article says print, not PDF, and gives no maximum batch size. Generic workaround, not from Intuit: most computers let you pick "Save as PDF" in the print dialog. Try a small batch first and check the result.

4. Export your estimates and purchase orders

Intuit calls these non-posting transactions, which don't affect your reports, so they have their own steps in the export article.

Estimates:

  1. Go to All apps, then Sales & Get Paid, then Sales transactions.
  2. From the Type dropdown, select Estimates.
  3. From the Date dropdown, set the date range you want.
  4. Select Export to Excel.

Purchase orders:

  1. Go to All apps, then Expenses & Bills, then Expense transactions.
  2. From the Transaction Type dropdown, select Purchase order.
  3. Select the Filter icon.
  4. Set the date range and any other filters you need, then select Apply.
  5. Select Export to Excel.

5. Export your bills, expenses and time through reports

I found no written steps for exporting bills, expenses or time entries from their own pages. Bills are posting transactions, so Intuit says the Export data tool saves their info. For the rest, use reports. Intuit's report list shows which plan has which:

  • Simple Start, Essentials and Plus: Transaction List by Vendor, Transaction List by Date and Check Detail.
  • Essentials and Plus: Unpaid Bills, Bill Payments List, Expenses by Vendor Summary, Vendor Balance Detail and Transaction Detail by Account.
  • Plus: Time Activities by Customer Detail, Time Activities by Employee Detail, Unbilled Time and Purchases by Vendor Detail.

Intuit says QuickBooks Advanced can run all of these.

You can also export one vendor at a time. Intuit's article on vendor transactions says to go to All apps, then Expenses & Bills, then Vendors, select the vendor, and select the Export icon to export that vendor's transactions to an Excel spreadsheet.

For projects, I found no export steps in the articles I read.

6. Export the reports your accountant needs

These are the books. Intuit's report list shows Account List, General Ledger, Journal, Trial Balance, Balance Sheet, Statement of Cash Flows and Reconciliation Reports on Simple Start, Essentials and Plus. It shows Profit and Loss Detail from Essentials.

Per Intuit's article on exporting reports to Excel:

  1. Go to Reports, then Standard reports.
  2. Search for and select the report you want to export.
  3. Select the Export/Print dropdown, then Export to Excel.
  4. Save the file somewhere you can find it.

Intuit's note: if data is missing when you open the report, Excel has the file in protected view. Select Enable Editing to see the full report.

Intuit's article on running reports lists two more choices in the same dropdown: Export as CSV, and Print/Save as PDF, with settings for orientation, a smart page break and a repeated header. It also notes that this feature is limited for QuickBooks Online Free and QuickBooks Online Lite.

Mind the size limits. Per Intuit's article on reports that are too large, an Excel export holds at most 1,024 columns, 400K cells with data and 10 MB. Per its article on PDF export, a report that reaches 50,000 cells cannot export to PDF, and Intuit's fix is to save it as a custom report and export it to Excel. Splitting a report by date keeps you under both.

The chart of accounts has its own steps in the export article: open the Account List report, select the Export/Print dropdown, then Export to Excel.

A woman at a desk hands a checked document to an outstretched hand, beside a paper tray, a clock, a desk lamp, a calendar and a filing cabinet.

7. Save your attachments and customer statements

Attachments, per Intuit's export article:

  1. Go to Settings and, in the Lists column, select Attachments.
  2. Select the attachments you want to export.
  3. Select the Batch actions dropdown, then select Export.

Intuit says your attachments are exported in a zip file. Its attachments article lists the supported file types as PDF, JPEG, PNG, DOC, XLSX, CSV, TIFF, GIF and XML, and says you can also download one file at a time from the same list. I found no documented limit on how many attachments one export holds, so export in batches and count the files.

Customer statements, per the same export article:

  1. Go to All apps, then Customer Hub, then Customers & leads.
  2. Select the customer whose statement you need.
  3. On the Statements tab, select the statement, then select Print. If you can't find it, change the date range in the Date dropdown.
  4. Select the Download icon, then choose the folder for the file.
  5. Select Save.

That is one customer and one statement at a time. The United States article does not state the file format. The global edition says the statement is exported in a PDF format.

8. Save your recurring templates, payroll and payments records

Recurring templates, per Intuit's export article:

  1. Go to Reports, then Standard reports.
  2. Find and select Recurring Template List.
  3. Select Export to Excel.

Intuit's report list shows this report from Essentials. Its recurring transactions article describes no export from the Recurring transactions page itself. If the report leaves out a schedule or an amount you need, write it down by hand.

Payroll is a separate subscription with its own reports. Intuit's payroll reports article gives these steps for its online payroll product:

  1. Go to Reports, then Standard reports.
  2. Scroll down to the Payroll section, or find the report by name.
  3. Select the report, filter it by date range, then select Apply.
  4. Select Share, then Export To Excel or Printer Friendly.

QuickBooks Payments records sit in the Merchant Service Center, not in QuickBooks Online. Intuit's Payments article says you can view and download your reports, statements and tax forms there.

9. Write down what has no export

For these, I found nothing in the articles I read. Each article is linked so you can check.

  • Custom form styles. I found no documented export of your invoice and estimate designs. Keep a printed copy of one invoice and one estimate so you can rebuild the look.
  • Bank connections. I found no article on what happens to bank connections when you cancel. If you disconnect an account yourself, Intuit's disconnect article says QuickBooks removes any transactions still in the Pending tab. Add or match every pending transaction first.
  • Bank rules, tags and budgets. I did not find export steps for these in the articles I read. Intuit's report list shows a Budget Overview report under Plus. Look for an export option on each page before you cancel.
  • Saved customer cards. Intuit's article on what moves to QuickBooks Desktop says customer credit card numbers and saved payment profiles don't move. That article is about a move to Desktop. Plan on the same for any move, and list who pays by saved card.
  • Audit log. The same article says the audit log doesn't move, and suggests keeping read-only access or exporting your history. Intuit's report list shows an Audit Log report on Simple Start, Essentials and Plus.

Two more things to know. Intuit's export article says you can also use third-party apps to back up your data. Its article on the Desktop migration tool says Intuit doesn't endorse third-party export apps, and to expect a cost. That tool is for a move to QuickBooks Desktop. It needs an admin sign-in, and Intuit says it doesn't save a backup of your QuickBooks Online data.

Bring it into Workspace369

Here is what the process looks like, from the QuickBooks export to AI Import.

  1. Start with the Customer Contact List from step 2. Check that your column headers sit on row 1.
  2. Run AI Import for your clients. You upload the CSV or XLSX. AI Import maps your columns to client fields and you review the mapping. It shows the AI usage estimate before it writes anything. AI Import is on every Workspace369 plan.
  3. Add your products and services from step 2. AI Import also reads CSV or XLSX files of products and services, so the catalog can come in the same way, up to your plan's limit.
  4. Bring in open invoices if you want them. AI Import reads invoice files too, so the Open Invoices report from step 3 can come in. Payment history does not move, and closed work stays in QuickBooks as your archive. Collect each open invoice in one system, not both.
  5. Bring in expenses on Specialist and higher. Expense import starts on the Specialist plan. A transaction report from step 5 is the file to try.
  6. Keep the rest as records. Reports, attachments, statements and printed invoices stay in your folder. Attach what you need to a client record by hand, and start tracking time in Workspace369 with timers or manual entries.
  7. Decide where the books live. Workspace369 has basic accounting from Specialist and full accounting from Commander. If you need payroll, bank feeds or tax reporting, keep QuickBooks for those.

I have not tested every QuickBooks export, so check every row before you save.

Saved payment methods cannot move between systems, so tell active clients where to pay next, and get the last open QuickBooks invoice paid before you cancel. Workspace369 payments run through your own Stripe account.

The full checklist, including what moves and what you re-create, is on the switch from QuickBooks page. For a feature-by-feature view, see Workspace369 vs QuickBooks. Leaving another tool too? The FreshBooks export checklist and the Harvest export checklist work the same way.

What happens when you cancel

Per Intuit's cancel article, for an account bought online, directly from Intuit:

  1. Sign in to the Intuit Account Manager.
  2. Select Products & billing, then select your company name.
  3. Find the product you want to cancel, then select Cancel.
  4. Follow the on-screen steps. Intuit says you get a confirmation after the cancellation is successful.

Intuit says the steps vary based on where you signed up. If you bought through the Apple App Store or Google Play, it sends you to Apple's or Google's own steps. If you use QuickBooks Online Advanced or Intuit Enterprise Suite, it says to contact your account manager. If your account is suspended, it says you need to resubscribe and reactivate it first.

  • Access. Intuit's data article says that when you cancel a QuickBooks Online subscription, you have read-only access to your data for one year. The cancel article says that after that, you must resubscribe to access your account data. The resubscribe article says Intuit preserves your company data for 365 days following the cancellation date. Treat one year as the limit.
  • More than one company. The cancel article says that if you have multiple QuickBooks Online subscriptions and keep at least one with the same login, you can keep read-only access indefinitely.
  • Exporting after you cancel. The data article says a former subscriber can export data to Excel, or to a desktop version of QuickBooks, up to a year after cancelling. It also recommends that you export or print your data before you cancel. I found no list of what read-only access lets you do, so export first.
  • Trials. If you cancel during a free trial, or the trial expires, Intuit says your data is available for 90 days, and that you must export within 90 days after you cancel.
  • Failed payments. Intuit says that if your credit card is declined, you have 14 days to update your billing information, with full access during that time. After that, the account is suspended and you have to resubscribe to access your data.
  • Payroll. Payroll has its own cancellation. Intuit's payroll cancel article says to complete and process your final payroll and print the payroll reports you need first. For its online payroll product, you go to Settings, then Subscriptions and billing, select Cancel in the Payroll section and fill out the online cancellation form. Intuit says you keep access to your payroll data until one year after the cancel date, and to export and save copies of your reports.
  • QuickBooks Payments. Payments is a separate account. Per Intuit's Payments article, you sign in to the Merchant Service Center as an admin user, select the Account tab, then Account Profile, then Close Account, pick a reason and select Submit. Intuit says you get an email within one business day that confirms the account is closed, and that you can still sign in for up to 12 months to view and download your reports, statements and tax forms.

I found no article that says whether cancelling QuickBooks Online also cancels payroll or QuickBooks Payments. Check each one.

If you need to get back in, the resubscribe article says to sign in, go to Settings, then Subscriptions and billing, select Resubscribe, enter your billing information and select Subscribe. Intuit says that area is only available in a computer browser.

Final check before you cancel

  • The Export data download is saved, and every file in it opens.
  • Your customer, vendor and product lists are saved, with column headers on row 1.
  • The Invoice List and Open Invoices reports are saved, with printed copies of the invoices you may need.
  • Estimates and purchase orders are exported.
  • Your accountant has every report they asked for, for every year they asked for.
  • The attachments zip is downloaded and the files are counted, and statements are saved for the customers who need them.
  • Recurring templates are listed, and payroll reports and QuickBooks Payments statements are saved.
  • Clients who pay by saved card or on a recurring invoice know where to pay next.
  • A second copy of the folder exists somewhere other than your laptop.

Then cancel QuickBooks, or keep it for the books and stop here. If you want to compare before you commit, the 14-day Workspace369 trial is card-first, so you add a card to start it. Here is the QuickBooks switch checklist.

Sources reviewed for this guide

FAQ

Can I export all my data from QuickBooks Online in one click?

No. The Export data tool, under Settings in the Tools column, exports your reports and lists as Excel files in one .zip file. Estimates, purchase orders, customer statements, attachments and recurring templates each have their own export steps, and other data comes out one report at a time.#

How do I export my customer list from QuickBooks Online?

Sign in as a primary or company admin and go to Reports, then Standard reports. Open the Customer Contact List, choose your columns under Customize, then select the Export icon and choose Export to Excel or Export as CSV. Remove the header rows so your column headers sit on row 1.#

Can I export my invoices from QuickBooks Online?

Yes, in two ways. Intuit says the Export data tool saves info from posting transactions, including invoices. Its report list also shows the Invoice List and Open Invoices reports on Simple Start, Essentials and Plus, and any report exports to Excel or CSV. For copies as your client saw them, select the invoices on the Sales transactions page and choose Print under Batch actions.#

Can I export QuickBooks Online reports as CSV or PDF?

Yes. Intuit says the Export/Print dropdown on a report has Export to Excel, Export as CSV and Print/Save as PDF. It gives limits of 1,024 columns, 400K cells with data and 10 MB for an Excel export, and says a report over 50,000 cells cannot export to PDF.#

How do I export attachments from QuickBooks Online?

Go to Settings and, in the Lists column, select Attachments. Select the attachments you want, open the Batch actions dropdown and select Export. Intuit says your attachments are exported in a zip file.#

Can I export my data after I cancel QuickBooks Online?

Intuit says a former subscriber can export data to Excel, or to a desktop version of QuickBooks, up to a year after cancelling, and that a trial must be exported within 90 days. It also recommends that you export or print your data before you cancel. I found no list of what read-only access lets you do, so export first.#

Is there a QuickBooks importer in Workspace369?

QuickBooks data moves over in two steps: you export your customer list and your products and services from QuickBooks, then use AI Import to bring them in as CSV or XLSX. It maps your columns, lets you review them and shows the AI usage estimate before it writes anything. Reports, attachments and statements stay as your records.#

What happens to my data if I cancel QuickBooks Online?

Intuit says you have read-only access to your QuickBooks Online data for one year after you cancel a subscription, and that after that you must resubscribe to access it. Its resubscribe article says company data is preserved for 365 days following the cancellation date. If you cancel during a free trial, Intuit says your data is available for 90 days.#

When should I cancel QuickBooks Online?

After every export is downloaded and opened, your accountant has the reports they asked for, payroll and QuickBooks Payments records are saved, and your clients know where to pay next. You can also keep QuickBooks for the books and move only your client work.#

Run client follow-up in one workspace.

CRM, inbox, voice, invoicing, payments, projects, files, AI, and workflow automations — connected instead of exported.

Start free

14-day free trial. Card required. After the trial: from $29/month. Renews automatically every month until you cancel. Cancel anytime in Settings → Billing.

See pricing