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.
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
- Lock the old system
At the cut-off date.
- Extract the closing position
Ledgers, parties, stock and tax balances.
- Load open items
For debtors and creditors, invoice by invoice.
- Load the other balances
Against the correct accounts.
- 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.
