P9-6C. On March 2, 2022, the accountant for Bergen Carpet Co. of Edmonton was injured in a skiing accident and was advised not to return to work for six weeks. The owners of the company are anxious to ensure that the company's bank statement is reconciled and have asked you to perform this task. You are presented with the following information: a. Bank reconciliation prepared by the regular accountant at January 31, 2022: Bergen Carpet Co. Bank Reconciliation January 31, 2022 Balance per Bank Statement Add: Deposit in Transit $ 8,364.02 2,576.03 10,940.05 Less: Outstanding Cheques No. 417 419 423 Balance per General Ledger S 28.30 1,043.25 1,722.30 2,793.85 $ 8,146.20 b. General ledger listing of Bank Account (#110) for the month of February (see page 457). c. Bank statement from the Royal Bank for the period ending February 26, 2022 (see page 458). Account Statement ROYAL BANK MAIN BRANCH 10107 JASPER AVENUE EDMONTON AB T5JIW9 Account No 03749 124-629-7 From BERGEN CARPET CO BAY 215 10620 - 104 AVENUE EDMONTON AB T5J 3G2 Period To Jan 27/22 Feb 26/22 Enclosures 1 Page Date Cheques & Des Deposits & Credits Balance Jan 28 Jan 28 2,576.03 404 419 423 424 974.15 1,043.25 1,722.30 133.75 Jan 29 Jan 30 Feb 01 Feb 04 8,364.02 10,940.05 8,922.65 7,200.35 7,066.60 15,211.98 20,403.13 21,372.14 8,145.38 5,291.15 434 100,00 Feb 05 Feb 06 969.01 2,782.00 425 22,776,82 Feb 07 80.25 601.87 695.20 121.75 697.35 697.35 430 436 435 Feb 08 2,169.96 21,260.37 23,319.19 Feb 10 Transaction Description Balance Forward Deposit Cheque - Cheque Cheque Cheque Deposit Deposit Cheque Deposit Deposit Cheque - Loan Payment - Principal Loan Interest Cheque - Cheque - Cheque Deposit Cheque - Cheque Cheque Cheque - Cheque Deposit Loan Management Fee Cheque - Cheque Cheque Deposit Deposit Cheque - Cheque - Cheque - NSF Returned NSF Charge Cheque - Cheque Deposit Cheque - Deposit Cheque Service Charge 431 433 432 428 426 111.14 1,091.40 94.66 6,829.28 240.75 15,063.10 Feb 13 404.46 438 427 437 40.00 2,010.40 4,559.11 112.50 Feb 18 Feb 18 3,610.18 4,068.68 Feb 18 Feb 18 429 441 442 25.00 802.50 246.10 404.46 15.00 697.35 697.35 8,745.55 12,355.73 16,399.41 15,596.91 14,946.35 14,931.35 13,536.65 15,112.68 Feb 21 Feb 24 444 445 Feb 25 2,569.07 439 993.04 Feb 26 4,674.30 446 240.00 18.45 19,528.53 No of Debits 30 Total Amount 26,095.71 No of Credis 11 Tocal Amount 37,260.22 Required Prepare the necessary reconciliation and any journal entries needed at February 28, 2022. Date: 11 Mar. 2022 11:06 am G/L Listing Page: 1 BERGEN CARPET CO General Ledger Listing as of 28 Feb 2122 G/L. listing for account | 1101 to 110 for department 1 1 to [222], for fiscal period [2] [ 21. sorted by Account Last posting sequence number: 4 Acct. Det Posting Entry Net Change Balance Pd Batch Entry Srce Date Description Reference Debits Credits 8,146,20 974.15 8,145.38 909.50 133.75 4,381.65 80.25 969.01 240.75 CHQ 404 1007 1018 CHQ 424 02-05 CHQ 425 10019 CHQ 426 1011 CHQ 427 CHQ 428 CHQ 429 CHQ 430 CHQ431 CHQ 432 CHQ433 CHQ 434 2,782.00 4,559.11 6,829.28 25.00 121.75 111.14 1,091.40 100,00 1012 2,169,96 NNNNNNNNNNNNNN NNNNNNNNNNNNNNNNNNNNNNNNNNNN 110 GLG GLGI GLG) GLG GL-GJ GLGI GLGJ GLG GL-G) GL-GJ GL-GI GLGI GLG) GLGJ GLGJ GLG GLG) GLG) GL-GJ GLGJ GLGJ GL-GJ GLG) GLG) GLG) GL-GJ GL-GJ GLG) GL GJ GLG) GLG) GL-G] GLG) GLGI GL-GJ GL-GJ GL-GI GLG) GLG GLGI GLG) GL GJ GLGJ Bank 01 Feb 16 01 Feb 16 04 Feb 16 04 Feb 16 04 Feb 16 05 Feb 16 05 Feb 16 06 Feb 16 06 Feb 16 07 Feb 16 07 Feb 16 07 Feb 16 08 Feb 16 08 Feb 16 08 Feb 16 08 Feb 16 04 Feb 16 08 Feb 16 06 Feb 16 08 Feb 16 08 Feb 16 08 Feb 16 13 Feb 16 13 Feb 16 13 Feb 16 13 Feb 16 15 Feb 16 18 Feb 16 18 Feb 16 18 Feb 16 18 Feb 16 18 Feb 16 25 Feb 16 25 Feb 16 25 Feb 16 25 Feb 16 24 Feb 16 26 Feb 16 26 Feb 16 28 Feb 16 28 Feb 16 28 Feb 16 28 Feb 16 KING PROPERTY SANDRA SMYTHE - Deposit INGRID LUNDREN Deposit CAMPUS COPY SHOPPE BENJAMIN YEE LITENORE NEON SIGNS NORM & JANET TAYLOR - Deposit NAME IT! JERRY SIMON - Deposit SAXONY WOOL MILLS QUALITY CARPET COMPANY JODY ARCHER CITY PHONE COMPANY CITY UTILITY COMPANY JOE'S GAS BAR WOODS STATIONERY CASH IVY LEUNG - Deposit EMILY BERGEN - Salary JAMES BERGEN - Salary RBC/TERMPLAN LOAN PAYMENT RBC/DEMAND LOAN INTEREST PAT HARPER - Deposit CITY LIGHTING FREDDY DUNCAN RECEIVER GENERAL FOR CANADA VOID WILSON INSURANCE AGENCY COMMUNITY CALENDAR STANDARD NEWS TC CHURCHILL - Deposit RBC/LOAN PROCESSING CHARGE BEATRICE DAY- Deposit JOAN ANDERSON - Deposit EMILY BERGEN - Salary JAMES BERGEN - Salary BOB JONES MICHEL ROBICHAUD - Deposit JUDY CARMICHAEL - Deposit DMJ CONSTRUCTION - Deposit FREDDY DUNCAN GEORGE BETTS GREENBRIAR RESTAURANT 2-1 2-2 2-3 2.4 2-5 2-6 2.7 2.9 2-10 2-11 2-12 2-13 2-14 2-15 2-16 2-17 2-18 2 - 19 2 - 20 2.21 2-22 2-23 2-27 2-29 2-30 2.31 2-32 2-33 2.34 2.35 2 - 36 2-37 2.38 2.44 2 - 46 2-47 2.49 2.53 2.54 2-55 2-56 2.57 2.58 2-1 2-2 2-3 2.4 2-5 2-6 2.7 2.9 2-10 2-11 2-12 2.13 2-14 2-15 2-16 2-17 2.18 2-19 2 - 20 2.21 2-22 2-23 2-27 2-29 2-30 2-31 2-32 2-33 2.34 2.35 2-36 2-39 2.38 2-44 2-46 2-47 2.49 2.53 2.54 2-55 2-56 2.57 2-58 697.35 697.35 601.87 695.20 404.46 112.50 2.010.40 993.04 CHQ 435 CHIQ 436 02-22 02-23 1013 CHQ 437 CHQ 438 CHQ439 CHQ 440 CHQ 441 CHQ 442 CHQ 443 1015 02 - 37 1016 02-44 CHQ 444 CHQ 445 CHQ 446 02.53 1022 02-55 CHQ 447 CHQ 448 CHQ 449 0.00 812.50 246.10 909.50 3,610.18 40.00 4,068.68 2,569.07 697,35 69735 240,00 3,456.10 1.218.20 1,786.90 1,950,00 1.213.20 76.15 9.429.09 Acct 110 - Balance Feb 28, 2122 17.575.29