• Practice
  • About 24 min
  • 5 practice questions

BRS from extracts of the cash book and bank statement

Compare the bank column of the cash book with the bank statement item by item, find the unmatched entries, and use them to prepare a bank reconciliation statement; know when the cash book must be updated.

If something looks wrong, please tell us.

By the end of this lesson you can

  • Tick matching entries in the cash book and the bank statement and list the unmatched ones.
  • Turn the unmatched entries into causes of difference and prepare the BRS.
  • Explain when the cash book should be corrected before the balance sheet is prepared.

In practice, nobody hands the accountant a neat list of causes. She has the bank column of the cash book and the bank statement, and must find the differences herself. This lesson shows the method the Tamil Nadu textbook describes and works through a full example with made-up figures.

The method

Finding the causes from two extracts

  1. Compare Go through the bank column of the cash book and the bank statement, line by line.
  2. Tick Tick each item that appears in both, with the same amount.
  3. List the unticked Unticked items in the cash book or the statement are the causes of difference.
  4. Reconcile Start from either balance and adjust for each cause.

Remember that each item appears on opposite sides: a deposit is a debit in the cash book and a credit in the bank statement; a cheque issued is a credit in the cash book and a debit (withdrawal) in the bank statement.

Worked example: Ponni Agencies, November 2024

Ponni Agencies (made up) gives the following two records. Prepare a bank reconciliation statement as on 30th November 2024.

Bank column of the cash book of Ponni Agencies, November 2024 (made up)
DateReceipts (Dr.)Amount ₹DatePayments (Cr.)Amount ₹
Nov 1To Balance b/d15,000Nov 3By Kumar A/c5,000
Nov 6To Arul A/c4,800Nov 12By Rent A/c2,400
Nov 15To Sales A/c3,200Nov 25By Devi A/c3,900
Nov 28To Baskar A/c6,500Nov 29By Salaries A/c1,500
Nov 30By Balance c/d16,700
Total29,500Total29,500
Bank statement of Ponni Agencies, November 2024 (made up)
DateParticularsWithdrawals (Dr) ₹Deposits (Cr) ₹Balance ₹
Nov 1Balance15,000 Cr
Nov 4Kumar (cheque paid)5,00010,000 Cr
Nov 8Arul (cheque collected)4,80014,800 Cr
Nov 14Rent (cheque paid)2,40012,400 Cr
Nov 16Cash deposited (sales)3,20015,600 Cr
Nov 20Interest on investment collected1,25016,850 Cr
Nov 26Insurance premium (standing instruction)90015,950 Cr
Nov 29Salaries (cheque paid)1,50014,450 Cr
Nov 30Bank charges12014,330 Cr

Step 1, tick. Opening ₹15,000 agrees. Kumar ₹5,000, Arul ₹4,800, Rent ₹2,400, Sales ₹3,200 and Salaries ₹1,500 appear in both. Step 2, unticked in the cash book: Baskar ₹6,500 (deposited 28th, not yet credited); Devi ₹3,900 (cheque issued 25th, not yet presented). Unticked in the bank statement: interest on investment ₹1,250 (credit); insurance premium ₹900 (debit); bank charges ₹120 (debit).

Step 3, check both closing balances. Cash book: 29,500 − 12,800 = ₹16,700. Bank statement running balance: 15,000 − 5,000 = 10,000; + 4,800 = 14,800; − 2,400 = 12,400; + 3,200 = 15,600; + 1,250 = 16,850; − 900 = 15,950; − 1,500 = 14,450; − 120 = ₹14,330.

Step 4, reconcile from the cash book. Add (bank higher): Devi's unpresented cheque 3,900 and interest 1,250 = 5,150; 16,700 + 5,150 = 21,850. Less (bank lower): Baskar's cheque 6,500, insurance 900, charges 120 = 7,520; 21,850 − 7,520 = ₹14,330, exactly the bank statement balance. The reconciliation proves that all differences are explained.

Bank reconciliation statement of Ponni Agencies as on 30th November 2024
ParticularsAmount ₹Amount ₹
Balance as per cash book (favourable)16,700
Add:
Cheque issued to Devi not yet presented3,900
Interest on investment collected by the bank1,2505,150
21,850
Less:
Cheque from Baskar deposited but not yet credited6,500
Insurance premium paid by the bank900
Bank charges1207,520
Balance as per bank statement (favourable)14,330

Updating the cash book

Some causes are items the business has simply not recorded yet: interest collected, insurance premium paid, bank charges. The textbook notes that adjusting the cash book before preparing the BRS is not compulsory for reconciliations during the year, but at the end of the accounting year the cash book must be updated so that the balance sheet shows the correct bank balance. For Ponni Agencies, the updated cash book balance would be 16,700 + 1,250 − 900 − 120 = ₹16,930; the remaining differences (3,900 and 6,500) are timing items: 16,930 + 3,900 − 6,500 = 14,330, agreeing again.

Worked example 2: an extract with an error

A made-up firm's cash book shows a cheque from Rajan deposited for ₹2,460, while the bank statement shows the same cheque credited as ₹2,640. The bank has confirmed the cheque was for ₹2,640. Working: this is an error in the cash book, which is 2,640 − 2,460 = ₹180 too low. Starting from the cash book balance, the bank balance is higher by ₹180: add 180. When the cash book is corrected, it is debited with ₹180 more.

  • Key takeaways: tick matching items; the unticked ones are the causes.
  • Check both closing balances before you reconcile; the BRS must end exactly at the other balance.
  • Unrecorded bank items should be entered in the cash book at the year end so the balance sheet is correct.

Check your understanding

  1. 1. When an extract of the cash book and bank statement is given, the causes of difference are found by:

    1. adding both balances
    2. comparing the cash book with the ledger
    3. taking only the cash column
    4. ticking items that appear in both and listing those that do not
    Show answer

    Answer: D. Matching items are ticked; the unmatched (unticked) items are the causes used in the reconciliation.

  2. 2. A cheque appears on the credit side of the cash book but not in the bank statement. It is:

    1. a cheque deposited but not credited
    2. a direct deposit
    3. a cheque issued but not yet presented
    4. bank charges
    Show answer

    Answer: C. Credit side of the cash book means a payment by cheque; if the bank has not debited it, it has not been presented.

  3. 3. Cash book balance ₹21,000 (Dr). Unmatched: interest ₹600 credited by the bank; cheque ₹4,000 deposited not credited; standing instruction payment ₹1,100. Bank statement balance:

    1. ₹26,700
    2. ₹16,500
    3. ₹15,300
    4. ₹17,700
    Show answer

    Answer: B. 21,000 + 600 = 21,600; less 4,000 + 1,100 = 5,100; 21,600 − 5,100 = ₹16,500.

  4. 4. Adjusting the cash book for unrecorded bank items is essential when:

    1. the BRS is prepared at the end of the accounting year
    2. the BRS is prepared mid-month
    3. the bank asks for it
    4. cheques are unpresented
    Show answer

    Answer: A. The textbook notes that it is not compulsory during the year, but at the year end the cash book must be updated so the balance sheet shows the correct bank balance.

  5. 5. A deposit of ₹3,950 is entered in the cash book as ₹3,590; the bank recorded it correctly. Starting from the cash book balance, the BRS should:

    1. subtract ₹360
    2. add ₹360
    3. add ₹3,950
    4. subtract ₹3,590
    Show answer

    Answer: B. The cash book is 3,950 − 3,590 = ₹360 too low, so the bank balance is ₹360 higher: add ₹360.

Privacy · Terms · Refunds · Delivery