How to switch accounting software without losing your history

The reason most businesses never leave their accounting software isn't price or features. It's fear of the switch itself: years of invoices, payments and reconciliations that might not come across intact, and an accountant who'll find out at tax time.

That fear is reasonable, because most migrations are never verified. Data gets copied, nobody checks the totals, and the new system starts life a few hundred dollars off. A good switch is built around proving the books match before you turn the old system off.

Pick the right moment

The cleanest time to switch is right after a period you've closed: the end of a quarter or, best of all, the end of your fiscal year after taxes are filed. Your opening balances are final and your accountant has already signed off on them.

Before you move anything

1. 1Reconcile every bank and credit card account in the old system through the last statement date.
2. 2Clear out stale items: old undeposited payments, duplicate customers, invoices you know you'll never collect.
3. 3Run and save the reports you'll compare against: trial balance, balance sheet, profit and loss for the year, A/R aging and A/P aging, all as of the same date.
4. 4Export your lists (customers, vendors, products, chart of accounts) as a backup, even if the new system imports them directly.

Move the data

If you're coming from QuickBooks Online, MitoBooks imports directly: lists, accounts and transactions. From anything else, import your lists from CSV and enter opening balances with one journal entry against Opening Balance Equity. The import guide covers both.

The check that matters: the trial balance

A trial balance lists every account with its balance on a given date. If your new system's trial balance matches the old one account by account, everything built on it (the balance sheet, the profit and loss, your aging reports) will match too.

MitoBooks runs this comparison for QuickBooks Online imports automatically and shows any account that differs. Common causes are payroll and inventory cost, which QuickBooks doesn't share through its connection. One adjusting entry brings them into line. See the Trial Balance guide for more.

After the move

• Set a closing date at the switch date so the imported history can't change by accident. See Closing the books.
• Run both systems in parallel for one month if you can, then compare the month-end reports.
• Keep read-only access to the old system until your next tax filing is done.
• Tell your accountant the switch date and send them the matching trial balances.