Bank Reconciliation Statement (BRS)
Prerequisite: Day 40 - Banking Overview
🎯 Learning Objectives:
- Understand reasons for difference between Company Books and Bank Passbook
- Perform manual BRS entry by setting Bank Dates in TallyPrime
- Perform Auto BRS by importing bank electronic statements (CSV/Excel)
- Resolve unpresented cheques, uncleared deposits & direct bank charges
2. What is this?
Simple Layman Definition: Bank Reconciliation Statement (BRS) is an essential component of Banking, providing structured operational procedures to ensure commercial compliance and financial clarity.
Professional Accounting Definition: Bank Reconciliation Statement (BRS) represents a standardized accounting and enterprise resource management methodology governed by Indian Accounting Standards (Ind-AS) and statutory regulatory mandates in TallyPrime.
| Aspect | Details & Practical Relevance |
|---|---|
| Primary Purpose | To systematically process, control, audit, and report bank reconciliation statement (brs) transactions with maximum financial accuracy and operational efficiency. |
| Where It Is Used | Implemented across corporate enterprises, SME trading houses, manufacturing plants, distribution networks, and chartered accountancy firms in India. |
| Who Uses It | Senior Accountants, Tally Operators, Accounts Executives, Finance Controllers, and Tax Auditors. |
| Why It Matters in Accounting Jobs | Mastery of Bank Reconciliation Statement (BRS) is directly tested in accounting employment interviews and required in day-to-day corporate accounts administration. |
📌 Real-Life Workplace Example:
A registered trading firm in Mumbai executes bank reconciliation statement (brs) to maintain real-time compliance with suppliers, clients, and GST authorities.
3. Why is this Important?
- Why Businesses Use It: Prevents revenue leakage, optimizes capital utilization, satisfies statutory audits, and preserves accurate corporate ledger history.
- Why Accountants Need It: Provides a structured protocol to record entries correctly on the first attempt without risking post-audit adjustments.
- Why Required in TallyPrime: TallyPrime automates report compilation, GST triangulation, and ledger balancing when Bank Reconciliation Statement (BRS) is configured properly.
- What Problem It Solves: Eliminates manual calculation errors, reconciles discrepancy gaps, and prevents non-compliance penalties under tax regulations.
- What Happens If Not Used Correctly: Incorrect handling causes erroneous financial statements, misleading management reports, and statutory penalties under GST/Income Tax Acts.
4. When is it Used?
Executed whenever relevant commercial events occur during the daily billing, payment, inventory movement, or period-end closing cycles.
⚖️ Decision-Making Rule:
Whenever evaluating this transaction, verify whether it represents an Asset, Liability, Revenue, or Expense. Apply double-entry rules strictly: Total Debits must equal Total Credits before confirming in TallyPrime.
5. How Does it Work?
The operational flow for Bank Reconciliation Statement (BRS) follows a clear sequential procedure:
1. Source Document Verification
➔
2. Identify Debit & Credit Ledgers
➔
3. Input in TallyPrime
➔
4. Audit & Reconcile Reports
- 1. Verify authorization and underlying source document (invoice, challan, advice, or receipt).
- 2. Identify the applicable accounts or inventory items affected by the bank reconciliation statement (brs) transaction.
- 3. Apply appropriate accounting rules, tax slabs, or inventory valuation parameters.
- 4. Navigate to the designated menu in TallyPrime and input mandatory master/voucher parameters.
- 5. Verify arithmetical balance, GST/TDS tax calculations, and bill-wise reference allocations.
- 6. Accept and save the entry; verify report reflections in Trial Balance, Stock Summary, or Day Book.
6. Accounting Logic & Journal Entry
Representative Transaction
Double-Entry Standard
"Reconciled cheque # 700101 of ₹45,000 issued to supplier; cleared in bank statement on 28th of the month."
Identified Accounts: Supplier A/c (Cleared) | Bank Current A/c (Reconciled)
Applied Rule: Set Bank Date in TallyPrime BRS screen to match exact clearance date on bank statement.
Applied Rule: Set Bank Date in TallyPrime BRS screen to match exact clearance date on bank statement.
| Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
| Sundry Creditor A/c | ₹45,000 | |
| To Bank Current A/c | ₹45,000 |
(Being cheque cleared and verified in Bank Reconciliation Statement.)
Why This Logic Works: The primary account is debited to recognize asset addition or operating expense; the bank account is credited to reflect the reduction in liquid funds.
7. TallyPrime Practical Execution (Step-by-Step)
1
Open Gateway of Tally
Launch TallyPrime
Load Active Company
2
Open Target Function
Press Alt+G (Go To) or select required menu for Bank Reconciliation Statement (BRS)
3
Select Mode / Voucher
Press designated shortcut key (e.g. F2 for Date, F4-F9 for Vouchers)
4
Input Party / Account
Select Debit and Credit ledgers or relevant item masters
5
Verify Values & Tax
Ensure invoice value, quantity, and statutory duty match source bills
6
Enter Bill-wise Reference
Allocate New Ref, Agst Ref, or Advance with credit terms
7
Save & Verify
Press Ctrl+A to save; inspect Trial Balance or Day Book to audit posting
8. Field-by-Field Screen Breakdown
| Field Name | Meaning & Significance | What to Enter | Accounting / Compliance Rule |
|---|---|---|---|
| Date | Effective transaction date | Current transaction date |
Must fall within active Financial Year |
| Particulars | Target ledger account | Applicable master ledger |
Select from pre-configured Chart of Accounts |
| Amount | Monetary transaction value | Exact invoice/voucher value |
Must balance exactly between Dr and Cr |
| Narration | Audit transaction description | Description for Bank Reconciliation Statement (BRS) |
Document voucher/instrument numbers for audit trail |
| Tax / Duty | Statutory deduction or tax | Applicable GST/TDS head |
Auto-computed or selected as per tax rate |
9. Real-World Business Case Scenarios
🏢 Indian Corporate Scenario:
Zenith Enterprises (Noida, UP) maintains computerized accounting for Bank Reconciliation Statement (BRS) across its trading operations with monthly turnover of ₹45 Lakhs.
10. Dedicated Practice Set & Tally Datasets
📝 Practical Assignment: Bank Reconciliation Statement (BRS) Practice Dataset
Input Bank Clearance Dates to reconcile Cash Book balance (₹3,50,000) with Bank Passbook.
| Voucher Date | Cheque / Ref # | Party Name / Transaction | Cheque Amt (₹) | Cash Book Status | Bank Clearance Date |
|---|---|---|---|---|---|
| 12-Apr | CHQ-400101 | Anil InfoTech (Payment) | 1,27,500 | Issued & Debited in Bank | 18-Apr-2026 |
| 15-Apr | CHQ-400102 | Mahendra InfoTech (Payment) | 76,200 | Issued but NOT presented | Pending / Uncleared |
| 18-Apr | CHQ-400103 | Sun Micro Pvt Ltd (Payment) | 54,000 | Issued & Debited in Bank | 24-Apr-2026 |
| 20-Apr | CHQ-80051 | Deepak Creation (Receipt Deposit) | 1,55,000 | Deposited & Credited in Bank | 23-Apr-2026 |
| 24-Apr | CHQ-80052 | Metro Retail Hub (Receipt Deposit) | 92,000 | Deposited but NOT collected | Pending / Uncleared |
| 30-Apr | Direct Debit | Bank Annual Locker Rent & SMS | 1,450 | Not recorded in Cash Book | 30-Apr-2026 |
| 30-Apr | Direct Credit | Interest on Term Deposit | 8,200 | Not recorded in Cash Book | 30-Apr-2026 |
| 30-Apr | Direct NEFT | Direct Customer Deposit (Sharma Bros) | 35,000 | Not recorded in Cash Book | 30-Apr-2026 |
🔍 Checking Effect & Report Verification in TallyPrime:
Navigation Path:
Gateway of Tally → Banking → Bank Reconciliation → Select Bank Account (Press F12 to configure)
(Shortcut: Press Alt + G → Type 'Statistics' → Drill down into voucher type)
Audit Checkpoint: Check that 'Balance as per Company Books' is ₹3,50,000, 'Amounts not reflected in Bank' is computed automatically, and 'Balance as per Bank' matches exact passbook closing.
🟢 Level 1 – Basic Knowledge & Mechanics (5 Questions)
Q1: What is the primary objective of preparing a Bank Reconciliation Statement (BRS)?
Standard Solution & Accounting Treatment:
To identify and explain the causes of difference between the bank balance in the company's Cash Book and the balance in the Bank Passbook.
To identify and explain the causes of difference between the bank balance in the company's Cash Book and the balance in the Bank Passbook.
Q2: Where do you access BRS in TallyPrime?
Standard Solution & Accounting Treatment:
Gateway of Tally → Banking → Bank Reconciliation (or Alt + G → Bank Reconciliation).
Gateway of Tally → Banking → Bank Reconciliation (or Alt + G → Bank Reconciliation).
Q3: What is an unpresented cheque?
Standard Solution & Accounting Treatment:
A cheque issued to a creditor that has not yet been presented at the bank for payment.
A cheque issued to a creditor that has not yet been presented at the bank for payment.
Q4: What is an uncollected / uncleared cheque?
Standard Solution & Accounting Treatment:
A cheque received from a customer and deposited into the bank, but the funds have not yet been cleared and credited by the bank.
A cheque received from a customer and deposited into the bank, but the funds have not yet been cleared and credited by the bank.
Q5: How do you enter the bank clearance date in TallyPrime BRS?
Standard Solution & Accounting Treatment:
Navigate to the Bank Reconciliation screen, highlight the transaction, and enter the date in the 'Bank Date' column.
Navigate to the Bank Reconciliation screen, highlight the transaction, and enter the date in the 'Bank Date' column.
🟡 Level 2 – Intermediate Practical Voucher Problems (5 Questions)
Q1: Bank credits ₹4,500 interest directly into your account. How do you bring this into TallyPrime?
Standard Solution & Accounting Treatment:
Pass a Receipt voucher (F6): Debit Bank Current A/c ₹4,500 | Credit Interest Received A/c ₹4,500.
Pass a Receipt voucher (F6): Debit Bank Current A/c ₹4,500 | Credit Interest Received A/c ₹4,500.
Q2: Bank debits ₹650 for cheque return charges. Pass the voucher entry.
Standard Solution & Accounting Treatment:
Pass a Payment voucher (F5): Debit Bank Charges A/c ₹650 | Credit Bank Current A/c ₹650.
Pass a Payment voucher (F5): Debit Bank Charges A/c ₹650 | Credit Bank Current A/c ₹650.
Q3: If Balance as per Cash Book is ₹1,00,000, Cheques issued but not presented are ₹20,000, and Cheques deposited but not cleared are ₹15,000, calculate Passbook balance.
Standard Solution & Accounting Treatment:
Passbook Balance = ₹1,00,000 + ₹20,000 (unpresented cheques) - ₹15,000 (uncleared cheques) = ₹1,05,000.
Passbook Balance = ₹1,00,000 + ₹20,000 (unpresented cheques) - ₹15,000 (uncleared cheques) = ₹1,05,000.
Q4: Explain the Auto-BRS feature in TallyPrime.
Standard Solution & Accounting Treatment:
TallyPrime allows importing bank electronic statements (in Excel, CSV, or MT940 format). It automatically matches cheque numbers and dates, reconciling matching entries instantly.
TallyPrime allows importing bank electronic statements (in Excel, CSV, or MT940 format). It automatically matches cheque numbers and dates, reconciling matching entries instantly.
Q5: What should you do if an issued cheque remains unpresented for more than 3 months?
Standard Solution & Accounting Treatment:
The cheque becomes stale under banking law. Reverse the payment voucher in TallyPrime: Debit Bank A/c and Credit Creditor A/c, then reissue a fresh cheque.
The cheque becomes stale under banking law. Reverse the payment voucher in TallyPrime: Debit Bank A/c and Credit Creditor A/c, then reissue a fresh cheque.
🔴 Level 3 – Job & Industry Audit Scenarios (5 Questions)
Q1: During monthly BRS, you spot a ₹50,000 credit in the bank statement with no customer name. How do you handle it in TallyPrime?
Standard Solution & Accounting Treatment:
Record a temporary Receipt voucher: Debit Bank A/c ₹50,000 and Credit 'Suspense A/c (Bank)'. Contact bank branch for remitter details; once confirmed, reclassify Suspense to the customer's ledger.
Record a temporary Receipt voucher: Debit Bank A/c ₹50,000 and Credit 'Suspense A/c (Bank)'. Contact bank branch for remitter details; once confirmed, reclassify Suspense to the customer's ledger.
Q2: A cheque of ₹18,000 received from customer was entered as ₹81,000 in the Cash Book. Explain the BRS effect and rectification.
Standard Solution & Accounting Treatment:
Cash book is overstated by ₹63,000. In BRS: Deduct ₹63,000 from cash book balance. Rectification in Tally: Alter the original receipt voucher or pass a journal debiting Customer and crediting Bank for ₹63,000.
Cash book is overstated by ₹63,000. In BRS: Deduct ₹63,000 from cash book balance. Rectification in Tally: Alter the original receipt voucher or pass a journal debiting Customer and crediting Bank for ₹63,000.
Q3: Can BRS be printed in TallyPrime for audit files?
Standard Solution & Accounting Treatment:
Yes, open Bank Reconciliation screen and press Alt + P (or Ctrl + P) → Configure options (show reconciled vouchers, narration) → Print.
Yes, open Bank Reconciliation screen and press Alt + P (or Ctrl + P) → Configure options (show reconciled vouchers, narration) → Print.
Q4: What is an Overdraft (unfavourable) balance in BRS?
Standard Solution & Accounting Treatment:
When cash book has a Credit balance (borrowed from bank). In overdraft BRS, the addition/deduction rules invert relative to favourable balances.
When cash book has a Credit balance (borrowed from bank). In overdraft BRS, the addition/deduction rules invert relative to favourable balances.
Q5: Why should BRS be prepared monthly rather than annually?
Standard Solution & Accounting Treatment:
To detect bank errors, unauthorized withdrawals, cheque frauds, and stale cheques promptly before year-end books close.
To detect bank errors, unauthorized withdrawals, cheque frauds, and stale cheques promptly before year-end books close.
⚡ Industry Challenge Scenarios (2 Complex Cases)
Challenge 1: Cash Book shows overdraft balance of ₹80,000 (Credit). Cheques issued but not presented: ₹35,000. Cheques deposited but not cleared: ₹50,000. Bank charges ₹1,200 not in cash book. Direct customer deposit: ₹22,000. Calculate Passbook balance.
Detailed Professional Solution:
Starting Overdraft = -₹80,000. + Unpresented Cheques: +₹35,000. - Uncleared Deposits: -₹50,000. - Bank Charges: -₹1,200. + Direct Deposit: +₹22,000. Result = -₹80,000 + 35,000 - 50,000 - 1,200 + 22,000 = -₹74,200 (Overdraft as per Passbook of ₹74,200).
Starting Overdraft = -₹80,000. + Unpresented Cheques: +₹35,000. - Uncleared Deposits: -₹50,000. - Bank Charges: -₹1,200. + Direct Deposit: +₹22,000. Result = -₹80,000 + 35,000 - 50,000 - 1,200 + 22,000 = -₹74,200 (Overdraft as per Passbook of ₹74,200).
Challenge 2: How do you reconcile post-dated cheques in TallyPrime BRS?
Detailed Professional Solution:
Post-dated cheques (marked with Ctrl+T) do not enter regular bank ledgers or BRS until their effective voucher date arrives, preventing artificial differences in bank reconciliation.
Post-dated cheques (marked with Ctrl+T) do not enter regular bank ledgers or BRS until their effective voucher date arrives, preventing artificial differences in bank reconciliation.
11. Practical Company Simulation Scenario
🏢 Company Case Study: Sharma Enterprises Pvt. Ltd.
Financial Year: 01-Apr-2026 to 31-Mar-2027 | Location: Delhi (State Code: 07)
Starting Balances: Cash in Hand ₹75,000 | State Bank of India ₹3,50,000 | Capital ₹5,00,000 | Anil InfoTech (Creditor) ₹1,27,500 | Deepak Creation (Debtor) ₹1,55,000
Dated Transaction Schedule for TallyPrime:
- 01-Apr-2026: Settle pending payment to Anil InfoTech of ₹1,27,500 against Bill # P-106 via SBI Bank cheque # 500101.
- 02-Apr-2026: Collect ₹1,55,000 from Deepak Creation against Bill # 102 deposited directly into SBI Current Account.
- 04-Apr-2026: Execute transaction for Bank Reconciliation Statement (BRS) valued at ₹45,000.
- 07-Apr-2026: Paid monthly shop rent ₹25,000 by cheque and stationery ₹2,400 in cash.
- 10-Apr-2026: Audit voucher postings in Day Book and confirm that no entries remain unallocated.
12. Expected Reports & Verification Keys
| Voucher Type | Debit Account | Credit Account | Amount (₹) | Audit Verification Key |
|---|---|---|---|---|
| F5 / F6 / F7 | Target Expense / Asset A/c | Bank / Cash / Creditor | ₹45,000.00 | Reflected in Day Book & Statistics register |
13. Common Mistakes & How to Avoid Them
❌ WRONG: Executing Bank Reconciliation Statement (BRS) under incorrect ledger group in TallyPrime
✅ CORRECT: Verify group classification in Chart of Accounts before recording entry
❌ WRONG: Omitting narration and source document reference numbers
✅ CORRECT: Always input invoice, challan, or cheque numbers in the narration field
❌ WRONG: Failing to select bill-wise reference details for debtor/creditor entries
✅ CORRECT: Always allocate against specific bill numbers to avoid 'On Account' ambiguity
❌ WRONG: Recording transactions without verifying applicable GST/TDS rates
✅ CORRECT: Confirm tax rates against latest CBIC notifications or party PAN status
❌ WRONG: Bypassing bank date allocation during reconciliation
✅ CORRECT: Input actual date from bank passbook statement to preserve BRS accuracy
14. Job-Oriented Interview Questions & Answers
Basic Interview Questions
1. What is the role of Bank Reconciliation Statement (BRS) in financial accounting? ▾
2. Which menu in TallyPrime provides access to Bank Reconciliation Statement (BRS)? ▾
3. Why is accurate source documentation mandatory for this topic? ▾
4. How does TallyPrime prevent unbalanced entries here? ▾
5. What is the consequence of selecting the wrong ledger group? ▾
Practical Interview Questions
1. Explain the step-by-step Tally procedure to configure Bank Reconciliation Statement (BRS). ▾
2. How do you verify that Bank Reconciliation Statement (BRS) has been correctly posted? ▾
3. Which shortcut key is most vital when executing this task? ▾
4. How do statutory taxes integrate with Bank Reconciliation Statement (BRS)? ▾
5. What report is reviewed by management to inspect this area? ▾
Scenario-Based Interview Questions
1. Your auditor notices a mismatch in Bank Reconciliation Statement (BRS) during year-end finalization. How do you resolve it? ▾
2. A client requests an instant statement for Bank Reconciliation Statement (BRS). How do you generate it? ▾
3. An entry for Bank Reconciliation Statement (BRS) was recorded with the wrong date. How do you correct it? ▾
15. Examination & Knowledge Assessment
16. Quick Revision & Key Takeaways
⚡ Essential Points to Remember:
- Core Concept: Bank Reconciliation Statement (BRS) is an essential component of Banking, providing structured operational procedures to ensure commercial compliance and financial clarity.
- Accounting Law: Every transaction impacts at least two accounts in opposite directions (Dr = Cr).
- Master Navigation: Gateway of Tally → Vouchers or Masters → Save with
Ctrl + A. - Audit Verification: Always cross-reference Day Book postings against physical source bills.
- Compliance Focus: Adhere strictly to Indian Accounting Standards and GST/TDS provisions.
💡 Golden Takeaway: Always audit your entries before closing the day. Accurate bookkeeping today prevents severe audit and tax liabilities tomorrow!
17. Calculation Formulas & Logic
📐 Applicable Formula:
Financial Equilibrium: Total Debits (Dr) = Total Credits (Cr) | Net Value = Gross Amount - Discounts + Applicable Taxes
18. Practical Execution Checklist
Daily Practical Task Milestones (Saved in Browser)
0 / 5 Completed