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, prepare a, bank reconciliation statement as at March 31, 2017.
(i) Balance as per cash book ₹ 3,200.
(ii) Cheque issued but not presented for payment ₹ 1,800.
(iii) Cheque deposited but not collected upto March 31, 2017 ₹ 2,000.
(iv) Bank charges debited by bank ₹ 150.
Bank balance of ₹ 40,000 showed by the cash book of Atul on December 31, 2016. It was found that three cheques of ₹ 2,000, ₹ 5,000 and ₹ 8,000 deposited during the month of December were not credited in the passbook till January 02, 2017. Two cheques of ₹ 7,000 and ₹ 8,000 issued on December 28 were not presented for payment till January 03, 2017. In addition to it bank had credited ₹ 325 as interest and had debited him with ₹ 50 as bank charges for which there were no corresponding entries in the cash book.
Prepare a bank reconciliation statement as on December 31, 2016.
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.
The passbook of Mr. Mohit current account showed a credit Balance of ₹ 20,000 on dated December 31, 2016. Prepare a Bank Reconciliation Statement with the following information.
(i) A cheque of ₹ 400 drawn on his saving account has been shown on current account.
(ii) He issued two cheques of ₹ 300 and ₹ 500 on of December 25, but only the 1st cheque was presented for payment.
(iii) One cheque issued by Mr. Mohit of ₹ 500 on December 25, but it was not presented for payment whereas it was recorded twice in the cash book.
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.
The passbook of Mr. Randhir showed an overdraft of ₹ 40,950 on March 31, 2017.
Prepare bank reconciliation statement on March 31, 2017.
(i) Out of cheques amounting to ₹ 8,000 drawn by Mr. Randhir on March 27, a cheque for ₹ 3,000 was encashed on April 2017.
(ii) Credited by bank with ₹ 3,800 for interest collected by them, but the amount is not entered in the cash book.
(iii) ₹ 10,900 paid in by Mr. Randhir in cash and by cheques on March, 31 cheques amounting to ₹ 3,800 were collected on April, 07.
(iv) A Cheque of ₹ 780 credited in the passbook on March 28 being dishonoured is debited again in the passbook on April 01, 2017. There was no entry in the cash book about the dishonour of the cheque until April 15.
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 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 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 up to 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 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.
