Home / Insights / QuickBooks Desktop to Online Migration: A Practical Checklist
Guide

QuickBooks Desktop to Online Migration: A Practical Checklist

A step-by-step checklist for moving from QuickBooks Desktop to QuickBooks Online without losing data or breaking reconciliations.

FinanceHands team ·

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

  1. 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.
  2. Reconcile every bank and credit card account up to the cut-off date. Unreconciled items become much harder to fix after the move.
  3. Clear undeposited funds and review old uncleared cheques and payments.
  4. Clean up lists. Merge duplicate vendors, customers and items; make inactive anything you no longer use.
  5. 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.
  6. 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.
  7. Back up the Desktop file and keep a read-only copy.

During the migration

  1. Pick a quiet cut-off date — ideally a month-end.
  2. Pause data entry in Desktop once the export starts.
  3. Run the conversion and note any warnings or items it could not move.

After the migration

  1. Compare reports in Online against the baseline you saved: trial balance, AR and AP ageing, and bank balances should match.
  2. Reconnect bank feeds and set the feed start date so nothing is imported twice.
  3. Rebuild bank rules, recurring transactions and memorised reports.
  4. Re-link apps such as Dext, Hubdoc, Bill.com or payroll.
  5. Set user roles and permissions for your team and your outsourced bookkeepers.
  6. 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.

Free workflow review

See what an extra pair of finance hands could do for you next month.

Book a free 30-minute workflow review. We'll look at your volumes, your platform and your pain points, and propose a pilot with clear targets.