Bank reconciliation

Tabasco Ltd is a small company which prepares accounts to 30 June each year. The
company’s financial statements for the year to 30 June 2008 cannot be completed until a
bank reconciliation has been performed for the month of June 2008. The cashbook for
June 2008 and the bank statement for that month are shown below. It may be assumed
that the bank’s records are entirely correct.

Cashbook

June Rs June Cheque no. Rs
2 Sales 876.48 1 Balance b/d 1,009.64
4 Sales 584.60 3 Petrol 914 76.04
9 R Raj 5,554.66 5 Rent 915 5,140.00
12 C Gunputh 1048.12 6 Bank charges (May) 45.00
14 J Kalachand Ltd 2,500.00 9 G Kent 916 837.12
18 Sales 1,509.76 12 R Makoond 917 3,193.48
26 J Williams 5,000 16 Cash 918 800.00
30 K Nagawa 23.74 21 S Shah 919 1,640.00
25 W Subadar 920 1,121.08
30 Petrol 921 25.56
30 Wages 922 1,989.3
30 Balance c/d 1,220.14
17,097.36 17,097.36

Bank statement
June Paid out Paid in Balance
1 Balance brought forward 1,098.46
2 Sundry credits 246.9 1,345.36
3 Cheque 913 1,800.00 454.64 OD
6 Sundry credits 1,461.08 1,006.44
9 Cheque 915 5,140.00 4,133.56 OD
9 Cheque 914 76.04 4,209.60 OD
11 Direct debit (Telecom plc) 700.00 4,909.6 OD
12 Cheque 916 857.12 5,766.72 OD
13 Credit transfer (T Lomas) 320.54 5,446.18 OD
13 Sundry credits 6,602.78 1,156.60
13 Cheque 911 600.00 556.60
16 J Kalachand Ltd 3,040.00 3,596.6
16 Cheque 918 800.00 2,796.6
19 Sundry credits 1,509.76 4,306.36
23 Dishonoured cheque 1,048.12 3,258.24
26 Cheque 919 1640.00 1,618.24
30 Bank charges 155.60 1,462.64

prepare a bank reconciliation statement and an amended cash book.