Business

Opening balance meaning: how to start your books mid-year

Opening balance meaning and how to enter it: the cash, bank, receivable and payable figures to collect on your start date, with a worked mid-year example.

Editorial illustration for Opening balance meaning: how to start your books mid-year

An opening balance is the starting figure of an account on the day your records begin: what is in your cash box, what the bank shows, what customers owe you and what you owe suppliers. Collect those figures for one chosen date and enter them first, and you can start keeping books in the middle of a year without re-entering everything from April.

What counts as an opening balance?

Any account that already has a value on your start date. For a small business that is usually four things: cash in hand, each bank account, receivables (money customers still owe you) and payables (money you still owe suppliers). Stock, loans and deposits paid can also have opening balances, but start with these four and add others when you are ready.

How do you choose the start date?

Pick a date where figures are easy to prove. The first day of a month works well because the bank statement for the day before gives a clean closing balance. Mid-year starts are fine: if your financial year runs April to March and you start on 1 October, the first six months simply are not in your new records. Ask your CA how earlier months should be handled for any filings.

A worked example: starting on 1 October

Say a small shop begins on 1 October. The figures below are made up. Cash in the till counted on the evening of 30 September is ₹8,500. The bank statement closing balance on 30 September is ₹1,24,300. Two customers owe ₹30,000 and ₹16,000, which is ₹46,000 in receivables. Two suppliers are owed ₹14,000 and ₹7,500, which is ₹21,500 in payables.

AccountTypeOpening figure
Cash in handAsset₹8,500
Bank accountAsset₹1,24,300
Customers owe youAsset₹46,000
You owe suppliersLiability₹21,500
Net starting position8,500 + 1,24,300 + 46,000 − 21,500₹1,57,300

The net figure is your starting position: ₹1,32,800 of cash and bank, plus ₹46,000 owed to you, minus ₹21,500 you owe. Write it down; if the first month of records ends with figures that cannot be explained from it, something was missed.

A checklist for collecting the figures

  1. Count the cash on the evening before the start date and note the time.
  2. Download or photograph the bank statement showing the closing balance for that day, for every account.
  3. List each customer who owes you, with the bill number, date and amount.
  4. List each supplier you owe, with the bill number, date and amount.
  5. Add any other balances you want to track from day one, such as a deposit paid or a loan balance, with proof.
  6. Add them up and keep the sheet along with the proofs.

What goes wrong with opening balances?

  • Using today's bank balance instead of the closing balance on the start date.
  • Entering a customer's old bill again later when it is paid, so it appears twice.
  • Forgetting small cash floats, like petty cash in a drawer.
  • Entering the opening balance as income, which inflates your first month's profit.

When a customer on your receivables list pays in October, record it as the receipt of an old bill, not as a fresh sale. The same goes for suppliers: paying the ₹14,000 you owed reduces the payable, it is not a new purchase. This is the most common way opening balances get counted twice.

What about a personal expense tracker?

A personal tracker needs less. SpendixAI records expenses from statements and manual entries; it is not a double-entry accounting system, so receivables, payables and opening ledger balances belong in your accounting software or sheet. If you later move records to Tally, Zoho Books or QuickBooks, its Export centre has templates for them, so the categories you built can travel with you.

Next step: choose your start date today, set a reminder to collect the four figures that evening, and file the proofs together.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports