How to Move QuickBooks Desktop Data to QuickBooks Online
Switching from QuickBooks Desktop to QuickBooks Online is a common move for small businesses looking for cloud access, but the process is not always as simple as clicking a button. While the two products share the QuickBooks name, they run on entirely different databases, which makes a direct “port” of your file impossible. Instead, you migrate your data through a conversion process.
Use the Built-In Migration Tool
QuickBooks Desktop includes a built-in tool designed to export your company file to QuickBooks Online. To use it, open your Desktop file and sign in as the Admin. Go to the Company menu, select Export Company File to QuickBooks Online, and follow the on-screen prompts.
Before starting, make sure your Desktop file is in good shape. Run a Verify and Rebuild to catch data errors, and ensure your target lists (customers, vendors, and inventory items) are within QuickBooks Online’s limits.
What Transfers — and What Doesn’t
The migration tool brings over your chart of accounts, customer and vendor lists, products and services, and historical transactions. However, some elements do not convert cleanly. Common gaps include:
- Recurring credit card charges
- Certain payroll setup details
- Customized reports and report templates
- Budgets (depending on your Desktop version)
- Multi-currency historical balances
Review your file carefully after migration to confirm your opening balances and key accounts match.
When the Built-In Tool Fails
The export tool can fail or stall for several reasons: your Desktop file is too large, the file has structural damage, or your lists exceed QuickBooks Online’s maximum thresholds. If you see repeated errors or the process times out, do not keep retrying blindly — a damaged transaction or broken list element is usually the culprit.
If your file is oversized, condensing it first can bring it down to a size the Online migration tool can handle reliably.
The Manual Export Alternative
If the automated path simply will not work for your file, a manual conversion is the fallback. This involves exporting your Desktop lists and balances to Excel or CSV files, importing them into a fresh QuickBooks Online company, and entering your opening balances by hand. It is more labor-intensive, but it gives you full control over what comes over.
For complex files that fail the standard migration — especially those with heavy inventory, large transaction histories, or data damage — professional conversion services can map and rebuild the data directly into a format QuickBooks Online can accept.
Next Steps
Before committing, create a backup of your Desktop file and run a trial balance dated the day before you plan to start using QuickBooks Online. That report becomes your verification tool: once the migration finishes, compare the Online trial balance to the Desktop version line by line to confirm everything landed correctly.