Bank reconciliation for small businesses: a monthly routine that works

Bank reconciliation is the most basic control in accounting and the one small businesses skip most often. It feels redundant: the bank already knows the balance. But the bank only knows its side. The reconciliation is what tells you whether your books — the numbers your GST returns, your MIS and your tax are built on — actually agree with what happened to your money.

What a reconciliation proves

A proper bank reconciliation establishes two things at once:

• Every transaction on the bank statement has been recorded in your books.
• Every bank transaction recorded in your books actually went through the bank.

Where the two records differ, each difference is listed with its reason, and the balance in your books, adjusted for those differences, arrives exactly at the balance on the statement. Not approximately. Exactly.

A reconciliation that is “only a few hundred rupees out” isn’t a reconciliation. It is an unexplained difference with a small number on it.

The five kinds of difference

Almost everything you find will be one of these.

1. Timing differences. Cheques you have issued that the payee hasn’t banked yet, and deposits you have recorded that the bank hasn’t credited yet. These are normal and clear on their own.
2. Bank-only items. Things the bank did that you haven’t recorded: charges and the GST on them, interest, loan EMIs and NACH auto-debits, and customer payments received directly into the account.
3. Errors in your books. A wrong amount, a transaction posted to the wrong bank account, a payment entered twice, or a receipt allocated to the wrong customer.
4. Errors by the bank. Rare, but real: a charge applied twice, or a transaction that belongs to another account.
5. Unidentified receipts. Money arriving by UPI or NEFT with no usable reference. Until someone works out which invoice it pays, the customer’s ledger is wrong.

The rule is simple. Timing differences stay on the reconciliation until they clear. Everything else gets booked, corrected or raised with the bank now.

A worked example

At 31 August, the bank ledger in the books shows ₹4,82,500. The bank statement shows ₹5,89,020. The reconciliation explains the ₹1,06,520 gap:

Item	Amount
Balance per books	₹4,82,500
Add: cheques issued, not yet presented	₹1,25,000
Less: deposit recorded, not yet credited by the bank	(₹60,000)
Less: bank charges and GST on them, not yet booked	(₹1,180)
Add: customer NEFT received, not yet booked	₹85,000
Less: loan EMI auto-debit, not yet booked	(₹42,300)
Balance per bank statement	₹5,89,020

The unpresented cheques and the uncredited deposit are timing: leave them on the reconciliation. The other three need entries in the books today. Once they are posted, the books show ₹5,24,020, and the bank balance adjusted for the two timing items shows the same ₹5,24,020. That agreement is the proof.

Notice what the unbooked items were doing in the meantime. The customer who paid ₹85,000 still looked overdue in the debtor ageing, and may have received a reminder. The interest inside the EMI was missing from the P&L, and the loan balance was overstated. Small omissions, but every report built on those books was wrong until they were fixed.

The monthly routine

1. Collect every statement for the full month. Current accounts, overdraft and cash-credit accounts, credit cards, payment gateways and wallets. The account nobody looks at is the one that goes wrong.
2. Match. Use bank feeds or statement imports to auto-match routine lines, then work through the rest by hand.
3. Book the bank-only items. Charges, interest, EMIs, auto-debits and direct receipts, allocated to the right customer or expense.
4. List the timing items with their dates. Anything still outstanding from an earlier month needs a reason. A cheque unpresented for three months is a question for the payee, not a timing difference.
5. Investigate unexplained differences now. They are far easier to trace in the month they happen than six months later.
6. Review and sign off. A second person checks the reconciliation before the month is closed.

This is one of the steps in the month-end close, and it should happen before the close, not after it. A P&L closed on an unreconciled bank is a draft.

Payment gateways and UPI

Gateways and marketplaces are where modern reconciliations get difficult. The money that arrives in the bank is a net settlement: many customer payments, bundled together, a day or two later, with the gateway’s fee and the GST on that fee already deducted.

Booking the settlement as a single receipt makes the bank agree but leaves the books wrong: sales are understated, the fee disappears, and the input credit on the fee is never claimed. The right approach reconciles in two steps — customer payments to the gateway’s settlement report, then the settlement report to the bank — so sales, fees and GST are each recorded at their true amounts.

UPI and NEFT receipts without a reference need a routine too: a short list, circulated to sales or collections weekly, of every unallocated receipt and its amount. Most are identified in minutes by the person who spoke to the customer.

Why year-end is too late

Plenty of businesses reconcile once a year, when the auditor asks. It is always more expensive than doing it monthly:

• Memory fades. Nobody remembers what an unreferenced ₹38,000 receipt in May was for by the following April.
• Credit is lost. Input tax credit for a financial year can only be claimed up to 30 November of the following year. GST on bank and gateway charges that is only discovered at a late year-end reconciliation can miss that cut-off and be lost for good.
• Decisions were made on wrong numbers. Every monthly MIS, cash forecast and debtor follow-up in between was built on books that didn’t agree with the bank.

Our finance operations team reconciles every bank, card and gateway account as part of each month’s close, and lists every open item with its age and reason. If your reconciliations are behind, that is usually the first thing we fix.