Opening balances
Who this is for: an owner or bookkeeper who wants Bakulai to start from the same position the old books closed at.
What an opening balance is
Section titled “What an opening balance is”Your old app closes on a date. On that date your business owns things, owes things, and has some equity. Those closing figures become Bakulai’s opening figures. Nothing about how you got there moves — no past invoices, no old payments, just the position.
That position arrives in separate steps, because ERPNext refuses to take them all through one door.
The cutoff date
Section titled “The cutoff date”Everything hangs off it. The cutoff date is the last day you used the old app — the date your balance sheet, your stock report and your aging reports are all printed for.
- It cannot be in the future, and it cannot be many years back. Opening balances come from books that are already closed.
- Every opening document is dated the cutoff date itself, not the day you ran the migration. That matters: a report with an “opening” column reads documents dated on the cutoff and ignores one dated a day later.
- Most people pick the last day of a month.
Three doors, not one
Section titled “Three doors, not one”opening_gl — the opening journal. Your balance sheet becomes one Journal Entry, marked as an opening entry and dated to the cutoff. Cash, fixed assets, loans, capital — the ordinary balance sheet lines.
opening_stock — opening stock. Stock does not go in a journal; ERPNext rejects a journal line to a stock account. Your stock report becomes a stock count instead, per item per warehouse.
opening_ar_ap — unpaid invoices. A receivable is not a lump sum, it is a list of people who owe you. Each aging line becomes its own opening invoice, so you can collect against it by name.
Rows that go somewhere else
Section titled “Rows that go somewhere else”A balance sheet carries lines the opening journal is not allowed to post. They are not failures, and the wizard marks them routed with the reason:
- Receivables and payables — “‘Debtors’ is created by the opening invoices step, not by the opening journal.” The total arrives there instead, invoice by invoice.
- Stock accounts — the same, pointing at opening stock.
- Profit and loss lines — Accurate’s Laba Tahun Ini, for example. ERPNext forbids them in an opening entry, so they are summed into a single Retained Earnings line: “‘Current Year Earnings’ is a profit and loss account; its balance is posted to Retained Earnings.” If your chart has no retained earnings account, that row fails and names what it looked for.
- Foreign-currency accounts — “‘USD Bank’ is kept in USD; only IDR accounts can be migrated for now.”
Routed rows are left out of the balance difference too, so the number you are shown is about the lines that actually posted.
What the opening journal reads
Section titled “What the opening journal reads”Map one signed Balance column, or the Debit and Credit columns — not both. Exports from Jurnal and Zahir come as two positive columns; Accurate and Odoo come as one signed column. Either shape works.
Which side a figure lands on is decided by the type of account, not a column: assets and expenses on the debit side, liabilities, equity and income on the credit side, and a negative amount flips the side — which is exactly what a contra account like accumulated depreciation needs.
Amounts are read as Indonesians actually write them. 1.234,56, 1,234.56, Rp 1.500.000 and (25.000) are all read correctly; brackets and a minus sign both mean negative.
Temporary Opening, and why it must end at zero
Section titled “Temporary Opening, and why it must end at zero”Exported balance sheets rarely add up to the last rupiah. Rather than refuse the file, Bakulai posts the journal anyway and parks the difference in the company’s Temporary Opening account, then shows you how big it was. The difference is a named line in the journal, not something hidden.
That account is a waiting room. When opening stock runs, the value it posts lands on the other side of it and drains it.
Once every opening step has run, Temporary Opening must be zero. A balance left in it means a figure crossed twice, a figure never crossed, or the old balance sheet did not close cleanly to begin with. It is the single most useful number to check, and making that check possible is why it exists.
What opening stock does
Section titled “What opening stock does”Your stock file becomes a Stock Reconciliation marked Opening Stock, dated the cutoff date, one line per item per warehouse. Large files are split across several documents.
- Cost per unit is required, and it has to come from the file — either a cost column, or a total value that is divided by the quantity. It is the cost, not the selling price. A line without one is reported rather than posted: “‘SKU-001’ has no cost per unit or total value; stock cannot be valued without one.” ERPNext would otherwise fill the gap from a purchase price or with zero, silently.
- Items tracked by serial or batch number are not supported yet. Those lines are reported, not posted, and have to be entered by hand.
- The same item in the same warehouse twice is merged — quantities added, cost averaged by weight — because ERPNext rejects the duplicate outright.
- No warehouse column? The line goes to your company’s main stock warehouse.
- Old item codes still work. A code exported without Bakulai’s company suffix is still recognised.
- Negative quantities are refused: ERPNext does not accept negative opening stock.
- The balancing side goes to Temporary Opening, which is why a stock account must not also appear in your balance sheet file — routed rows handle that for you.
What opening invoices do
Section titled “What opening invoices do”Each line of your aging report becomes one opening invoice — a Sales Invoice for a customer, a Purchase Invoice for a supplier — for the amount still owed, not the original invoice total.
- No item details. The invoice carries a single line called Opening Invoice Item. You are recording a debt, not re-creating a sale, and your stock is already handled by the opening stock step.
- The old invoice number is kept, in the invoice’s remarks — and in Supplier Invoice No for a purchase. That is what lets you match a payment to the right old invoice months later.
- The customer or supplier has to exist already. Run the parties step first. A line whose party is missing is reported, not invented: “No Customer in Bakulai matches ‘Toko Sinar’. Run the parties step first.” A name is all an aging column gives you, and a contact made of nothing but a name is worse than no contact.
- Invoice date is the old invoice’s date, or the cutoff date if the file has none. An invoice dated after the cutoff is reported, not posted — it belongs to Bakulai, not to the migration.
- A due date earlier than the invoice date is moved to the invoice date. An invoice cannot fall due before it exists. It is still overdue from that date onwards.
- Company currency only. “‘PT Global’ is billed in USD; only IDR invoices can be migrated for now.”
- Zero outstanding is skipped; a negative amount is reported. A credit balance is not an opening invoice.
Safe to run more than once
Section titled “Safe to run more than once”Unlike the journal and the stock count, this step reads one row at a time, and an old invoice number that already has a posted opening invoice is skipped.
That is deliberate, and it is why Mekari Jurnal’s three-month export cap does not hurt here: upload every piece of the aging report, run the step on each, and the overlapping rows are recognised rather than duplicated.
One of each, per company
Section titled “One of each, per company”One opening journal and one opening stock per company — the invoices step is the exception described above. Running either of those two a second time does not add another set of balances — it refuses and names the document that already exists: “An opening journal already exists for this company (ACC-JV-2026-00007). Roll the earlier migration back before running this step again.”
If you need to redo it, roll the migration back first.
Did it land correctly?
Section titled “Did it land correctly?”When the last step finishes, Bakulai checks its own work. A Verification card appears on the results step — first as “Checking the books”, then with a verdict.
It does not compare the documents with themselves, which would prove nothing. It re-reads your original files through the mapping you approved, works out what the ledger should say, and asks the ledger what it actually says.
Four comparisons, expected against actual, with any gap shown in bold:
- Temporary Opening must be zero. The first number to look at. A balance left in it means the source balance sheet did not close cleanly, or one of the other steps has not run yet.
- Every balance sheet account — your file’s figure against the ledger balance on the cutoff date.
- Receivables and payables — your aging totals against the company’s control accounts. Only the side you uploaded a file for is checked.
- Stock value — your stock file’s total against the inventory value in the books.
A green verdict says “The books match your files. Temporary Opening is zero.” A red one names how many figures disagree and what to do: “3 figures do not match yet. Fix the source or run the missing step, then check again.”
Fix the cause — correct the file and re-run a step, or run a step you skipped — then press Check again. The answer comes back immediately; it is not queued.
Related
Section titled “Related”What moves, step by step · If it goes wrong · Reports you will use
