A bank reconciliation statement (BRS) is a document that explains the difference between the bank balance shown in your accounting books and the balance shown on the bank statement. This guide covers the complete BRS format, preparation method, and examples for Indian businesses.
What is a Bank Reconciliation Statement?
Bank reconciliation is the process of matching your cash book balance (accounting records) with the bank statement balance. Differences arise due to:
- Checks issued but not yet cleared
- Checks deposited but not yet credited
- Bank charges and interest
- Direct deposits and withdrawals
- Errors in books or bank records
- Standing instructions (EMI, insurance premiums)
Bank Reconciliation Statement Format
Format 1: Starting From Bank Statement Balance
Format 2: Starting From Cash Book Balance
Step-by-Step Preparation Method
Step 1: Get the Bank Statement
Download or collect the bank statement for the reconciliation period (usually monthly). Most Indian banks provide statements in PDF, Excel, or CSV format via net banking.
Step 2: Get the Cash Book / Ledger
Export the bank ledger from your accounting software (Tally, Busy, Zoho Books). This shows all bank transactions recorded in your books.
Step 3: Match Transactions
Compare each entry in the cash book with the bank statement. Mark matched items. Unmatched items fall into categories:
| Category | Description | Adjustment |
|---|---|---|
| Checks issued, not cleared | Payment recorded in books, not in bank | Add to bank balance |
| Checks deposited, not cleared | Receipt recorded in books, not in bank | Less from bank balance |
| Bank charges | Debited by bank, not in books | Less from book balance |
| Interest credited | Added by bank, not in books | Add to book balance |
| Direct deposits | Received directly in bank (e.g., NEFT) | Add to book balance |
| Direct withdrawals | EMI, insurance, standing instructions | Less from book balance |
Step 4: Prepare the Statement
Using either format above, add/subtract the adjustments to arrive at the matching balance. If both sides don't match, there's an error — recheck your entries.
Step 5: Pass Adjusting Entries
For every item found during reconciliation that isn't in your books, pass a journal entry:
- Bank charges: Dr Bank Charges, Cr Bank
- Interest credited: Dr Bank, Cr Interest Income
- Direct deposit: Dr Bank, Cr Party/Revenue
- EMI/Insurance debit: Dr Loan/Expense, Cr Bank
Worked Example
| Particulars | Amount (₹) |
|---|---|
| Balance as per Cash Book (31 March 2026) | 2,45,000 |
| Add: Checks issued but not cleared | 35,000 |
| Add: Bank charges not recorded | 1,200 |
| Less: Checks deposited but not cleared | (28,000) |
| Less: Interest credited by bank | (3,200) |
| Less: EMI auto-debit not recorded | (15,000) |
| Adjusted Bank Balance | 2,35,000 |
| Balance as per Bank Statement | 2,35,000 |
| Difference | NIL ✅ |
✓ Verify all NEFT/RTGS/IMPS entries
✓ Account for bank charges and interest
✓ Track standing instructions (EMI, insurance)
✓ Record all direct deposits and withdrawals
✓ Investigate all unmatched items
✓ Pass adjusting journal entries
✓ File reconciliation report for audit trail
Automate Bank Reconciliation
ReconcileAI does bank reconciliation in 30 seconds. Upload bank statement + Tally ledger. High-accuracy AI matching. 2 free uses monthly.
Try ReconcileAI Free →Why Bank Reconciliation Matters
- Financial accuracy: Ensures your books reflect actual bank position.
- Fraud detection: Unauthorized transactions are caught immediately.
- Tax compliance: Accurate cash flow data is essential for GST and income tax filing.
- Audit readiness: CAs and auditors require monthly reconciliation reports.
- Cash flow management: Know your exact cash position for business decisions.
How Often Should You Reconcile?
| Business Type | Frequency | Reason |
|---|---|---|
| Small business (< ₹50 lakh turnover) | Monthly | Basic compliance |
| Medium business (₹50 lakh – 5 crore) | Weekly | Better cash control |
| Large business (> ₹5 crore) | Daily | Fraud prevention |
| CA firm (client books) | Monthly (per client) | Compliance + reporting |