Migrating a QuickBooks Desktop Company File to QuickBooks Online

Last reviewed 2026-08-04 4 min read

Export a Desktop company file to QuickBooks Online without losing data: covers file-size prep, list limits, export execution, and post-conversion trial-balance verification.

Migrating a company file from QuickBooks Desktop to QuickBooks Online is a one-way operation: once the conversion completes, there is no built-in path back. Our engineers treat this as a staged project with checkpoints at each phase, because the most common problems — truncated lists, unsupported transaction types, and trial-balance mismatches — surface only after the export has already run. This playbook walks through the full sequence: preparing the Desktop file, executing the export, and reconciling the result.

Assess File Size and List Counts

Open the Desktop file in single-user mode and press F2 to open the Product Information window. Record the file size and the total list counts (Chart of Accounts, Customers, Vendors, Employees, and Items). QuickBooks Online enforces a hard ceiling on overall list entries; files that approach or exceed that limit will fail mid-export or arrive with missing records. If the Desktop file is oversized, run a SuperCondense before attempting the migration to bring the list count and file size into a safe range.

Run Verify and Rebuild

Before exporting, run Verify Data from the File > Utilities menu in single-user mode. If Verify reports errors, run Rebuild Data and then Verify again. Repeat until Verify passes clean. Attempting to export a file with structural damage will carry those errors into the Online environment, where they are far harder to isolate and repair. If Rebuild cannot resolve the errors, the file needs repair work before migration proceeds.

Clean Up Unsupported Elements

QuickBooks Online does not support every transaction and list type that Desktop does. Review the file for the following and address each before exporting:

Estimates, Sales Orders, and Purchase Orders: These may convert as non-posting transactions or may not carry over with full detail.
Inventory Assembly items: Online handles inventory differently; assembly items require manual reconciliation after migration.
Sub-customers and jobs: The job-costing structure in Desktop does not map one-to-one with Online's project hierarchy.
Memorized transactions: These frequently do not migrate and must be recreated manually.
Payroll service links: Historical payroll data transfers as static records; live payroll setup is a separate step.

Document what exists in the Desktop file so you have a checklist for post-migration verification.

Set the Target Online Subscription and Accountant Access

Ensure the QuickBooks Online subscription is active and at the correct tier before initiating the export. Grant Accountant access to the Online company so an engineer or advisor can review the converted file independently once the migration completes. Confirm the Online subscription supports the feature set the Desktop file relies on — most critically, advanced inventory, class tracking, and location tracking.

Execute the Export

With the Desktop file open in single-user mode as the Admin, go to Company > Export Company File to QuickBooks Online. Sign in with the Intuit account linked to the Online subscription. Select the correct Online company from the list and choose the export scope — full export or a date-restricted export if you are migrating only recent history.

The export runs as a background process on Intuit's servers. Do not close Desktop, log out, or let the machine sleep while the upload is in progress. Large files can take several hours to fully process on the server side after the upload itself completes.

Verify the Trial Balance

Once you receive the confirmation email that the migration is complete, open the Online company and generate a Trial Balance for the most recent month-end. Compare it line-by-line against the Desktop Trial Balance for the same date. Mismatches most commonly trace to unsupported transaction types that dropped during conversion, rounding differences on multicurrency files, or inventory valuation discrepancies.

Run a Profit and Loss comparison and a Balance Sheet comparison for the same period. Investigate every variance before beginning live work in the Online file.

Reconcile Bank and Credit Card Accounts

For each bank and credit card account, compare the last reconciled statement balance in Desktop against the opening balance in Online. If the balances do not match, note the discrepancy and reconcile the difference manually. This step catches transactions that posted in Desktop after the export cutoff date but before the Online go-live date.

Rollback Point

Because the migration is one-way, the rollback strategy is to preserve the Desktop file as the system of record until every verification check passes. Keep the final Desktop backup in a secure location and do not make further entries in Desktop after the agreed-upon cutoff date until the Online file is fully validated. If the conversion is unacceptable and you need to return to Desktop or move the other direction, the original Desktop file must remain intact and untouched.

A clean outcome is a QuickBooks Online company file where the Trial Balance, Profit and Loss, and Balance Sheet all match the Desktop source as of the cutoff date, every bank and credit card account reconciles, and the list counts align with the pre-migration inventory.