Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Test opening balances before accepting an accounting migration

Compare the old and new ledgers at one cutoff, including customer balances, vendor balances, supporting schedules, and the first live transactions.

By Institution2 minute readPublished View sources
In this guide

Agree the source balance and cutoff

Choose the approved closing trial balance that will become the new system's opening position. Record the entity, currency, accounting basis, cutoff date, and unresolved items. A migration should not silently turn provisional balances into approved ones.

Decide whether historical detail or only opening balances and selected open transactions will move. Document what remains in the archive and how it can be retrieved. A smaller migration can be reasonable when its limits are understood and the historical records remain usable.

Reconcile totals and the detail behind them

Compare every opening account with the source and the approved account mapping. Then reconcile customer invoices, vendor bills, loans, assets, prepayments, and other relevant schedules. A trial balance that balances mathematically can still contain the wrong account classifications or missing customer detail.

For an illustrative $12,000 receivables opening balance, verify that the migrated unpaid invoices and credits total $12,000. An additional $12,000 opening journal on top of those invoices would duplicate the receivable. Confirm how the migration tool creates control balances before adding manual entries.

Test settlement across the cutover

Choose an invoice issued before migration and paid afterward, a prior supplier bill settled later, and a transfer crossing the cutoff. Confirm the new system applies each event to the correct opening item without creating new revenue or expense unnecessarily.

Check bank-feed download dates against the opening entries and imported history. Overlapping downloads need careful matching or duplicate handling through the platform's supported workflow. Do not accept a first bank reconciliation that was forced to agree through an unexplained opening-balance adjustment.

Sign off with exceptions that have owners

Keep the comparison, mapping, sample tests, and approved corrections together. Identify any missing attachments, unsupported balances, or unconverted history, with an owner and agreed resolution. The business should know what remains incomplete before the old system is canceled.

After the first full close in the new system, compare the result with the expected opening position and subsequent activity. Review recurring journals and integrations that may still be running in the old environment. Accept the migration when the new ledger can support the next accounting cycle and the historical evidence remains accessible.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.