Advertisements
Advertisements
Question
Prepare bank reconciliation statement as on 31st March, 2017 from the following extracts of cash book and bank statement.
Dr. | Cash book (Bank column only) | Cr. | |||
Date | Receipts | Amount ₹ | Date | Payments | Amount ₹ |
2017 March |
2017 March |
||||
1 | To Balance b/d | 9,000 | 4 | By Drawings | 1,700 |
3 | To Ram | 2,200 | 8 | By Sumi | 3,300 |
9 | To Prem | 1,500 | 12 | By Salary | 2,800 |
16 | To Pavithra | 3,400 | 16 | By Kayal | 1,700 |
23 | To Devi | 2,600 | 18 | By Pooja | 4,200 |
27 | To Mani | 1,100 | 26 | By Sam | 2,000 |
30 | To Shankar | 350 | 28 | By Raheem | 1,100 |
30 | By Rent | 1,100 | |||
30 | By Balance c/d | 2,250 | |||
20,150 | 20,150 |
Date | Particulars | Dr. Withdrawals ₹ |
Cr. Deposits ₹ |
Balance Dr./Cr. |
2017 March |
||||
1 | By balance b/d | 9,000 Cr. | ||
4 | To cheque- drawings | 8,300 Cr. | ||
5 | By cheque- Ram | 700 | 2,200 | 10,500 Cr. |
9 | To cheque – Sumi | 7,200 Cr. | ||
11 | By cheque- Prem | 3,500 | 1,500 | 8,700 Cr. |
12 | To cheque – Salary | 5,900 Cr. | ||
17 | To cheque – Kayal | 2,800 | 4,200 Cr. | |
20 | By cheque- Devi | 1,700 | 2,600 | 6,800 Cr. |
30 | By interest received | 900 | 7,700 Cr. | |
30 | To bank charges | 15 | 7,685 Cr. |
Solution
Bank reconciliation statement
as on 31st March, 2017
Particulars | Amount ₹ | Amount ₹ |
Balance as per cash book | 2,250 | |
Add: | ||
Interest received but not entered in cashbook | 900 | 10,300 |
Cheques issued but not presented for payment (4,200 + 1,100 + 2,000) |
7,300 | |
Cheques drawn for personal use but not cashed | 1,000 | |
Rent paid by cheque but not entered in cash book | 1,100 | |
12,550 | ||
Less: | ||
Cheques deposits but not yet credited | 3,400 | 4,865 |
Cheques deposited but not credited | 1,100 | |
Cheques deposited but not credited | 350 | |
Bank charges not entered in cash book | 15 | |
Balance as per bank statement | 7,685 |
APPEARS IN
RELATED QUESTIONS
Adjusting the cash book before preparing the bank reconciliation statement is compulsory.
From the following particulars of Kamakshi traders, prepare a bank reconciliation statement as on 31st March, 2018.
- Debit balance as per cash book ₹ 10,500
- Cheque deposited into bank amounting to ₹ 5,500 credited by bank, but entered twice in the cash book
- Cheques issued and presented for payment amounting to ₹ 7,000 omitted in the cash book
- Cheque book charges debited by the bank ₹ 200 not recorded in the cash book.
- Cash of ₹ 1,000 deposited by a customer of the business in cash deposit machine not recorded in the cash book.
From the following information, prepare bank reconciliation statement to find out the bank statement balance as on 31st December, 2017.
Particulars | ₹ |
1. Balance as per cash book | 15,000 |
2. Cheques deposited but not yet credited | 1,000 |
3. Cheques issued and entered in the cash book before 31st December 2017 but not presented for payment until that date | 1,500 |
4. Dividend directly received by bank | 200 |
5. Direct payment made by bank for rent | 1,000 |
6. Locker rent charged by the bank not recorded in cash book | 1,200 |
7. Wrong debit given by the bank on 30th December 2017 | 500 |
8. A payment made through net banking has been entered twice in the cash book | 300 |
Briefly explain the term favourable balance as per cash book
What is a bank reconciliation statement? Why is it prepared?
The cash book shows a bank balance of ₹ 7,800. On comparing the cash book with passbook the following discrepancies were noted:
(a) Cheque deposited in bank but not credited ₹ 3,000
(b) Cheque issued but not yet present for payment ₹ 1,500
(c) Insurance premium paid by the bank ₹ 2,000
(d) Bank interest credit by the bank ₹ 400
(e) Bank charges ₹ 100
(d) Directly deposited by a customer ₹ 4,000
On comparing the cash book with passbook of Naman it is found that on March 31, 2014, bank balance of ₹ 40,960 showed by the cash book differs from the bank balance with regard to the following:
(a) Bank charges ₹ 100 on March 31, 2017, are not entered in the cash book.
(b) On March 21, 2017, a debtor paid ₹ 2,000 into the company’s bank in settlement of his account, but no entry was made in the cash book of the company in respect of this.
(c) Cheques totaling ₹ 12,980 were issued by the company and duly recorded in the cash book before March 31, 2017, but had not been presented at the bank for payment until after that date.
(d) A bill for ₹ 6,900 discounted with the bank is entered in the cash book with recording the discount charge of ₹ 800.
(e) ₹ 3,520 is entered in the cash book as paid into bank on March 31st, 2017, but not credited by the bank until the following day.
(f) No entry has been made in the cash book to record the dishonor on March 15, 2017 of a cheque for ₹ 650 received from Bhanu.
Prepare a reconciliation statement as on March 31, 2017.
Prepare bank reconciliation statement as on December 31, 2017. This day the passbook of Mr. Himanshu showed a balance of ₹ 7,000.
(a) Cheques of ₹ 1,000 directly deposited by a customer.
(b) The bank has credited Mr. Himanshu for ₹ 700 as interest.
(c) Cheques for ₹ 3,000 were issued during the month of
December but of these cheques for ₹ 1,000 were not presented during the month of December.
From the following particulars prepare a bank reconciliation statement showing the balance as per cash book on December 31, 2016.
(a) Two cheques of ₹ 2,000 and ₹ 5,000 were paid into bank in October, 2016 but were not credited by the bank in the month of December.
(b) A cheque of ₹ 800 which was received from a customer was entered in the bank column of the cash book in December 2016 but was omitted to be banked in December, 2016.
(c) Cheques for ₹ 10,000 were issued into bank in November 2016 but not credited by the bank on December 31, 2016.
(d) Interest on investment ₹ 1,000 collected by bank appeared in the passbook.
Balance as per Passbook was ₹ 50,000.
From the following particulars, prepare a bank reconciliation statement as at March 31, 2017.
- Balance as per cash book ₹3,200.
- Cheque issued but not presented for payment ₹1,800.
- Cheque deposited but not collected upto March 31, 2014 ₹2,000.
- Bank charges debited by bank ₹150.