Advertisements
Advertisements
Question
On 1st January 2017, Rakesh had an overdraft of ₹ 8,000 as showed by his cash book. Cheques amounting to ₹ 2,000 had been paid in by him but were not collected by the bank by January 01, 2017. He issued cheques of ₹ 800 which were not presented to the bank for payment up to that day. There was a debit in his passbook of ₹ 60 for interest and ₹ 100 for bank charges.
Prepare bank reconciliation statement for comparing both the balance.
Advertisements
Solution
| Bank Reconciliation Statement of Rakesh as on January 01, 2017 | ||
| Particulars | Amount Details ₹ |
Amount ₹ |
| Overdraft as per the Cash Book (Cr.) | 8,000 | |
| Add: Cheques deposited but not yet cleared | 2,000 | |
| Interest on overdraft debited by bank | 60 | |
| Bank debited charges | 100 | 2,160 |
| 10,160 | ||
| Less: Cheques issued but not presented for payment | 800 | |
| Overdraft as per the Pass Book (Dr.) | 9,360 | |
RELATED QUESTIONS
Adjusting the cash book before preparing the bank reconciliation statement is compulsory.
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 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 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.
From the following information, prepare bank reconciliation statement as on 31st December, 2017 to find out the balance as per bank statement.
| Particulars | ₹ |
| (i) Bank overdraft as per cash book | 20,000 |
| (ii) Cheques deposited but not yet credited | 4,000 |
| (iii) Cheque issued but not yet presented for payment | 1,000 |
| (iv) Rent collected by the bank as per standing instruction | 500 |
| (v) Interest on overdraft debited by bank | 2,000 |
| (vi) Amount wrongly debited by bank | 300 |
| (vii) Cheque issued on 30th December 2017 dishonoured by the bank | 5,000 |
| (viii) A customer’s cheque deposited in the bank dishonoured by bank not recorded in the cash book | 2,000 |
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
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
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.
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.
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.
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.
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.
Correct and rewrite the following statement:
When extracts are given for common period only common items are to be considered.
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 the Bank Reconciliation Statement as of 30th June 2019.
- Credit balance as per Pass Book ₹ 20,000.
- A cheque for ₹ 3,500 was issued and paid by the bank, recorded in the Pass Book as ₹ 5,300.
- The cheque deposited ₹ 9,700 collected by the bank was not recorded in the Cash Book.
- The payment side of the Cash Book was undercast by ₹ 100.
- The electricity bill paid by the bank ₹ 6,200, was recorded twice in the 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.
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 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.
