Loading…
Loading…
The order to load opening balances into ERPNext — masters, opening stock, GL and party balances — and how to reconcile every figure back to your legacy system before go-live.
30 checks · 6 sections
Getting opening balances right is what makes an ERPNext go-live trustworthy — if the trial balance, stock value and party outstandings don't match the legacy books on day one, nobody believes the reports that follow. This is a reference for the real ERPNext flow: load master data first, bring in opening stock through Stock Reconciliation, post opening GL and party balances against the Temporary Opening account, then reconcile every number back to your old system before you sign off. Work top to bottom — the sequence matters, because each stage depends on the one before it. Use it to brief your team and to sanity-check the work your implementation partner delivers.
Fix a cut-over date and freeze the legacy books + 3 more
Finalise the Chart of Accounts before any balance is posted + 4 more
Use a Stock Reconciliation with Purpose = 'Opening Stock' + 4 more
Confirm a 'Temporary Opening' account of account_type 'Temporary' exists + 4 more
Load customer outstandings with the Opening Invoice Creation Tool (Invoice Type = Sales) + 4 more
Trial Balance in ERPNext must equal the legacy trial balance + 5 more
All 30 checks across 6 sections as a clean branded Excel — each item with the guidance for why it matters, ready to share with your team. Free, no email required.
It's an account of type 'Temporary' that ERPNext uses as the counter-entry for opening balances — opening stock, GL Journal Entries and opening AR/AP invoices all offset against it. When every opening figure is loaded correctly, the Temporary Opening account nets to zero. A leftover balance is your fastest signal that something was missed or entered twice.
Use the Opening Invoice Creation Tool. Set Invoice Type to Sales for debtors or Purchase for creditors, add one row per outstanding amount with the party and due date, and it creates Sales/Purchase Invoices flagged is_opening = 'Yes' against the Temporary Opening account. This reproduces your ageing without re-billing goods. For net-only party balances you can instead post an 'Opening Entry' Journal Entry with the party set.
Use a Stock Reconciliation with Purpose set to 'Opening Stock'. Enter quantity, valuation rate and warehouse for each item (serial/batch items carry their identifiers via the serial and batch bundle), dated at your cut-over. This sets both quantity and value together, and with perpetual inventory the stock value posts to the GL so it can be reconciled to the inventory control account.
After loading everything, run the ERPNext Trial Balance at the cut-over date and match it to the legacy trial balance; match AR/AP Summary to the old ageing and Stock Balance to the legacy valuation. Then tie opening GST input/output and TDS ledger balances to your last filed GSTR/returns, so the first live return period starts from figures that already agree with what you've filed. Acube signs this off with your finance team before any live transaction is posted.
Get a clear plan, an honest timeline, and a fixed scope. Talk to a real expert today — whether or not you work with us.
Kochi (Kadavanthra & Infopark) · Thiruvananthapuram · across India & overseas · In business since 2011