Back to Blog|Bank Reconciliation

Matching Bank Ledger & Cash Book: Reconciliation Guide

June 4, 202612 Min ReadCA Rakesh Sharma

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 DifferenceExamplesReconciliation Action
Timing DifferencesUnpresented cheques, deposits in transitNo adjustment needed; list in BRS statement
Book ErrorsWrong transaction amounts, omitted entriesRecord adjusting journal entries in ledger
Bank EntriesAuto-deducted bank charges, interest creditsPost 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.

Stop entering bank transactions line-by-line: Skip the manual ledger matching. Just upload your bank statement PDF, and TrulyInvoice will clean up transaction details and sync your payments and deposits directly to Tally Prime in minutes.
C
CA Rakesh SharmaExpert Reviewer

Chartered Accountant & Accounting Automation Specialist

Last Verified: June 4, 2026
TallyPrime FY 2026-27 (v4.0+)
Ready to save time?

Stop Manual Voucher Entry.

TrulyInvoice automates your complete invoice workflow and syncs directly to Tally Prime.

No credit card · 14-day free trial

01

Upload Invoice

Drag & drop PDFs, scans, or photos.

02

AI Extraction

Line items, tax, and ledgers mapped.

03

1-Click Review

Verify extracted details on dashboard.

04

Direct Sync

Vouchers created instantly in Tally Prime.

Chat with us