Lesson 18 of 33 · Free
Contents
- 1 Bank Reconciliation
- 1.1 Why bank reconciliation is non-negotiable
- 1.2 Why book balance ≠ bank balance
- 1.3 The 6-step process
- 1.4 Worked example
- 1.5 The follow-up journal entries
- 1.6 How often to reconcile
- 1.7 Lesson recap
- 1.8 Practical Indian Application
- 1.9 Worked Example — Yatra Books Bank Reconciliation
- 1.10 Common Mistakes in BRS
- 1.11 Frequently Asked Questions
- 1.12 Fraud Detection and Modern Reconciliation Tools
Bank Reconciliation
Why your books and your bank never match — and how to find every difference. The 6-step process plus the journal entries that follow.
Why bank reconciliation is non-negotiable
Your books say the company has ₹52,500 in the bank. The bank statement says ₹59,830. Both can be right — there’s a list of timing differences and corrections that explains the gap. Bank reconciliation is the monthly discipline of identifying and resolving every item on that list, so you can confidently say “this is exactly how much cash we have, and these are the open items”.
Skip bank reconciliation and three things happen: bank charges get missed, cheque frauds go undetected, and your cash balance on the balance sheet is wrong. None of those are acceptable.
Why book balance ≠ bank balance
Five categories of differences:
- Timing — deposits in transit. You deposited a cheque on Mar 31 but the bank credited it on Apr 1. Your books include it; the bank statement doesn’t.
- Timing — outstanding cheques. You issued a cheque on Mar 28 but the payee hasn’t deposited it yet. Your books deduct it; the bank statement doesn’t.
- Bank items not in your books. Service charges, interest credited, automatic loan EMI debits, NSF cheques returned. The bank knows, you don’t (until you reconcile).
- Errors in your books. Wrong amount entered, transposed digits, missed transaction.
- Errors at the bank. Rare but happens. Wrong account credited, duplicated debit.
The 6-step process
- Get the bank statement for the period.
- Compare line by line with your cash book. Tick off matches.
- List unticked items from both sides. These are your reconciling items.
- Identify the cause for each unticked item — is it timing, a bank item, or an error?
- Adjust the book balance for items the bank knew first (charges, interest, NSF, errors).
- Confirm that adjusted book balance = adjusted bank balance. If not, repeat from step 2.
Worked example
March-end. Cash book balance ₹52,500. Bank statement balance ₹59,830. After investigation:
| Item | Side affected | Amount (₹) |
|---|---|---|
| Bank charges debited Mar 28 — not in books | Reduce book balance | (450) |
| Cheque from customer XYZ returned NSF | Reduce book balance | (3,500) |
| Interest credited by bank | Increase book balance | +280 |
| Cheque #1042 issued ₹5,400 but recorded as ₹4,500 | Reduce book balance | (900) |
| Deposit Mar 31 not yet shown by bank | Increase bank balance | +8,200 |
| Outstanding cheques (3 cheques) | Reduce bank balance | (20,100) |
Adjusted book balance: 52,500 − 450 − 3,500 + 280 − 900 = ₹47,930
Adjusted bank balance: 59,830 + 8,200 − 20,100 = ₹47,930 ✓
The match means the books are complete. The four book-side adjustments now need to be journalised — that’s the part beginners forget.
The follow-up journal entries
The reconciliation reveals what the books are missing. Each correction becomes a journal entry:
Mar 31 Bank Charges A/c Dr. 450
To Bank 450
Mar 31 Accounts Receivable Dr. 3,500
To Bank 3,500
(Being NSF cheque from XYZ — re-instate AR)
Mar 31 Bank Dr. 280
To Interest Income 280
Mar 31 Suspense / Vendor X Dr. 900
To Bank 900
(Being correction of cheque #1042 mis-entry)
After these entries are posted, the cash book balance moves from ₹52,500 to ₹47,930 — matching the adjusted bank balance.
How often to reconcile
Monthly at minimum, ideally weekly for a high-transaction-volume business. Reconciling daily is overkill for most businesses but mandatory for banks themselves and large e-commerce operations where cash positions move millions of rupees in a day.
Software (Tally, Zoho, QuickBooks, Xero) can import bank statements and auto-match — turning an afternoon’s work into 20 minutes. Use it.
Lesson recap
- Bank rec catches timing differences, bank-side items, and errors.
- Adjust both sides until adjusted balances match.
- Adjustments to the book side must be journalised.
- Monthly is the minimum cadence.
Cement what you just learned
Head to our free Study Hub and find Bank Reconciliation. Each topic comes with four interactive study modes — quiz yourself, flip through flashcards, unscramble jumbled terms, and solve a topic-specific crossword. No login required.
Go deeper with these accounting classics
Hand-picked books to reinforce what you’ve learned in this lesson.
Apply what you’ve learned
Practical Indian Application
Tools to bookmark: Tally Prime Auto-BRS; Zoho Books Bank Feed integration; RBI Positive Pay portal; ICAI’s Guidance Note on Bank Audit for control framework; major bank business banking portals for daily CSV/PDF downloads.
Worked Example — Yatra Books Bank Reconciliation
Suppose Yatra Books, Delhi, has cash book balance ₹8,00,000 on 31 May 2026 but the SBI passbook shows ₹6,75,000. Investigation: Cheques deposited but not cleared ₹1,80,000 (add to passbook), cheques issued but not presented ₹2,50,000 (deduct from passbook), bank charges not booked ₹3,500 (deduct from cash book), interest credited but not recorded ₹4,500 (add to cash book), direct debit for EMI ₹85,000 not booked (deduct from cash book), UPI receipts from customers ₹1,50,000 not booked (add to cash book). After adjustments cash book and passbook reconcile to a common figure, and the accountant must pass entries for the bank charges, interest, EMI deduction, and UPI receipts to bring the cash book up to date.
Common Mistakes in BRS
- Skipping the BRS for any month — once skipped, future reconciliation becomes harder
- Not investigating stale cheques (older than 3 months per RBI) — these need reissuance
- Missing automated bank charges that recur monthly
- Not segregating multiple bank accounts properly in the chart of accounts
Frequently Asked Questions
How frequently must BRS be performed?
At least monthly for SMEs, daily or weekly for high-volume firms. Quarterly is too long for audit comfort.
What is the positive pay system?
An RBI-mandated process where issuers electronically share key cheque details with their bank for verification before payment. Mandatory for cheques ≥ ₹5 lakh, optional for ₹50,000 and above.
Are bank charges tax-deductible?
Yes, under Section 37(1) of the Income-tax Act, ordinary bank charges incurred wholly for business are deductible.
Can Tally auto-reconcile?
Yes — Tally Prime imports CSV/PDF and matches by amount, date and narration; unmatched items can then be resolved manually.
Fraud Detection and Modern Reconciliation Tools
Bank reconciliation is often the first line of defence against insider fraud. A common scheme is the ‘lapping’ fraud — pocketing collections from one customer, then covering it with collections from a later customer. The BRS exposes this through delays in customer-credit posting. Another scheme: cheques issued to fictitious vendors that show as ‘unpresented’ on the BRS indefinitely — investigate any cheque outstanding beyond 30 days. RBI’s positive pay system reduces both risks materially. Modern tools: Tally Prime’s auto-BRS imports SBI/HDFC/ICICI bank CSVs and matches transactions algorithmically. Zoho Books integrates directly with bank feeds for real-time reconciliation. For high-volume e-commerce firms, RecKonnect and ReconArt are popular reconciliation platforms.
Workflow Integration
Make BRS a non-negotiable monthly discipline. Use Tally Prime’s auto-BRS import feature for SBI/HDFC/ICICI/Axis bank CSVs. Investigate every unreconciled item beyond ₹10,000 within 48 hours. The discipline catches fraud, errors, and missed deposits early — well before they compound into audit qualifications or notice from tax authorities.
The Audit Trail Era — Post April 2023
Rule 3 of the Companies (Accounts) Rules 2014, as amended in 2023, requires every company using accounting software to maintain an audit trail of every edit, modification, and deletion. The audit trail must be tamper-proof — once recorded, it cannot be disabled or altered. For bank reconciliation, this means every entry passed against the bank ledger is timestamped and attributed to a specific user. Auditors are now mandated to verify the audit trail feature is active throughout the year. Non-compliance attracts penalty under Section 450 of the Companies Act. Tally Prime, Zoho Books, SAP, Oracle NetSuite have all updated their software to meet this requirement — verify with your vendor that the audit trail is active in your installation.