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 doesn't carry over
QuickBooks Online is not a copy of Desktop with a new coat of paint. It's a different system, and a handful of things do not convert cleanly:
- Reconciliation reports. Transactions come across, but your historical reconciliation reports do not. Save them as PDFs first, or you lose the paper trail.
- Memorized reports and most customizations. Custom report layouts don't convert. Expect to rebuild the reports your team relies on.
- The audit trail. Desktop's audit history doesn't come with you; Online starts its own log from day one.
- Inventory valuation. Desktop values inventory at average cost; Online (Plus/Advanced) uses FIFO. Quantities carry, but valuation can shift, so inventory asset and COGS may not match exactly.
- Payroll history is limited, and some recurring/memorized transactions need to be rebuilt.
Check your file size before you start
QuickBooks Online won't import a Desktop file above roughly 750,000 targets (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 (in Desktop, Company → Export Company File to QuickBooks Online) rather than re-keying. 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.
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 from the FIFO change 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, re-create recurring transactions, rebuild your key reports, re-add users and their permissions, restore your invoice template and logo, 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 we do.
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, roughly 750,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.
This is general guidance, not a substitute for your accountant's judgment on your specific books.