Question: Based on the account statement on page 349, (1) complete the bank reconciliation for Rick's Deli of Regina found on the reverse of the bank
Casing Suppliers Ltd.
General Ledger Listing as of March 31, 2015
-1.png)
Casing Suppliers Ltd.
Bank Reconciliation
February 28, 2015
-2.png)
-3.png)
-4.png)
-5.png)
a. Cheques outstanding: No. 110, $80; No. 116, $160; No. 118, $52.
b. A deposit of $416 is in transit.
c. The cheque book balance of Rick's Deli shows an ending balance of $798.
d. Jim Rice's cheque for $40 bounced because of lack of sufficient funds.
ng Period Source Date Description 3 GL-GJ 2-Mar-15 WESTERN PROPERTIES LTD 3 GL-GJ 2-Mar-15 WALLY PIERCE- Deposit 3 GL-G) 3-Mar-15 SANDY NESS Deposit CHQ 3525 3-1 1,498.00 3,243.34 Dr GL-GJ 3-Mar-15 CARSON WHOLESALE INC. 3 GL-G 4-Mar-15 QUICK COMPUTER REPAIRS LTD. CHQ 3527 3-5 136.00 9,082.14 Dr 1,510.00 7,572.14 Dr GL-GJ 4-Mar-15 NIVENS QUALITY UPHOLSTERING CHQ 3528 3-6 3 GL-G 4-Mar-15 ALLEN MURRAY Deposit 3 GL-G 5-Mar-15 A.F. KINGSLEY, ACCOUNTANT CHQ 3529 3-8 3 GL-GJ 6-Mar-15 BRENDA KELLY Deposit 3 GL-GJ 6-Mar-15 EVANS CONTRACTING LTD 3 GL-GJ 6-Mar-15 CORRINTHIAN CONSULTING CO. CHQ 3531 3 11 3 GL-GJ 6-Mar-15 NANCY SNYDER 3 GL-GJ 6-Mar-15 CITY PHONE COMPANY 3 GL-GJ 9-Mar-15 LYCOS UTILITIES INC. 3 GL-GJ 9-Mar-15 CASEY VALENCE 749.00 15,565.14 Dr. CHQ 3530 3 10 5,248.95 12,072.44 Dr. 2,850.00 9,222.44 Dr. 1,500.00 7,722.44 Dr. 168.45 7,553.99 Dr. 318.96 7,235.03 Dr. 418.50 6,816.53 Dr. 641.30 6,175.23 Dr. 365.00 5,810.23 Dr. CHQ 3536 3 14 15 CHQ 3539 3-17 CHQ 3540 3 19 GL-GJ 9-Mar-15 STATIONERY DEPOT LTD. 3 GL-GJ 10-Mar-15 JAMIE DUPRE 3 GL-GJ 11-Mar-15 WAN TSUI Deposit GL-GJ 11-Mar-15 LARRY MURDOCH- Salary 3 GL-GJ 11-Mar-15 FREDA WANDERLING - Salary 3 GL-GJ 12-Mar-15 RBC-Loan Interest 3 GL-GJ 12-Mar-15 K CARDINAL Deposit 3 GL-GJ 13-Mar-15 JAMISON SUPPLIERS LTD 3 GL-G) 16-Mar-15 WORD WIZARDS LTD 3 GL-GJ 16-Mar-15 Canada Revenue Agency 3 GL-GJ 16-Mar-15 RBC Loan Repayment 3 GL-GJ 16-Mar-15 JOY AMITY- Deposit 1,645.20 5,781.85 Dr 1,586.45 4,195.40 Dr 368.40 3,827.00 Dr. 10,302.20 Dr 2,167.10 8,135.10 Dr. 742.00 7,393.10 Dr. 1,684.52 5,708.58 Dr. 3,000.00 2,708.58 Dr. CHQ 3541 3-20 3-22 6,475.20 CHQ 3542 3-23 29 CHQ 3546 3-31 CHQ 3548 3-37 GL-GJ 16-Mar-15 THOMAS HUNT Insurance 1,014.58 2,342.00 Dr. 125.00 2,217.00 Dr. 682.45 1,534.55 Dr. 35.30 1,499.25 Dr. 3 GL-GJ 17-Mar-15 PEARSON HIGH SCHOOL ADVERT. CHQ 3547 3 32 3 GL-GJ 17-Mar-15 THE LOCAL TIMES GL-G 18-Mar-15 RBC - New cheques ordered 38 3 GL-GJ 20-Mar-15 LINDA FRANKLIN- Deposit 3 GL-GJ 20-Mar-15 GRADY PURBOO Deposit 3 GL-GJ 23-Mar-15 LARRY MURDOCH Salary 4 3-44 1,867.95 CHQ 3549 3 45 CHQ 3550 3-46 CHQ 3551 3-47 Dr 1,645.20 4,568.54 Dr. 1,586.45 2,982.09 Dr. 1,256.75 1,725.34 Dr GL-GJ 23-Mar-15 FREDA WANDERLING -Salary 3 GL-GJ 24-Mar-15 CRISPIN ROBICHAUD 3 GL-GJ 26-Mar-15 KEN CHARLES Deposit 3 GL-GJ 27-Mar-15 WANDA GRIERSON - Deposit GL-GJ 27-Mar-15 OREST FELDMAN Deposit 3 GL-GJ 27-Mar-15 TIM EWASIUK Deposit 3 GL-GJ 27-Mar-15 GRAHAM DENMANN 3 GL-GJ 30-Mar-15 STILL PRODUCTIONS COMPANY CHQ 3553 3 57 3 GL-GJ 30-Mar-15 BRYANT WHOLESALE CHQ 3552 3 56 CHQ 3554 3 58 CHQ 3555 3 62 11,769.69 Dr Dr. 4,516.84 9,801.18 Dr. 1,648.75 8,152.43 Dr. 6,745.14 1,407.29 Dr. SUPPLIERS LTD GL-GJ 30-Mar-15 AGENCY RESTAURANT 158.76 1,248.53 Dr. 3 GL-GJ 30-Mar-15 COMPACT DESIGNS LTD 3 GL-GJ 31-Mar-15 AMY FIELDING Deposit CHQ 3556 3 65 3-66 2,866.38 Balance per Bank Statement Add: Deposit in Transit 5,183.83 3,640.58 8,824.41 53.18 1,685.25 2,344.64 Less: Outstanding Cheques: 3496 3523 3524 4,083.07 Balance per General Ledger 4741.34 ROYAL BANK OF CANADA Centreville Branch Suite 410, Ambrose Gardens Oakville, ON M4W 7H2 Account Statement Account No. 765-432-8 Period Mar 1/15 Mar 31/15 CASING SUPPLIERS LTD. 1840 Rochester Road Oakville, ON M7) 4D6 Enclosures Pa Balance Feb 28 Balance Forward 5,183.83 8,824.41 6,479.77 4,981.77 3,296.52 9,722.00 12,886.17 9,271.32 9,135.32 17,877.32 16,377.32 11,128.37 12,884.62 12,135.62 11,767.22 10,257.22 9,938.26 7,088.26 6,919.81 6,278.51 7,895.33 7,476.83 13,952.03 12,365.58 10,720.38 8,553.28 7,811.28 7,775.98 6,091.46 5,076.88 4,394.43 5,042.43 2,042.43 4,888.97 4,240.97 4,220.97 6,088.92 4,502.47 4,588.67 2,943.47 1,686.72 3,640.58 sit Mar 02 Cheque Chequ Mar 02 Cheque Mar 02 Deposit sit Mar 04 Cheque 3524 3525 3523 2,344.64 1,498.00 1,685.25 6,425.48 3,164.17 8,742.00 1,756.25 Chequ 3526 3527 3,614.85 136.00 Mar 04 Deposit Mar 09 Cheque Mar 09 Cheque sit 3532 3530 1,500.00 5,248.95 749.00 368.40 3529 Mar 09 Loan Interest Payment Mar 10 Cheque Mar 11 Cheque Chequ Mar 11 Cheque Chequ sit Mar 12 Cheque sit Mar 12 Cheque Chequ Mar 16 Cheque 3528 3536 3531 3535 3538 2,850.00 168.45 641.30 1,616.8 6,475.20 3537 418.50 3541 3540 3542 3543 1,586.45 1,645.20 2,167.10 742.00 35.30 1,684.52 1,014.58 682.45 Mar 16 Cheques Ordered Mar 17 Cheque Mar 17 Cheque Mar 18 Cheque sit 3544 3546 3548 648.00 2,846.54 1,867.95 Mar 18 Loan Principal Payment 3,000.00 Mar 20 NSF Cheque Joy Amity Mar 20NSF Service Charge 648.00 sit Mar 22 Cheque 3550 3549 3551 1,586.45 Mar 24Interest Earned Mar 24 Cheque Mar 25 Cheque 1,645.20 1,256.75 Mar 26 | Deposit Mar 27 Cheque Mar 27 Deposit Mar 27 Deposit Mar 30 Cheque Mar 30 Deposit Mar 30 Bank Service Charge Mar 30 Cheque 3,335.37 (1,181.47) 5,565.43 7,214.23 5,565.48 8,113.81 8,071.06 7,912.30 1,648.65 3552 4,516.84 6,746.90 1,648.80 3553 1,648.75 2,548.33 42.75 158.76 3555 BANE CF SASKATCHEWAN Account Statement 41 64 241 6736 RICKKS DES 11-102 Street AprO1 Balance Forward Apr 02 Cheque Apr 03 Cheque Apr 10 Deposit pr 10 Cheque 718.00 108 114 36.00 70.00 40.00 770.00 Apr 17 Cheque Apr 20 Apr 20 NSF Retamed Item Apr 23 Deposit Apr 24 Cheque Apr 27 Deposi Apr 28 Cheque Apr 30 Service Charge 80.00 160.00 B50.00 160.00 2400 714.00 109 80.00 30.00 344.00
Step by Step Solution
3.53 Rating (177 Votes )
There are 3 Steps involved in it
BANK OF SASKATCHEWAN MAIN BRACH REGINA SASKATCHEWAN This form is provided to help you balanc... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
725-B-A-B-S-C-F (2329).docx
120 KBs Word File
