REQUIRED Based on the cash book and bank statement of Joe Wilson ltd 1. Prepare an adjusted cashbook 2. Bank reconciliation statement
JOE WILSON LTD
CASHBOOK - MANNA COMMERCIAL BANK
Date |
Particulars |
GH¢ |
Date |
Particulars |
GH¢ |
2014 |
|
|
2014 |
|
|
3-Jan |
Chq 1050 |
16,000 |
1-Jan |
Bal brought fwd |
110,000 |
6-Jan |
Chq 6060 |
30,000 |
13-Jan |
Chq 4440 |
15,000 |
15-Jan |
Chq 4443 |
23,000 |
13-Jan |
Chq 4441 |
13,000 |
15-Jan |
Chq 4440 |
15,000 |
15-Jan |
Chq 4442 |
16,000 |
16-Jan |
Chq 3232 |
8,000 |
18-Jan |
Chq 4444 |
120,000 |
17-Jan |
Chq 9112 |
34,000 |
19-Jan |
Chq 4445 |
17,000 |
31-Jan |
Chq 9112 |
34,000 |
20-Jan |
Chq 4440 |
25,000 |
31-Jan |
Chq 9080 |
72,000 |
21-Jan |
Chq 4446 |
32,000 |
31-Jan |
Bal c/d |
116,000 |
|
|
|
348,000 348,000
Bal b/f 116,000
JOE WILSON LTD
BANK STATEMENT FOR THE MONTH OF JANUARY 2014
|
|
DEBIT |
CREDIT |
BALANCE |
2014 |
|
GH¢ |
GH¢ |
GH¢ |
1-Jan |
Bal b/f |
|
|
(110,000) |
3-Jan |
Chq 1050 |
|
16,000 |
(94,000) |
17-Jan |
Bank Charges |
600 |
|
(94,000) |
18-Jan |
Chq 1010 Supplier TM |
|
8,000 |
(86,600) |
18-Jan |
Chq 5010 Supplier VAR |
|
12,000 |
(74,600) |
18-Jan |
Standing Order ECG |
800 |
|
(75,400) |
18-Jan |
Chq 4441 |
13,000 |
|
(88,400) |
18-Jan |
Chq 9112 |
|
34,000 |
(54,400) |
31-Jan |
Chq 4444 |
|
120,000 |
65,600 |
26-Jan |
Chq 4445 |
17,000 |
|
48,600 |
31-Jan |
Chq 3333 Dishonored chq |
4,500 |
|
44,100 |
It has been determined that the bank credited cheque no 4444 in error
REQUIRED
Based on the
1. Prepare an adjusted cashbook
2.
Step by step
Solved in 2 steps with 2 images