Disclaimer: QuickBooksUsers.com is an independent service operated by E-Tech Corporation and is not affiliated with, endorsed by, or sponsored by Intuit Inc. "QuickBooks" is a registered trademark of Intuit Inc., used for identification and reference purposes only. See our Terms of Service.

QuickBooks

Switching From QuickBooks Desktop to QuickBooks Online

QuickBooksUsers.com TeamUpdated 2026-08-052 min read

If you are transitioning from QuickBooks Desktop to QuickBooks Online, a little preparation goes a long way. The move is usually straightforward, but the condition and size of your Desktop file determine whether the migration succeeds cleanly or stalls out partway through.

Before You Start

QuickBooks Online has a target limit of 750,000 targets. If your Desktop file is approaching or exceeding that number, importing it directly can cause the process to fail or result in a sluggish online file. Running a condense on your Desktop file first is often the best way to bring the target count down and ensure a smooth import.

Prepare Your Desktop File

Take a few standard housekeeping steps before exporting:

  • Run Verify Data and Rebuild Data in QuickBooks Desktop to catch and repair any structural corruption.
  • Reconcile all bank and credit card accounts up to your final Desktop cutoff date.
  • Clean up undeposited funds and resolve any lingering negative inventory quantities.
  • Make a full backup (.qbb) of your company file and keep it somewhere safe.

Export From Desktop

With your file cleaned up, sign in to QuickBooks Online from inside Desktop. Go to Company, select Export Company File to QuickBooks Online, and follow the on-screen prompts. You will choose which Online subscription to map to, then authorize the upload. Depending on file size, the import can take several minutes to a few hours.

What Transfers — and What Does Not

Most of your core data makes the trip, including customers, vendors, chart of accounts, products and services, and historical transactions. However, some elements do not convert perfectly:

  • Payroll data and employee earnings setup usually need to be reconfigured in Online.
  • Inventory valuation can occasionally shift if your Desktop file uses Advanced Inventory or older Average Cost calculations.
  • Custom reports and report formatting generally have to be rebuilt in the Online interface.

What to Do If the Import Fails

Large files or files with underlying data damage are the most common reasons a migration stalls. If your file is too large to bring over cleanly, condensing it first can shrink the target count and strip out years of old, closed transactions so the Online version stays fast and manageable. If the export fails outright due to data errors, repairing the Desktop file before trying again is usually the fastest path to a successful migration.

Once the import finishes, run a trial balance in QuickBooks Online and compare it to the same report in Desktop as of your cutoff date. If the numbers match, you are clear to close out Desktop and pick up where you left off.

Need Professional Help?

Contact Us