Question:
From the following July 28, 2017, bank statement (p. 387),
(a) Complete a bank reconciliation for The Fresh Flower Shop of Halifax and
(b) Journalize the appropriate entries as needed.
a. A deposit of $2,122 is in transit.
b. The Fresh Flower Shop has an ending cheque-book balance of $5,111.
c. Cheques outstanding: No. 231, $298; No. 245, $509; No. 246, $76; No. 247, $237.
d. Jane Yates's cheque for $225 bounced because of non-sufficient funds.
Casing Suppliers Ltd.
General Ledger Listing as of March 31, 2018
Casing Suppliers Ltd.
Bank Reconciliation
February 28, 2018
e. Cheque No. 241 for utilities expense was entered in the cash payments journal as $358.
f. The cheque for $607 shown by the bank as paid on July 28 was actually a cheque of the Active Automotive Repair. This error will be corrected by the bank next month. The bank apologized for the error?
Transcribed Image Text:
Posting Entry Balance Forward Net Date Debits Credits Period Source Description 1050 Royal Bank - Chequing Reference Balance Dr/Cr. 4,328.94 Dr. CHQ 2325 GL-GJ 2-Mar-18 WESTERN PROPERTIES LTD. GL-GJ 2-Mar-18 WALLY PIERCE - Deposit GL-GJ 2-Mar-18 SANDY NESS - Deposit 3 -1 1,746.20 2,582.74 Dr. 8,769.16 Dr. 12,230.00 Dr. 8,752.84 Dr. 8,607.84 Dr. 6,962.84 Dr. 15,781.84 Dr. 14,925.84 Dr. 16,540.09 Dr. 10,955.94 Dr. 8,169.44 Dr. 6,519.44 Dr. 6,353.02 Dr. 6,010.30 Dr. 5,504.60 Dr. 4,835.98 Dr. 4,459.98 Dr. 7,877.23 Dr. 6,013.03 Dr. 4,298.48 Dr. 3,972.06 Dr. 9,818.90 Dr. 6,359.69 Dr. 5,387.69 Dr. 3,645.33 Dr. 1,645.33 Dr. 2,597.33 Dr. 1,844.09 Dr. 1,694.09 Dr. 6,186.42 3,460.84 942 3-2 943 3- 3 GL-GJ 2-Mar-18 CARSON WHOLESALE INC. CHQ 2326 CHQ 2327 3-4 3,477.16 GL-GJ 5-Mar-18 QUICK COMPUTER REPAIRS LTD. GL-GJ 5-Mar-18 NIVENS QUALITY UPHOLSTERING CHQ 2328 GL-GJ 6-Mar-18 ALLEN MURRAY - Deposit GL-GJ 6-Mar-18 A.F. KINGSLEY, ACCOUNTANT GL-GJ 6-Mar-18 BRENDA KELLY - Deposit 3-5 145.00 1,645.00 3 -6 3 -7 3-8 944 8,819.00 CHQ 2329 856.00 945 3-9 1,614.25 3 - 10 3- 11 GL-GJ 6-Mar-18 EVANS CONTRACTING LTD. CHQ 2330 CHQ 2331 CHQ 2332 CHQ 2335 CHQ 2336 CHQ 2337 CHQ 2338 CHQ 2339 946 5,584.15 2,786.50 GL-GJ 6-Mar-18 CORRINTHIAN CONSULTING CO. 1,650.00 GL-GJ 6-Mar-18 NANCY SNYDER GL-GJ 6-Mar-18 CITY PHONE COMPANY 3- 12 3 - 13 166.42 GL-GJ 9-Mar-18 LYCOS UTILITIES INC. 3- 14 342.72 GL-GJ 9-Mar-18 CASEY VALENCE GL-GJ 9-Mar-18 STATIONERY DEPOT LTD. 3- 15 505.70 3- 16 668.62 GL-GJ 9-Mar-18 JAMIE DUPRE GL-GJ 10-Mar-18 WAN TSUI - Deposit GL-GJ 10-Mar-18 LARRY MURDOCH - Salary GL-GJ 10-Mar-18 FREDA WANDERLING - Salary GL-GJ 11-Mar-18 RBC - Loan Interest GL-GJ 11-Mar-18 K CARDINAL - Deposit 3- 17 376.00 3- 18 3,417.25 CHQ 2340 CHQ 2341 01 - 21 3- 19 1,864.20 1,714.55 3- 20 3 - 21 326.42 5,846.84 947 3- 22 GL-GJ 13-Mar-18 JAMISON SUPPLIERS LTD. GL-GJ 16-Mar-18 WORD WIZARDS LTD. CHQ 2342 CHQ 2343 CHQ 2344 01 - 24 3- 23 3,459.21 3- 27 972.00 GL-GJ 16-Mar-18 Canada Revenue Agency GL-GJ 16-Mar-18 RBC - Loan Repayment GL-GJ 16-Mar-18 JOY AMITY - Deposit 3- 28 1,742.36 2,000.00 3- 29 948 3- 30 952.00 CHQ 2346 CHQ 2347 GL-GJ 16-Mar-18 THOMAS HUNT - Insurance GL-GJ 17-Mar-18 PEARSON HIGH SCHOOL 3- 31 753.24 3- 32 150.00 ADVERTISING CHQ 2348 01 - 29 GL-GJ 17-Mar-18 THE LOCAL TIMES 3- 37 682.45 1,011.64 Dr. GL-GJ 18-Mar-18 RBC - New cheques ordered GL-GJ 19-Mar-18 LINDA FRANKLIN - Deposit GL-GJ 20-Mar-18 GRADY PURBOO - Deposit GL-GJ 21-Mar-18 LARRY MURDOCH - Salary GL-GJ 23-Mar-18 FREDA WANDERLING - Salary GL-GJ 24-Mar-18 CRISPIN ROBICHAUD 3- 38 35.30 976.34 Dr. 949 3- 39 2,456.38 1,964.25 3,432.72 Dr. 5,396.97 Dr. 3,532.77 Dr. 1,818.22 Dr. 561.47 Dr. 3 - 44 3- 45 950 CHQ 2349 CHQ 2350 CHQ 2351 1,864.20 1,714.55 1,256.75 3- 46 3- 47 GL-GJ 25-Mar-18 KEN CHARLES - Deposit GL-GJ 27-Mar-18 WANDA GRIERSON - Deposit GL-GJ 27-Mar-18 OREST FELDMAN - Deposit GL-GJ 27-Mar-18 TIM EWASIUK - Deposit 951 3- 48 1,906.72 3,868.46 2,842.66 2,442.91 2,468.19 Dr. 6,336.65 Dr. 9,179.31 11,622.22 Dr. 7,163.44 Dr. 5,569.10 Dr. -271.50 Cr. 3- 49 952 3- 51 953 Dr. 954 CHQ 2352 CHQ 2353 CHQ 2354 3. 3- 52 3 - 56 4,458.78 1,594.34 GL-GJ 27-Mar-18 GRAHAM DENMANN GL-GJ 30-Mar-18 STILL PRODUCTIONS COMPANY GL-GJ 30-Mar-18 BRYANT WHOLESALE 3- 57 3- 58 5,840.60 SUPPLIERS LTD CHQ 2355 CHQ 2356 3 - 62 3- 65 3. GL-GJ 30-Mar-18 AGENCY RESTAURANT GL-GJ 31-Mar-18 COMPACT DESIGNS LTD. GL-GJ 31-Mar-18 AMY FIELDING - Deposit 162.70 -434.20 Cr. 268.45 -702.65 Cr. 3 - 66 3. 955 3,148.62 2,445.97 Dr. Balance per Bank Statement 5,183.83 2,856.32 8,040.15 Add: Deposit in Transit Less: Outstanding Cheques: 2296 2323 2324 87.26 1,457.50 2,166.45 3,711.21 Balance per General Ledger 4,328.94