Bank reconciliation is one of the most fundamental yet error-prone tasks in day-to-day accounting. Whether you run a small business or manage accounts for a CA firm with 50+ clients, a well-prepared Bank Reconciliation Statement (BRS) prevents fraud, catches errors, and ensures your cash book always matches your bank passbook.
What Is a Bank Reconciliation Statement?
A Bank Reconciliation Statement is a document that explains the difference between the balance shown in your bank passbook and the balance in your company's cash book (or bank ledger) at a specific date.
Differences arise due to timing gaps — transactions recorded in one book but not yet reflected in the other. These are normal and expected; the BRS identifies and explains every rupee of difference.
Why BRS Matters for Indian Businesses
- Detects fraud and unauthorized transactions early
- Ensures correct cash position for day-to-day financial decisions
- Required by auditors during statutory and internal audit
- Helps reconcile NACH/ECS mandates, UPI credits, and RTGS receipts
- Supports accurate GST input tax credit claims linked to bank payments
Common Causes of Differences Between Cash Book and Bank Statement
Understanding why differences arise makes reconciliation faster and more systematic.
1. Outstanding Cheques (Issued but Not Presented)
You issue a cheque of ₹45,000 to a supplier on 28 March 2026. The supplier deposits it on 5 April. In your cash book, the payment is recorded on 28 March. But the bank statement only reflects it in April. This leaves a ₹45,000 difference at 31 March.
2. Deposits in Transit (Lodged but Not Credited)
You deposit a cheque of ₹1,20,000 on 30 March 2026. The bank credits it on 1 April (next working day). Your cash book shows the receipt in March; the bank statement shows it in April.
3. Bank Charges and Interest
Banks debit service charges, SMS alerts, or locker rent directly. Until your accountant sees the bank statement, these remain unrecorded in the cash book.
4. Direct Credits via NEFT/RTGS/UPI
A debtor transfers ₹75,500 via NEFT directly to your bank account. The bank credits it immediately, but unless the cash book is updated on the same day, the receipt stays unrecorded.
5. ECS/NACH Auto-Debits
Loan EMIs, insurance premiums, and utility payments on ECS mandates are debited by the bank automatically. These often get missed in the cash book until the statement is reviewed.
6. Errors in Cash Book or Bank Statement
A cheque of ₹12,300 is entered as ₹1,23,000 — a classic transposition error. Or the bank wrongly credits or debits your account, requiring a formal error correction request to the branch.
Step-by-Step BRS Preparation Method
Follow this process every month to produce an audit-ready BRS.
Step 1: Match Opening Balances
Confirm the opening balance in your cash book matches last month's closing reconciled balance. Any carry-forward error compounds over time.
Step 2: Compare Transactions Line by Line
Place the bank statement and cash book side by side (or import both into accounting software). Tick off every matching transaction in both records.
Step 3: List Unmatched Items
Note every transaction that appears in one record but not the other. Classify each as: outstanding cheque, deposit in transit, bank charge, direct credit, or error.
Step 4: Prepare the BRS Table
| Particulars | Amount (₹) |
|---|---|
| Balance as per Cash Book (Dr.) | 2,85,000 |
| Add: Cheques deposited but not yet credited | 1,20,000 |
| Less: Cheques issued but not yet presented | (45,000) |
| Add: Bank interest credited, not in cash book | 3,200 |
| Less: Bank charges debited, not in cash book | (850) |
| Less: ECS auto-debit not recorded in cash book | (12,500) |
| Balance as per Bank Statement | 3,49,850 |
Step 5: Verify the Closing Balance
The final figure must exactly match the closing balance on your bank statement. If it does not, there is a missing item or arithmetic error — repeat the line-by-line comparison until they agree.
Step 6: Update the Cash Book
For any item in the bank statement not yet in the cash book (bank charges, direct credits, ECS debits), pass journal entries immediately so your records are current before month-end closing.
Frequency and Best Practices
Monthly BRS is the minimum — but high-transaction businesses in retail, e-commerce, or manufacturing should reconcile weekly or even daily.
- Use a single dedicated current account per entity to simplify reconciliation
- Download bank statements in CSV format and import directly into accounting software
- Set up SMS or email alerts for every debit/credit above ₹10,000
- Keep the BRS register signed by both the preparer and a reviewer for audit trail
- Flag outstanding cheques older than 90 days — they may need reversal and reissuance
- Reconcile all bank accounts, not just the primary operating account
BRS and GST/TDS Compliance
BRS is not just an accounting formality — it directly affects tax compliance.
GST payments: GSTR-3B liability paid via the electronic cash ledger must tally with actual bank debits on the same date. Mismatches can trigger scrutiny notices from the GST department.
TDS challans: TDS deposited via Challan 281 should be verified against the bank statement. Short payments attract interest under Section 201A of the Income Tax Act.
Statutory audit evidence: Under Rule 11 of the Companies (Audit and Auditors) Rules, statutory auditors will invariably request monthly BRS as supporting documentation during balance sheet verification.
How corpus Helps
corpus automates the most time-consuming parts of BRS preparation:
- Bank feed import: Upload your bank statement in CSV or OFX format. corpus automatically maps every debit and credit to the correct ledger entry using intelligent narration matching.
- Smart matching engine: corpus flags unmatched transactions with suggested matches based on amount, date, and narration — cutting manual comparison time by up to 80%.
- Outstanding cheque tracker: corpus maintains a running register of all issued cheques and automatically clears each entry the moment the corresponding bank debit appears.
- One-click BRS report: Generate a formatted, audit-ready BRS for any date range — including a GSTR-3B payment verification column — in seconds.
- Multi-client dashboard: For CA firms managing multiple clients, corpus displays the reconciliation status of every client account at a glance, with automated alerts for any account not reconciled in the last 30 days.
Conclusion
A timely, accurate Bank Reconciliation Statement is the backbone of reliable financial reporting. It prevents fraud, ensures tax compliance, and gives business owners a true picture of their cash position. Done monthly — or more frequently — BRS catches errors early, before they cascade into larger audit or compliance problems.
If you are still preparing BRS manually in Excel or Tally, it is time to switch to a smarter solution. Try corpus free for 14 days and experience automated bank reconciliation built specifically for Indian businesses and CA firms.
Contributing author at corpus. Expert in Indian accounting compliance, GST, and financial reporting for professionals and growing businesses.
Smarter accounting starts with corpus
AI-powered cloud accounting built for Indian professionals. GST, payroll, TDS — all in one platform. Join 2,400+ CAs on the waitlist.
Join the Waitlist →