Bank reconciliation guide: match your books with the bank statement every month

Bank reconciliation is the monthly habit of matching every entry in your books against every entry on the bank statement and explaining the gap. The gap is normal: cheques you issued have not cleared, UPI settlements land a day later, the bank quietly deducts charges. Done every month, it takes 30 to 60 minutes, catches missing entries and fraud early, and gives your CA clean figures for GST and income tax.

Why the books and the bank never agree on the same day

Your cash book (or the bank ledger in your billing app) records transactions when you make them. The bank records them when they actually hit the account. The lag between the two, plus things only the bank knows about, is the entire reason reconciliation exists.

Typical causes of difference, in order of how often they show up for a small business:

• Cheques you issued that the payee has not yet deposited or that are still in clearing.
• Cheques or cash you deposited that the bank has not yet credited (outstation cheques can take 2 to 3 working days).
• UPI, card and marketplace collections settled in a batch on a later day, net of charges.
• Bank charges, SMS charges, cheque book charges, minimum balance penalties and NEFT/IMPS fees you never recorded.
• Interest credited on the account or debited on an overdraft.
• Auto-debits (EMIs, insurance, subscriptions) and standing instructions you forgot to book.
• Direct credits from customers who paid by NEFT without telling you.
• Cheques that bounced (yours or your customer's) and were reversed.
• Plain errors: ₹12,540 entered as ₹12,450, a transaction posted twice, or one posted to the wrong bank account.

None of these is a problem by itself. The problem is discovering them in March, when the trail is cold.

What you need before you start

Keep the process boring and repeatable. You need:

1. The bank statement for the month, ideally as a spreadsheet. If the bank gives only PDF, convert it (see the section below).
2. Your cash book or bank ledger for the same month from your billing app or Excel.
3. Last month's reconciliation statement, because items uncleared last month must be checked again this month.
4. The receipt and payment vouchers for the month, so you can trace anything odd.

If you run more than one bank account, reconcile each one separately. Do not mix a personal savings account with business collections if you can avoid it; see current account opening guide for why.

Step-by-step monthly reconciliation

Step 1: Start from the reconciled balance of last month

Take the closing balance from last month's BRS and confirm it is still the opening balance in both your books and the statement. If someone back-dated an entry after you reconciled, this is where it shows up.

Step 2: Tick the matches

Go line by line. For each entry in the bank statement, find the same amount and roughly the same date in your books, and mark both. Spreadsheet users can put a "matched" column and the statement date against each book entry. Work in this order: large amounts first, then cheques (they carry numbers), then NEFT/IMPS (they carry UTR numbers), then UPI (transaction reference), then everything else.

Step 3: List what is in the books but not in the bank

These are timing items: cheques issued but not presented, deposits in transit, UPI settlements due. Write each one with the date, party, cheque or reference number and amount.

Step 4: List what is in the bank but not in the books

Bank charges, interest, auto-debits, direct customer credits, bounced cheques. Each of these needs an entry in your books. This is the step that actually fixes your accounts.

Step 5: Investigate anything that matches neither side cleanly

A ₹25,000 debit with no cheque number and no vendor you recognise is either an unauthorised transaction or a payment someone made from the account without telling you. Either way, find out this week, not in March.

Step 6: Pass the missing entries and prepare the statement

Book the items from step 4. Then prepare the BRS itself: start with the bank statement balance, add deposits in transit, subtract cheques not yet presented, adjust for errors, and you should land exactly on your book balance. If you do not, the difference is an error you have not yet found; a difference that divides by 9 usually points to two digits transposed.

The BRS template

Use this table every month. Keep the completed sheets in a folder; banks and auditors ask for them.

Lines F and L must be equal. Lines H to K are the entries you now book. Lines B, C and D are timing items that should clear next month; if a cheque in line D is still uncleared after three months, it is stale and needs a reversal.

Worked example: a Ludhiana transporter

Harpreet runs a small goods transport business in Ludhiana with four trucks and one current account. On 31 August 2026 his ledger shows a bank balance of ₹2,38,150 and the bank statement shows ₹2,84,600. Here is what the month's matching threw up.

Cheques issued but not presented: ₹68,000 to a tyre dealer (issued 28 August) and ₹44,000 to the diesel pump (issued 30 August). Total ₹1,12,000. These are timing differences; the money will leave in September.

A customer's cheque of ₹45,000 deposited on 31 August was credited only on 2 September. Timing difference, added back.

Freight collections through a logistics platform for the last two days of August, ₹18,750, were settled on 1 September. Timing difference.

On the bank side, he found a ₹590 debit for cheque book and SMS charges, a truck loan EMI of ₹12,300 that his staff forgot to book, ₹210 interest credited on the balance, and a ₹10,880 NEFT from a Jalandhar consignor who paid without sending a message.

Adjusted bank balance: 2,84,600 + 45,000 + 18,750 − 1,12,000 = ₹2,36,350. Adjusted book balance: 2,38,150 − 590 − 12,300 + 210 + 10,880 = ₹2,36,350. Tallied. Harpreet books four entries, updates the consignor's ledger so he does not send a payment reminder for money already received, and files the sheet.

Without the exercise, he would have chased a customer who had paid, understated his loan repayment, and shown ₹1,800 less expense than real. Multiply that by twelve months.

Uncleared cheques, stale cheques and bounced cheques

A cheque is valid for three months from the date written. If it has not been presented by then, it is stale: reverse the entry in your books and, if you still owe the money, issue a fresh cheque. Do not let stale cheques sit in the BRS for a year; auditors treat that as a hidden liability.

Many banks now require Positive Pay confirmation for cheques above ₹50,000 (mandatory in some banks for ₹5 lakh and above). If you forget to lodge the details, the cheque bounces even though you had funds. Record the bounce, the bank's return charge, and re-issue.

When a customer's cheque bounces, the bank reverses the credit and charges you. Book the reversal against the customer's ledger the same day, so the outstanding shows correctly, and start the Section 138 clock; the cheque bounce guide explains the notice timelines.

Bank charges and interest: the entries everyone misses

Charges are small individually and large in total: ₹590 here, ₹1,180 there, a ₹2,950 annual charge on the current account, IMPS fees, GST on all of them. They are business expenses and the GST on them is input credit (the bank issues a monthly tax invoice you can download). Book them monthly from the statement.

On an overdraft or cash credit account, interest is debited monthly, usually at month-end. It is deductible and often large. If your books do not show it, your profit is overstated and your Section 43B working is incomplete.

UPI settlement timing and how to book it

Two different things are both called "UPI" and they behave differently in reconciliation.

Direct UPI to your bank account (customer scans your bank's QR or pays your VPA linked to the current account). The credit is instant and appears as a separate line per payment with the payer's name or VPA. Match line by line.

UPI through a payment gateway, soundbox provider or marketplace. The provider collects all payments during the day and settles one lump sum to your account, usually T+1 working day, sometimes T+2 over weekends and holidays, net of any fees. Your books have twenty receipts of ₹300 to ₹5,000; the statement has one credit of ₹41,760.

For the second type, download the provider's settlement report, which lists every transaction in the batch. Match the batch total to the statement credit, and the individual transactions to your receipts. Treat the difference (fees, if any) as an expense. Book the last day or two of the month as "settlements receivable" in your BRS.

Most merchants pay zero MDR on UPI P2M, but platforms may charge convenience or subscription fees, and card payments through the same gateway do carry charges. See the UPI for business guide for the collection setup that keeps this simple.

Converting statement PDFs to Excel

Ticking entries on a printed PDF is slow and error-prone. Convert the statement into a spreadsheet first. Most Indian bank statements are text-based PDFs, so the conversion needs no OCR and preserves dates, narrations, reference numbers, debits, credits and running balance as columns.

Once in a sheet: sort by amount to find matches for large items, filter narrations for "CHRG" or "CHARGES" to catch fees, filter for "UPI" to isolate collections, and use a matched column to tick off. Keep the converted file with the month's BRS. Never edit the amounts in the converted sheet; if there is a genuine bank error, take it up with the branch in writing.

Finding the missing entries faster

When the two sides do not tally and you have ticked everything obvious, try these in order:

• Compute the difference. If it equals one entry on either side, that entry is missing.
• If the difference divides by 9, look for transposed digits (₹5,430 entered as ₹4,530).
• If it is exactly double an entry, the entry was posted on the wrong side (a receipt booked as a payment).
• Check the opening balance; a back-dated entry after last month's reconciliation moves everything.
• Look at the last and first two days of the month; that is where settlement batches straddle the cut-off.
• Search the statement for every cheque number in your issued cheque register.

Common mistakes

Reconciling only at year end. Twelve months of small gaps become one unsolvable pile. Monthly is the minimum.

Forcing the difference. Passing a "suspense" or "miscellaneous expense" entry to make the sides tally. That hides fraud and mis-postings and your CA will find it anyway.

Booking gateway settlements as one sale. The lump-sum credit is not a sale; the individual receipts are. Post receipts customer-wise, then match the batch.

Ignoring small charges. ₹18 IMPS fees add up to real money and real GST credit over a year.

Not updating customer ledgers after matching. Reconciliation that stops at the bank ledger leaves the outstanding statement wrong and results in reminders to customers who have already paid.

Sharing statement PDFs over WhatsApp with staff. Statements carry account numbers and full transaction history. Convert, share only the sheet needed, and delete from chat.

How VyaparKit helps

VyaparKit does not perform the reconciliation for you, but it removes the tedious parts. The bank statement to Excel converter turns text-based statement PDFs into a clean spreadsheet without OCR, so matching is a sort-and-filter job (three conversions a month are free). Every receipt you record against an invoice updates the customer ledger, and vendor payments update the vendor ledger, so after matching the bank you can confirm party balances in one place. Print a payment receipt for each collection so there is a voucher trail for every credit on the statement.

Next steps

• Download last month's statement, convert it to a spreadsheet and try the six steps once.
• Set a calendar reminder for the 5th of every month for the reconciliation.
• Build a cheque register (number, date, payee, amount, cleared date) if you do not have one.
• List your auto-debits and standing instructions so they are booked without waiting for the statement.
• Read bookkeeping basics for small business if your cash book itself is not up to date.