November 18, 2026
QuickBooks Online to Desktop: Intuit’s migration tool vs a managed conversion, what moves, what doesn’t, and how to prove the result
The short answer: Intuit’s free migration tool can turn a QuickBooks Online company into a new QuickBooks Desktop file, and for a clean file with no inventory or payroll it is the sensible first try. It does not export inventory quantities, it moves only payroll transactions (not the payroll service), it keeps no backup of the Online data, and Intuit itself says some data “changes shape or doesn’t move”. If your file carries stock, payroll, years of history or a non-US setup, plan for a managed conversion and use the tool, if at all, as a starting point that you then prove.
The facts below come from Intuit’s help article “Use the migration tool to move QuickBooks Online data to QuickBooks Desktop” (updated 5 November 2026), read on 18 November 2026. That article is published on Intuit’s US help site and lists only US Desktop editions; if your books are kept in Canada, the UK, Australia or elsewhere, confirm with Intuit that the tool and a matching Desktop edition are offered in your region before you plan around it.
What the tool needs before you start
- QuickBooks Desktop installed, activated and updated to the latest release, open on the same computer. The tool installs on the computer; it does not run in a browser.
- Admin sign-in to the QuickBooks Online company.
- A company small enough to fit Desktop’s list limits. Desktop caps the number of list entries; a large customer, vendor or item list can stop the import.
- Time. Intuit warns that large files can take hours.
How it works, in three stages
- Download the tool. From the Export Overview page in QuickBooks Online, choose Get Started, then Download tool, and install it.
- Request and download the export. Choose All financial data or All financial data without transactions. Intuit emails you when the file is ready; you then download it as a QBXML file.
- Import into Desktop. With Desktop open on the No Company Open screen, run the tool, browse to the QBXML file, name and save the new company file, allow the certificate, and let the meter finish.
Intuit then asks you to run Profit and Loss and Balance Sheet reports in both products on the accrual basis, because cash-basis reports may not match even when the data moved correctly. If accrual reports still differ after a second import, the fix is manual adjusting entries in Desktop.
What does not come across
- Inventory quantities. Intuit states that quantities for products and services do not export. Item lists may arrive, but stock on hand and its value need to be rebuilt and tied to the Online inventory valuation report at the cut-off date.
- The payroll service. If you use QuickBooks Workforce, only payroll transactions move. You cancel Workforce and activate QuickBooks Desktop Payroll, which in turn needs year-to-date totals set up correctly.
- A safety net. The tool does not back up your Online data, so take your own exports first.
- Everything Intuit does not list. The article does not say how attachments, the audit log, reconciliation history, recurring transactions, custom fields, budgets, sales tax settings or multicurrency are handled. Treat each as “check after import”, not “moved”.
Migration tool vs managed conversion
| Your file | Migration tool alone | Managed conversion |
|---|---|---|
| Service business, no stock, no payroll, one currency | Usually fine; prove it with accrual reports | Rarely needed |
| Inventory with quantities and values | Quantities do not export | Opening stock rebuilt and tied to the valuation report |
| Payroll run in QuickBooks Online | Transactions only; service and YTD setup are yours | Payroll liabilities and YTD totals reconciled |
| Large lists or many years of history | Can hit Desktop list limits or run for hours | History scoped (full detail, summary years, or both) |
| Books outside the US | Regional availability to confirm with Intuit | Route planned around the edition sold in your region |
A pre-export checklist that saves the second attempt
- Freeze a cut-off date and stop edits in Online while you export, so nothing changes underneath the file. It is the same discipline as locking an old Desktop file; see the closing date before you migrate.
- Save what Desktop will not rebuild: the audit log, reconciliation reports and attachments, as exported files. Our note on the QuickBooks Online audit log before migration explains why it matters.
- Record custom fields and the reports that rely on them; custom fields before migration covers the mapping.
- Run your tie-out reports in Online on the accrual basis at the cut-off: trial balance, AR and AP ageing, inventory valuation, payroll liabilities, bank balances.
- Import, then compare the same reports in Desktop. Differences you cannot explain are the list for manual entries or for a specialist.
The reverse journey has its own traps; if you came to Online from Desktop in the first place, what doesn’t convert lists them.
FAQ
Is there a free way to convert QuickBooks Online to Desktop?
Yes. Intuit offers a migration tool that exports your Online data as a QBXML file and imports it into a new QuickBooks Desktop company file. You need Desktop installed and updated, and admin access to Online.
Does inventory move from QuickBooks Online to Desktop?
Not fully. Intuit says inventory quantities for products and services do not export, so opening stock has to be rebuilt in Desktop and tied to the Online inventory valuation report.
Why don’t my Desktop reports match QuickBooks Online after the move?
Compare both on the accrual basis first; Intuit notes cash-basis reports may not match even when the data moved correctly. If accrual reports still differ, re-run the import or post adjusting entries in Desktop.
Related service: QuickBooks Online to Desktop conversion, with inventory and payroll rebuilt and reports tied