Preparing a Bank Reconciliation Statement

In the previous chapter, "Why Cash Book and Pass Book Differ", we looked at all the sneaky reasons your business's accounting records and the bank's records drift apart. We learned about timing differences, like cheques floating in the mail, and transactions the bank does behind your back, like deducting service charges.

Knowing why they differ is the first half of the battle. Now, we have to actually fix it.

In this chapter, we are going to roll up our sleeves and prepare a Bank Reconciliation Statement (BRS). We will start with a normal, healthy bank balance in our own Cash Book, and mathematically walk our way across the bridge until we perfectly match the balance shown in the bank's Pass Book.

By the end of this chapter, you will not need to memorize long, confusing tables of "what to add" and "what to deduct." Instead, you will understand the simple, foolproof logic that makes every BRS problem easy to solve.

The Mindset of Reconciliation

Before we look at formats and numbers, we need to get our mindset right.

A Bank Reconciliation Statement is not an account. It is not a part of your double-entry bookkeeping system. You do not pass journal entries into a BRS.

Instead, a BRS is simply a piece of paper—a mathematical worksheet—where you prove that the difference between two numbers is entirely explainable. You are acting as a detective. You are saying, "My book says I have ₹50,000. The bank says I have ₹55,000. Here is the exact mathematical proof of why we are both technically correct at this specific moment in time."

To build this proof, you always need a starting point and a destination.

In this chapter, our starting point will always be the Cash Book, and our destination will always be the Pass Book. We are going to take our Cash Book balance, add the things the bank added, deduct the things the bank deducted, and see if we land exactly on the Pass Book balance.

The Starting Line: A Favorable Cash Book Balance

Every BRS problem begins by giving you a starting balance. For this chapter, we are focusing exclusively on a favorable balance as per the Cash Book.

What does "favorable" mean? It means you actually have money in the bank. You are not overdrawn; you do not owe the bank money. It is your asset.

When you see a question that says, "Prepare a BRS starting with a debit balance as per Cash Book of ₹10,000," you immediately know two things:

1. 1You are starting with a positive ₹10,000.
2. 2Your goal is to adjust this number to find out what the Pass Book says.

The Golden Rule: Copy the Destination

This is the most important section of this chapter. If you understand this one rule, you will never get a BRS question wrong.

When you are preparing a BRS, you are trying to make your starting point match your destination. Since we are starting with the Cash Book and trying to reach the Pass Book, we must treat the Pass Book as the ultimate boss. Whatever the Pass Book did, we must copy it.

Ask yourself one simple question for every single transaction: "Because of this event, is the Pass Book balance currently higher or lower than my Cash Book balance?"

• If the Pass Book balance is higher, you must ADD the amount to your starting balance to catch up.
• If the Pass Book balance is lower, you must DEDUCT the amount from your starting balance to match it.

Let's apply this golden rule to the most common situations you will face.

Breaking Down the Adjustments: When to Add and Deduct

We will now look at the classic scenarios that cause disagreements, and apply our "Copy the Boss" logic to each one. Remember, our starting point is the Cash Book, so the Pass Book is the Boss.

1. Cheques Issued but Not Yet Presented for Payment

The Scenario: You write a cheque for ₹5,000 to your supplier, Mr. Sharma, and hand it to him on March 28th. What happened in the books? The moment you handed over the cheque, your accountant immediately deducted ₹5,000 from your Cash Book. But Mr. Sharma put the cheque in his wallet and hasn't gone to the bank yet. The bank knows nothing about this. Who is higher? Because you deducted ₹5,000 and the bank did not, the Pass Book (the Boss) is currently higher than your Cash Book. The Action: To make your Cash Book match the Pass Book, you must reverse your deduction. You must ADD the ₹5,000 back.

2. Cheques Deposited but Not Yet Cleared (or Collected)

The Scenario: A customer gives you a cheque for ₹10,000. You happily deposit it into your bank branch on March 30th. What happened in the books? The moment you filled out the deposit slip, your accountant added ₹10,000 to your Cash Book. But the cheque takes three days to clear. On March 31st, the bank has not yet added the money to your account. Who is higher? Because you added ₹10,000 and the bank did not, the Pass Book (the Boss) is currently lower than your Cash Book. The Action: To make your Cash Book match the Pass Book, you must undo your addition. You must DEDUCT the ₹10,000.

3. Bank Charges and Interest Charged by the Bank

The Scenario: The bank deducts ₹500 for SMS alert fees or debit card annual charges. What happened in the books? The bank quietly deducted ₹500 from your account. You won't know about this until you check your statement at the end of the month. So, your Cash Book has not recorded this drop. Who is higher? Because the bank deducted money and you did not, the Pass Book (the Boss) is currently lower than your Cash Book. The Action: To match the Pass Book, you must copy its deduction. You must DEDUCT the ₹500.

4. Interest Allowed by the Bank

The Scenario: The bank gives you ₹1,000 as interest on your savings account balance. What happened in the books? The bank quietly added ₹1,000 to your account. You haven't recorded this in your Cash Book yet because you haven't seen the statement. Who is higher? Because the bank added money and you did not, the Pass Book (the Boss) is currently higher than your Cash Book. The Action: To match the Pass Book, you must copy its addition. You must ADD the ₹1,000.

5. Direct Deposits by Customers

The Scenario: A customer transfers ₹15,000 directly into your bank account via NEFT/RTGS, but forgets to tell you. What happened in the books? The bank received the money and added it to your Pass Book. Your Cash Book knows nothing about it. Who is higher? The Pass Book (the Boss) is higher. The Action: To match the Pass Book, you must ADD the ₹15,000.

6. Direct Payments by the Bank (Standing Instructions)

The Scenario: You told the bank to automatically pay your ₹2,000 insurance premium every month. The bank pays it on the 25th. What happened in the books? The bank deducted ₹2,000. Your accountant forgot to record it in the Cash Book. Who is higher? The Pass Book (the Boss) is lower. The Action: To match the Pass Book, you must DEDUCT the ₹2,000.

The Standard Format of a BRS

There are two common ways to draw a Bank Reconciliation Statement on paper: the Plus/Minus Columns method and the Add/Less method. Both are perfectly correct and will give you the exact same answer.

For exams and practical understanding, the Add/Less method is usually preferred because it reads like a logical story from top to bottom.

Here is the skeleton of the Add/Less format:

Bank Reconciliation Statement as on [Date]

• Starting Point: Debit Balance as per Cash Book (Write the amount in the outer column)
• Add: (List all the items where the Pass Book is higher)
• Item 1 (Inner column)
• Item 2 (Inner column)
• Total of Additions (Move to outer column and add to starting balance)
• Less: (List all the items where the Pass Book is lower)
• Item 1 (Inner column)
• Item 2 (Inner column)
• Total of Deductions (Move to outer column and subtract)
• Destination: Credit Balance as per Pass Book (The final resulting figure)

Worked Example: Putting It All Together

Let’s walk through a complete, exam-style problem from start to finish. Do not just read the solution—follow the logic for every single step.

The Problem: On 31st March 2026, the Cash Book of Gupta Traders showed a debit balance of ₹40,000. On comparing the Cash Book with the Pass Book, the following differences were found:

1. 1Cheques issued for ₹12,000 were not yet presented for payment.
2. 2Cheques deposited into the bank for ₹8,000 were not yet cleared.
3. 3The bank charged ₹300 as incidental charges, not recorded in the Cash Book.
4. 4A customer directly deposited ₹5,000 into the bank account.
5. 5The bank paid electricity bill of ₹1,500 as per standing instructions, not recorded in the Cash Book.
6. 6Interest credited by the bank ₹700, not entered in the Cash Book.

Prepare a Bank Reconciliation Statement as on 31st March 2026.

Step-by-Step Solution Logic

Before we draw the table, let's use our "Copy the Boss" method to figure out what to do with each item. Our starting point is the Cash Book. The Pass Book is the Boss.

The Final Statement

Now, we simply organize our logic into the formal Add/Less structure.

Bank Reconciliation Statement of Gupta Traders as on 31st March 2026

Starting Balance: Debit Balance as per Cash Book: ₹40,000

Add:

• Cheques issued but not yet presented for payment: ₹12,000
• Direct deposit by a customer: ₹5,000
• Interest credited by the bank: ₹700
• Total Additions: + ₹17,700

Subtotal (40,000 + 17,700): ₹57,700

Less:

• Cheques deposited but not yet cleared: ₹8,000
• Bank incidental charges: ₹300
• Electricity bill paid by bank: ₹1,500
• Total Deductions: - ₹9,800

Final Balance: Credit Balance as per Pass Book (57,700 - 9,800): ₹47,900

And just like that, we have solved the mystery. We have proven mathematically that our Cash Book balance of ₹40,000 and the bank's Pass Book balance of ₹47,900 are both correct, and the ₹7,900 difference is entirely due to timing and unrecorded items.

Quick Revision

Here are the high-yield points to scan before your exam:

• The Goal: A BRS reconciles the difference between the Cash Book (bank column) and the bank Pass Book on a specific date.
• Favorable Balances: A favorable balance is a Debit balance in the Cash Book, but a Credit balance in the Pass Book.
• The Core Logic: When starting with the Cash Book, the Pass Book is your destination. If a transaction makes the Pass Book balance higher than the Cash Book, ADD it. If it makes the Pass Book lower, DEDUCT it.
• Cheques Issued: Always ADD (because your Cash Book went down, but the Pass Book hasn't yet).
• Cheques Deposited: Always DEDUCT (because your Cash Book went up, but the Pass Book hasn't yet).
• Bank Charges / Direct Payments: Always DEDUCT (because the Pass Book went down without you knowing).
• Interest Allowed / Direct Deposits: Always ADD (because the Pass Book went up without you knowing).
• Not an Account: A BRS is a statement, not a ledger account. It does not use double-entry bookkeeping rules.