Cash Balance vs Bank Balance: Keeping Them Honest

Every few months, a customer of some billing software writes in to say the balance is wrong. The books show one figure, the bank app shows another. In nearly every case the software is fine. The two numbers disagree because they are measuring slightly different things, and nobody has compared them line by line.

That comparison is called reconciliation. It sounds heavy. For a small business it is mostly patience and a pen.

Why the two numbers drift apart

Your books record what you have told them. Your bank records what actually moved. Differences come from a short list of causes, and once you know them the hunt gets quick:

• Cheques not yet cleared. You recorded a payment on the 28th, the supplier banks it on the 3rd.
• Bank charges and interest that the bank applied and you never entered.
• Direct deposits from a customer who paid by transfer without telling you.
• Entries recorded twice, often a payment logged by both the owner and a staff member.
• Cash that went into the bank but was never recorded as a deposit, or the other way round.
• Typing mistakes, such as 12,500 entered as 21,500.

A routine that takes under an hour

1. 1Pick a period. A month is easiest. Start from the closing balance on the bank statement for that month.
2. 2List every statement line in a column. Tick each one against your books.
3. 3Anything on the statement but not in your books: add it to your books (charges, direct deposits).
4. 4Anything in your books but not on the statement: usually uncleared cheques. Note them, do not delete them.
5. 5Add uncleared receipts and subtract uncleared payments from the statement balance. That adjusted figure should equal your books.
6. 6If the numbers still differ, look for a transposed figure or a doubled entry, starting with amounts equal to the difference.

That last tip saves a lot of time. If the gap is exactly ₹4,500, search both sides for a 4,500 entry before you read every line.

Cash is a different animal

Cash has no statement. The only evidence is what is physically in the drawer, so counting is your reconciliation. Count at closing, compare to what the books say the drawer should hold, and write down any difference, however small.

We would not try to explain away small mismatches with 'it evens out'. If a shop is short by ₹40 on Tuesday and over by ₹30 on Wednesday, that is a pattern worth looking at, usually wrong change or a missed entry. The routine in a daily cash register closing routine is the daily version of this.

What the software can and cannot do

Billy shows your bank and cash balance on the dashboard, built from the payments you record against invoices and purchase bills. So its figure is only as good as the payments entered. It does not read your bank statement for you, and we would not claim it matches your account automatically. The comparison above is still a human job.

What it does give you is a clear starting point: one bank figure, one cash figure, updated as you record payments. That makes the monthly comparison faster, because you are checking one number against one number first.

Habits that make it painless

• Record payments the day they happen, not at month end.
• Enter every bank charge when you see the SMS alert.
• Reconcile monthly, not yearly. A year of drift is a weekend of misery.
• Have one person own the bank entries. Two people entering the same payment is the classic doubled-entry cause.

If you plan to share your books with an accountant later, reconciled balances make that handover much smoother, which we cover in preparing your books for your accountant.

A short example

Say your books show ₹84,000 in the bank and the statement shows ₹79,500. You find a supplier cheque for ₹6,000 not yet cleared, which explains part of it, and a ₹1,500 bank charge you never entered. Now the books, adjusted, and the statement, adjusted, agree. The route there took twenty minutes, because you followed the list instead of guessing. The amounts are illustrative, but the pattern of one timing item and one forgotten charge is extremely common.

A difference between books and bank is not an accusation, it is information. Most of the time the answer is dull: a cheque in transit, a bank fee. Treat the reconciliation as a monthly health check and the surprises mostly vanish.

If your setup has several accounts or several businesses and you want the balances laid out differently, talk to us about what you need.