- 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
- Compare Go through the bank column of the cash book and the bank statement, line by line.
- Tick Tick each item that appears in both, with the same amount.
- List the unticked Unticked items in the cash book or the statement are the causes of difference.
- 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.
| Date | Receipts (Dr.) | Amount ₹ | Date | Payments (Cr.) | Amount ₹ |
|---|---|---|---|---|---|
| Nov 1 | To Balance b/d | 15,000 | Nov 3 | By Kumar A/c | 5,000 |
| Nov 6 | To Arul A/c | 4,800 | Nov 12 | By Rent A/c | 2,400 |
| Nov 15 | To Sales A/c | 3,200 | Nov 25 | By Devi A/c | 3,900 |
| Nov 28 | To Baskar A/c | 6,500 | Nov 29 | By Salaries A/c | 1,500 |
| Nov 30 | By Balance c/d | 16,700 | |||
| Total | 29,500 | Total | 29,500 |
| Date | Particulars | Withdrawals (Dr) ₹ | Deposits (Cr) ₹ | Balance ₹ |
|---|---|---|---|---|
| Nov 1 | Balance | 15,000 Cr | ||
| Nov 4 | Kumar (cheque paid) | 5,000 | 10,000 Cr | |
| Nov 8 | Arul (cheque collected) | 4,800 | 14,800 Cr | |
| Nov 14 | Rent (cheque paid) | 2,400 | 12,400 Cr | |
| Nov 16 | Cash deposited (sales) | 3,200 | 15,600 Cr | |
| Nov 20 | Interest on investment collected | 1,250 | 16,850 Cr | |
| Nov 26 | Insurance premium (standing instruction) | 900 | 15,950 Cr | |
| Nov 29 | Salaries (cheque paid) | 1,500 | 14,450 Cr | |
| Nov 30 | Bank charges | 120 | 14,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.
| Particulars | Amount ₹ | Amount ₹ |
|---|---|---|
| Balance as per cash book (favourable) | 16,700 | |
| Add: | ||
| Cheque issued to Devi not yet presented | 3,900 | |
| Interest on investment collected by the bank | 1,250 | 5,150 |
| 21,850 | ||
| Less: | ||
| Cheque from Baskar deposited but not yet credited | 6,500 | |
| Insurance premium paid by the bank | 900 | |
| Bank charges | 120 | 7,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. When an extract of the cash book and bank statement is given, the causes of difference are found by:
- adding both balances
- comparing the cash book with the ledger
- taking only the cash column
- 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. A cheque appears on the credit side of the cash book but not in the bank statement. It is:
- a cheque deposited but not credited
- a direct deposit
- a cheque issued but not yet presented
- 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. 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:
- ₹26,700
- ₹16,500
- ₹15,300
- ₹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. Adjusting the cash book for unrecorded bank items is essential when:
- the BRS is prepared at the end of the accounting year
- the BRS is prepared mid-month
- the bank asks for it
- 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. 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:
- subtract ₹360
- add ₹360
- add ₹3,950
- 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.
Sign in to keep track of the lessons you finish.