Module 05 · Bookkeeping Software

6 Migration Mistakes That Corrupt Your Opening Balances

Accounting software data migration errors often start with mismatched opening balances, wrong account mapping or skipped parallel runs. Learn to fix each.

6 min readLesson 11 of 13 in this moduleUpdated 2026-08-25

A failed migration to new accounting software rarely announces itself with a crash or a visible data-loss event. It shows up quietly instead — a wrong opening balance, a mis-mapped account — sitting underneath every report the new system produces until someone finally notices the numbers don't add up. Accounting software migration mistakes trace back to the setup almost every time, not to the software itself. If you haven't started the switch yet, how to migrate to accounting software walks through the whole process; this article is specifically about where it goes wrong.

Key takeaways

  • The opening trial balance in your new software must have total debits equal to total credits before you enter a single new transaction.
  • Most migration failures come from six specific, avoidable mistakes — not from the software itself.
  • An opening balance error doesn't stay contained to one month. It's carried forward into every report produced afterward, until it's found and corrected.
  • A short parallel-run period, recording the same transactions in both the old and new system, is the cheapest insurance against most of these mistakes.
  • Bringing your accountant into migration planning early, not after something looks wrong, catches mapping errors before they're posted.

Why opening balances are the whole game

Every one of these mistakes ends the same way: a wrong number sitting at the top of your new ledger. Because a general ledger is cumulative, an error in the opening balance doesn't get corrected by time — it's added to every transaction that comes after it, and it stays wrong in every report until someone traces it back to its source and fixes it. That's what makes migration different from ordinary bookkeeping error-checking: you get one setup, and everything downstream depends on it being right. If any of the terms below are unfamiliar, the accounting software glossary defines each one plainly.

1. Opening balances that don't match the old system's closing balances

This is the single most common mistake, and the easiest one to prevent. The opening trial balance in your new software should be an exact copy of the old system's closing trial balance as of the agreed cutover date — same accounts, same figures, debits equal to credits. If cash showed $18,000 in the old system on 31 January, it needs to show $18,000 in the new one on 1 February, not a re-estimated or rounded figure typed in from memory.

Verify before you enter a single new transaction

Once new transactions start posting against a wrong opening balance, correcting it means untangling every transaction that followed — not just fixing one line. Verify the opening trial balance balances (debits = credits) and matches the old system's final figures before anyone records anything new.

2. Migrating far more historical detail than you need

The instinct to bring across "everything, just in case" is understandable, but re-entering years of line-by-line transaction history rarely gets referenced again and multiplies the chance of a transcription error somewhere in the pile. Most migrations only need: summarized opening balances for prior periods, plus full detail for open invoices, unpaid bills, and the current fiscal year. Anything older stays safely archived in the old system or an export file — it doesn't need to live inside the new one.

3. Wrong account or tax-code mapping

Your old chart of accounts and your new software's default one rarely line up one-to-one. A sale mapped to the wrong revenue account, or a tax code that doesn't match your actual registered rate, won't throw an error — the entry will post cleanly and simply be wrong, sitting quietly in the wrong bucket until a report or an accountant catches the mismatch. Build an explicit mapping table — old account name → new account name — before importing anything, and have someone check it line by line rather than trusting an automatic match.

4. Skipping the parallel-run period

Running the old and new systems side by side for a short period — entering the same real transactions into both, as described in the migration readiness checklist — is the cheapest way to catch every mistake on this list before it's permanent. Skipping straight from the old system to the new one, live, on day one removes your only chance to compare two independent sets of numbers and see where they disagree.

A one-month parallel run

A café owner migrating from a spreadsheet keeps recording daily sales and expenses in the old spreadsheet for one full month after go-live, alongside entering the same transactions in the new software. At month-end, both systems' totals for revenue, cash, and outstanding bills are compared line by line. Two mismatches turn up — a supplier invoice entered twice in the new system, and a sales tax rate that mapped to the wrong percentage — both caught before they ever reached a real filed report.

5. Leaving the accountant out of the planning

An accountant reviewing the account mapping and opening balances before go-live catches exactly the kind of errors described above — a misclassified account, a tax code that doesn't match your registration, an opening balance that's off by a rounding error nobody else would notice. Bringing them in only after something looks wrong means the clean-up happens after months of transactions have already posted on top of the mistake, which is a much bigger job than reviewing the setup once, up front.

6. Going live without reconciling first

A migration that goes live without first reconciling bank, customer, and vendor balances against original source documents (bank statements, unpaid invoices, supplier statements) is trusting that the old system's own records were already perfect. They usually aren't perfectly current — a customer payment might be sitting unrecorded, a vendor credit note forgotten. Reconciling each balance against an independent source before cutover catches these gaps while they're still small and traceable, instead of after they've been carried forward as "opening balance" into a system with no memory of how that number was built.

Mistake The fix
Opening ≠ old closing balance Copy the old system's final trial balance exactly; verify debits = credits
Excess historical detail migrated Bring summarized balances + current-year detail only
Wrong account/tax mapping Build and review an explicit old-account → new-account map first
No parallel-run period Run both systems side by side for at least one month
Accountant left out Involve them in mapping and opening-balance review before go-live
No reconciliation before cutover Reconcile bank, AR and AP against source documents before go-live
Doing this in Reyuko

Reyuko's Trial Balance report is built specifically to catch mistake #1 above: it shows every Level-4 account's debit or credit balance, placed by its normal-balance side, with a total debit and total credit figure and a clear balanced-or-unbalanced indicator — computed live from the same ledger balances used elsewhere in the app, not a separately maintained number. Before entering a single new transaction into a fresh Reyuko ledger, running this report against your migrated opening balances is a direct way to confirm debits equal credits, the same check described in mistake #1.

Reyuko's account structure is also a fixed four-level Chart of Accounts (Assets, Liabilities, Equity, Revenue, Expenses at the top level, down to individual ledger accounts), which is worth reviewing against your old system's account list — the explicit mapping exercise described in mistake #3 — before you migrate any balances across.

Before you go live

Run through this once, out loud, with whoever is doing the migration: does the new opening trial balance balance? Does every account map to something specific, not a guess? Has an accountant reviewed it? Has at least a month of parallel entries been compared? If any answer is no, that's not a reason to abandon the migration — it's the specific thing to fix before go-live, using the migration readiness checklist as a working list rather than this article's warning signs. And if you haven't picked a system yet, the criteria for choosing accounting software are worth settling before any of the mistakes above become possible.

Frequently asked questions

What are the most common mistakes when migrating accounting software?

The most common ones are opening balances that differ from the old system's closing balances, account or tax-code mapping errors, copying far more historical detail than needed, skipping a parallel run, and going live without reconciling bank, customer and vendor balances. Most of these come from setup rather than the software, so they can be prevented before cutover.

Why does an opening error show up in every later report?

A general ledger is cumulative, so a wrong opening balance is carried into every transaction posted after it. Time does not correct it. Each report from the cutover date onward stays wrong until someone traces the error back to its source and fixes it, which is why the opening trial balance must match the old system exactly from day one.

How do I check that the new trial balance matches the old one?

Before entering any new transaction, pull a trial balance from the new system and check two things. Total debits must equal total credits, and every account balance must match the old system's closing trial balance for the cutover date. If cash was 18,000 in the old system, the new system should show exactly 18,000, not a rounded or remembered figure.

What happens if accounts are mapped to the wrong categories?

The entry still posts without an error message, so the mistake stays hidden. A sale mapped to the wrong revenue account, or a tax code that does not match your registered rate, sits in the wrong bucket until a report or an accountant spots it. Build an explicit old-to-new account list and review it line by line before importing anything.

Can a parallel run catch migration errors?

Yes. Record the same real transactions in the old and new systems for two to four weeks, including one month-end, then compare revenue, cash and outstanding bills line by line. Duplicate entries, missed accounts and wrong tax rates usually show up this way while they are still small. Going live directly on day one removes your only chance to compare two separate sets of numbers.

When should I bring my accountant into a migration?

Involve your accountant during migration planning, before go-live, so they can review the account mapping and the opening balances. Bringing them in only after something looks wrong means the clean-up happens after months of transactions have posted on top of the error, which is a much bigger job than one setup review.

Get the opening balance right the first time

Reyuko's Trial Balance report shows a live debit/credit total with a balanced-or-not indicator, so a mismatched opening balance is visible before you post a single new transaction.

Download Reyuko freeSee what's included