Skip to main content

Finance operations

How to Verify Opening Balances After Moving Your Books

Verify opening balances after moving accounting software: match the trial balance, open invoices, advances and control accounts before routine posting begins.

8 min read

Short answer

Verify opening balances by comparing the new system's opening trial balance with the approved closing trial balance, account by account. Then match outstanding customer and supplier invoices, advances and supporting schedules to their control accounts, with every difference explained and corrected. Save the comparison and obtain the owner's or authorised finance reviewer's sign-off before routine posting begins.

Already seeing this in your business? Describe what is happening instead of reading to the end.

Which records should you agree before the transfer?

Start with one approved set of closing records and a clear cut-off: the point where entries stop in the old system and begin in the new one. Record the business, branches, currency and reporting period covered. Export the closing reports after the final approved adjustments, and keep a reference copy that nobody edits.

  • Closing trial balance, including account codes and debit or credit balances.
  • Customer and supplier open-item lists showing invoices, credit notes, part-payments and unallocated amounts.
  • Separate schedules for customer advances, supplier advances, staff advances and deposits.
  • Bank reconciliations, cash counts, stock valuation, fixed-asset schedules and loan statements where applicable.
  • A mapping from every old account to its destination account, including approved combinations or splits.

Name the person who approved these records. If closing adjustments are still pending, call the transfer provisional and keep routine posting on hold until you have an agreed starting point.

How should you compare the two trial balances?

Export the opening trial balance from the new system before adding fresh transactions. Compare it with the approved closing trial balance using the account mapping. Check each account's amount and debit or credit direction, then compare total debits and total credits. Matching totals alone do not establish that individual balances reached the right accounts.

Opening trial balance comparison sheet
CheckWhat to compareEvidence to retain
CompletenessEvery old account has a destination; every new opening balance has a source.Account mapping with any combinations or splits explained.
Amount and directionThe mapped closing balance agrees with the opening debit or credit.Side-by-side comparison showing each difference.
Report settingsBoth reports cover the same business, branches, currency and cut-off.Report headings and selected filters.
Unexplained accountsOpening adjustment, suspense and unmapped accounts contain no unexplained amounts.Supporting entries and approval for any legitimate balance.

Keep the original amounts visible when accounts are combined. If several expense accounts become one, show their individual closing balances and the combined opening amount. Investigate differences rather than changing the approved comparison to make it agree.

How do you verify outstanding invoices and credit notes?

Compare customer and supplier balances at invoice level, not just party level. For each open item, check the party, document reference, original document date, due date, currency and amount still unpaid. Include credit notes and unallocated receipts or payments. Preserve the original dates so the collection and payment lists remain useful.

For a partly settled invoice, verify both the remaining amount and the information needed to explain it. An illustrative invoice of Rs 50,000 with Rs 20,000 already received should leave Rs 30,000 outstanding. Do not transfer the full invoice as unpaid or bring the earlier receipt across again without a clear reason.

Compare each party's net balance, then compare the full customer and supplier lists with their respective control accounts. Review debit and credit items separately as well: a matching net balance can conceal a missing invoice and a missing credit of the same amount.

After sign-off, use the receivables collection routine guide and the weekly supplier payment run guide to turn the verified open items into working follow-up lists.

Where should advances and unallocated amounts sit?

Prepare separate checks for customer advances, supplier advances, staff advances and deposits. For each amount, retain the party, purpose, supporting reference and remaining balance. Confirm how it will be applied, repaid or reviewed. Do not clear an advance merely because the new software handles it differently.

For an unallocated customer receipt, establish whether it is an advance or belongs against an existing invoice. For an unapplied supplier payment, check the same question from the payment side. Ask your accountant to approve the treatment where the records do not establish the answer.

What proves that control accounts agree with their schedules?

A control account is the ledger total you compare with a detailed supporting list. For migration sign-off, record the opening ledger amount, the corresponding schedule total and any difference. Check receivables and payables first, then apply the same comparison to other relevant balances.

  • Bank: match the opening book balance to the approved bank reconciliation and retain outstanding items. Use the monthly bank reconciliation guide for the ongoing routine.
  • Cash: compare the opening balance with the approved cash count.
  • Stock: compare the opening ledger value with the approved stock valuation and check quantities by item and godown where relevant.
  • Fixed assets and loans: compare each ledger balance with the corresponding asset or loan schedule.
  • Tax balances: compare the transfer with approved schedules and relevant portal records, with reconciling items explained.

For tax balances, ask your CA to review unresolved differences between books, returns and portal records. Consult the official GST or income-tax portal for current requirements. This verification routine does not determine tax eligibility or replace a return reconciliation. Last reviewed: October 2026.

What can a matching total still hide?

Illustrative example: the approved customer control balance is Rs 1,25,000. It consists of Rs 90,000 due from one party and Rs 35,000 from another. The imported control balance is also Rs 1,25,000, but the new outstanding list shows Rs 1,00,000 and Rs 25,000 respectively.

The total agrees, yet Rs 10,000 sits against the wrong party. Collection follow-ups would therefore use incorrect amounts. Trace the affected documents, correct the allocation and rerun both reports. This is why the sign-off needs account, party and document checks.

What common mistakes should you avoid?

  • Comparing a final closing report with an opening report taken before the last import.
  • Accepting equal debit and credit totals without checking account mapping and balance direction.
  • Loading both summary balances and detailed entries without checking their combined ledger effect.
  • Replacing original invoice dates with the migration date.
  • Moving unexplained differences into suspense or capital simply to finish.
  • Allowing fresh entries in both systems without a controlled cut-off record.

Who should sign off before routine posting begins?

Have someone other than the preparer review the comparison where possible. In a small business, this may be the owner reviewing with the accountant. Keep one sign-off pack containing the approved closing reports, mapping, new opening reports, detailed reconciliations and correction record.

  • Every opening balance agrees with its approved source, including documented mapping changes.
  • Outstanding documents and advances agree with party balances and control accounts.
  • Every difference has a supported resolution and the corrected reports have been checked again.
  • The reviewer records approval, the cut-off and who may authorise later opening-balance changes.

Release routine posting only after this review. If you are transferring full transaction history or moving mid-year, agree the additional checks with your accountant, including period activity and year-to-date results. Opening-balance sign-off alone does not verify the whole history.

Sources and review

Published by ThynkBored. Published 25 October 2026. Content review completed 25 October 2026. The byline identifies accountability for the page; it does not represent an individual author, credential, professional certification, or evidence of CA, CS, accounting, or legal review.

  1. GST portal

    Goods and Services Tax Network. Accessed 25 October 2026.

    Supports: Official portal referred to for reviewing relevant GST records alongside approved tax-balance schedules; no statutory thresholds or migration procedures are attributed to it.

  2. Income Tax Department e-filing portal

    Income Tax Department, Government of India. Accessed 25 October 2026.

    Supports: Official portal referred to for current income-tax information and relevant account records; no statutory thresholds or migration procedures are attributed to it.

This guide provides a practical opening-balance verification routine, not an audit opinion or accounting, tax or legal advice. All worked-example amounts are illustrative. The checks must be adapted to the records and import method used. Full-history transfers, foreign-currency balances and unresolved closing adjustments need additional review. Confirm current tax requirements with the relevant official portal or your CA.

Start with the balances that do not agree

Describe whether the difference is in the trial balance, outstanding invoices, advances or a supporting schedule. ThynkBored can help organise a comparison and a clear sign-off routine before daily posting begins.

Share categories and approximate ranges only. Do not send trial balances, invoices, party details, bank statements, tax records, passwords, OTPs or files through the form. Agree a secure handoff first if records need review.

Diagnose this issue

A person reads every enquiry. We reply as soon as we can.

Questions owners ask

Is a balanced opening trial balance enough to approve a migration?

No. Also compare each mapped account with the approved closing balance, then check party balances, outstanding documents, advances and supporting schedules. Equal debit and credit totals do not establish that balances belong to the right accounts or parties.

Should I import invoices as well as customer and supplier totals?

Choose the opening-entry method before importing. If you need invoice-level collection and payment lists, verify how those documents affect the ledger. Avoid adding summary balances that duplicate entries already created by the document import.

What if the old closing records contain an error?

Refer the error to the accountant or authorised reviewer. Document the approved correction and its effect on both the closing reference and opening records. Do not quietly alter the imported amount or force agreement through an unexplained adjustment.

Can opening balances change after sign-off?

Allow changes only through a recorded approval process. Explain the reason, retain the supporting entry, rerun the affected comparisons and obtain renewed approval. Keep enough evidence to distinguish a closing correction from a new-period transaction.