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. |
Advertisements
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
From the following particulars of Raja traders, prepare a bank reconciliation statement as on 31st January, 2018.
- Balance as per bank statement ₹ 5,000
- Cheques amounting to ₹ 800 had been recorded in the cash book as having been deposited into the bank on 25th January 2018, but were entered in the bank statement on 2nd February 2018.
- Amount received by bank through NEFT amounting to ₹ 3,000, omitted in the cash book.
- Two cheques issued for ₹ 3,000 and ₹ 2,000 on 29th March 2018. Only the first cheque is presented for payment.
- Insurance premium on motor vehicles for ₹ 1,000 paid by the bank as per standing instruction not recorded in the cash book.
- Credit side of cash book was undercast by ₹ 700
- Subsidy received directly by the bank from the state government amounting to ₹ 10,000, not entered in cash book.
Briefly explain the term favourable balance as per cash book
What is a bank reconciliation statement? Why is it prepared?
Balance as per passbook of Mr. Kumar is 3,000.
(a) Cheque paid into bank but not yet cleared
Ram Kumar ₹1,000
Kishore Kumar ₹ 500
(b) Bank Charges ₹ 300
(c) Cheque issued but not presented
Hameed ₹ 2,000
Kapoor ₹ 500
(d) Interest entered in the passbook but not entered in the cash book ₹ 100.
Prepare a bank reconciliation statement.
Prepare bank reconciliation statement.
(i) Overdraft shown as per cash book on December 31, 2017 ₹ 10,000.
(ii) Bank charges for the above period also debited in the passbook ₹ 100.
(iii) Interest on overdraft for six months ending December 31, 2017 ₹ 380 debited in the passbook.
(iv) Cheques issued but not encashed prior to December 31, 2017 amounted to ₹ 2,150.
(v) Interest on Investment collected by the bank and credited in the passbook ₹ 600.
(vi) Cheques paid into bank but not cleared before December, 31 2017 were ₹ 1,100.
Kumar find that the bank balance shown by his cash book on December 31, 2017 is ₹ 90,600 (Credit) but the passbook shows a difference due to the following reason:
A cheque (post-dated) for ₹ 1,000 has been debited in the bank column of the cash book but not presented for payment. Also, a cheque for ₹ 8,000 drawn in favour of Manohar has not yet been presented for payment. Cheques totaling ₹ 1,500 deposited in the bank have not yet been collected and cheque for ₹ 5,000 has been dishonored
Raghav and Co. have two bank accounts. Account No. I and Account No. II. From the following particulars relating to Account No. I, find out the balance on that account of March 31, 2017 according to the cash book of the firm.
- Cheques paid into bank prior to March 31, 2017, but not credited for ₹ 10,000.
- Transfer of funds from account No. II to account no. I recorded by the bank on
- March 31, 2017 but entered in the cash book after that date for ₹ 8,000.
- Cheques issued prior to March 31, 2017 but not presented until after that date for ₹ 7,429.
- Bank charges debited by bank not entered in the cash book for ₹ 200.
- Interest debited by the bank not entered in the cash book ₹ 580.
- Overdraft as per Passbook ₹ 18,990.
Prepare a bank reconciliation statement from the following particulars and show the balance as per cash book.
(i) Balance as per passbook on March 31, 2017 overdrawn ₹ 20,000.
(ii) Interest on bank overdraft not entered in the cash book ₹ 2,000.
(iii) ₹ 200 insurance premium paid by bank has not been entered in the cash book.
(iv) Cheques drawn in the last week of March, 2017, but not cleared till date for ₹ 3,000 and ₹ 3,500.
(v) Cheques deposited into bank on February, 2017, but yet to be credited on dated March 31, 2017 ₹ 6,000.
(vi) Wrongly debited by bank ₹ 500.
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.
From the following particulars prepare Bank Reconciliation Statement as on 30th June 2019.
Credit balance as per Pass Book ₹ 20,000.
- A cheque for ₹ 3,500 was issued and paid by bank, recorded in Pass Book as ₹ 5,300.
- Cheque deposited ₹ 9,700 collected by the bank was not recorded in Cash Book.
- Payment side of Cash Book was undercast by ₹ 100.
- Electricity bill paid by bank ₹ 6,200 was recorded twice in Pass Book.
