17. Bank Reconciliation



1. Introduction — Why Bank Reconciliation Matters

Bank Reconciliation (BRS) is one of the most critical monthly accounting controls. It ensures that the cash balance in the books matches the balance in the bank account. Without BRS, businesses risk misstatements, fraud, GST/TDS errors, and inaccurate cashflow reporting.
Even minor differences, if ignored, can grow into major compliance and financial issues.
Key Points:• BRS ensures accuracy of cash and bank balances.• Detects errors, omissions, and irregularities.• Prevents GST, TDS, and cashflow reporting mistakes.• Essential for audit readiness and month-end closing.• A strong BRS system prevents fraud and leakage.

2. Objective

To provide a simple and structured method for preparing accurate monthly bank reconciliations and strengthening cash/bank internal controls.

3. Core Concepts — What Is a Bank Reconciliation?

Bank Reconciliation is the process of matching:Book Balance (as per ledger)withBank Balance (as per bank statement)
Differences arise because:• Cheques issued but not presented• Cheques deposited but not cleared• Bank charges not recorded• Interest not posted• Reversal/chargeback entries• Duplicate entries• Errors in posting
A proper BRS explains these differences and ensures accuracy.

4. Common Causes of Differences

A. Timing Differences

Transactions recorded by the business but not yet processed by the bank:• Uncleared cheques• Pending deposits• Salary payouts initiated but not debited

B. Bank-Initiated Entries

Items not recorded in the books:• Bank charges• Interest income• ECS/Auto-debit payments• Penalties or service charges

C. Posting Errors

• Wrong amount posted• Wrong ledger used• Duplicate entries• Missed entries

D. Fraud or Irregular Activity

BRS can uncover:• Unknown withdrawals• Unauthorised payments• Reversed transactions

5. CABTA Framework — “The 5-Step Bank Reconciliation Method”

A clear, practical system for monthly reconciliation:

Step 1 — Extract Data

• Bank statement• Bank ledger• Cashbook/ERP report• Previous BRS

Step 2 — Match Opening Balances

Opening mismatch = prior-year carry-forward issue → fix immediately.

Step 3 — Identify Unmatched Items

Mark each of these:• Deposits not reflected• Payments not reflected• Bank charges not posted• Interest not posted• Duplicate entries• Wrong postings

Step 4 — Prepare the BRS Statement

Structure:Book Balance
  • Deposits not credited– Payments not debited+/- Errors= Bank Balance
ORReverse format starting from bank balance.

Step 5 — Pass Adjustment Entries

Correct the books by posting:• Bank charges• Interest• Dishonour charges• ECS/Loan EMI debits• Corrections for wrong postings
Outcome:Books and bank match, ensuring financial accuracy and audit readiness.

6. Case Example — Eliminating Long-Standing Cashflow Errors

Client: Service companyIssue: Cashflow reports were inaccurate; GST payment shortages happened due to wrong bank balances.
CABTA Intervention:• Implemented monthly BRS checklist• Identified uncleared cheques > 90 days• Corrected duplicate postings• Fixed opening balance mismatch• Introduced maker–checker control
Result:• Accurate bank balances every month• Avoided GST interest due to wrong challans• Improved financial discipline and cashflow planning

7. Tools & Templates (Application Layer)

• Standard Bank Reconciliation Template• Bank Ledger vs Statement Matching Tool• Monthly BRS Checklist• Bank Posting SOP• Suspense & Unreconciled Items Tracker

8. CABTA Insight

“A disciplined BRS routine protects the business from invisible financial leaks.”

Next Article