Advertisements
Advertisements
Question
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.
Advertisements
Solution
| Bank Reconciliation Statement of Mr. Mohit, as on December 31, 2016 | |||
| S.No. | Particulars | (+) Amount ₹ | (-) Amount ₹ |
| Balance as per passbook | 20,000 | ||
| (i) | Cheque issued from saving account wrongly debited in the current account of the passbook | 400 | |
| (ii) | Cheque issued but not presented for payment | 500 | |
| (iii) | Cheque issued but not presented for payment and twice recorded in cash book | 1,000 | |
| 1,500 | |||
| Balance as per cash book (20,400 - 1,500) | 18,900 | ||
| 20,400 | 20,400 | ||
Note:
In the question item (i), it is not given whether it is the current account of Pass Book or the current account of Cash Book.
In the solution, we have assumed that it is the current account of the Pass Book.
RELATED QUESTIONS
From the following particulars prepare a bank reconciliation statement of Jayakumar as on 31st December, 2016.
- Balance as per cash book ₹ 7,130
- Cheque deposited but not cleared ₹ 1,000
- A customer has deposited ₹ 800 into the bank directly.
From the following particulars of Raheem traders, prepare a bank reconciliation statement as on 31st March, 2018.
- Overdraft as per cash book ₹ 2,500. On the same day the balance as per bank statement is ₹ 1,99,000.
- Interest on debentures of ₹ 700 was received by the bank directly.
- Amount received by bank through RTGS amounting to ₹ 2,00,000, omitted in the cash book.
- Two cheques issued for ₹ 1,800 and ₹ 2,000 on 29th March 2018. Only the second cheque is presented for payment.
- Insurance premium on car for ₹ 1,000 paid by the bank as per standing instruction not recorded in the cash book.
Prepare bank reconciliation statement from the following data and find out the balance as per cash book as on 31st March, 2018.
| Particulars | ₹ |
| (i) Bank balance as per bank statement | 15,000 |
| (ii) Cheques issued but not yet presented for payment | 2,500 |
| (iii) Bank charges not recorded in the cash book | 250 |
| (iv) Interest charged by bank not recorded in the cash book | 500 |
| (v) Bank paid insurance premium as per standing instruction but not recorded in the cash book | 300 |
| (vi) Cheques deposited but not yet credited | 900 |
From the following particulars of Simon traders, prepare a bank reconciliation statement as on 31st March, 2018.
- Debit balance as per bank statement ₹ 2,500
- Cheques deposited amounting to ₹ 10,000, not yet credited by bank.
- Payment through net banking for ₹ 2,000, omitted in the cash book
From the following particulars, ascertain the cash book balance as on 31st December, 2016.
- Overdraft balance as per bank statement ₹ 1,26,640
- Interest on overdraft entered in the bank statement, but not yet recorded in cash book ₹ 3,200
- Bank charges entered in bank statement, but not found in cash book ₹ 600
- Cheques issued, but not yet presented for payment ₹ 23,360
- Cheques deposited into the bank but not yet credited ₹ 43,400
- Interest on investment collected by the bank ₹ 24,000
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. |
Briefly explain the term favourable balance as per cash book
Enumerate the steps to ascertain the correct cash book balance
Explain the process of preparing bank reconciliation statement with amended cash balance
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.
The cash book shows a bank balance of ₹ 7,800. On comparing the cash book with passbook the following discrepancies were noted:
- Cheque deposited in bank but not credited ₹ 3,000.
- Cheque issued but not yet present for payment ₹ 1,500.
- Insurance premium paid by the bank ₹ 2,000.
- Bank interest credit by the bank ₹ 400.
- Bank charges ₹ 100.
- 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.
- Cheques of ₹ 1,000 directly deposited by a customer.
- The bank has credited Mr. Himanshu for ₹ 700 as interest.
- 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.
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
On December 31, 2017, the cash book of Mittal Bros showed an overdraft of ₹ 6,920. From the following particulars prepare a Bank Reconciliation Statement and ascertain the balance as per passbook.
- Debited by bank for ₹ 200 on account of interest on overdraft and ₹ 50 on account of charges for collecting bills.
- Cheques drawn but not encashed before December, 31 2017 for ₹ 4,000.
- The bank has collected interest and has credited ₹ 600 in passbook.
- A bill receivable for ₹ 700 previously discounted with the bank had been dishonoured and debited in the passbook.
- Cheques paid into bank but not collected and credited before December 31, 2017 amounted ₹ 6,000.
Overdraft shown by the passbook of Mr. Murli is ₹ 20,000. Prepare bank reconciliation statement on dated March 31, 2017.
(i) Bank charges debited as per passbook ₹ 500.
(ii) Cheques recorded in the cash book but not sent to the bank for collection ₹ 2,500.
(iii) Received a payment directly from customer ₹ 4,600.
(iv) Cheque issued but not presented for payment ₹ 6,980.
(v) Interest credited by the bank ₹ 100.
(vi) LIC paid by bank ₹ 2,500.
(vii) Cheques deposited with the bank but not collected ₹ 3,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 up to 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 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 upto March 31, 2014 ₹ 2,000.
- Bank charges debited by bank ₹ 150.
Rectify the following errors:
- Credit sales to Mohan Rs 7,000 were not recorded.
- Credit purchases from Rohan Rs 9,000 were not recorded.
- Goods returned to Rakesh Rs 4,000 were not recorded.
- Goods returned from Mahesh Rs 1,000 were not recorded.
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.
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 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.
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.
