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
Select the most appropriate alternative from those given and rewrite the following statement:
Debiting an entry in Cash Book ___________ cash balance.
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 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 |
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.
Prepare bank reconciliation statement of Shri Bhandari as on March 31, 2017.
- The payment of a cheque for ₹ 550 was recorded twice in the passbook.
- Withdrawal column of the passbook undercast by ₹ 200.
- A cheque of ₹ 200 has been debited in the bank column of the Cash Book but it was not sent to bank at all.
- A cheque of ₹ 300 debited to bank column of the cash book was not sent to the bank.
- ₹ 500 in respect of dishonoured cheque were entered in the passbook but not in the cash book. Overdraft as per passbook is ₹ 20,000.
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 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.
