How to migrate accounting software
The free conversion tool will tell you this is a one-click move. It is not. Here is the honest switching-cost reality: what actually transfers, what the converter quietly skips, what breaks, and the realistic timeline and year-end checklist for changing accounting software without leaving holes an auditor will find.
The conversion tool moves data. It does not move trust.
Let me puncture the marketing up front. The free converters — Xero's "convert from QuickBooks," Intuit's import from Xero, the Jet Convert and Dataswitcher engines behind them — are genuinely good at the easy 80%: your chart of accounts, customers, suppliers and the last year or two of transactions land in the new system. That is the part everyone shows you. It is also the part that was never the risk.
The switching cost lives in the 20% they do not mention. Document attachments do not come across. Payroll history arrives incomplete or not at all. Every transaction lands unreconciled, so your bank reconciliation history — the thing that proves the books are right — resets to zero. Memorized and recurring transactions vanish. Bank feeds are subscriptions, not data, so they break and must be reconnected. And most free conversions stop at the current and prior fiscal year; older history costs extra or has to be exported to spreadsheets and archived. Unimpressive to demo, but it is exactly what your accountant, your auditor and the tax authority care about. Plan the move around verifying correctness, not around clicking convert — and pick the destination using how to choose accounting software.
The six phases of an accounting migration
The single highest-leverage decision is when. Migrate at the start of a new fiscal year if you can, the start of a quarter if you cannot. Mid-period switches force you to keep two systems for the same months and reconcile both — the most common reason a migration turns into a slog. Set a clean cutover date and freeze new entry in the old system after it.
Garbage in, garbage out — and the converter will faithfully carry your mess across. Fully reconcile every bank and credit-card account, clear suspense and undeposited-funds balances, and confirm your trial balance ties out before you migrate. A clean source is what lets the new system's opening balances match to the penny; an unreconciled source guarantees you chase differences for weeks.
Before you touch the conversion tool, manually pull what it skips: download all invoice and bill attachments, export full payroll reports and employee tax details, and save complete financial statements and the general ledger for every year you are required to keep — typically beyond the two years the free tool moves. Store these as PDFs and spreadsheets; they are your record when migrated history falls short.
Run the migration, then do the work the tool will not: compare the trial balance, balance sheet and aged receivables/payables in both systems as of the cutover date. They should match exactly. Re-enter recurring and memorized transactions by hand, rebuild your chart-of-accounts tweaks and tax codes, and reconnect bank feeds — they are subscriptions, so every account re-authenticates in the new tool.
Do not trust the new system on faith. Run one full cycle — a complete month of reconciliation and, if you have staff, at least one live payroll run — and check the outputs against the old system or your exported reports. Payroll is where migrations quietly break: tax withholdings and year-to-date totals are the most likely figures to land wrong, and the cost of getting them wrong is a compliance problem, not a cosmetic one.
Once balances tie out and a cycle has run clean, switch fully to the new tool — but keep read-only access to the old one through at least your next tax filing. The attachments, prior reconciliations and audit trail that did not migrate live only there, and you will want them the moment an accountant or the tax authority asks. Cancel after the filing, not before, and write down the new month-end process so the team does not relearn it.
The export gotchas, named
Some tools make this harder than others, and we score it. QuickBooks Online and Xero at least offer official, free conversion paths between each other — the friction is the skipped data above, not the move itself. The genuine lock-in risk is at the heavy end: NetSuite migrations are real projects with implementation partners and cost, which is the price of its depth, and consolidating off Sage's older desktop lineage can mean wrangling exports by hand. The lightweight tools cut the other way: leaving Wave or FreshBooks is easy precisely because there is less history and structure to carry. Weigh exit cost before you enter, not after.
The marketing says yes; the reality is no. Free conversion tools like Xero's or Intuit's move the chart of accounts and a slice of transactional history, and that lulls people into thinking the job is done. What they quietly skip — attachments, payroll history, reconciliation status, memorized transactions, and usually anything older than the current and prior fiscal year — is precisely the part an auditor or a nervous accountant cares about. The data move is easy; getting your books verifiably correct afterwards is the work.
Reliably missing: document attachments on bills and invoices, payroll history and employee tax details, bank reconciliation status (transactions arrive unreconciled), memorized or recurring transaction templates, and bank feeds, which are subscriptions you reconnect rather than data. Most free conversions also cap history at about two fiscal years; older data costs extra or must be exported to spreadsheets and kept for the record.
At a clean period boundary — ideally the start of a new fiscal year, second-best the start of a quarter. Migrating mid-period forces you to reconcile two systems for the same months and is the single biggest avoidable cause of a painful switch. Reconcile and close the old books fully first, migrate with opening balances that tie out, then run the new system from a clean start date.
A sole trader on a simple cash basis can switch in a day or two. A small business with payroll, inventory, multi-currency and a year of attachments is realistically two to six weeks of elapsed time, including a parallel-running period where both systems are live and you verify the first reconciliation and a payroll run in the new tool before trusting it.
No. Keep it on read-only access for at least a full reporting cycle, and ideally through your next tax filing, so you can reference attachments, prior reconciliations and audit trail that did not migrate. Cancelling early to save a month's fee is how businesses lose the source records they need exactly when an auditor or the tax authority asks for them.
One email when the rankings move. The shortlist, the tradeoffs, the price changes. No filler.