Most QuickBooks Desktop-to-Online migrations don't fail loudly. The file moves over, everything looks roughly right, and the trouble shows up weeks later when a balance doesn't tie out and nobody can say when it drifted. The good news: that failure mode is avoidable. It comes down to knowing what will and won't carry across, taking a clean "before" snapshot, and running a short list of checks afterward.
Know what carries over, and what doesn't
QuickBooks Online is not a copy of Desktop with a new coat of paint. It's a different system. Most of your data comes across, some of it changes shape on the way, and some of it doesn't come across at all. This is Intuit's own list, cut down to what matters in a small business's file:
| Comes across | |
|---|---|
| Chart of accounts | Every account, with an Online "detail type" added that you can change later. |
| Customers and vendors | Names, contact details, addresses, notes, and custom fields. |
| Employees | Active and inactive, with wages and year-to-date balances, when payroll moves to QuickBooks Online too. |
| Bank rules | Rules made in Express and Advanced mode. |
| Attachments | Files of 30 MB or less stored on your computer's hard drive. |
| Multicurrency | Settings and transactions, on the Plus and Advanced plans only. |
| Favorite reports | The reports on your favorites list. |
| Comes across, but changes | |
| Jobs | A job with no jobs under it becomes a project. Every other job becomes a sub-customer. |
| Items | Become products and services. Sub-items more than five levels deep are flattened to the fifth. |
| Group items | Become bundles, which aren't tracked as inventory. |
| Assemblies | Show as a single inventory item on sales. |
| Inventory valuation | FIFO and average cost both carry over, but Online recalculates inventory, so inventory asset and COGS may not match exactly. |
| Memorized transactions | Become recurring transactions. Groups are lost, and each one keeps its next date but not its start date. |
| Paychecks | Come across as regular checks. The current year's pay is copied as lump sums. |
| Reconciled transactions | Keep their R (reconciled) and C (cleared) marks. |
| Credit card charges | Become expenses. |
| Item receipts | Become bills. |
| Early-payment discounts | Customer discounts become credit memos. Discounts you took from vendors become vendor credits. |
| Estimates | Active estimates are marked Closed, and inactive ones Rejected. |
| Sales orders | Intuit's own pages disagree. Its transfer list says open and closed sales orders come across, and its list of matching terms says Online has no sales orders. Check on your plan before you count on them. |
| Open purchase orders | Don't show items received until each one is linked to its bill. |
| Inactive customers | One with an open balance comes across active. |
| Sales tax | Some of it moves as journal entries, and past sales tax payments land on the wrong filings. Intuit's fix is to delete them and record them again in Online. |
| Doesn't come across | |
| Reconciliation reports | Your historical reconciliation reports do not come across. Save them as PDFs first, or you lose the paper trail. |
| Memorized reports | Custom report layouts don't convert. Expect to rebuild the reports your team relies on. |
| The audit trail | Online starts its own log from day one. |
| Users and permissions | Every user has to be invited again from Online. |
| Bank connections | Reconnect each one. Uncategorized transactions still waiting in a bank feed are lost. |
| Custom form templates | Your logo moves. The templates don't. |
| Some list fields | Customer type, price level, and credit limit; job status and description; vendor type and 1099 ID; custom fields on items and employees. |
| Also left behind | Units of measure, the To Do list, pending sales, and past mileage, which has to be entered again by hand. |
Source: Intuit, "Learn how features and data transfer from QuickBooks Desktop to QuickBooks Online", updated 29 September 2026. Intuit changes this list, so check it again close to your move.
Check your file size before you start
QuickBooks Online won't import a Desktop file with 4,000,000 targets or more (Desktop shows the count under Product Information; press F2). A file over the limit needs to be condensed, or you start fresh with lists and balances only. Find this out before migration day, not during it.
Take a clean "before" snapshot
Everything after this hinges on having something to compare against. In Desktop, first reconcile every bank and credit-card account up to your cutover date. Then export and save, as of that same date:
- Balance Sheet: both accrual and cash basis
- Trial Balance
- Profit & Loss for the year
- A/R Aging Summary and A/P Aging Summary
- Every account's most recent reconciliation report
Save them as PDF or Excel and set them aside. This is your source of truth for verifying the move.
Run the migration on a quiet day
Use Intuit's built-in export rather than re-keying. In Desktop Pro or Premier, go to Company, then Migrate this company file to QuickBooks Online, then Export Your Company File to QuickBooks Online. In Enterprise, press Ctrl+1 to open Product Information, then Ctrl+B+Q together to open the export window. Pick a time when no one is working in the file, and don't touch either copy while it runs. Migrations are much easier to trust when nothing changed mid-flight.
Time the Online side too. Once the QuickBooks Online company exists, you have 90 days to move your Desktop data into it, or 180 days if your accountant set it up. One of Intuit's own error pages still gives 60, so create the Online company when you're ready to move, not weeks before.
Verify before you trust the numbers
This is the step people skip, and it's the whole point. In the new Online company, run the same reports as of the same cutover date and compare them to your snapshot:
- Balance Sheet and Trial Balance (accrual) should match to the penny.
- A/R and A/P aging totals should match your snapshot.
- Inventory quantities should match; expect a valuation difference if the costing method changes, and reconcile it deliberately rather than ignoring it.
If accrual matches but cash basis doesn't, that's usually normal timing behavior. But confirm it, don't assume it.
Then rebuild what didn't come across
Once the numbers tie out: reconnect bank feeds, check your recurring transactions, rebuild your key reports, re-add users and their permissions, rebuild any custom invoice templates, and confirm reconciled status on migrated accounts (keep those saved reconciliation PDFs handy). Spot-check a sample of real transactions across a few months to make sure detail, not just totals, looks right.
When to bring in help
A clean, small file with no inventory is a reasonable DIY. Inventory-heavy businesses, payroll, multi-currency, files near the size limit, or anything where the balances have to be exactly right for a lender or auditor are worth a second set of hands. That's the kind of migration I do.
Ten Rivers Systems handles technical setup, configuration, and data migration only and does not provide accounting or tax advice. I am not an accountant or tax adviser. How you keep your books and what you owe stays between you and your own professionals.
Common questions
Does everything transfer from QuickBooks Desktop to Online?
No. Transactions and lists come across, but historical reconciliation reports, memorized and customized reports, the audit trail, and most payroll history do not. Save reconciliation reports as PDFs before you migrate, and plan to rebuild the reports your team relies on.
How do I verify the migration worked?
Run the Balance Sheet and Trial Balance on an accrual basis in both systems as of the same cutover date. They should match to the penny. Then compare A/R and A/P aging totals against the snapshot you saved before migrating.
Is there a file-size limit for moving to QuickBooks Online?
Yes. The file has to be under 4,000,000 targets (press F2 in Desktop to see your count). A file over the limit needs to be condensed first, or you start fresh in Online with lists and balances only.
