Question:
Shown below are the following for Casing Suppliers Ltd. of Oakville:
a. General ledger printout for March 2022.
b. Bank reconciliation as of February 28, 2022.
c. Bank statement for March 2022.
Required
Prepare a bank reconciliation at March 31, 2022.
Transcribed Image Text:
Period Source
Date Description
1050 Royal Bank - Chequing
3
GL-GJ 2-Mar-22 WESTERN PROPERTIES LTD.
GL-GJ 2-Mar-22 WALLY PIERCE - Deposit
3
3
GL-GJ 3-Mar-22
SANDY NESS - Deposit
3
GL-GJ 3-Mar-22
CARSON WHOLESALE INC.
3 GL-GJ 4-Mar-22
3
GL-GJ 4-Mar-22
GL-GJ 4-Mar-22
3
3
GL-GJ 5-Mar-22
GL-GJ 6-Mar-22
GL-GJ 6-Mar-22
2
GL-GJ 6-Mar-22
GL-GJ 6-Mar-22
MANG
NANCY SNYDER
GL-GJ 6-Mar-22
CITY PHONE COMPANY
CLC OM-32
GL-GJ 9-Mar-22 LYCOS UTILITIES INC.
GL-GJ 9-Mar-22
CASEY VALENCE
3
STATIONERY DEPOT LTD.
GL-GJ 9-Mar-22
3 GL-GJ 10-Mar-22
3 GL-GJ 11-Mar-22
3 GL-GJ 11-Mar-22
3
GL-GJ 11-Mar-22
GL-GJ 12-Mar-22
3
GL-GJ 12-Mar-22
3
GL-GJ 13-Mar-22
3 GL-GJ 16-Mar-22
GL-GJ 16-Mar-22
GL-GJ 16-Mar-22
San Lore
3
3
3
3
3
3
3
3
3
3 GL-GJ 16-Mar-22
3 GL-GJ 16-Mar-22
3
3
3
3
3
3
3
3
3
3
3
3
3
3
GL-GJ 17-Mar-22
GL-GJ 17-Mar-22
GL-GJ
CLC 16-Mar-22
GL-GJ 20-Mar-22
GL-GJ 20-Mar-22
GIGJ AFME-ZZ
GL-GJ 23-Mar-22
GL-GJ 23-Mar-22
at
GL-GJ 24-Mar-22
GL-G] 24-Mar-22
GL-GJ 26-Mar-22
GL-GJ 27-Mar-22
GL-GJ 27-Mar-22
3 GL-GJ 27-Mar-22
3 GL-GJ 27-Mar-22
3 GL-GJ 30-Mar-22
GL-GJ 30-Mar-22
3
3 GL-GJ 30-Mar-22
3 GL-GJ 30-Mar-22
3 GL-GJ 31-Mar-22
Balance per Bank Statement
Add: Deposit in Transit
Less: Outstanding Cheques:
Casing Suppliers Ltd.
General Ledger Listing as of March 31, 2022
Posting
Entry
Balance Forward
3-1
3-2
3-3
3-4
23
3-5
2-3
Balance per General Ledger
CHQ 3526
QUICK COMPUTER REPAIRS LTD. CHQ 3527
NIVENS QUALITY UPHOLSTERING
CHQ 3528
ALLEN MURRAY-Deposit
A.F. KINGSLEY, ACCOUNTANT
BRENDA KELLY - Deposit
EVANS CONTRACTING LTD.
Co
JAMIE DUPRE
WAN TSUI - Deposit
CHQ 3530
CORRINTHIAN CONSULTING CO. CHQ 3531
CHQ 3531
GRADY PURBOO - Deposit
GRADI PURBOO
LARRY MURDOCH-
Salary
FREDA WANDERLING - Salary
tomon
CHQ 3525
1241
1242
CRISPIN ROBICHAUD
CRISP
KEN CHARLES-Deposit
WANDA GRIERSON - Deposit
OREST FELDMAN - Deposit
TIM EWASIUK- Deposit
GRAHAM DENMANN
STILL PRODUCTIONS COMPANY
BRYANT WHOLESALE
SUPPLIERS LTD
AGENCY RESTAURANT
COMPACT DESIGNS LTD.
AMY FIELDING - Deposit
1243
com
LARRY MURDOCH-Salary
FREDA WANDERLING - Salary
RBC-Loan Interest
K CARDINAL-Deposit
JAMISON SUPPLIERS LTD.
WORD WIZARDS LTD.
Canada Revenue Agency
RBC-Loan Repayment
JOY AMITY - Deposit
THOMAS HUNT - Insurance
CHQ 3546
PEARSON HIGH SCHOOL ADVERT. CHQ 3547
THE LOCAL TIMES
CHQ 3548
RBC-New cheques ordered
LINDA FRANKLIN - Deposit
CHQ 3529
and 352
1244
3496
3523
3524
che ade
CHO 3532
CHQ 3535
COLEX REAK
CHO 3536
22232
CHQ 3537
CHQ 3557
CHQ 3538
CHQ 3539
1245
CHQ 3540
CHQ 3541
01-21
1246
CHQ 3542
CHQ 3543
CHQ 3544
01-24
1247
01-29
129
1248
1249
CHQ 3549
CHQ 3550
CHO 3551
1250
1251
1252
1253
CHQ 3552
CHQ 3553
CHQ 3554
CHQ 3555
CHQ 3556
1254
Casing Suppliers Ltd.
Bank Reconciliation
February 28, 2022
3-6
2-0
3-7
251
3-8
3-0
3-9
3-
3-10
20
3-11
20
3-12
200
3-13
20
3-14
20
3-15
200
3-16
20
3-17
3-18
3-19
3-20
3-21
3-22
3-23
3-27
3-28
3-29
3-30
3-31
3-32
3-37
20
3-38
330
3-39
3-39
3-44
3-444
3-45
3-43
3-46
3-440
3-47
3-41
3-48
END
3-49
3-56
3-57
3-58
3-62
3-65
3-66
Debits
53.18
1,685.25
2,344.64
6,425.48
3,164.17
8,742.00
1,756.25
1,616.82
1,648.65
6,746.90
3-51 1,648.80
3-52
2,548.33
6,475.20
648.00
2,846.54
1,867.95
2,866.38
5,183.83
3,640.58
8,824.41
4,083.07
4,741.34
Credits
1,498.00
3,614.85
136.00
1,510.00
749.00
418.50
641.30
365.00
Net
Balance Dr./Cr.
Dr.
4,741.34
3,243.34
Dr.
DE
9,668.82
2,000.02
12,832.99
Dr.
9,218.14
DE
Dr.
9,082.14 Dr.
Dr.
Dr.
7,572.14
16.314.14
10,314-14
15,565.14
15,903-14
5,248.95 12,072.44 Dr.
$200
2,850.00 9,222.44
Dr.
1,500.00
168.45
318.96
2,167.10
742.00
Dr.
DE
Dr.
$200
17,321.39 Dr.
7,722.44
7,553.99
7,235.03
cob.de
6,816.53
6,175.23
Dr.
5,810.23
Dr.
7,427.05 Dr.
1,645.20 5,781.85 Dr.
1,586.45 4,195.40 Dr.
368.40 3,827.00 Dr.
10,302.20 Dr.
8,135.10 Dr.
Dr.
7,393.10
5,708.58
Dr.
Dr.
1,684.52
3,000.00 2,708.58
1,645.20
1,586.45
Dr.
200
Dr.
$200
Dr.
200
Dr.
3,356.58 Dr.
1,014.58 2,342.00 Dr.
125.00
2,217.00 Dr.
682.45
1,534.55
Dr.
Dt.
35.30
1,499.25.
1,499.25
4,345.79
723224
0,418.14
6,213.74
4,568.54
2,982.09
1,256.75 1,725.34
Dr.
DE
3,373.99
Dr.
DE
Dr.
DE
10,120.89
11,769.69 Dr.
DI
14,318.02 Dr.
4,516.84
9,801.18 Dr.
1,648.75 8,152.43 Dr.
6,745.14 1,407.29 Dr.
Dr.
20
Dr.
Dt.
Dr.
DI
Dr.
DI
Dr.
DE
158.76 1,248.53 Dr.
253.60 994.93 Dr.
3,861.31 Dr.
