Explore Deepvue's Enterprise Plan for Free: Insights, Dashboards, APIs and More

Bank Reconciliation Statement Format: A Complete Guide with Examples

Bank Reconciliation Statement Format: A Complete Guide with Examples

A digital banner featuring "Bank Reconciliation Statement Format: A Complete Guide With Examples," showcasing a sample Bank Reconciliation Statement and two illustrated people shaking hands.

Any company, small or large, relies on accurate financial statements to make smart choices. The most important tool in ensuring financial accuracy is the Bank Reconciliation Statement (BRS). The statement may seem formalistic at first, but when done regularly and accurately, it protects a company from costly errors, dishonesty, and financial blind spots.

What is Bank Reconciliation?

Fundamentally, bank reconciliation is the adjustment of a company’s internal accounting records (the cash book) to the bank’s records (the bank statement) in order to make both equal the same cash balance.

You may wonder—shouldn’t they always be the same? Ideally, yes. But in the real world, timing differences, delays at banks, and human or system mistakes tend to cause differences. Reconciliation fills this gap by finding and accounting for every difference until both accounts agree.

Imagine this: Your books say you have ₹2,50,000 in the bank, but the bank statement shows ₹2,30,000. Where did the ₹20,000 go? It could be a cheque that hasn’t cleared, a bank fee you forgot to record, or even a fraudulent transaction. A BRS helps you find out.

Why Do Differences Arise Between Cash Book and Bank Statement?

1. Timing Differences

  • Cheques Issued but Not Presented: You’ve issued a cheque to a vendor, but they haven’t yet deposited it. Your cash book reflects the deduction, but the bank doesn’t.
  • Cheques Received but Not Cleared: A customer pays you by cheque. You’ve made the deposit entry, but the bank hasn’t cleared it.

2. Direct Bank Entries

  • Bank Charges or Interest: Usually, banks debit charges or credit interest. In case it is not entered in the cash book, this will result in a difference.
  • Auto-Debits & Standing Instructions: EMIs on loans, SIPs, or other regular payments may be auto-debited, catching you off guard if not tracked.

3. Recording Errors 

  • In the Cash Book: You can enter the transaction twice or with the wrong value.
  • In the Bank Statement: Banks can also err, although this is uncommon.

Key Components of a Bank Reconciliation Statement

A BRS is not a checklist—it has a logical format. It generally includes the following:

  • Opening Balance: The balance of either the bank statement or cash book.
  • Additions: Merchandise that increases the bank balance (i.e., uncleared deposits).
  • Deductions: Items that reduce the bank balance (e.g., unpresented cheques, bank charges).
  • Adjusted Closing Balance: Adjusted balance after making all adjustments.

Bank Reconciliation Statement Format

There are two standard formats, depending on where you begin: from the balance of the cash book or from the balance of the bank statement. Both are attempts to reach the adjusted (true) balance.

Let us examine the structure:

Format 1: Starting with Cash Book Balance

ParticularsAdd/LessAmount (₹)
Balance as per Cash BookX
Add: Cheques issued but not presentedAddY
Less: Cheques deposited but not clearedLessZ
Less: Bank charges not recordedLessA
Adjusted Balance as per Bank StatementFinal

Format 2: Starting with Bank Statement Balance

ParticularsAdd/LessAmount (₹)
Balance as per Bank StatementX
Add: Deposits not yet credited by the bankAddY
Less: Cheques issued but not presentedLessZ
Less: Auto-debits not in the booksLessA
Adjusted Balance as per Cash BookFinal

Step-by-Step Guide to Preparing a BRS

Step-by-step guide to preparing a Bank Reconciliation Statement: collect statements, match entries, identify differences, adjust cash book, prepare BRS in the recommended Bank Reconciliation Format, and verify balance. Icons illustrate each step.

If you’re preparing a BRS manually or even using software, the process usually follows these steps:

Step 1: Collect Statements

Get the cash book and bank statement for the same period. These are your main documents.

Step 2: Look for Similar Entries

Match every bank transaction with the cash book. Mark off all similar entries.

Step 3: Mark Differences

Make a note of mismatches, like missing entries, timing discrepancies, or direct bank debits.

Step 4: Modify the Cash Book (if needed)

If you have postings such as bank fees or auto-debits that do not appear in your books, enter them before reconciliation.

Step 5: Make the BRS ready

Use the format described above to reconcile and balance systematically.

Step 6: Verify

The final step is validation. Your adjusted cash book balance should match the adjusted bank statement balance.

Bank Reconciliation Statement Example

Let’s make this simple using an example.

Scenario:

  • Cash book balance: ₹1,00,000
  • Cheque issued to supplier (not presented): ₹10,000
  • Cheque deposited from client (not cleared): ₹15,000
  • Bank charges not recorded: ₹500

BRS (Beginning with Cash Book):

ParticularsAdd/LessAmount (₹)
Balance as per Cash Book1,00,000
Add: Cheques issued but not presentedAdd10,000
Less: Cheques deposited but not clearedLess15,000
Less: Bank charges not recordedLess500
Adjusted Balance as per Bank Statement94,500

Common Errors to Shun

  • Overlooking minor charges: Service tax or bank charges can appear small, but they can upset your balances.
  • Failure to update the cash book in real-time: Late additions result in inaccurate reconciliations.
  • Neglecting old unpresented cheques: They can have to be re-issued or cancelled.
  • Blending personal and business accounts: Reconcile business accounts separately always.
A comparison chart listing common errors and benefits of regular bank reconciliation using a clear Bank Reconciliation Statement format; errors in red on the left, benefits in green on the right.

Benefits of Regular Bank Reconciliation

  • Fraud Detection: Quickly spot unauthorized or fraudulent withdrawals.
  • Cash Flow Control: Know exactly how much liquidity you truly have.
  • Compliance & Audit Readiness: Clean records simplify statutory audits.
  • Error Resolution: Rectify mistakes before they become major issues.

How Accounting Software Simplifies Reconciliation?

Many businesses now use tools like Tally, QuickBooks, or Zoho Books, which can sync with bank accounts and auto-reconcile transactions.

Benefits:

  • Automatic matching of entries
  • Real-time mismatch alerts
  • Visual dashboards for exceptions
  • Reduced manual data entry, fewer errors

When Should You Bring in a Professional?

If you’re seeing persistent variances, dealing with duplicate accounts, or preparing for a statutory audit, a pro accountant can enlighten.

Not only do they identify errors sooner, but they can also help institute a stronger reconciliation procedure, especially for growing businesses.

Conclusion

A Bank Reconciliation Statement is not just a financial to-do list—it’s your protection against mistakes, fraud, and bad decisions. No matter how you do it, with pen and paper, Excel, or accounting software, it’s about doing it regularly and accurately.

By knowing the format, having clean books, and reconciling on a regular basis, companies can remain financially fit, compliant, and audit-ready.

To make reconciliation even more seamless, our Bank Statement Analysis API automates the extraction, categorization, and interpretation of bank transactions in real time. It highlights discrepancies, identifies earnings trends, signals missing debits or credits, and even assists with matching transactions to in-house records—dramatically minimizing manual labor and errors.

FAQs 

What is a Bank Reconciliation Statement (BRS)?

Why do I need a BRS?

How frequently should I prepare a BRS?

What are the common reasons for mismatches?

Can I use software to automate BRS?

Bridging the gap between tech jargon and plain English! With over 2 years of content writing experience, I bring clarity and insight to every piece I create. I mix technical chops with a creative spin to keep readers informed and intrigued.
Share this on
You Might Also Like
Discover how credit unions differ from banks and why they matter for financial inclusion, fintech partnerships, and community lending.
Learn about Optical Character Recognition (OCR), how it works, its benefits, applications in industries like banking & healthcare, and future advancements.
UBO regulations are tightening—ensure your PSP meets compliance. Explore how to identify beneficial owners, verify their details, and stay audit-ready.

Get Started with Deepvue

Your gateway to the unified customer insights

Top Products

Aadhaar Verification API

API allows you to verify and authenticate your user identity using the Aadhaar offline verification process.

PAN Card Verification API

API allows you to quickly and easily verify user identities with authoritative sources like NSDL.

ID Card OCR API

ID Card OCR API allows you to quickly and easily convert your physical ID card into a digital equivalent.