Many businesses and accounting firms are moving client files from QuickBooks Desktop to QuickBooks Online. The conversion tool does most of the heavy lifting, but a clean migration depends on what you do before and after it. This checklist is the one our team works through on every migration.
Before you migrate
- Decide the scope. Full history, or opening balances plus open items? Full history keeps everything in one place; a summary migration is faster and often cleaner for very old files.
- Reconcile every bank and credit card account up to the cut-off date. Unreconciled items become much harder to fix after the move.
- Clear undeposited funds and review old uncleared cheques and payments.
- Clean up lists. Merge duplicate vendors, customers and items; make inactive anything you no longer use.
- Check the file size and features in use. Some Desktop features (certain inventory methods, advanced reporting, some payroll setups) work differently or not at all in Online.
- Run and save key reports as at the cut-off date: trial balance, balance sheet, P&L, AR and AP ageing. These are your validation baseline.
- Back up the Desktop file and keep a read-only copy.
During the migration
- Pick a quiet cut-off date — ideally a month-end.
- Pause data entry in Desktop once the export starts.
- Run the conversion and note any warnings or items it could not move.
After the migration
- Compare reports in Online against the baseline you saved: trial balance, AR and AP ageing, and bank balances should match.
- Reconnect bank feeds and set the feed start date so nothing is imported twice.
- Rebuild bank rules, recurring transactions and memorised reports.
- Re-link apps such as Dext, Hubdoc, Bill.com or payroll.
- Set user roles and permissions for your team and your outsourced bookkeepers.
- Run the first month-end close in Online with extra review.
Common pitfalls
- Bank feeds re-importing transactions already entered in Desktop.
- Sales tax settings that need reconfiguring.
- Inventory valuation differences.
- Unreconciled history that makes the first Online reconciliation impossible to tie out.
If you'd rather hand the whole project to a team that does this routinely, our cleanup and migration service runs it as a fixed-price project with validation before and after the move.