Software
24 Points
Posted on 22 October 2026
A routine that keeps mistakes low, month after month:
1. Check the statement first. Opening balance + total credits - total debits should equal the closing balance, and it should agree with the bank ledger's balance at the start of the period. If it doesn't, find that difference before entering anything.
2. Classify each row: money out = Payment (F5), money in = Receipt (F6), cash withdrawal/deposit or transfer between the client's own banks = Contra (F4). Bank charges, interest, GST on charges, TDS and EMI rows usually have a fixed ledger, so set them once.
3. Rows you can't identify yet go to a Suspense ledger, not a guessed party. Your Suspense balance is then the list of questions to ask the client.
4. UPI narrations: the payee's UPI ID and the 12-digit reference identify the party far better than the truncated name.
5. Reconcile: open Banking > Bank Reconciliation for the bank ledger and enter the bank date for each entry. What's left (cheques not yet presented, deposits not yet credited) is your BRS.
6. Finally, the bank ledger's closing balance for the period should equal the statement's closing balance to the rupee.
For long statements, typing is where mistakes creep in, and converting the PDF and importing vouchers is faster. Disclosure: we build KhataSheet, a free in-browser converter that does this with a row-by-row balance check. We also wrote a month-end BRS checklist: https://khatasheet.com/guides/bank-reconciliation-checklist?utm_source=caclubindia&utm_medium=community&utm_campaign=2026-w43-launch