Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    Glossary · Accounting & Bookkeeping

    ERP Open Balances

    Definition

    ERP open balances are the starting balances loaded into a new ERP or accounting system when it goes live. They are the closing balances of the old system at the cut-off date: every ledger account, unpaid customer invoice, unpaid supplier bill, stock item and tax balance. They are entered as opening entries, so the new system starts exactly where the old one stopped.

    • Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Read the full entry

    At a glance

    Category
    Accounting & Bookkeeping
    In this entry
    What it means for Indian businesses How it works · Example

    In practice

    01 What it means for Indian businesses

    A migration does not usually re-enter years of transactions. It loads the position at one date. If those starting figures are wrong, every later report in the new system carries the error.

    The test is simple: the new system's opening trial balance must equal the old system's closing trial balance at the cut-off. Where the cut-off is a year-end, the figures should also agree with the balance sheet already audited or filed for that year. Any difference must be traced, not written off to a suspense account.

    Customer and supplier balances should be loaded as open items: each unpaid invoice or bill with its own date and number. A net balance (one total per party) breaks ageing reports, bill-by-bill settlement, GST matching and balance confirmations.

    Every package has its own route. Tally sets an opening balance on each ledger and shows a "difference in opening balances" if they do not net to zero. Zoho Books and Odoo use an opening-balance adjustment or equity account. In each, a balance left in that account means the load has not tied.

    How it works

    02 How it works

    1. Lock the old system

      At the cut-off date.

    2. Extract the closing position

      Ledgers, parties, stock and tax balances.

    3. Load open items

      For debtors and creditors, invoice by invoice.

    4. Load the other balances

      Against the correct accounts.

    5. Prove the trial balance

      Reconcile opening to old closing until nothing is left in suspense.

    Worked example

    03 Example

    An example, not advice on your facts.

    A Lucknow retailer goes live on a new ERP.

    Item Amount (₹) How it is loaded
    Debtors 15,00,000 Invoice by invoice
    Creditors 9,00,000 Bill by bill (e.g. one supplier's ₹3,00,000 entered as its four unpaid bills)
    Closing stock 22,00,000 From the closing stock valuation
    Opening trial balance — Must equal the old system's closing trial balance

    The go-live is complete only when the two trial balances agree and the adjustment account is zero.

    Watch out

    04 Common mistakes

    • Balances that do not tie to the old closing trial balance.
    • Lump-sum debtors or creditors with no invoice detail.
    • A residue left in suspense or the opening-balance adjustment account.
    • A wrong opening date that does not match the cut-off.

    Need help with opening balances? See our Migration: Tally to Zoho Books or Migration: Tally to Odoo.

    Review and sources

    Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Talk to an expert

    Tell us what you need and the right person calls you back.

    🇮🇳 +91

      By sending this form you agree to our privacy policy.

      Get compliance due-date alerts on WhatsApp. Join →