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 information, prepare bank reconciliation statement to find out the bank statement balance as on 31st December, 2017.
| Particulars | ₹ |
| 1. Balance as per cash book | 15,000 |
| 2. Cheques deposited but not yet credited | 1,000 |
| 3. Cheques issued and entered in the cash book before 31st December 2017 but not presented for payment until that date | 1,500 |
| 4. Dividend directly received by bank | 200 |
| 5. Direct payment made by bank for rent | 1,000 |
| 6. Locker rent charged by the bank not recorded in cash book | 1,200 |
| 7. Wrong debit given by the bank on 30th December 2017 | 500 |
| 8. A payment made through net banking has been entered twice in the cash book | 300 |
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.
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.
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.
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 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.
