Accounting Software Migration Checklist

Common SMB paths: QuickBooks Desktop to QBO, QBO to Xero, QBO or Xero to Sage Intacct or NetSuite. Source/target combination drives which migration tool you can use (Dataswitcher, Movemybooks, Intuit's QBDT-to-QBO converter, native Xero conversion service).

Cut over at a clean period boundary — first day of a fiscal quarter or fiscal year. Mid-month cutovers force partial-month reconciliations that fight you for the next two closes. Avoid cutting over during the week payroll runs or the week sales tax is due.

Name a single owner for each domain: Controller (chart of accounts, opening balances), AP lead (vendor list, open bills), AR lead (customer list, open invoices), Payroll lead (employee records, YTD totals if mid-year), IT (integrations and bank-feed connections). One owner per domain — not a committee.

Bring every operating account, savings account, and credit card current through the most recent statement. Migrating with unreconciled accounts carries the mess into the new system and obscures opening-balance variances. Document any uncleared items older than 90 days — most are stale and should be voided before cutover.

Merge duplicate accounts, deactivate unused ones, and collapse over-granular accounts that should have been classes or locations. A migration is the cheapest time to do COA cleanup — every junk account you carry forward becomes a class-tracking workaround in the target system.

Run the A/R aging summary and confirm it ties to the receivables control account on the trial balance. Same for A/P aging vs. payables. Variances usually mean journal entries were posted directly to the control account instead of through invoices/bills — fix these in source before they become harder to find in target.

For QuickBooks Desktop, take a portable company file (.QBM) and a full backup (.QBB). For QBO, export the audit log and run reports as PDFs and Excel for the trial balance, GL detail, and all sub-ledger detail through cutover. Store backups in two locations; you cannot re-derive these once the source is decommissioned.

Run the trial balance as of the cutover date in the source system and save as PDF and Excel. This is the document everything reconciles back to — it does not change after cutover. Have the partner or controller sign off on the TB before any data moves.

Set a closing-date password in QBO/Desktop or revoke edit permissions in Xero. Communicate the freeze to AP, AR, and payroll so no late entries hit the source after the TB is locked. Any post-cutover transactions in the source will create reconciliation differences nobody wants to chase.

Import the cleaned COA from cleanup. Map account types carefully — QBO and Xero handle Other Current Asset, Fixed Asset, and Equity differently than Desktop or Intacct. Set up classes/locations/tracking categories before any transactions land.

Import the cleaned vendor list with 1099 flags and tax IDs, and the customer list with default tax codes and payment terms. Verify foreign-currency customers/vendors carry the correct currency setting if the target system supports multi-currency.

Run the migration tool (Dataswitcher, Movemybooks, native conversion, or CSV import). Expect unsupported items: certain memorized transactions, attached documents, audit-log history. Document each unsupported category in the variance log so it doesn't surprise anyone in reconciliation.

Run the trial balance in the target system as of cutover and compare line-by-line to the locked source TB. Every account should match to the penny. Differences usually trace to rounding on multi-currency, sales-tax payable splits, or retained-earnings rollover handled differently across systems.

Walk each variance to root cause: unsupported transaction type, FX rate difference, or sub-ledger control account miscategorized. Document the adjusting JE for each variance with a memo referencing the source-system transaction. Do not close out reconciliation with unexplained differences; they compound.

Run the A/R aging summary and A/P aging summary in the target system and compare totals and bucket distribution (current, 30, 60, 90+) against source. If buckets don't match, the import used the wrong invoice/bill date and aging calculations will be wrong for collections and partner pay decisions.

Run role-specific sessions: AP (entering bills, approval workflow, payment runs), AR (invoicing, applying payments), bookkeeper (bank rec, JEs, month-end close), reviewer (reports, dashboards). Record each session and post in the team's shared drive — turnover within a year is common, and the recording is the onboarding asset.

Rewrite each existing SOP to reference the target-system menus, button names, and report locations. Generic procedures ("reconcile bank account") don't survive a system change; staff need screenshot-level guidance for the first close in the new system.