Move QuickBooks Online to Desktop: preserve evidence and prove the result

Quick answer: treat the move as a controlled conversion

First verify that your organisation can license and operate the required QuickBooks Desktop product and that every critical workflow has a supported destination. Export reports, lists, and non-posting records from QuickBooks Online, record a clean cutoff, use the migration tool obtained from the authenticated QuickBooks Online Export Overview, then compare both systems at the same date and accounting basis before entering new Desktop transactions.

Intuit's current documentation says the migration tool can export all financial data or financial data without transactions, but inventory for products and services is not exported through that choice. Intuit also documents product-specific conversion behavior and a four-million-target ceiling. Read the current limitations page for your data before approving the move.

Check whether Desktop still fits the operating model

Document the reason for moving and prove each requirement:

• authorised Desktop product, subscription, edition, version, support lifecycle, and country;
• supported Windows, server, hosting, backup, remote-access, and multi-user design;
• users, simultaneous access, accountant workflow, roles, approvals, and audit needs;
• payroll, payments, bank feeds, inventory, sales tax, email, forms, reporting, and industry workflows;
• Web Connector, third-party apps, imports, exports, API dependencies, devices, and support ownership;
• recovery, cybersecurity, patching, administrator, training, and long-term maintenance capacity.

Do not use a hard-coded online price comparison as the decision. Current commercial terms, available Desktop products, hosting, payroll, support, implementation, hardware, and labour vary. Obtain dated quotes only after the technical fit is proven.

Define exactly what “move the books” includes

Read the current conversion limitations line by line

QuickBooks Online and QuickBooks Desktop use different data structures and features. Intuit's transfer guide describes how lists, accounts, transactions, inventory, payroll, tax, reconciliations, attachments, audit history, classes or locations, custom fields, recurring activity, and other data behave. Build a gap register from that current page; do not rely on an old checklist.

For every gap, choose one outcome: migrated by the official tool, entered manually, imported through a verified method, retained only in the source archive, exported to a readable evidence file, rebuilt in a destination feature, or intentionally retired with approval.

Close, reconcile, and export the source before requesting data

1. Clear the exception queues. Resolve uncategorised, duplicated, unapplied, negative, overdue, suspense, and sync-exception items.
2. Reconcile every account to the cutoff. Reconcile every bank and card account through the cutoff date and preserve statements and reports.
3. Tie the control accounts. Tie receivables, payables, tax, payroll, inventory, fixed assets, loans, equity, clearing accounts, and other controls.
4. Run the control reports. Run trial balance, profit and loss, balance sheet, general ledger, journal, aged reports, inventory, tax, payroll, and other material reports at consistent dates and bases.
5. Export reports, lists, and the gaps. Export reports and lists through QuickBooks Online's current export function, plus non-posting transactions and supporting records the standard bundle does not include.
6. Record the configuration. Record users, roles, settings, automations, customisations, integrations, bank rules, templates, recurring transactions, and attachments.
7. Freeze entry at a named cutoff. Stop new entry at a named cutoff or establish a controlled delta-entry plan.

Use the migration tool from the authenticated Export Overview

Install, activate, and update the licensed QuickBooks Desktop destination first. In QuickBooks Online, open the Export Overview, download the migration tool from that authenticated workflow, keep the required page open, choose the documented data scope, request the export, and retain the resulting QBXML file in a versioned working folder. Follow Intuit's current steps exactly.

Open Desktop at the No Company Open screen when instructed, run with the required Windows permissions, choose a new destination path, and retain the tool's messages and logs. Never overwrite a company file that contains live data. Do not retry a partial conversion until you know what the destination contains.

Validate source and destination at the same cutoff

• trial balance agrees by account and total debits equal total credits;
• profit and loss and balance sheet agree on both cash and accrual bases where material;
• aged receivables and payables agree to their control accounts and open documents;
• bank and card registers agree to reconciled statement evidence without duplicate imports;
• inventory quantities, valuation method effects, items, and control accounts are explicitly reconciled;
• tax, payroll, loans, fixed assets, projects, classes, currencies, and clearing balances pass specialist-approved checks;
• users, forms, reports, attachments, integrations, backups, printing, email, and multi-user access pass scripted tests;
• every known non-transfer item has an owner, disposition, and retained source record.

Investigate differences of any size based on the account's risk and nature. A one-dollar tolerance is not appropriate for every account, filing, or control.

Cut over once—and keep the source readable

Name the destination company file and canonical storage path, publish the go-live time, enable users in role order, reconnect apps one at a time, and reconcile each first sync. Enter controlled delta transactions only once. Lock or restrict the source so it cannot become a competing live ledger.

Export and retain source reports before cancelling. Intuit's current policy says a paid QuickBooks Online subscription generally remains read-only for one year after cancellation, while trial data has a shorter window. Treat that as temporary access, not the sole retention plan; policies and account status can change.

Stop before a second attempt makes the evidence ambiguous

Capture the exact message, source company, destination product/version/release, Windows version, export request time and time zone, QBXML filename and size, tool version, destination path, last completed step, log, and whether the destination file was created or changed. Preserve the first output for analysis.

Contact Intuit when the authenticated export or supported migration tool fails. Contact the Desktop administrator for Windows, permissions, licensing, file, or multi-user problems. Involve the accountant, payroll professional, or tax adviser when balances, inventory costing, filed tax, payroll, or historical records differ. Never send passwords, license keys, bank credentials, taxpayer data, or an unrestricted company file through an unapproved channel.