RefinePoint

Blog · · 7 min read

Bank reconciliation in 2026: a practical method beyond the BRS

A step-by-step bank reconciliation method for Indian finance teams: matching passes, UTRs, cut-off, running balance checks and a BRS that proves itself.

Most of us learnt bank reconciliation as a statement: start from the balance as per the cash book, add cheques issued but not presented, deduct cheques deposited but not credited, and arrive at the balance as per the bank. The bank reconciliation statement (BRS) is still the right output. What has changed is the volume: a mid-size company now sees thousands of UPI, NEFT, IMPS and RTGS lines a month, plus cheques, gateway settlements and auto-debits. Ticking those by hand is slow, and it hides errors. This post sets out a method that works at that volume, in a spreadsheet or a tool.

Start with clean inputs, not with matching

Before any matching, check the two files you are about to compare. Most "unreconcilable" differences are input problems.

The bank statement

  • Run a balance check. Each line's balance should equal the previous balance plus the amount. If line 214 does not follow from line 213, a row is missing, duplicated or out of order. Downloads from net banking that are split across pages are the usual culprit.
  • Look for duplicate lines. Same date, same reference, same amount and same balance means the export repeated a row. Same amount and reference with a different balance is usually two real transactions.
  • Agree the opening balance to last month's closing balance. If they differ, stop and find out why before going further.

The cash book

  • Export from Tally, Zoho Books or SAP for exactly the same period and the same bank ledger.
  • Make the signs consistent with the statement: money in positive, money out negative. Tally's ledger export has separate debit and credit columns, and in the books a receipt is a debit to the bank ledger while on the statement it is a credit. Turn one side around before comparing.

Know what your references look like

The reference is what makes a match certain, so it helps to know what each payment rail puts on the statement.

Payment type Reference on the statement Typical form
NEFT UTR 16 characters, starting with the sending bank's four-letter code
RTGS UTR 22 characters
IMPS, UPI RRN (often called UTR) 12 digits
Cheque (CTS) Cheque number 6 digits
Gateway settlement UTR in the narration, with the gateway's name Varies by bank

Banks print these in different places. Some have a separate reference column; many bury the UTR inside the narration, as in NEFT CR-HDFC0000123-SHARMA TRADERS-HDFCN52026110412345. Your cash book needs the same number in the voucher narration or reference field for a reference match to work. If your team keys UTRs into Tally when booking receipts, the reconciliation gets much easier.

Match in passes, strictest first

Do not try to match everything with one rule. Run several passes in order, where each pass looks only at what the earlier passes left open.

  1. Reference and amount. Same UTR or cheque number, same amount, dates within a few days. Most lines should match here, and these matches need no review.
  2. Amount and date. No usable reference, but the same amount within two or three days. Good for card swipes and small UPI receipts. Two receipts of ₹5,000 on the same day can pair the wrong way round, which matters if you post receipts against customers.
  3. One bank line against several book entries. A cash deposit of ₹48,500 at the branch may be four counter receipts in the books. Look for a group of book entries whose total equals the bank line, within the same few days.
  4. Several bank lines against one book entry. The opposite case: a salary file posted as one journal in the books but debited as 120 lines by the bank, or a loan EMI split into principal and interest by the bank.
  5. A looser last try. Same amount within a week. Treat these as suggestions and have a person confirm each one.

The order matters. If the loose pass ran first, it could pair a ₹10,000 receipt with the wrong ₹10,000 payment and leave the correct partner unmatched.

Handle reversals before they become breaks

A NACH debit that bounced and was reversed appears twice on the statement, once each way, and never in the books. A cheque deposited and returned unpaid does the same. Pair these within the same side first: two entries whose amounts cancel to zero and whose references agree. They settle each other and need no counterpart.

Watch the month-end cut-off

Timing differences are expected, but you should know which ones to expect.

  • NEFT runs in half-hourly batches, 24 hours a day. A transfer you initiate at 11:50 pm on 31 October can settle in the first batch after midnight and appear on the statement on 1 November.
  • Cheques clear faster than they used to. Since 4 October 2025 the Cheque Truncation System has moved to continuous clearing with settlement on realisation, so a cheque presented in the day's session is normally credited the same day. A deposited cheque that is still uncredited after two or three working days deserves a phone call to the bank, not a line in the BRS.
  • Issued cheques still depend on when the payee deposits them. These are the classic "issued but not presented" items, and their age is worth tracking.

A worked example

Here is an illustrative month for a current account. After matching, these items remained open.

Item Side Amount (₹)
Cheque 004512 to Mehta Packaging, issued 29 Oct, not yet presented Cash book 62,000
Counter deposit of 31 Oct, credited by bank on 1 Nov Cash book 25,000
Account maintenance charges and GST, not yet booked Bank 1,180
Interest on sweep deposit, not yet booked Bank 3,420
NEFT from Kaveri Foods, UTR not quoted, not yet booked Bank 8,000

Balance as per cash book: ₹17,96,110. Balance as per bank statement: ₹18,43,350.

Bank reconciliation statement as on 31 October 2026 ₹
Balance as per cash book 17,96,110
Add: cheques issued, not presented 62,000
Less: deposits not yet credited (25,000)
Less: bank charges not in books (1,180)
Add: interest not in books 3,420
Add: receipt not in books 8,000
Balance as per bank statement 18,43,350

The point of the BRS is that the difference of ₹47,240 is fully explained by listed, open items. If it is not, something was matched wrongly or a row is missing. A BRS that does not tie out is a signal to go back, not a figure to plug.

Three of the five items need entries in the books: the charges, the interest and the Kaveri Foods receipt. The other two should clear next month. If cheque 004512 is still open in December, ask Mehta Packaging whether they received it.

Carry open items forward and age them

Each month's open items are the starting point for the next. The ₹25,000 deposit should match 1 November's statement line in the next run. Age the open items and look hardest at anything over 30 days: stale cheques never presented, unidentified receipts in a suspense ledger, and small bank charges nobody books, which add up across a year.

Explain repeat differences once, and sign off

Every month brings the same kinds of difference: SMS charges, GST on charges, interest, rounding on foreign currency receipts. Write a rule for each ("narration contains CHG and amount is at most ₹500 means bank charges") so your reviewer only looks at what is new. The reconciliation is finished when someone other than the preparer has reviewed it; keep the statement, the cash book export, the match result and the BRS together, with who prepared and reviewed it. That is what your auditor will ask for.

How RefinePoint does it

RefinePoint's built-in Bank reconciliation template follows this method. It has two sides, Bank statement and Cash book, and five matching passes in order: reference and amount (dates within five days), amount and date (within three days), one deposit for several receipts, several entries for one book entry (groups of up to six), and amount within a week, which is proposed for a person to confirm rather than accepted automatically. References are compared as document numbers, so formatting differences do not stop a match. Its checks look for statement duplicates, verify the statement's running balance, produce the bank reconciliation statement and age the open items. Open items are followed from run to run with their age, reason codes can label repeat differences such as bank charges, and journals for those charges can be raised, approved by a second person and posted to Tally, Zoho Books, QuickBooks or Xero. Statements can be uploaded as CSV or Excel, or received through a bank feed (in India, via Account Aggregator).

To see it on your own statements, request a demo at refinepoint.com or start free at app.refinepoint.com.

Sources

  • RBI, NEFT available 24x7 with 48 half-hourly batches: rbi.org.in notification
  • RBI, Continuous Clearing and Settlement on Realisation in CTS, circular of 13 August 2025: rbi.org.in
  • UTR and RRN formats for NEFT, RTGS, IMPS and UPI: Winvesta, Eximpe

Filed under Bank reconciliation

Reconcile it in RefinePoint

Templates for bank, vendor, GST, payroll, card and payment reconciliations. Upload two files and see the matches, the differences and why.

Request a demoStart free