How to Export QuickBooks Data: Online, Desktop and History

How to export QuickBooks Online data, step by step

QuickBooks Online has one built-in bulk export, and it produces spreadsheets rather than a database copy. Intuit's own instructions are short: Export your reports and lists as Excel files in one .zip file, which covers the posting transactions that change your balances, such as invoices, receipts and bills. Everything else is exported one area at a time.

Run the export as an admin, while the subscription is active, and run it once per year of history if your books are large. Smaller date ranges finish faster and are easier to check against the year-end reports you already filed.

• Go to Settings, and in the Tools column select Export data.
• Select the reason for exporting, then Continue.
• On the Reports tab, set the date range. Choose the widest range the tool allows, or repeat the export one year at a time.
• On the Reports and Lists tabs, turn on every report and list you need, then select Export to Excel.
• Export attachments next: Settings, then Attachments in the Lists column, select the files, then Batch actions and Export. They arrive as a zip file.
• Export the non-posting transactions the main export leaves out: estimates from Sales transactions, purchase orders from Expense transactions, and customer statements from each customer's Statements tab.
• Export the chart of accounts (Account List report), the products and services list, and the Recurring Template List from Standard reports.

Source: QuickBooks Help: Export your QuickBooks Online data

What the QuickBooks Online export includes and leaves out

The table maps each kind of record to the place you export it from. Intuit separates "posting" transactions, which the Export data tool covers, from what it calls non-posting transactions that don't impact your reports. Those are often the most revealing records: an estimate that never became an invoice, or a purchase order that was cut back before it was billed.

Keep the audit log: who changed what, and when

The audit log is the part owners forget, and it is the part that shows how the books were actually kept. QuickBooks Online records user sign-ins, changes to QuickBooks settings, edits to customers, vendors, employees, and payroll submission, along with deleted transactions. Intuit is clear about its depth: events recorded in the audit log are available for two years. Using it requires an active subscription and admin access, so it is the first thing to lose when you cancel.

There is no one-click export of the log in the Online help pages we read. The practical route is to filter it by date and user, open the History view for transactions that matter, and print or save the results to PDF month by month. If your accountant has a tool that reads the log through the QuickBooks Online Accounting API, use it while the subscription is live.

• Filter by Date and save each month of events. Results show 150 records at a time.
• Open History on edited and deleted transactions. Those trails show corrections, approvals and reversals.
• Note the system users: Online Banking Administration, System Administration and Import Administration events are made automatically, not by a person.

Source: QuickBooks Help: Use the audit log in QuickBooks Online

How to export QuickBooks Desktop data

QuickBooks Desktop stores the books in a company file on your own computer or server, so the first export is simply a backup of that file kept somewhere safe. For data you can open without QuickBooks, Desktop moves lists and transactions in Excel or CSV files and in Intuit Interchange Format: Intuit says to Use IIF files to import and export complex data structures. Reports can be saved to Excel from the report window.

When a Desktop subscription ends, View-only access remains for 1 year after your subscription ends. You can view reports and export, but not create transactions. The limits matter: only company file admins can use view-only mode, it may not work in multi-user mode, and it does not work after a reinstallation. In view-only mode you won't be able to view attachments linked to transactions, so export the attached documents before the subscription lapses.

Intuit adds a useful line for owners: "As a QuickBooks Desktop user, you still own your data, regardless of subscription status." Old versions are a separate risk. QuickBooks Desktop 2023 was discontinued after May 31, 2026, which ended bank feeds, payroll services and security updates for that version. A company file sitting on an old, unsupported install is worth exporting now.

• Make a backup copy of the company file and store two copies, one off the machine.
• Export lists (customers, vendors, items, chart of accounts) to Excel or IIF.
• Save the Journal, General Ledger and Transaction Detail reports to Excel for each year.
• Copy the attachments folder or export the attached documents while the subscription is active.
• Write down the version and edition, so the file can be opened again later.

What happens to QuickBooks data after you cancel

For QuickBooks Online, cancelling does not delete the books at once. When you cancel your QuickBooks Online subscription you have read-only access to your QuickBooks Online data for one year, and you can export to Excel or to a desktop version of QuickBooks during that year. After it, you must resubscribe to access your account data. Two details help: a company with several QuickBooks Online subscriptions can keep one active on the same login to keep read-only access indefinitely, and QuickBooks Online Advanced customers cancel through their account manager rather than the Account Manager page.

Source: QuickBooks Help: What happens to my QuickBooks Online data after I cancel?

Keep the records linked: numbers, dates and attachments

An export that keeps the links between records is worth far more, to you and to anyone who later reviews or licenses the books, than a pile of separate spreadsheets. Each later question, from an audit to a buyer's due diligence, starts with tracing one transaction from the estimate to the invoice to the payment and the receipt.

• Keep transaction numbers, dates and the customer or vendor name on every row. Do not delete columns to tidy the spreadsheets.
• Keep the chart of accounts with its account numbers; every report refers to it.
• Record which transaction each attachment belongs to. A file list with the attachment name, the transaction type, number and date is enough.
• Export each year as its own set and note the date range on the folder, so gaps are obvious.
• Keep the audit log PDFs next to the year they cover.
• Store the original zips unchanged and work on copies.

Why years of accounting history matter now

The same export that protects you at tax time can also be an asset. AI developers license the working records of real companies to train and test agents for business tasks, and finance records are among those buyers ask for. In QuickBooks the outcome signal is the chain from estimate to invoice to payment, with credit memos, voids and reversals showing what went wrong, and the audit log showing who corrected what and when. When a bankrupt airline's data was sold in 2026, Axios reported the dataset included "financial databases, audits and presentations" alongside marketing materials, project documents and HR information. That archive was sold whole in a bankruptcy; for an owner licensing books, the HR and payroll part is the piece to leave out.

Smaller sellers are active too. MIT Technology Review reported in October 2026 that one wind-down firm's data sales platform has handled over 150 deals and expects to return over $10 million to startups by the end of 2026. For books, value comes from unbroken years in one company file, attachments matched to their transactions and an audit trail of corrections, not from totals alone. See what company data is worth, which records can be licensed and the guide to licensing ERP and accounting records.

Whose data is in your books, and who owns it

Your company owns its books, but the books describe other people. Customer names and addresses, vendor bank details, negotiated prices and employee pay all sit inside a QuickBooks export. Keep the files encrypted, limit who can open them, and do not hand them to anyone outside the company without a written agreement.

Before any licensing conversation, the personal and confidential parts need work. In QuickBooks, personal data sits in customer and vendor records, in vendor bank details used for payments, in employee records and payroll if you run payroll there, in memo and description fields, and in attachments such as receipts and tax forms. Leave payroll, employee records and expense claims out entirely, and treat anything a vendor contract makes confidential the same way. If you prepare tax returns for clients, their ledgers are not yours to license; read Section 7216 and AI data licensing first. The de-identification guide shows how to replace names with stable tokens so the records still link.

Back up a QuickBooks Desktop company file before anything else

A local backup is the .qbb file QuickBooks Desktop restores from, so make one before exporting reports or moving machines. Intuit's steps for a local backup:

• File > Switch to Single-user Mode.
• File > Back up Company > Create Local Backup, then choose Local Backup and Next.
• Under Local Backup Only, select Browse and pick a folder, optionally set how many backups to keep, and let QuickBooks test the file before it saves.
• Select OK, then Save it now and Next. The file ends in .qbb.

Intuit says a backup saves everything in the company file, including templates, letters, logos and images and the files for Statement Writer, Cash Flow Projector, Business Planner and Loan Manager, and notes that QuickBooks doesn't automatically back up payroll forms. A backup kept on an external drive or a service such as Box has to be moved to the local hard drive before you can restore it.

Source: QuickBooks Help: Back up your QuickBooks Desktop company file

Before you cancel QuickBooks: a short checklist

Work through the list while the subscription is active, then check the files before you cancel. The guide to exporting company records before closing covers the other systems, and keeping company data sellable explains which deletion settings to pause.

Once the export is safe, you can find out what the history is worth. See what your records are worth from a few questions about the business, with no files shared.

Not sure whether a buyer or an offer is sound? Origin checks who the buyer is, what the license allows and how the price compares with published deals before anything is signed. Get a free estimate and a second opinion.

• Run Export data for every year of history and check the totals against your filed returns.
• Export attachments, estimates, purchase orders and statements separately.
• Save the audit log, month by month, while you still have admin access.
• For Desktop, back up the company file and export attachments before view-only mode starts.
• Keep one admin login and the files until record-keeping periods end.