Opening balances are the account balances your books start with in the new system, exactly as they stood at the end of the last day in the old one: cash and bank, customer receivables, supplier payables, stock, fixed assets, loans and equity. If these balances go in wrong, every report that follows is wrong, however correct the later entries are.
That is why getting opening balances right is the most important step in any move to a new accounting system, whether you are coming from spreadsheets or from older software. In opening balances accounting, a mistake rarely shows on day one. It shows months later, when the bank will not reconcile or a customer disputes a statement.
This guide explains how to choose the cut-over date, how to enter general account, customer, supplier and stock balances, and then walks through the opening balance journal entry with a full example and how to check it against the trial balance before go-live.
What are Opening Balances and Why Do They Decide Your Year’s Accuracy?
Opening balances are the balances of balance sheet accounts (assets, liabilities and equity) on the date you start working in the new system. Revenue and expense accounts are normally not carried over as separate balances when you switch at the start of the financial year, because they have already been closed to retained earnings.
Every figure in later balance sheets equals the opening balance plus the movement for the period. If the opening bank balance is overstated by SAR 20,000, that error sits in every report until someone finds it, and the bank reconciliation fails every month for no obvious reason.
Choosing the Right Cut-Over Date
The best cut-over date is the start of the financial year. Next best is the start of a quarter or month after the previous period has been closed. What matters is that the date is the end of a closed and reviewed period in the old system, not the middle of an open month.
| Cut-Over Option | Advantages | What to Watch |
|---|---|---|
| — | — | — |
| Start of the financial year | No need to carry over revenue and expense activity; all annual statements come from one system | Waiting for the old year to close and the year-end stock count |
| Start of a VAT quarter | Lines up with the VAT return period | Carrying over year-to-date revenue and expense balances |
| Start of a month | Quick to start | Requires a careful close of the previous month and transfer of income statement balances |
For a brand-new business, opening balances are simple: paid-in capital and the matching bank balance, plus any assets contributed by the partners. That case is covered in our guide to your new company’s first 90 days.
Opening Balances for General Accounts
Start with a final trial balance from the old system at the cut-over date, then map each account to its counterpart in the new chart of accounts. This mapping step decides whether the figures move across intact.
General accounts include cash on hand, each bank account separately as per the bank statement, fixed assets at cost with their accumulated depreciation, loans, VAT payable or recoverable, capital and retained earnings. Do not combine bank accounts into one figure, because you will need to reconcile each account against its own statement.
If the new chart of accounts is structured differently from the old one, design the new chart first, then prepare a clear mapping table between the two. To see how a chart of accounts is built inside the system, read Odoo’s interface, charts of accounts and ledgers.
Customer and Supplier Balances
Do not enter receivables as one total. The right way is to enter each customer’s balance separately, ideally at the level of open invoices with their dates and due dates, so the aged receivables report and customer statements work from day one.
The same applies to suppliers: each supplier with its balance, and each open invoice with its due date, so you know what has to be paid this week. Before entering them, confirm balances with your main customers and suppliers through signed or acknowledged statements, because disputes found after go-live are much harder to settle.
| Customer | Invoice | Due Date | Amount (SAR) |
|---|---|---|---|
| — | — | — | — |
| Customer A | Invoice 1184 | 15 January | 90,000 |
| Customer B | Invoice 1201 | 30 January | 60,000 |
| Customer C | Invoice 1210 | 10 February | 35,000 |
| Total customer balances (equals receivables account) | 185,000 |
The key condition is that the detailed customer balances add up exactly to the receivables account in the old trial balance, and the same for suppliers.
Opening Stock Balance
The opening stock balance must be entered by quantity and cost for every item in every warehouse, not as a single value. The system needs both quantity and cost to calculate cost of goods sold from the first sales invoice.
Carry out a physical count on the cut-over date or as close to it as possible, then multiply each item’s quantity by its cost under your chosen costing method. The total value of all items must equal the inventory account in the general ledger. If the count differs from the old books, resolve the difference in the old system before you switch, so the new system does not inherit the error.
Also read: Trial balance analysis and error detection in an ERP system.
The Opening Balance Entry with an Example
The opening balance journal entry is a single journal entry, or a set of entries, dated at cut-over that debits or credits each account with its closing balance from the old system. Like any double entry, total debits must equal total credits.
Example for a trading company switching to a new system on 1 January:
| Account | Debit (SAR) | Credit (SAR) |
|---|---|---|
| — | — | — |
| Cash on hand | 15,000 | |
| Bank (current account) | 210,000 | |
| Accounts receivable (detailed as above) | 185,000 | |
| Inventory | 260,000 | |
| Equipment and furniture (at cost) | 140,000 | |
| Accumulated depreciation, equipment and furniture | 40,000 | |
| Accounts payable | 160,000 | |
| VAT payable | 28,000 | |
| Bank loan | 100,000 | |
| Share capital | 300,000 | |
| Retained earnings | 182,000 | |
| Total | 810,000 | 810,000 |
Retained earnings here is not a plug figure calculated to make the entry balance. It must equal the balance in the old system’s closing balance sheet. If you find yourself needing a balancing figure, a balance is missing or wrong and has to be traced.
Checking with the Trial Balance Before Go-Live
After entering the balances, run the trial balance in the new system at the cut-over date and compare it account by account with the closing trial balance from the old system. Every balance must agree, not just the totals.
Pre-go-live checklist:
- Total debits equal total credits in the opening balance entry.
- Each bank account balance matches the bank statement at the cut-over date.
- Detailed customer balances add up to the receivables account, and the same for suppliers.
- Inventory value by item equals the inventory account.
- Retained earnings and capital match the approved closing balance sheet.
- Periods before the cut-over date are locked so no entry is posted to them by mistake.
Reviewing the trial balance regularly after go-live catches any error that did not surface at the start, especially in the first months.
Opening Balances in Odoo with Daysum
In Odoo-based systems, opening balances for accounts can be entered directly from the chart of accounts screen, and balances can also be imported from structured files. Customer and supplier balances can be entered as open invoices linked to each partner, and stock can be entered by quantity and cost for each item. Odoo also provides lock dates that prevent posting to earlier periods.
In implementation projects, the Daysum team works with your finance team to prepare the account mapping table, clean up customer, supplier and product data, import it, and reconcile the trial balance before go-live. For a broader view of the move itself, see migrating to Odoo ERP. If you are planning that move and want to start with correct figures, talk to the Daysum team to review your current data.
Conclusion: A Clean Start for Your New System
Correct opening balances mean that the first balance sheet from the new system matches the last one from the old system, and that every customer, supplier and item starts with its real balance. Choose a closed date, enter the detail rather than totals, and never rely on a plug figure in retained earnings.
A few extra hours of reconciliation before go-live save months of chasing differences afterwards. If you would like help planning your data migration and opening balances, contact the Daysum team.
FAQs About Opening Balances
It is a journal entry dated on the first day in the new system that records each balance sheet account with its closing balance from the old system. Assets usually sit on the debit side, and liabilities and equity on the credit side. Total debits must equal total credits.
Enter each customer's balance separately, ideally as open invoices with their dates and due dates. That way the aged receivables report and customer statements work from day one. Make sure the detailed balances add up to the receivables account in the old trial balance.
Compare the new trial balance with the old one account by account to find the account that differs. Common causes are a balance entered on the wrong side, an account that was not carried over, or detailed balances that do not add up to the control account. Do not clear the difference with a balancing entry in retained earnings before you know its cause.
Not if you switch at the start of the financial year, because revenue and expenses have already been closed to retained earnings. If you switch mid-year, you need to carry over the year-to-date balances so the annual income statement is complete. They can go in as one total per account or as monthly balances, depending on the reports you need.
Enter it after a physical count on the cut-over date or as close to it as possible, and after resolving count differences in the old system. Enter it by quantity and cost for each item in each warehouse, not as a single value. The total value of all items must equal the inventory account.
