ERP Opening Balances and Cut-over: The Migration Step Most Projects Underestimate

The Stock Count at Cut-over

Stock is often the largest figure in the opening balance sheet and the hardest to get right, because it carries quantity, location, lot, cost and value at once. A procedure that works:

1. Stop movements: finish receipts and deliveries, and pause picking.
2. Count by location with blind count sheets, so counters do not see expected quantities.
3. Recount any difference above a tolerance agreed in advance.
4. Post the count in the old system, so its closing stock equals the count.
5. Agree each product's unit cost with finance.
6. Load quantities by product, location and lot at those costs.
7. Check that quantity times cost equals the stock value in the opening trial balance.

Then settle the edge cases: goods in transit, goods received but not invoiced, consignment stock and goods held for customers. Each needs a decision on which side of the cut-over it falls, and whether it sits in stock, in payables or in neither. If the new system values stock automatically, loading the count may post its value to the ledger, so book the value once, through the count or through the opening entry, never both.

Receivables and Payables at Document Level

A receivable balance tells you the total, but it does not let anyone collect it. Load every open customer invoice and supplier bill as its own document, with the partner, original number, invoice date, due date, amount still due and currency. Watch the special cases:

• Part-paid invoices: load the amount still due, and keep the original total in the reference.
• Advances and unallocated receipts: load them as credits on the partner, ready to apply later.
• Unused credit notes: load them as credit notes, not negative invoices.
• Foreign currency: load the original currency amount and the rate used in the old books, so revaluation starts from the right base.
• Post-dated checks: common in the UAE, they need a decision on whether they sit in receivables, in a separate account or in a check register.
• Retentions: load them as separate items with their own due dates.

Load these documents against clearing accounts, and in the opening trial balance replace the receivable and payable lines with the same clearing accounts. Do not charge VAT again: the VAT on these documents was recorded in the old system and arrives through the VAT balances.

A Worked Example: Proving the Receivable

The old trial balance shows receivables of AED 250,000. Its aging report lists open invoices of AED 262,000 and unapplied customer credits of AED 12,000. In the new system:

1. The opening entry debits AED 250,000 to the receivable clearing account instead of receivables.
2. The open invoices debit receivables by AED 262,000 and credit the clearing account by the same amount.
3. The credits debit the clearing account by AED 12,000 and credit receivables.

The clearing account ends at zero, and receivables show AED 250,000, now split by customer and invoice. If the clearing account shows a balance instead, such as AED 3,000, something was missed, perhaps a credit note, and you find out before go-live rather than at the first month-end.

Validating ERP Opening Balances

Validation is a finance sign-off with evidence, not a glance at the trial balance. Build a reconciliation pack and have the finance lead sign each line:

• The new trial balance matches the old one at cut-over, account by account, after mapping.
• Receivable and payable aging matches in total and partner by partner.
• Every clearing account is at zero.
• Stock quantities match the count, and stock value matches the stock accounts.
• Bank balances match the statements, with uncleared items listed.
• The fixed asset register matches the cost and accumulated depreciation accounts.
• VAT balances match the old VAT ledgers and the last return filed.
• Sample transactions work: a statement prints correctly, an invoice can be paid and a bill can be matched.

Then lock the opening period so nobody posts into it by mistake. StarBiz has fiscal-year locks and period closing controls, and Odoo has lock dates, described in its year-end closing documentation.

A Rollback Plan You Hope Never to Use

Every cut-over needs a way back, written down before go-live. A rollback plan is not pessimism. It is what lets the steering group approve go-live with confidence.

1. Go or no-go criteria: validation passed, key users trained, integrations tested and support cover booked.
2. A decision point: a named person, a time and the checks that must pass by then.
3. The old system kept intact: closed for posting, but able to reopen if needed.
4. A log of everything entered in the new system after go-live, so it can be re-keyed in the old one.
5. Messages ready for staff, customers and banks.

Agree where the point of no return lies. It usually arrives when invoices with new numbers have reached customers, or payments have run from the new system. After that, problems are fixed forward, which is why hypercare, the period of close support straight after go-live, matters.

Parallel Running: Pros and Cons

Parallel running means entering the same transactions in both systems for a period and comparing the results. It sounds like the safest option, and for some processes it is.

A middle path often works better: run payroll or one critical process in parallel for a cycle, and rely on rehearsals, the validation pack and the rollback plan for everything else.

How Star Bit Solutions Can Help

Cut-over is part of every implementation we run. On StarBiz, our AI-driven ERP, the migrate and train phase covers cleaned master data, opening balances, role-based training and user acceptance testing, followed by a supported cut-over and hypercare. On Odoo Enterprise or Community, our OdooStar team handles extraction, cleansing and mapping, reconciled opening balances and, where it earns its cost, a parallel run.

Moving from Tally? Our Tally to Odoo migration plan applies these steps to one source system. For anything else, send us your current system, preferred go-live month and year-end through the contact page or on +971 55 973 4524, and an engineer will outline a cut-over plan.