How to Move Your QuickBooks Desktop File to QuickBooks Online

Last reviewed 2026-07-17

Migrating your accounting data from QuickBooks Desktop to QuickBooks Online is a significant transition. While Intuit provides a built-in migration tool, moving a file that has been used for years often means carrying over outdated lists, bloated registers, or minor data corruption. To ensure a smooth conversion and a clean start in the cloud, we recommend preparing your desktop file long before you initiate the export.

Check Your Size and List Limits

QuickBooks Online has strict limits on list sizes and total targets. If your Desktop file has accumulated a massive number of customers, vendors, or inventory items over the years, the automated migration tool may fail or leave data behind. Review your lists and consider inactivating obsolete entries. If your file is exceptionally large, you might want to condense the company file to strip out years of old, closed transactions before attempting the move.

Verify and Rebuild Your Desktop Data

The QuickBooks Online import tool requires a perfectly healthy source file. If your Desktop data has structural damage—even if you haven't noticed any obvious symptoms—the export process will inevitably stall or fail. Run the standard Verify Data utility under the File > Utilities menu. If Verify reports any issues, run Rebuild Data immediately. For stubborn structural errors, such as target chaining failures or unreadable lists, you may need professional file repair before the file can be successfully migrated.

Clean Up Your Accounts

A migration is the perfect time to clean up your books. Clear out undeposited funds, reconcile your bank and credit card accounts to the most recent statement, and fix any lingering negative inventory values. The cleaner your balance sheet is on the Desktop side, the more accurate your new QuickBooks Online setup will be.

Execute the Migration

Once the file is verified and under the target limits, log into your QuickBooks Desktop account as the Admin. Go to the Company menu, select Export Company File to QuickBooks Online, and follow the on-screen prompts. You will need your QuickBooks Online login credentials. The process runs in the background, and Intuit will send you an email notification once the data is fully populated in your new account.

Review the Conversion Results

After receiving the completion email, carefully compare your Balance Sheet and Profit & Loss reports in QuickBooks Online against the Desktop versions for the same period. Discrepancies usually point to damaged transactions or list limits that were hit during the export. If you discover that critical historical data is missing or corrupted during the transition, reach out to our team to evaluate the file and recover the missing targets.