Bank Reconciliation Statement

Need for Reconciliation — Part 1: Introduction and Basic Concept

Chapter 5: Bank Reconciliation Statement

Page 1 of 5: Need for Reconciliation — Part 1: Introduction and Basic Concept

Welcome to the world of financial accuracy! Imagine you keep a diary of all the money you deposit into and withdraw from your bank account. At the end of the month, you ask the bank for their record. You expect both records to show the exact same final balance. But what if they don't? This is a common situation for businesses, and that's where the Bank Reconciliation Statement comes in.

Why Don't the Balances Tally?

A business maintains a record of all its bank transactions in the Cash Book, specifically in the bank column. This book shows the business's perspective of its bank balance.

Simultaneously, the bank maintains its own record of the business's account. This record, provided to the customer, is called the Bank Statement or Passbook. This is the bank's perspective of the same account.

In a perfect world, the balance as per the Cash Book should be identical to the balance as per the Passbook on any given day. However, it is a common experience that these two balances do not match.

{{KEY: type=concept | title=The Core Reconciliation Problem | text=The balance in the Cash Book (Bank Column) represents the business's record of its bank transactions. The balance in the Passbook (Bank Statement) represents the bank's record of the same transactions. Differences between these two balances arise primarily due to the time lag in recording entries and, occasionally, errors by either party.}}

This mismatch doesn't necessarily mean something is wrong. More often than not, it's due to transactions that one party has recorded, but the other has not yet recorded. Our job as accountants is to identify these differences and prepare a statement explaining them.

{{VISUAL: diagram: A side-by-side comparison of a Cash Book's bank column and a Bank Passbook for the same company, highlighting a matching entry (e.g., a salary payment) and a non-matching entry (e.g., a cheque deposited but not yet cleared).}}

{{ZOOM: title=A Tale of Two Perspectives: Debit vs. Credit | text=When you deposit money, you debit the bank column in your Cash Book because Bank (an asset) is increasing. For the bank, however, your deposit is a liability (they owe you that money), so they credit your account in their books. This is why a credit balance in the Passbook is favorable (money in the bank), while a debit balance in the Cash Book is favorable.}}

Introducing the Bank Reconciliation Statement (BRS)

To resolve the discrepancy between the Cash Book and Passbook balances, we prepare a special statement.

{{KEY: type=definition | title=Bank Reconciliation Statement (BRS) | text=A Bank Reconciliation Statement is a statement prepared to reconcile the difference between the bank balance shown in the company's Cash Book and the balance shown in the bank's Passbook on a particular date.}}

The purpose of a BRS is not to be a part of the formal Double Entry System (it's not a ledger account). Instead, it is a working paper, a tool used by the accountant to:

• Identify the reasons for the difference.
• Ensure the accuracy of entries in both the Cash Book and the Passbook.
• Ascertain the correct bank balance that should be shown in the Balance Sheet.

The two main causes for differences are:

1. Timing Differences: Transactions recorded at different times by the business and the bank.
2. Errors: Mistakes made by either the business's accountant or the bank's staff.

{{VISUAL: diagram: A flowchart showing the information flow. A box for 'Business Transactions' leads to arrows pointing to 'Cash Book (Bank Column)' and 'Bank Statement'. A dotted line connects these two, labeled 'Mismatch?'. An arrow from this dotted line points to 'Bank Reconciliation Statement', the solution.}}

Proforma of a Bank Reconciliation Statement

To prepare a BRS, we start with the balance from one book (say, the Cash Book) and make adjustments for all the items causing the difference, ultimately arriving at the balance as per the other book (the Passbook).

There are two common formats.

Format 1: Add and Less Method

This is a simple narrative-style format. You start with a balance, add certain items, and subtract others.

Bank Reconciliation Statement as on [Date]

{{VISUAL: diagram: A clean, formatted representation of the first proforma of a Bank Reconciliation Statement (as per Fig. 5.2), showing the 'Add' and 'Less' structure clearly.}}

{{KEY: type=points | title=Documents Needed for BRS | text=- The Cash Book (specifically the bank column) for the period.

• The Bank Statement or Passbook for the same period.
• A list of identified differences after comparing the two documents.}}

Format 2: Tabular Method (+ and - Columns)

This format is often preferred for its clarity. It uses two separate amount columns for additions and deductions, which can make calculations easier.

Bank Reconciliation Statement as on [Date]

{{VISUAL: diagram: A clean, formatted representation of the second proforma of a Bank Reconciliation Statement (as per Fig. 5.3), with distinct '+' (Additions) and '-' (Deductions) columns.}}

{{KEY: type=exam | title=Starting Point is Key | text=In exams, a BRS question can ask you to start with either the Cash Book balance and arrive at the Passbook balance, or vice-versa. The items to be added or subtracted will reverse depending on your starting point. Always read the question carefully to identify the given starting balance.}}

In the next section, we will delve deeper into the specific "timing differences" that cause these balances to diverge.

Need for Reconciliation — Part 2: Causes of Differences

Why Don't My Books Match the Bank's?

Imagine you and your friend are tracking the money you owe each other in separate notebooks. You pay him ₹100 and write it down immediately. He receives the money two days later and only writes it down then. For those two days, your notebooks won't match! This simple idea of a time lag is the main reason a company's cash book balance often disagrees with its bank passbook balance.

Reconciliation is simply the process of explaining these differences. The causes of disagreement between the cash book and the bank passbook fall into two major categories:

• Timing Differences: Transactions recorded at different times by the business and the bank.
• Errors: Mistakes made by either the business or the bank.

Let's explore these causes in detail.

{{KEY: concept | title=The Core Conflict: Two Sets of Books | text=A business maintains a record of its bank transactions in the 'Bank' column of its Cash Book. The bank, in parallel, maintains a record of the business's transactions in its own ledger, a copy of which is provided to the customer as a Bank Statement or Pass Book. Since these are two independent records of the same transactions, differences are bound to arise due to timing and errors.}}

Timing Differences: It's All About When

When a transaction is recorded in one book but not the other due to the time gap in processing, it's called a timing difference. This is the most common reason for discrepancies.

Cheques Issued but Not Yet Presented for Payment

When a business issues a cheque to a supplier (a creditor), it immediately records the payment on the credit side of the cash book. This reduces the bank balance in the company's books.

However, the bank only knows about this payment when the supplier actually deposits the cheque and it is presented for payment. This might happen days or even weeks later. During this gap, the bank's records show a higher balance than the company's cash book.

• Impact: Balance as per Cash Book < Balance as per Pass Book

{{VISUAL: diagram: A flowchart showing the timeline. Step 1: Business issues a cheque and immediately credits its Cash Book. Step 2: A time gap of several days. Step 3: The supplier presents the cheque to the bank. Step 4: Bank debits the business's account. The difference exists during Step 2.}}

Cheques Paid into the Bank but Not Yet Collected

Conversely, when a business receives a cheque from a customer (a debtor), it's immediately recorded on the debit side of the cash book. This increases the bank balance in the company's books.

The bank, however, will only credit the business's account after the cheque goes through the clearing process and the money is actually received from the customer's bank. This can take a few working days. During this period, the company's books show a higher balance than the bank's records.

• Impact: Balance as per Cash Book > Balance as per Pass Book

{{VISUAL: diagram: A simple 3-step process illustrating cheque clearing. 1. Cheque deposited at the business's bank. 2. Bank sends the cheque for clearing to the customer's bank. 3. Amount is realized and credited to the business's account. A 'Pending' status is shown during step 2.}}

{{ZOOM: title=What is Cheque Clearing? | text=In India, the Cheque Truncation System (CTS) is used. Instead of physically moving the cheque, an electronic image is transmitted for clearing. While this has significantly sped up the process to 1-2 days, the time lag, though shorter, still exists and remains a primary cause of differences.}}

Direct Debits Made by the Bank on Behalf of the Customer

A business may give standing instructions to its bank to make regular payments on its behalf, like electricity bills, insurance premiums, or loan EMIs. The bank debits the account on the due date and records it.

The business, however, might not know about this deduction until it sees the bank statement. Until the business records this transaction, its cash book balance will be higher than the passbook balance. Other examples include bank charges or interest on an overdraft.

• Impact: Balance as per Cash Book > Balance as per Pass Book

{{VISUAL: photo: A montage of icons representing common direct debits: an electricity bill, a life insurance policy document, a loan agreement, and a bank's logo with "charges" written below.}}

{{KEY: definition | title=Standing Instructions | text=An instruction a bank account holder gives to their bank to pay a certain amount at regular intervals to another account. This automates recurring payments.}}

Amounts Directly Deposited in the Bank Account

Sometimes, customers or other parties may deposit money directly into the company's bank account (via NEFT, RTGS, UPI, or cash deposit). The bank will immediately credit the account.

The business will only learn of this deposit when it receives a credit alert or checks its bank statement. Until then, this amount is present in the passbook but not in the cash book. Other examples include interest or dividends collected by the bank on behalf of the business.

• Impact: Balance as per Cash Book < Balance as per Pass Book

{{VISUAL: chart: A simple table comparing two scenarios. Column 1: Transaction. Column 2: Effect on Cash Book. Column 3: Effect on Pass Book. Row 1: "Direct deposit by customer". Column 2 shows "No effect (until informed)". Column 3 shows "Balance increases".}}

{{KEY: points | title=Common Timing Differences | text=- Cheques issued but not yet presented.

• Cheques deposited but not yet cleared/collected.
• Direct debits by bank (e.g., bank charges, standing instructions).
• Direct credits to account (e.g., interest credited, direct deposits by customers).}}

Errors Made by the Business or the Bank

Less common than timing differences, but equally important, are straightforward mistakes.

• Errors by the Business: These can include recording a cheque on the wrong side of the cash book, entering an incorrect amount, forgetting to record a transaction entirely, or calculation mistakes when balancing the account.
• Errors by the Bank: Although rare, banks can also make mistakes. They might debit or credit the wrong account, or record an incorrect amount.

Correcting these errors is a crucial outcome of the reconciliation process.

Key Takeaway: The Bank Reconciliation Statement acts as a bridge, connecting the balance of the Cash Book to the balance of the Pass Book by accounting for every timing difference and error.

Solved Numericals

Let's apply these concepts to prepare a Bank Reconciliation Statement (BRS).

Example 1: Finding the Pass Book Balance

GIVEN: On 31st March 2023, the Cash Book of M/s Sharma Traders showed a bank balance of ₹45,000. On comparing with the Pass Book, the following were noted:

1. Cheques issued for ₹12,000 were not yet presented for payment.
2. The bank had debited ₹500 as annual maintenance charges, which was not recorded in the Cash Book.
3. A customer directly deposited ₹5,000 into the bank account.

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

FORMULA / LOGIC: We will start with the Cash Book balance and adjust for items that the bank knows about but we haven't recorded, or vice versa. The format is: Balance as per Cash Book + Items Increasing Pass Book Balance - Items Decreasing Pass Book Balance = Balance as per Pass Book

SUBSTITUTION & WORKING:

Bank Reconciliation Statement of M/s Sharma Traders as on 31st March 2023

ANSWER: The balance as per the Pass Book is ₹61,500.

{{KEY: exam | title=Understanding the Adjustments | text=When starting with the Cash Book balance, think from the bank's perspective. Add items that have reduced your Cash Book balance but not yet the Pass Book (like cheques issued). Subtract items that have reduced the Pass Book balance but not yet your Cash Book (like bank charges).}}

Example 2: Finding the Cash Book Balance

GIVEN: On 31st December 2023, the Pass Book of Gupta Enterprises showed a credit balance of ₹22,500. A comparison with the Cash Book revealed the following:

1. Cheques of ₹8,000 were deposited into the bank in December but were cleared in January 2024.
2. Bank paid an insurance premium of ₹1,500 as per standing instructions, not yet recorded in the Cash Book.
3. Cheques issued of ₹4,000 were not presented for payment until January 2024.

Prepare a BRS to find the balance as per the Cash Book.

FORMULA / LOGIC: Here, we start with the Pass Book balance and work backward to find the Cash Book balance. Balance as per Pass Book + Items Increasing Cash Book Balance - Items Decreasing Cash Book Balance = Balance as per Cash Book

SUBSTITUTION & WORKING:

Bank Reconciliation Statement of Gupta Enterprises as on 31st December 2023

ANSWER: The balance as per the Cash Book is ₹28,000.

Try It Yourself

1. If the Cash Book shows a balance of ₹15,000 and cheques issued but not presented amount to ₹3,000, what would be the balance as per Pass Book, assuming no other differences?
2. Balance as per Pass Book is ₹50,000. Bank charges of ₹250 and interest on investment of ₹1,000 collected by the bank were not recorded in the Cash Book. Find the balance as per Cash Book.
3. Cheques of ₹7,500 were deposited but not yet collected. If the balance as per Cash Book is ₹40,000, this transaction would cause the Pass Book balance to be (higher/lower) than the Cash Book balance by ₹7,500.

Answer Key:

1. ₹18,000
2. ₹49,250
3. lower

Preparation of Bank Reconciliation Statement — Part 1: Favourable Balances

Preparation of Bank Reconciliation Statement — Part 1: Favourable Balances

Welcome back! Now that we understand why the Cash Book and Passbook balances might differ, it's time to learn the practical skill of preparing the Bank Reconciliation Statement (BRS). This is the process of formally aligning one balance to arrive at the other.

There are two primary approaches to this task.

The Two Methods of Reconciliation

When a business prepares a BRS, it can choose one of two paths:

1. Prepare the BRS without adjusting the Cash Book balance: This is a direct method where we start with either the Cash Book or Passbook balance and make a series of additions and subtractions on a separate statement (the BRS) to arrive at the other book's balance. This method is used to simply explain the difference on a particular date.
2. Prepare the BRS after adjusting the Cash Book balance: In this method, the business first updates its own Cash Book for any items it was unaware of (like bank charges or direct deposits). Then, a BRS is prepared for the remaining timing differences. This is the more common method in practice, which we will cover later.

For now, we will focus on the first method: Preparing the BRS without adjusting the Cash Book.

{{VISUAL: diagram: A flowchart showing two branching paths. Path 1 is "Prepare BRS without adjusting Cash Book". Path 2 is "Adjust Cash Book first, then prepare BRS". The flowchart highlights that we are currently following Path 1.}}

Starting with a Favourable Balance

Before we can start reconciling, we need a starting point. This is usually the balance from either the Cash Book or the Passbook. A favourable balance is a positive balance, meaning the business has money in its bank account.

{{KEY: definition | title=Favourable Balance | text=A favourable balance indicates that the business has deposited more money than it has withdrawn. It is shown as a debit balance in the Cash Book (Bank Column) and a credit balance in the Passbook.}}

Think about it from both perspectives:

• From the Business's view (Cash Book): The bank is an asset. Money in the bank is a Debit balance.
• From the Bank's view (Passbook): The business's deposit is a liability to them (they owe you that money). Liabilities have a Credit balance.

So, a favourable balance means:

• Debit Balance as per Cash Book
• Credit Balance as per Passbook

{{VISUAL: diagram: A simple T-account for "Cash Book (Bank Column)" showing a Debit balance. Next to it, a T-account for "Passbook (Customer's Account)" showing a Credit balance. Arrows connect them, labeled "Represents the same positive funds".}}

Steps to Prepare BRS (from a Favourable Cash Book Balance)

Let's assume we are given the Debit balance as per the Cash Book and need to find the balance as per the Passbook. Our goal is to adjust the Cash Book balance to make it agree with the Passbook balance. We ask ourselves, "What has the bank done that we haven't, or what have we done that the bank hasn't yet?"

Here is the step-by-step process:

1. Start with the Balance: Write the heading "Bank Reconciliation Statement as on [Date]". The first line will be "Balance as per Cash Book" and place the amount in the + (Plus) column.

2. Add Items that Increase the Passbook Balance: Add all transactions that have increased the balance in the Passbook but have not yet been recorded in the Cash Book.

   • Cheques issued but not presented for payment: You have credited (reduced) your Cash Book, but the bank hasn't debited (reduced) the Passbook yet. To match the higher Passbook balance, you must add this amount back.
   • Interest/Dividends collected by the bank: The bank has credited (increased) your Passbook, but you haven't recorded it yet. To match the Passbook, you must add this income.
   • Direct deposits by customers: A customer paid directly into your account. The Passbook balance is up, but your Cash Book isn't. Add this to your starting balance.

3. Deduct Items that Decrease the Passbook Balance: Subtract all transactions that have decreased the balance in the Passbook but have not yet been recorded in the Cash Book.

   • Cheques deposited but not yet collected/credited: You have debited (increased) your Cash Book, but the bank hasn't credited (increased) the Passbook yet. To match the lower Passbook balance, you must deduct this amount.
   • Bank charges and interest on overdraft: The bank has debited (decreased) your Passbook for its services. To match the Passbook, you must deduct these expenses.
   • Direct payments made by the bank on your behalf (standing instructions): The bank paid your insurance premium. The Passbook balance is down, but your Cash Book is not. Deduct this payment.
   • Cheques deposited but dishonoured: A cheque you deposited bounced. The bank reversed the credit, decreasing your Passbook balance. You must also deduct it.

4. Final Calculation: Total the + and - columns. The difference between the totals will be the final reconciled amount, which should be the Balance as per Passbook.

{{VISUAL: diagram: A process diagram with four steps. Step 1: "Start with Cash Book Balance". Step 2: "ADD items that increase Passbook balance". Step 3: "LESS items that decrease Passbook balance". Step 4: "Arrive at Passbook Balance".}}

{{KEY: points | title=Logic of Adjustments (Starting from Cash Book) | text=- ADD Cheques issued but not yet presented.

• ADD Interest/Dividends/Direct Deposits credited by bank.
• DEDUCT Cheques deposited but not yet credited.
• DEDUCT Bank charges/Direct Payments debited by bank.
• DEDUCT Cheques deposited and dishonoured.}}

A key principle: When starting with the Cash Book balance, you are trying to think like the Passbook. Adjust your balance for everything the bank has recorded that you haven't, and reverse everything you have recorded that the bank hasn't.

What if we start with the Passbook balance? The logic is simply reversed! If you start with the Balance as per Passbook, you will:

• Deduct cheques issued but not presented.
• Add cheques deposited but not collected.
• ...and so on. You adjust the Passbook balance to think like the Cash Book.

{{VISUAL: chart: A two-column table titled "Common BRS Adjustments (Starting from Cash Book)". The left column is "Items to ADD (+)" and lists "Cheques issued but not presented", "Direct deposits", "Interest credited". The right column is "Items to DEDUCT (-)" and lists "Cheques deposited but not collected", "Bank charges", "Standing payments".}}

Solved Numericals

Let's apply this logic to some practical examples.

Example 1 (Based on NCERT Illustration 1)

GIVEN: From the following particulars of Mr. Vinod, prepare a Bank Reconciliation Statement as on March 31, 2017.

1. Bank balance as per Cash Book: ₹ 50,000.
2. Cheques issued but not presented for payment: ₹ 6,000.
3. The bank had directly collected dividend of ₹ 8,000 and credited to the bank account but was not entered in the Cash Book.
4. Bank charges of ₹ 400 were not entered in the Cash Book.
5. A cheque for ₹ 6,000 was deposited but not collected by the bank.

WORKING:

SOLUTION:

| Bank Reconciliation Statement of Mr. Vinod as on March 31, 2017 | | :------------------------------------------------------------- | Amount (+) <br> ₹ | Amount (-) <br> ₹ | | Particulars | | Balance as per Cash Book (Favourable) | 50,000 | | | Add: | | | | 1. Cheques issued but not presented for payment | 6,000 | | | 2. Dividend directly collected by bank | 8,000 | | | Less: | | | | 3. Cheque deposited but not collected by bank | | 6,000 | | 4. Bank charges debited by bank | | 400 | | Balance as per Passbook | 57,600 | | | Total | 64,000 | 64,000 |

ANSWER: The balance as per the Passbook is ₹ 57,600.

{{KEY: exam | title=BRS Format | text=Always use a clear, two-column format for amounts (+ and -). The final balancing figure (e.g., Balance as per Passbook) is placed in the appropriate column to make the totals of both columns equal. This demonstrates the reconciliation.}}

Example 2 (Based on NCERT Illustration 3)

GIVEN: The bank passbook of M/s. Boss & Co. showed a balance of ₹ 45,000 on May 31, 2017. Prepare a BRS based on the following:

1. Cheques issued before May 31, 2017, amounting to ₹ 25,940, had not been presented for encashment.
2. Two cheques of ₹ 3,900 and ₹ 2,350 were deposited into the bank on May 31 but the bank gave credit for the same in June, 2017.
3. There was also a debit in the passbook of ₹ 2,500 in respect of a cheque dishonoured on 31.05.2017.

WORKING: Note: This time we start with the Passbook balance. The logic is reversed.

SOLUTION:

| Bank Reconciliation Statement of M/s. Boss & Co. as on May 31, 2017 | | :--------------------------------------------------------------------- | Amount (+) <br> ₹ | Amount (-) <br> ₹ | | Particulars | | Balance as per Passbook (Favourable) | 45,000 | | | Add: | | | | 1. Cheques deposited but not credited by bank (₹6,250) | 6,250 | | | 2. Cheque dishonoured but not recorded in Cash Book | 2,500 | | | Less: | | | | 3. Cheques issued but not presented for payment | | 25,940 | | Balance as per Cash Book | 27,810 | | | Total | 53,750 | 53,750 |

ANSWER: The balance as per the Cash Book is ₹ 27,810.

Try It Yourself

1. On 31st December 2022, the Cash Book of Priya Enterprises showed a bank balance of ₹ 37,500. On comparing with the Passbook, the following was found:

   • Cheques issued for ₹ 5,000 were not yet presented.
   • Cheques deposited for ₹ 8,000 were not yet credited by the bank.
   • Bank charges of ₹ 250 were debited in the Passbook only.
   • Interest allowed by the bank ₹ 1,000 was credited in the Passbook only. Prepare a Bank Reconciliation Statement.

2. Prepare a Bank Reconciliation Statement from the following particulars as on March 31, 2023:

   • Credit balance as per Passbook: ₹ 10,000.
   • Cheques issued but not presented for payment: ₹ 4,000.
   • Cheques deposited but not cleared: ₹ 3,000.
   • A customer directly deposited ₹ 1,500 into the bank account. Find the balance as per the Cash Book.

Answer Key: 1. Balance as per Passbook = ₹ 35,250. 2. Balance as per Cash Book = ₹ 12,500.

Preparation of Bank Reconciliation Statement — Part 2: Dealing with Overdrafts

Preparation of Bank Reconciliation Statement — Part 2: Dealing with Overdrafts

So far, we've looked at situations where a business has money in its bank account—a favourable balance. But businesses often have arrangements with banks that allow them to withdraw more money than they have deposited. This facility is known as a bank overdraft.

When a business has an overdraft, its bank account has a negative balance. This changes how we approach the reconciliation process. The fundamental goal remains the same: to explain the difference between the cash book and the passbook. However, the treatment of adjustments is reversed.

{{KEY: type=definition | title=Bank Overdraft | text=A bank overdraft is a facility provided by a bank that allows an account holder to withdraw more money than is available in their account, resulting in a negative or credit balance. It is a form of short-term loan.}}

Understanding Overdraft Balances

When you have a positive balance, your Cash Book (Bank Column) shows a debit balance (asset), and the Passbook shows a credit balance (liability for the bank). With an overdraft, this relationship flips:

• Cash Book (Bank Column): Shows a Credit Balance. This signifies that the business owes money to the bank, which is a liability for the business.
• Passbook: Shows a Debit Balance. This signifies that the account holder owes money to the bank, which is an asset for the bank.

This reversal is the key to understanding how to prepare a BRS for an overdraft.

{{VISUAL: diagram: A side-by-side comparison showing a Favourable Balance (Cash Book Dr, Passbook Cr) and an Overdraft Balance (Cash Book Cr, Passbook Dr) with arrows indicating the flow of funds.}}

The Logic of Reconciling an Overdraft

Think of an overdraft as a loan or a debt you owe to the bank. When preparing the BRS:

• Any transaction that increases your debt to the bank will be added to the starting overdraft balance.
• Any transaction that decreases your debt to the bank will be subtracted from the starting overdraft balance.

This is the opposite of how we treat favourable balances. For a favourable balance, anything that increases our money is added, and anything that decreases it is subtracted. For an overdraft, anything that makes our negative balance more negative (increases the overdraft) is added.

{{KEY: type=concept | title=Reversed Treatment for Overdrafts | text=When reconciling an overdraft, the treatment of all adjusting items is the reverse of when reconciling a favourable balance. Transactions that would be 'added' to a favourable balance are 'deducted' from an overdraft, and vice-versa. The goal is to determine the correct, reconciled overdraft amount.}}

Starting with Overdraft as per Cash Book (Credit Balance)

This is a very common scenario. We are given the overdraft amount as recorded in our own books and need to find the overdraft amount as per the bank's records (the passbook).

Let's take the Credit Balance (Overdraft) as per Cash Book as our starting point.

Items to be ADDED (Things that increase the overdraft):

• Bank Charges/Interest on Overdraft: The bank has debited our account, increasing our overdraft, but we haven't recorded it yet.
• Cheques Deposited but Dishonoured: We thought we had deposited money (decreasing the overdraft), but the cheque bounced. So, we must add it back to the overdraft.
• Direct Payments made by Bank: The bank paid an expense on our behalf (like insurance premium), increasing our overdraft, which is not yet in our cash book.

Items to be DEDUCTED (Things that decrease the overdraft):

• Cheques Issued but Not Presented for Payment: We have issued a cheque, increasing our overdraft in the cash book. But since the person hasn't taken the money from the bank yet, the bank's overdraft figure is lower. We deduct this to match the passbook.
• Direct Deposits by Customers: A customer deposited money directly, reducing our overdraft at the bank, but we haven't recorded it yet.
• Interest/Dividends Collected by Bank: The bank collected income for us, which reduced our overdraft, but it's not yet in our cash book.

{{VISUAL: diagram: A flowchart starting with 'Overdraft as per Cash Book'. Two branches emerge: 'Add' and 'Subtract'. The 'Add' branch lists items like 'Bank Charges', 'Cheques Dishonoured'. The 'Subtract' branch lists 'Cheques Issued but not Presented', 'Direct Deposits'.}}

{{KEY: type=exam | title=Common Trap with Overdrafts | text=Students often mechanically apply the rules for a favourable balance to an overdraft problem. Always read the question carefully to see if it says 'balance' or 'overdraft'. If it's an overdraft, you MUST reverse the treatment of additions and subtractions.}}

Starting with Overdraft as per Passbook (Debit Balance)

Occasionally, you might start with the overdraft figure from the passbook and need to reconcile it to find the cash book balance. The logic is simply the reverse of the previous method.

Let's take the Debit Balance (Overdraft) as per Passbook as our starting point.

Items to be ADDED (Things not yet in the passbook that increase the overdraft):

• Cheques Deposited but Not Yet Credited: We have recorded the deposit in our cash book (reducing our overdraft), but the bank hasn't processed it yet. To match our cash book, we must add this amount back to the bank's overdraft figure.

Items to be DEDUCTED (Things not yet in the passbook that decrease the overdraft):

• Cheques Issued but Not Yet Presented: The bank's overdraft figure doesn't include these cheques yet. Since our cash book does include them (increasing our overdraft), we must deduct them from the passbook balance to reconcile.

{{VISUAL: diagram: A two-column table comparing the treatment of items. Column 1: 'Starting with Overdraft as per Cash Book'. Column 2: 'Starting with Overdraft as per Passbook'. Rows show items like 'Cheques Issued' and their treatment ('Deduct' in Col 1, 'Deduct' in Col 2 - wait, that's not right. 'Deduct' in Col 1, 'Add' in Col 2 is the logic... let me re-verify. If we start with passbook overdraft, and we need to reach cashbook overdraft. Cashbook overdraft is higher due to issued cheques. So we need to ADD the issued cheques to the passbook overdraft. Okay, correction. Add to Passbook Overdraft: Cheques Issued but not Presented. Deduct from Passbook Overdraft: Cheques Deposited but not Credited. The visual should reflect this correct logic. Let's re-specify. }}

{{VISUAL: diagram: A T-account style diagram. Left side is 'Overdraft as per Cash Book to Pass Book'. Right side is 'Overdraft as per Pass Book to Cash Book'. Each side shows the specific additions and subtractions required to reconcile.}}

Solved Numericals

Let's apply these concepts to practical problems. Remember to think about whether a transaction increases or decreases the amount owed to the bank.

Example 1: Starting with Overdraft as per Cash Book

GIVEN: On 31st March 2023, the cash book of M/s Sharma Traders showed a bank overdraft of ₹ 42,000. On comparing it with the passbook, the following was found:

1. Cheques issued for ₹ 15,000 were not presented for payment until April 2023.
2. Cheques deposited for ₹ 11,000 were not collected and credited by the bank.
3. Bank charges of ₹ 500 were debited in the passbook but not recorded in the cash book.
4. A customer directly deposited ₹ 4,000 into the firm's bank account, which was not recorded in the cash book.
5. The bank paid an insurance premium of ₹ 2,500 as per standing instructions, not yet recorded in the cash book.

Prepare a Bank Reconciliation Statement.

SOLUTION: We will start with the overdraft as per the cash book and adjust it to find the overdraft as per the passbook.

Bank Reconciliation Statement of M/s Sharma Traders as on 31st March, 2023

Answer: The overdraft as per the Passbook is ₹ 37,000.

{{KEY: type=points | title=Logic for Example 1 | text=- Bank charges and insurance premium payments increased the bank's overdraft figure, so they are added to the cash book overdraft to match.

• Cheques deposited but not collected means the bank's overdraft is higher than we think, so we add it.
• Cheques issued but not presented and direct deposits means the bank's overdraft figure is lower than what we recorded, so we deduct them.}}

Example 2: Starting with Overdraft as per Passbook

GIVEN: On 31st December 2023, the passbook of Gupta & Sons showed an overdraft of ₹ 25,000.

1. Cheques issued before 31st December amounting to ₹ 8,000 were not presented for payment.
2. Cheques paid into the bank for ₹ 5,500 were not credited by the bank.
3. Interest on overdraft charged by the bank was ₹ 750.
4. A bill receivable for ₹ 3,000, previously discounted with the bank, was dishonoured. The bank debited the account but no entry was made in the cash book.

Prepare a BRS to find the balance as per the Cash Book.

SOLUTION: Here, we start with the passbook overdraft and work backwards to find the cash book overdraft.

Bank Reconciliation Statement of Gupta & Sons as on 31st December, 2023 (Using the alternate presentation method)

Answer: The overdraft as per the Cash Book is ₹ 23,750.

Reasoning for Example 2: To get from the Passbook overdraft to the Cash Book overdraft, we add items recorded in the Cash Book but not Passbook (like issued cheques) and deduct items recorded in the Passbook but not Cash Book (like bank charges and dishonoured bills).

Try It Yourself

1. From the following, find out the balance as per Passbook on 31st March 2023:

   • Overdraft as per Cash Book: ₹ 18,000
   • Cheques issued but not cashed: ₹ 5,000
   • Bank interest debited in Passbook only: ₹ 300
   • Cheques deposited but not cleared: ₹ 2,500

2. The Passbook of M/s. Priya Enterprises showed an overdraft of ₹ 9,200 on 31st July. Prepare a BRS given that cheques issued but not presented were ₹ 2,100 and cheques deposited but not credited were ₹ 3,500. Find the overdraft as per the Cash Book.

3. Credit balance as per Cash Book is ₹ 10,000. Cheques for ₹ 2,000 were issued but not presented. A customer directly deposited ₹ 1,500 in the bank. Bank charges were ₹ 100. What will be the balance as per Passbook?

Answer Key: 1. Overdraft as per Passbook: ₹ 15,800 2. Overdraft as per Cash Book: ₹ 10,600 3. Overdraft as per Passbook: ₹ 6,600

Summary & Quick Revision

Chapter 5 Summary: Bank Reconciliation Statement

This chapter has equipped you with a crucial accounting skill: reconciling the bank balance as per the company's books with the balance shown by the bank's statement. We've learned that while both the Cash Book (Bank Column) and the Bank Pass Book record the same transactions, they often show different balances on a particular date. The Bank Reconciliation Statement (BRS) is the tool we use to identify, explain, and account for these differences.

The core purpose is to ensure the accuracy of our cash records, detect any errors, and maintain control over our bank transactions.

Key Learnings at a Glance

• Purpose of BRS: To explain the causes of difference between the bank balance as per the Cash Book and the bank balance as per the Pass Book.
• Causes of Difference: These differences primarily arise due to:
  1. Timing Differences: Transactions recorded at different times by the business and the bank.
  2. Transactions Recorded by the Bank Only: Items like bank charges, interest credited, or direct payments that the business is unaware of until it sees the Pass Book.
  3. Errors: Mistakes made either by the business in the Cash Book or by the bank in the Pass Book.
• Two Starting Points: A BRS can be prepared starting with either the balance as per the Cash Book or the balance as per the Pass Book. The goal is to arrive at the balance of the other book.
• Types of Balances: We dealt with two main scenarios:
  • Favourable Balance: An asset for the business (Debit balance in Cash Book, Credit balance in Pass Book).
  • Unfavourable Balance (Overdraft): A liability for the business (Credit balance in Cash Book, Debit balance in Pass Book).

{{KEY: definition | title=Bank Reconciliation Statement (BRS) | text=A statement prepared periodically (usually monthly) to reconcile the bank balance as per the Cash Book with the bank balance as per the Pass Book by showing all the causes of difference between the two.}}

Decoding the Differences: A Quick Recap

Understanding why the balances differ is the first step to reconciliation. Let's categorise the common reasons.

{{VISUAL: diagram: Mind map showing the main causes of differences between Cash Book and Pass Book, branching into Timing Differences and Errors, with specific examples like 'Cheques issued but not presented' under Timing Differences.}}

1. Timing Differences

• Cheques issued but not yet presented for payment: We credit (decrease) our Cash Book immediately, but the bank only debits (decreases) our account when the cheque is actually presented by the payee.
• Cheques deposited but not yet collected/credited: We debit (increase) our Cash Book as soon as we deposit a cheque, but the bank only credits (increases) our account after the cheque is cleared.

2. Transactions Recorded Only in the Pass Book

• Direct debits by the bank: Bank charges, interest on overdraft, payments made on our standing instructions. The bank has decreased our balance, but we haven't recorded it in the Cash Book yet.
• Direct credits by the bank: Interest earned, dividends collected by the bank on our behalf, direct deposits by customers. The bank has increased our balance, but we haven't recorded it in the Cash Book yet.

3. Errors

• Errors by the Firm: Wrong amount recorded, transaction omitted, etc., in the Cash Book.
• Errors by the Bank: Wrong amount debited/credited, a transaction for another customer posted to our account, etc., in the Pass Book.

{{KEY: points | title=Common Reconciling Items | text=- Cheques issued but not presented.

• Cheques deposited but not collected.
• Bank charges and interest on overdraft debited by the bank.
• Interest and dividends credited by the bank.
• Direct deposits made by customers into the bank.
• Payments made by the bank on standing instructions.
• Dishonour of a cheque or bill receivable.}}

The Mechanics of Reconciliation

The process is logical. You start with one balance and adjust it for all the items that the other book has recorded but the starting book has not, to arrive at the other book's balance.

{{VISUAL: diagram: Flowchart illustrating the steps to prepare a Bank Reconciliation Statement, starting from 'Take a starting balance (Cash Book or Pass Book)' to 'Add/Subtract reconciling items' and ending with 'Arrive at the other book's balance'.}}

The fundamental rule is:

To go from the Cash Book balance to the Pass Book balance, you must mirror the actions of the Pass Book. If the bank has added an amount (e.g., interest) that you haven't, you ADD it. If the bank has subtracted an amount (e.g., bank charges) that you haven't, you SUBTRACT it.

The opposite logic applies if you start with the Pass Book balance.

{{KEY: concept | title=Favourable vs. Overdraft Balance | text=A favourable balance (or positive balance) is an asset. It appears as a debit balance in the Cash Book and a credit balance in the Pass Book. An overdraft (or unfavourable balance) is a liability, representing money owed to the bank. It appears as a credit balance in the Cash Book and a debit balance in the Pass Book. The treatment of reconciling items is reversed for an overdraft.}}

{{VISUAL: chart: A two-column chart comparing the meaning of balances. Column 1: Favourable Balance (Asset) - Debit in Cash Book, Credit in Pass Book. Column 2: Overdraft (Liability) - Credit in Cash Book, Debit in Pass Book.}}

Solved Numericals

Let's apply these concepts with some practical examples.

Example 1: Starting with Favourable Cash Book Balance

GIVEN: On 31st December 2023, the Cash Book of 'Sharma Electronics' shows a bank balance of ₹ 75,000. On comparing with the Pass Book, the following differences were noted:

1. Cheques issued for ₹ 15,000 were not presented for payment until January 2024.
2. A cheque of ₹ 8,000 deposited on 28th Dec was cleared by the bank on 2nd Jan 2024.
3. The bank credited ₹ 2,000 as interest on investment collected on behalf of Sharma Electronics. This was not recorded in the Cash Book.
4. Bank charges of ₹ 500 were debited by the bank.

Prepare a Bank Reconciliation Statement.

FORMULA/LOGIC: We start with the Cash Book balance and adjust for items recorded in the Pass Book but not in the Cash Book, and for timing differences. Our goal is to arrive at the Pass Book balance.

SUBSTITUTION & WORKING:

Bank Reconciliation Statement of Sharma Electronics as on 31st December 2023

ANSWER: The balance as per the Pass Book on 31st December 2023 is ₹ 83,500.

{{VISUAL: diagram: A clearly laid out template of a Bank Reconciliation Statement with two amount columns (Plus and Minus), showing where the starting balance, additions, and subtractions are placed.}}

Example 2: Starting with Favourable Pass Book Balance

GIVEN: On 31st March 2024, the Pass Book of 'Gupta Traders' showed a credit balance of ₹ 45,000. A comparison with the Cash Book revealed the following:

1. Cheques of ₹ 10,000 deposited into the bank in March were not credited by the bank.
2. Cheques issued for ₹ 18,000 in March were not presented for payment.
3. A customer directly deposited ₹ 5,000 into the firm's bank account, which was not recorded in the Cash Book.

Prepare a Bank Reconciliation Statement.

FORMULA/LOGIC: Here, we start with the Pass Book balance. The treatment will be the reverse of the previous example. We adjust for items recorded in the Cash Book but not in the Pass Book, and for timing differences, to arrive at the Cash Book balance.

SUBSTITUTION & WORKING:

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

ANSWER: The balance as per the Cash Book on 31st March 2024 is ₹ 32,000.

{{KEY: exam | title=Common Trap: Signs and Balances | text=Always double-check the starting balance type. Favourable balance in Cash Book is Debit (Dr.), but in Pass Book it's Credit (Cr.). An Overdraft is the reverse. The 'Add' and 'Less' treatments for an overdraft are opposite to that for a favourable balance.}}

Try It Yourself

Test your understanding with these short problems.

1. Balance as per Cash Book is ₹ 20,000. Cheques issued but not presented amount to ₹ 4,000. Cheques deposited but not yet cleared amount to ₹ 3,000. What is the balance as per Pass Book?
2. The Pass Book shows a credit balance of ₹ 50,000. It was found that bank charges of ₹ 200 were not entered in the Cash Book, and dividends of ₹ 1,500 collected by the bank were also not recorded in the Cash Book. Find the balance as per Cash Book.
3. The Cash Book shows an overdraft of ₹ 12,000. Cheques of ₹ 5,000 issued were not yet presented for payment. Interest on overdraft charged by the bank was ₹ 600. What is the overdraft as per Pass Book?

Answer Key 1. Balance as per Pass Book: ₹ 21,000 2. Balance as per Cash Book: ₹ 48,700 3. Overdraft as per Pass Book: ₹ 7,600