Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A junior accountant faces a bank statement with unfamiliar columns and does not know which ones to compare against the cash book.
Map the bank's columns to a standard set, then match each statement line to the cash book on amount and reference, using the date as a guide and the value date to decide the month.
Standard columns: date, value date, narration, cheque or reference number, withdrawal, deposit, closing balance. Bank-specific names are mapped to these before matching.
A ticked statement where every line is matched to the cash book or listed as an open item to follow up, ending at the printed closing balance.
A bank statement lists every debit and credit in your account, each with a transaction date, a value date, a narration, a cheque or reference number and a running balance. To reconcile it, you match each statement line to your cash book on amount and reference, use the dates to decide which month it belongs to, and finish at the closing balance printed by the bank.
What does each column mean, and which one do you match on?
Indian banks use slightly different names, but almost every statement carries the same seven pieces of information.
| Column (common names) | What it tells you | Use in reconciliation |
|---|---|---|
| Date / Txn Date | The day the bank recorded the entry | Rough guide to find the cash book entry |
| Value Dt / Value Date | The day the money counts for balance and interest | Decides the month when dates straddle a month-end |
| Narration / Description / Particulars | Bank’s short description: NEFT, UPI, CHQ DEP, charges | Tells you what the entry is and who the other party is |
| Chq./Ref. No. | Cheque number, UTR or other reference | Strongest match key after amount |
| Withdrawal / Debit | Money going out | Matches a payment in your cash book |
| Deposit / Credit | Money coming in | Matches a receipt in your cash book |
| Closing Balance / Balance | Running balance after each line | Your end point; the last figure is what you reconcile to |
Some banks show one amount column with Dr or Cr beside it instead of two columns. The meaning does not change.
The order of matching that works for most people is simple:
- Find an entry in the cash book with the same amount.
- Confirm it with the cheque number or the reference (UTR for NEFT and RTGS, the reference number for UPI and IMPS).
- Check the date is close. A gap of a day or two is normal.
- Tick both entries.
Why do the transaction date and the value date differ, and which month does an entry belong to?
The transaction date is when the bank recorded the entry. The value date is when the money is treated as available. They are often the same for electronic transfers. They can differ for cheques you deposit, because the bank credits your account only when the cheque clears, and around bank holidays and weekends.
Month-end is where this matters. Say you deposit a cheque on 31 March and the bank shows it with a transaction date of 31 March but a value date of 1 April, or does not show it until April at all. Your cash book has it in March. The March statement may not. That difference is a timing item, and it goes into your bank reconciliation statement (BRS) for March.
A simple rule: your BRS is prepared as at the closing date of the statement. Anything the bank had not shown by that date is a reconciling item, whatever the date in your books.
A worked example: ticking six lines
Here is a short extract from a March statement, ticked against the cash book.
| Date | Narration | Ref. No. | Withdrawal (₹) | Deposit (₹) | Balance (₹) | In cash book? |
|---|---|---|---|---|---|---|
| 25 Mar | Opening balance | 1,50,000 | ||||
| 26 Mar | NEFT CR SHARMA TRADERS | N0861234 | 45,000 | 1,95,000 | Yes, ticked | |
| 27 Mar | CHQ PAID 004512 | 004512 | 18,500 | 1,76,500 | Yes, ticked | |
| 28 Mar | UPI RAVI ENTERPRISES | 408812345678 | 6,200 | 1,70,300 | Yes, ticked | |
| 29 Mar | CHQ DEP CLG | 112233 | 22,000 | 1,92,300 | Yes, ticked | |
| 30 Mar | SMS AND SERVICE CHARGES | 590 | 1,91,710 | No | ||
| 31 Mar | NEFT DR PRIYA LOGISTICS | N0869876 | 12,000 | 1,79,710 | Yes, ticked |
Check the running balance: ₹1,50,000 + ₹45,000 − ₹18,500 − ₹6,200 + ₹22,000 − ₹590 − ₹12,000 = ₹1,79,710. It agrees with the last line.
Five lines tick. One does not: the ₹590 charge. The bank has taken it, but your cash book does not know about it yet. Follow it up, find the charge advice or the bank’s schedule of charges, and pass an entry in your books. Until you do, it is a reconciling item.
Why is the narration the hardest column to match?
Amounts and references are numbers, so they either match or they do not. Narrations are short text, cut off at a fixed length, and written differently by each bank. The same customer can appear as SHARMA TRADERS on one statement and SHARMA TRAD PVT on another. When there is no reference, or two payments share the same amount, the narration is often the only clue left.
That is why it pays to learn the common narration patterns for your bank. Once you can read them, you can turn them into a match key for each line.
What to read next
- Next in this series: Ledger balance vs available balance: which one goes into a bank reconciliation?
- Go deeper: Bank statement narration patterns in India
- Go deeper: HDFC Bank reconciliation in India
- For teams: Bank reconciliation software for India
When statements run to hundreds of lines a month, TransactIG matches bank statement lines to your books, puts the leftovers in an exception queue and gives you audit-ready exports.