Prepare John Snow’s bank reconciliation at November 30 th Based on the below. Da
ID: 2459253 • Letter: P
Question
Prepare John Snow’s bank reconciliation at November 30th Based on the below.
Date
Cheque #
Item
Cheque
Deposit
Balance
Nov
1
$705
4
622
Direct Energy
$19
686
9
Dividends
$116
802
13
623
Canadian Tire
43
759
14
624
Petro-Canada
58
701
18
625
Cash
50
651
26
626
Faith of the Seven Church
25
626
28
627
Beyond the Wall Apartments
275
351
30
Paycheque
846
1,197
Balance
$705
Add deposits
116
Deduct cheques
No.
622
623
624
625
Amount
$19
43
85
50
Other charges:
NSF cheque
$8
Service charge
20
Balance
$604
Date
Cheque #
Item
Cheque
Deposit
Balance
Nov
1
$705
4
622
Direct Energy
$19
686
9
Dividends
$116
802
13
623
Canadian Tire
43
759
14
624
Petro-Canada
58
701
18
625
Cash
50
651
26
626
Faith of the Seven Church
25
626
28
627
Beyond the Wall Apartments
275
351
30
Paycheque
846
1,197
Explanation / Answer
Bank Reconciliation at November 30th
Particulars Amount $ Balance as per bank book 604 Less: Mistake in balance of bank book 8 (705+116-19-43-85-50-8-20=596) 596 Less: Cheque issued but not accounted in bank book Faith of the Seven Church 25 Beyond the Wall Apartments 275 Add: Cheque received but not entered 846 Add: Excess cheque amount shown in bank book cheque no 624 (85-58) 27 Add: Cheque issued but not presented in bank NSF cheque 8 Service charge 20 Balance as per Bank Statement 1,197