Matching Bank Ledger & Cash Book: Reconciliation Guide
Matching Bank Ledger & Cash Book: Reconciliation Guide
Identify timing differences, resolve errors, reconcile Cash-in-Transit deposits, and automate BRS configurations in Tally Prime.
Who is this for: Bank Reconciliation
reconciling the bank ledger with your actual cash book is one of the first checks performed during monthly closures. Timing differences and transaction discrepancies can cause book balances to drift from actual bank balances.
Establishing a structured **Bank Reconciliation Statement (BRS)** helps accountants isolate timing differences from errors and adjust book ledgers.
1. Timing Differences vs. Permanent Errors
Discrepancies in reconciliations fall into two categories:
| Type of Difference | Examples | Reconciliation Action |
|---|---|---|
| Timing Differences | Unpresented cheques, deposits in transit | No adjustment needed; list in BRS statement |
| Book Errors | Wrong transaction amounts, omitted entries | Record adjusting journal entries in ledger |
| Bank Entries | Auto-deducted bank charges, interest credits | Post corresponding payment/receipt vouchers |
2. Reconciling Bank Interest and TDS u/s 194A
Banks credit interest on savings and fixed deposit accounts periodically. Under Section 194A of the Income Tax Act, banks must deduct TDS at **10%** if interest earnings exceed ₹40,000 (₹50,000 for senior citizens) in a financial year.
These deductions are often recorded in bank statements without individual advices. Reconciling them requires pulling monthly statements, isolating interest receipts and TDS withholdings, and posting adjusting entries:
Debit: Bank Account (Net Interest) ₹9,000 Debit: TDS Receivable Account (194A) ₹1,000 Credit: Interest Income Ledger ₹10,000
3. Petty Cash Management & Section 40A(3) Controls
Petty cash accounts present higher operational risks due to the physical nature of transactions. To establish control, businesses use the Imprest System, where the petty cashier starts with a fixed float (e.g. ₹10,000). At weekly intervals, the cashier submits receipts, and the main cashier replenishes the exact spent amount.
Additionally, under Section 40A(3) of the Income Tax Act, any single cash payment exceeding **₹10,000** to a single person in a day is disallowed as a business expense. Expense matching tools verify that cash transactions comply with this threshold.
4. Case Study: Reconciling Cash-in-Transit (CIT)
On March 30, 2026, a retail store deposits **₹50,000** in physical cash via a bank deposit machine. The store accountant credits the Cash ledger and debits the *Bank* ledger.
However, due to a bank system update, the deposit is only credited to the bank account on April 2.
The adjusting entries required to track this transit sequence correctly are:
Entry 1: Record Cash Sent for Deposit (March 30, 2026) Debit: Cash-in-Transit Account ₹50,000 Credit: Cash Ledger ₹50,000 Entry 2: Reconciled Bank Deposit (April 2, 2026) Debit: Bank Account ₹50,000 Credit: Cash-in-Transit Account ₹50,000
5. Statutory Auditing Protocols for Cash Book and BRS Verification
Under CARO 2020 guidelines, auditors perform physical cash counts at year-end and compare balances with the cash book. In addition, auditors verify that all material timing differences (such as unpresented cheques exceeding ₹1,00,000) are valid and clear the bank in subsequent periods.
If cheques remain uncleared past 3 months, auditors verify that they are reversed to prevent window dressing.
6. Handling Cash Book Discrepancies and Shortages
If physical cash verification reveals a shortage against cash book records, and investigation cannot trace the discrepancy, the shortage must be written off.
To adjust the books, record a journal entry debiting *Loss on Cash Discrepancy* and crediting the *Cash* ledger. This write-off is generally deductible u/s 37(1) if it occurred during normal business operations.
7. Reconciling Ledger Balances in Tally Prime
To manage cash book and bank ledger matchings:
Tally Bank Reconciliation:
Go to **Gateway of Tally > Display More Reports > Account Books > Cash/Bank Book**. Select your bank account and press **Alt+R (Reconcile)**.
Input the actual clearing date for each transaction from the bank statement. Tally will calculate the difference between the book balance and bank balance, generating a compliant BRS report.
Chartered Accountant & Accounting Automation Specialist