Solution of Bank Reconciliation Statement (BRS)
Solution and Problem of Bank Reconciliation Statement (BRS)
Bank Balance as per Cashbook
Practice problem 1
The following information is given to you
a. Bank Balance as per cash book 20000
b. Cheque issued of 5000 but not presented for payment
c. Interest on deposit allowed by the bank 5000 but not recorded in the cashbook
d. bank charges charged by the bank 200 but not recorded in the cash book
Required: Bank Reconciliation
Statement
Bank
Reconciliation Statement
Particular |
Amount |
Amount |
Bank balance as per cash book |
|
20000 |
Add: |
|
|
:- Cheque issued but not presented for payment |
5000 |
|
:- Interest on deposit allowed by the bank but not recorded in Cashbook |
500 |
5500 |
|
|
25500 |
Less: |
|
|
:- Bank charges charged by the bank but not recorded in the cashbook |
200 |
|
:- Cheque deposited into a bank but has not been collected by the bank |
7000 |
(7200) |
Balance as per Cashbook |
|
18300 |
Practice problem 2
From the following particulars, prepare a Bank
Reconciliation Statement
a. Debit balance as per cash book 15000
b. Three cheques of 1500, 2500 and 3000 were issued, but not presented for payment
c. A cheque of 2000 paid into the bank for collection, but not collected by the bank
d. Bank charges debited in passbook but not recorded in cashbook 1000
e. Interest collected and credited by the bank but not entered in the cash book of 1500
Bank Reconciliation Statement
Particular |
Amount |
Amount |
Bank balance as per cash book Add: A cheque was issued but not present for
payment Interest collected and credited by the bank
but not entered in a cashbook |
7000 1500 |
15000 |
Less: A cheque paid into the bank for collection
but not collected by the bank Bank charges debited in passbook but not entered in a cashbook |
|
23500 |
Balance as per passbook |
|
20500 |
Bank
Practice problem 3
Mr Arun Shrestha has found that on 31st Dec. 2004 his cash book shows a Bank balance of
21500. On comparing it with the passbook he found that:
a. Cheque of 1200 issued, out of which cheques for 2000 only were presented for payment.
b. A cheque of 1000 deposit but dishonoured by the bank
c. Cheques for 8000 were deposited into a bank but only for 3000 were cleared by the bank
d. Interest on investment of 3200 collected by the bank but not recorded in the cashbook.
Required: Bank Reconciliation
Statement
Solution
Bank Reconciliation Statement
Particulars |
Detail |
Amount |
Cash balance as per Passbook Add: :- Cheque
issued but only a few were presented for payment :-
Interest on investment collected by the bank but not recorded in the cashbook |
|
21500 13200 |
Less: :- A
cheque deposited but dishonoured by the bank :-
Cheque was deposited into a bank but only were cleared by the bank |
1000 5000 |
34700 (6000) |
Balance as per cash book |
|
28700 |
Practice problem 4
From the following particulars, prepare a Bank
Reconciliation Statement as of 31st March 2004
i. Balance as per cashbook on 31st March 2004 was 12000
ii. Cheques deposited in the bank on 27th March 6000 credited in the passbook on 5th April 2004
iii. Interest 14 credited by the bank on 31st March 2004 were not presented to the bank till 31st March 2004
iv. Cheques worth 8000 issued prior to 31st March 2004 were not presented
v. Bank charges 18 recorded in passbook only.
vi. Cheques issued to a creditor for 500 by mistake entered in the cash column of the cashbook. The cheque had not been presented for payment.
Solution
Bank
Reconciliation Statement
Particular |
Amount |
Amount |
Bank balance as per cash book Add: :- Interest credited by the bank was not entered in a cashbook :- Cheque issued were not presented to the bank |
14 8000 |
12000 8014 |
Less: :- Cheque deposited in the bank on 27th
march credited in the passbook on 5th April 2004 :- Bank charges recorded in passbook only. |
6000 18 |
20014 |
Balance as per passbook |
|
139913996 |
[For
transaction (.vi) it has no adverse effect on agreement of balance as per cash
book and passbook. It is not shown in the bank reconciliation statement]
Practice problem 5
From the following particulars supplied by Mr Ramesh Jaiswal,
prepare a Bank Reconciliation Statement as of 31st Dec 2004
a. The cheque of 900 was deposited in the bank in December 2004 but were realized by the bank in Jan 2005.
b. Cheque issued to Rajan for 225 in Dec. 2004 were encashed in Jan 2005.
c. Cheque for 200 received from Prema on 26th December was entered in the cash book but not deposited into the bank.
d. Cheque for 500 and interest on investment 100 collected by the bank were entered in the passbook only.
e. Payment side of the cash book was undercast by 10
f. Balance as per cash book on 31st December, 2004 was 3000
Solution
Bank
Reconciliation Statement
Particular |
Amount |
Amount |
Bank balance as per cash book Add: :- Cheque
issued to Rajan in Dec., 2004 were encashed in Jan, 2005 :- Cheque and interest on investment collected
by the bank were entered in the passbook only. |
255 600 |
3000 855 |
Less: :- The cheque was deposited in the bank in December,
2004 but were realized by the bank in Jan, 2005.
|
200 10 |
3855 (1110) |
Balance as per passbook |
|
2745 |
Practice problem 6
From the following particulars, ascertain the bank
balance in the passbook of Mohan as 31st Dec. 2004
a. The bank overdraft as per cash book on 31st Dec, 2004 was 10000
b. Interest on overdraft of 400 is debited in the Passbook
c. Bank charges charged by the bank amounting to 100
d. Cheque issued of 4000 but only cheque of 1000 were presented for payment
e. Cheques paid into a bank of 7000 but only cheque of 2000 was credited by the bank
f. Interest on investment collected by the bank 4000 but recorded in cashbook as 400
Solution
Bank
Reconciliation Statement
Particulars |
Detail |
Amount |
The bank overdraft as per cash book Add:
|
3000 3600 |
(10000) 6600 |
Less: (b) Interest
on overdraft is debited in the Passbook (c) Bank
charges charged by the bank
|
400 100 |
(3400) |
Overdraft balance as per passbook |
|
8900 |
Practice problem 7
Following facts were given to
you
Balance as per cashbook (Cr) 1400
Unpresented cheque. 1720
Uncredited cheques by the bank. 1130
You have been given the following
figures as additional information
1. The debit side of the cash book (bank column) has been undercast by 250
2. A cheque for 200 paid to the creditor has been wrongly entered in the cash column.
3. Bank commission and other charges for the services 40 have not been recorded in the cashbook.
Required: Bank Reconciliation
Statement
Bank
Reconciliation Statement
Particulars |
Detail |
Amount |
The bank overdraft as per cash book Add: :- Unpresented
cheques :- The
debit side of the cashbook has been undercast |
1720 |
(1400) |
Less: :-
Uncredited Cheques by bank :- A
cheque paid to the creditor has been wrongly entered in the cash column :- Bank
commission and other charges for the services, have not been recorded in the
cashbook. |
1130 200 40 |
570 |
Overdraft as per passbook |
|
800 |
Note
It is overdraft when Cass book
is credited (cr)
It is overdraft when the passbook
is debited
Practice Problem 8
Consider the following
information:
a.
Bank overdraft as per cash book 8110
b.
Cheques deposited as per bank statement but not
entered in cashbook 260
c.
Cheques recorded for collection but not sent to
the bank 900
d.
Bank charges recorded twice in cash book 50
e.
Credit side of Bank column shirt 200
f.
Customer’s cheque returned being dishonoured but
not recorded in cashbook 700
g.
Cheques issued but dishonoured on technical
grounds 1000
h.
Bills collected by the bank directly 1300
i.
Cheques received entered twice in cashbook 200
Required: Bank Reconciliation Statement
Solution
Bank
Reconciliation Statement
Particulars |
Detail |
Amount |
Overdraft as per cash book Add: (c)
Cheques recorded for collection but not sent to the back (e)
Credit side of the bank column cast short in the cash book (f)
Customer cheque returned dishonoured but not recorded in the cashbook (i)
Cheques received entered twice in a cashbook |
900 200 200 |
(8110) |
Less (b)
Cheques deposited
but not entered in a cashbook (d)
Bank Charges recorded twice in a cashbook (g)
Cheque issued but dishonoured (h)
Bills directly collected by bank |
260 50 1000 1300 |
10110 (2610) |
Overdraft as per cash book |
|
7500 |
Balance as per passbook
Practice problem 1
From the following, prepare
the bank reconciliation statement
a.
Balance as per pass book 12000
b.
Cheques were drawn for 10000 but cheques of 5000 has been
presented for payment
c.
Interest credited by the bank 250
d.
Bank charges debited by the bank 50
e. Cheque paid into bank but the same has NAT been cleared by the bank 3500
Solution
Bank Reconciliation Statement
Particulars |
Detail |
Amount |
Balance as per passbook Add: (d) Bank Charges debited by the bank (e) Cheques paid into bank but has not been cleared by the bank |
3500 |
12000 |
Less: (b) Cheques were drawn but only a few cheques have been presented for payment (C) Interest
credited by the bank |
250 |
15550 |
Balance as per cash book |
|
10300 |
Prepare a Bank Reconciliation Statement for the following
transactions
a. Balance as per pass book (credit) is 16000
b. Cheques were drawn for 8000 but presented for payment amounting to 4000
c. Cheques issued but omitted to be recorded in the cash book of 500
d. Cheques deposited into a bank but omitted to be recorded in the cash book of 600
e. The receipts side of cash book over cost by 1000
f. Bank gave the debit of 35 for sundry charges
g. Bank received directly from the customer 500 but not recorded in the cashbook
Solution
Bank Reconciliation
Statement
Particulars |
Detail |
Amount |
Balance as per passbook Add (C) Cheques issued but omitted
to record in a cashbook (e) The receipts side of cash
book over cost (f) Bank gave the debit for
sundry charges |
500 1000 35 |
16000 1535 |
Less: (b) Cheques were drawn but not presented for payment (d) Cheques
deposited into a bank but omitted to be recorded in the cash book (g) Bank
received directly from a customer but not recorded in the cashbook |
4000 |
17535 |
Balance as per passbook |
|
12435 |
Practice problem 3
The following information is given to you as of 31st
December 2005
a. Bank balance as per passbook 5000
b. A cheque for 700 issued to a creditor was lost in transit and not presented for payment
c. A cheque for 840 had been debited in the bank column of the cash book but it has not been sent to the bank
d. Interest on overdraft debited by the bank 140
e. Payment side of cashbook has been undercast by 240
f. Interest on investment collected by the bank 340
Required: Bank Reconciliation Statement, showing the balance
as per Cashbook
Solution
Bank
Reconciliation Statement
Particulars |
Detail |
Amount |
Bank balance as per passbook Add: (c) A cheque
has been debited in the bank column of the cashbook but it had not been sent to the bank
|
840 140 240 |
5000
1220 |
Less: (b) A cheque
issued but not presented for payment (f) Interest
on investment collected by the bank |
700 340 |
6220
(1040) |
Balance as per cash book |
|
5180 |
Practice problem 4
The following information is given to you
a. Credit balance as per passbook 50000
b. A cheque for 40000 issued was entered in the cash column of the cashbook instead of the bank column and cashed by the bank.
c. Cheque paid into bank but omitted to be recorded in the cash book amounting to 16600
d. A bill receivable for 56000 which was discounted with the bank Dishonoured on the due date
e. Debit side of the cash book has been undercast by 28000
Required: Bank Reconciliation Statement
Solution
Bank
Reconciliation Statement
Particulars |
Detail |
Amount |
Credit balance as per passbook Add: b. A
cheque issued was entered in the cash column of the cashbook instead of the bank
column and cashed by the bank. d. A
bill receivable which was discounted with the bank dishonoured on the due
date |
40000 56000 |
50000
96000 |
Less: c. Cheque
paid into bank but omitted to be recorded in the cash book e. Debit
side of the cash book has been under the cast |
16600 28000 |
146000
(44600) |
Balance as per cash book |
|
101400 |
Practice problem 5
The following information is given to you. You are required to
prepare Bank Reconciliation Statement.
a. Credit balance as per passbook 7200
b. Cheques not presented for payment yet 10000
c. Cheques sent for deposit but not collected by the bank 3120
d. A cheque issued to Sarita but omitted to be recorded in cashbook 2400
e. The debit card of the bank column cash book has been undercast by 6000
f. Bank charges 960 has not been entered in the cash book.
Solution
Bank
Reconciliation Statement
Particulars |
Detail |
Amount |
Credit
balance as per passbook Add: c. Cheques
sent for deposit but not collected by the bank d. A
cheque was issued to Sarita but omitted to be recorded in the cashbook
|
3120 2400 960 | 7200 6480 |
Less: b. Cheques
not presented for payment yet e. The
debit card of the bank column cash book has been undercast |
10000 6000 |
13680
(16000) |
Overdraft as per cash book |
|
2320 |