Mastering the Bank Reconciliation Statement (BRS)

        Reconciliation of the cash book and the bank passbook balances amounts to an explanation of differences between them. The core purpose is to ascertain the correct bank balance and reflect the differences properly.
    

1. The Logic Behind Preparing a BRS

Every business maintains a Cash Book (with a bank column) to record bank transactions. Simultaneously, the bank maintains a ledger account for the business, providing a copy known as the Passbook or Bank Statement. Ideally, the balance in both books should tally. However, in practice, they often differ. A Bank Reconciliation Statement is prepared to reconcile these two balances.

The differences arise primarily due to two reasons:

Timing Differences: A time gap between recording a transaction in the cash book and its actual clearance by the bank (e.g., cheques issued but not yet presented for payment, or cheques deposited but not yet collected).
Errors: Mistakes committed either by the business firm in the cash book (omissions, wrong casting) or by the bank in the passbook.

2. Classification of BRS Problems (The Four Types)

There are four different starting points (situations) when preparing a BRS:

Type 1: Favourable Balance as per Cash Book (Debit Balance): Deposits exceed withdrawals. We start with the Cash Book and adjust to match the Passbook.
Type 2: Favourable Balance as per Pass Book (Credit Balance): We start with the Passbook and reverse the adjustment rules to find the Cash Book balance.
Type 3: Unfavourable Balance (Overdraft) as per Cash Book (Credit Balance): Withdrawals exceed deposits. Treated as a negative starting figure.
Type 4: Unfavourable Balance (Overdraft) as per Pass Book (Debit Balance): Started as a negative figure from the passbook perspective.

Type 1: Favourable Balance as per Cash Book (Debit Balance)

The Golden Rule for Type 1: We know the Cash Book balance. We want to find out what the Bank Passbook is showing. Therefore, whatever the Bank has added (which we haven't), we will ADD. Whatever the Bank has deducted (which we haven't), we will DEDUCT. Our goal is to mirror the bank.

Question 1:

Prepare a Bank Reconciliation Statement as on 31st March 2024 from the following particulars:

Debit balance as per Cash Book ₹ 50,000.
Cheques issued to creditors but not yet presented for payment ₹ 12,000.
Cheques deposited into bank but not yet collected by bank ₹ 8,000.
Bank charges debited by the bank but not entered in Cash Book ₹ 500.
Interest credited by the bank ₹ 1,500.
A customer directly deposited money into the bank account ₹ 10,000.
Insurance premium paid by the bank as per standing instructions ₹ 3,000.
A cheque of ₹ 4,000 deposited into bank was dishonoured, but no entry was passed in the Cash Book.

Solution 1:

Particulars	(+) Amount ₹	(-) Amount ₹
Balance as per Cash Book (Dr.)	50,000
Add: Cheques issued but not presented	12,000
Logic: We reduced our Cash Book balance when we issued the cheque. The bank has not yet processed it, so the Passbook balance is higher. We ADD it back to match the bank.
Add: Interest credited by bank	1,500
Logic: The bank added interest, increasing our Passbook balance. Our Cash Book is unaware and therefore lower. We ADD it to match the bank.
Add: Direct deposit by customer	10,000
Logic: The bank received funds directly, increasing the Passbook balance. Our Cash Book hasn't recorded this yet. We ADD it to match the bank.
Less: Cheques deposited but not yet collected		8,000
Logic: We increased our Cash Book balance immediately upon depositing the cheque. The bank hasn't cleared it yet, so the Passbook is still lower. We DEDUCT it to match the bank.
Less: Bank charges debited by bank		500
Logic: The bank deducted charges, lowering the Passbook balance. Our Cash Book is unaware and artificially high. We DEDUCT it to match the bank.
Less: Insurance premium paid by bank		3,000
Logic: The bank made a payment on our behalf, lowering the Passbook balance. Our Cash Book hasn't recorded this payment. We DEDUCT it to match the bank.
Less: Cheque deposited dishonoured		4,000
Logic: We previously increased our Cash Book when we deposited this cheque. The bank rejected it, so the Passbook never got the increase. We must DEDUCT it from our Cash Book to match the bank.
Balance as per Passbook (Cr.)	58,000
Total	73,500	73,500

Question 2:

From the following information, prepare a BRS as on 31st December 2023:

Balance as per Cash Book ₹ 75,000.
Cheques drawn but not encashed ₹ 15,000.
Cheques paid into bank but not cleared ₹ 18,000.
Dividend collected by bank ₹ 4,500.
Direct debit by bank for club membership fee ₹ 2,000.
Cheque recorded in cash book but omitted to be banked ₹ 5,000.
Bank incidental charges ₹ 300.
A cheque of ₹ 3,500 received and deposited was returned unpaid by the bank.

Solution 2:

Particulars	(+) Amount ₹	(-) Amount ₹
Balance as per Cash Book (Dr.)	75,000
Add: Cheques drawn but not encashed	15,000
Logic: "Drawn" means issued. We lowered our Cash Book balance. The bank hasn't paid them yet, so Passbook is higher. We ADD back to match.
Add: Dividend collected by bank	4,500
Logic: Bank received money on our behalf, increasing the Passbook. Cash Book is missing this entry. We ADD to match the bank.
Less: Cheques paid into bank but not cleared		18,000
Logic: "Paid into" means deposited. Cash Book was increased. Bank hasn't cleared it yet, so Passbook is lower. We DEDUCT to match.
Less: Direct debit for club membership fee		2,000
Logic: Bank deducted money automatically, lowering the Passbook. Cash Book hasn't recorded this deduction. We DEDUCT to match.
Less: Cheque recorded in CB but omitted to be banked		5,000
Logic: We recorded a receipt in the Cash Book (increasing it), but forgot to physically deposit it. The bank obviously doesn't have it, so Passbook is lower. We DEDUCT to match reality.
Less: Bank incidental charges		300
Logic: Bank subtracted fees, lowering the Passbook. Cash Book is unaware. We DEDUCT to match the bank.
Less: Cheque deposited returned unpaid (dishonoured)		3,500
Logic: Cash Book was increased when deposited. The bank returned it unpaid, meaning the Passbook did not increase. We must DEDUCT to reverse our premature addition.
Balance as per Passbook (Cr.)	65,700
Total	94,500	94,500

Type 2: Favourable Balance as per Pass Book (Credit Balance)

The Golden Rule for Type 2: We know the Passbook balance. We want to find out what the Cash Book is showing. Here, our goal is to mirror the Cash Book. If the Cash Book added an amount (and the bank didn't), we must ADD it to the Passbook. If the Cash Book deducted an amount (and the bank didn't), we must DEDUCT it from the Passbook. It is the exact reverse of Type 1.

Question 3:

Prepare a Bank Reconciliation Statement as on 30th June 2024:

Credit balance as per Pass Book ₹ 60,000.
Cheques issued but not presented for payment ₹ 8,500.
Cheques deposited but not yet credited by bank ₹ 14,000.
Interest allowed by bank not recorded in CB ₹ 800.
Bank charges recorded in passbook only ₹ 300.
Direct payment by bank for rent ₹ 5,000.
Direct deposit by a debtor ₹ 10,000.
Payment side of Cash Book undercast by ₹ 1,000.

Solution 3:

Particulars	(+) Amount ₹	(-) Amount ₹
Balance as per Passbook (Cr.)	60,000
Add: Cheques deposited but not credited	14,000
Logic (Reverse): The Cash Book added this amount upon deposit. The Passbook hasn't yet. To make the Passbook match the artificially higher Cash Book, we ADD.
Add: Bank charges	300
Logic (Reverse): The Passbook deducted these charges, but the Cash Book didn't. Therefore, the Cash Book is higher. We ADD it back to the Passbook to match.
Add: Direct payment by bank for rent	5,000
Logic (Reverse): The Passbook dropped by ₹5,000. The Cash Book missed this entry and remained high. We ADD it back to the Passbook to match the Cash Book.
Add: Payment side of CB undercast	1,000
Logic (Reverse): The Cash Book recorded ₹1,000 less in payments, making its final balance ₹1,000 higher. We ADD to the Passbook to catch up to this higher error.
Less: Cheques issued but not presented		8,500
Logic (Reverse): The Cash Book reduced its balance when issued. The Passbook hasn't. To match the lower Cash Book, we must DEDUCT from the Passbook.
Less: Interest allowed by bank		800
Logic (Reverse): The Passbook increased due to interest. The Cash Book is unaware and therefore lower. We DEDUCT from the Passbook to match the Cash Book.
Less: Direct deposit by debtor		10,000
Logic (Reverse): The Passbook received a boost from the deposit. The Cash Book is unaware and lower. We DEDUCT from the Passbook to match.
Balance as per Cash Book (Dr.)	61,000
Total	80,300	80,300

Question 4:

From the following, ascertain the Cash Book balance as on 31st August 2024:

Balance as per Pass Book ₹ 42,000.
Cheques drawn but not cleared ₹ 6,000.
Cheques deposited but not collected ₹ 9,000.
Bank collected interest on investment ₹ 1,500.
Bank deducted locker rent ₹ 800.
A cheque deposited was dishonoured, entered only in Passbook ₹ 2,000.
A customer deposited directly into the bank ₹ 5,500.
A cheque issued for ₹ 1,200 was recorded twice in the Cash Book.

Solution 4:

Particulars	(+) Amount ₹	(-) Amount ₹
Balance as per Passbook (Cr.)	42,000
Add: Cheques deposited but not collected	9,000
Logic (Reverse): Cash Book added this immediately. Passbook hasn't. We ADD to Passbook to match the Cash Book's expectation.
Add: Bank deducted locker rent	800
Logic (Reverse): Passbook dropped. Cash Book didn't. Cash Book is higher. We ADD back to Passbook to match.
Add: Cheque deposited dishonoured	2,000
Logic (Reverse): Cash Book added this when deposited and hasn't reversed it yet. Passbook rightly rejected it. To match the artificially high Cash Book, Passbook must ADD it.
Less: Cheques drawn but not cleared		6,000
Logic (Reverse): Cash Book deducted this. Passbook hasn't. To match the lower Cash Book, we must DEDUCT.
Less: Bank collected interest on investment		1,500
Logic (Reverse): Passbook increased. Cash Book is unaware and lower. DEDUCT from Passbook to match.
Less: Customer deposited directly		5,500
Logic (Reverse): Passbook got a boost. Cash Book is missing it. DEDUCT from Passbook to match the Cash Book.
Less: Cheque issued recorded twice in CB		1,200
Logic (Reverse): Cash Book deducted this ₹1,200 an extra time by mistake, driving its balance lower. Passbook only deducted it once. To match the Cash Book's erroneous lower balance, we must DEDUCT another ₹1,200.
Balance as per Cash Book (Dr.)	39,600
Total	53,800	53,800

Type 3: Unfavourable Balance as per Cash Book (Overdraft / Credit Balance)

The Golden Rule for Type 3: An overdraft is a negative balance (you owe the bank). You will start by placing the opening balance in the (-) column. From there, apply the exact same logic as Type 1: Try to mirror the Bank. The mathematical placement takes care of the "overdraft" nature automatically.

Question 5:

Prepare BRS as on 31st October 2023:

Overdraft as per Cash Book ₹ 25,000.
Cheques deposited but not cleared ₹ 12,000.
Cheques issued but not presented ₹ 9,000.
Bank charges debited by bank ₹ 400.
Interest on overdraft charged by bank ₹ 1,500.
Interest on investment collected by bank ₹ 2,000.
Direct deposit by a customer ₹ 8,000.
Insurance paid by bank ₹ 3,000.

Solution 5:

Particulars	(+) Amount ₹	(-) Amount ₹
Overdraft as per Cash Book (Cr.)		25,000
Add: Cheques issued but not presented	9,000
Logic: We deducted this in CB. Bank hasn't deducted it yet. We ADD back to match the bank's higher position.
Add: Interest on investment collected by bank	2,000
Logic: Bank added money. CB didn't. We ADD to match the bank.
Add: Direct deposit by a customer	8,000
Logic: Bank added funds. CB didn't. We ADD to match the bank.
Less: Cheques deposited but not cleared		12,000
Logic: We added this in CB. Bank hasn't added it yet. We DEDUCT to match the bank.
Less: Bank charges debited		400
Logic: Bank deducted fees. CB didn't. We DEDUCT to match the bank.
Less: Interest on overdraft charged		1,500
Logic: Bank deducted interest, worsening the overdraft. CB didn't. We DEDUCT to match the bank.
Less: Insurance paid by bank		3,000
Logic: Bank deducted the premium. CB didn't. We DEDUCT to match the bank.
Overdraft as per Passbook (Dr.)	22,900
Total	41,900	41,900

Question 6:

Prepare BRS as on 31st January 2024:

Credit Balance as per Cash Book ₹ 30,000.
Cheques issued, not cashed ₹ 15,000.
Cheques deposited, not credited by bank ₹ 20,000.
Bank charges entered in Passbook only ₹ 500.
Dividend collected by bank ₹ 4,000.
Direct debit for electricity bill ₹ 2,500.
Bill receivable discounted dishonoured ₹ 5,000.
Cheque paid into bank, but omitted to be recorded in CB ₹ 3,000.

Solution 6:

Particulars	(+) Amount ₹	(-) Amount ₹
Overdraft as per Cash Book (Cr.)		30,000
Add: Cheques issued, not cashed	15,000
Logic: CB deducted. Bank hasn't. ADD to match Bank.
Add: Dividend collected by bank	4,000
Logic: Bank added. CB didn't. ADD to match Bank.
Add: Cheque paid into bank omitted in CB	3,000
Logic: Bank added the deposit. CB forgot to record it. ADD to match Bank.
Less: Cheques deposited, not credited		20,000
Logic: CB added. Bank hasn't yet. DEDUCT to match Bank.
Less: Bank charges		500
Logic: Bank deducted. CB didn't. DEDUCT to match Bank.
Less: Direct debit for electricity		2,500
Logic: Bank deducted. CB didn't. DEDUCT to match Bank.
Less: Bill receivable dishonoured		5,000
Logic: Bank deducted the amount of the failed bill. CB hasn't recorded the failure yet. DEDUCT to match Bank.
Overdraft as per Passbook (Dr.)	36,000
Total	58,000	58,000

Type 4: Unfavourable Balance as per Pass Book (Overdraft / Debit Balance)

The Golden Rule for Type 4: Start with the negative Passbook balance (place it in the (-) column). Then, strictly apply the rules of Type 2 (Reverse logic: Try to mirror the Cash Book). Because we place the starting figure in the (-) column, the math correctly calculates the final overdraft or favourable balance.

Question 7:

From the following, prepare a BRS as on 31st March 2024:

Overdraft as per Pass Book ₹ 40,000.
Cheques issued but not presented ₹ 11,000.
Cheques deposited but not collected ₹ 16,000.
Bank charges ₹ 600.
Interest on overdraft charged by bank ₹ 2,200.
Direct deposit by a customer ₹ 12,000.
Interest collected by bank ₹ 1,800.
Direct payment by bank (taxes) ₹ 4,500.

Solution 7:

Particulars	(+) Amount ₹	(-) Amount ₹
Overdraft as per Passbook (Dr.)		40,000
Add: Cheques deposited but not collected (Reverse)	16,000
Logic (Reverse): CB added this. Passbook hasn't. ADD to Passbook to match CB.
Add: Bank charges (Reverse)	600
Logic (Reverse): Passbook deducted this. CB didn't. ADD back to Passbook to match CB.
Add: Interest on overdraft (Reverse)	2,200
Logic (Reverse): Passbook deducted interest. CB didn't. ADD back to Passbook to match CB.
Add: Direct payment by bank for taxes (Reverse)	4,500
Logic (Reverse): Passbook dropped. CB didn't. ADD back to Passbook to match CB.
Less: Cheques issued but not presented (Reverse)		11,000
Logic (Reverse): CB deducted this. Passbook hasn't. DEDUCT from Passbook to match the lower CB.
Less: Direct deposit by customer (Reverse)		12,000
Logic (Reverse): Passbook increased. CB didn't. DEDUCT from Passbook to match CB.
Less: Interest collected by bank (Reverse)		1,800
Logic (Reverse): Passbook increased. CB didn't. DEDUCT from Passbook to match CB.
Overdraft as per Cash Book (Cr.)	41,500
Total	64,800	64,800

Question 8:

Prepare a BRS as on 30th November 2023:

Debit Balance as per Pass Book ₹ 55,000.
Cheques deposited, not cleared ₹ 22,000.
Cheques issued, not cleared ₹ 18,000.
Bank collected dividend ₹ 3,500.
Bank deducted charges ₹ 700.
Life insurance paid by bank ₹ 5,000.
Cheque deposited dishonoured ₹ 4,000.
Direct deposit by debtor ₹ 9,000.

Solution 8:

Particulars	(+) Amount ₹	(-) Amount ₹
Overdraft as per Passbook (Dr.)		55,000
Add: Cheques deposited, not cleared (Reverse)	22,000
Logic (Reverse): CB added. Passbook hasn't. ADD to match CB.
Add: Bank deducted charges (Reverse)	700
Logic (Reverse): Passbook deducted. CB didn't. ADD back to match CB.
Add: Life insurance paid by bank (Reverse)	5,000
Logic (Reverse): Passbook deducted. CB didn't. ADD back to match CB.
Add: Cheque deposited dishonoured (Reverse)	4,000
Logic (Reverse): CB incorrectly added this and hasn't fixed it yet. Passbook rightly rejected it. To match the CB's artificially inflated balance, we must ADD it to the Passbook.
Less: Cheques issued, not cleared (Reverse)		18,000
Logic (Reverse): CB deducted. Passbook hasn't. DEDUCT to match CB.
Less: Bank collected dividend (Reverse)		3,500
Logic (Reverse): Passbook increased. CB didn't. DEDUCT to match CB.
Less: Direct deposit by debtor (Reverse)		9,000
Logic (Reverse): Passbook increased. CB didn't. DEDUCT to match CB.
Overdraft as per Cash Book (Cr.)	53,800
Total	85,500	85,500

« Previous Topic ⌂ Content Page

BOOKKEEPING MASTER

CLASS XI CHAPTER 5(B) Master Bank Reconciliation Statements (BRS): Complete Logic & Solved Examples