NEED TO PREPARE A BANK RECONCILIATION FOR FEBRUARY 28, 2022 - ASAP PLEASE THIS IS FOR MY QUIZ. THANKS!
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 $ 28.30 1,043.25 1,722.30 2,793.85 $ 8,146.20 Date: 11 Mar. 2022 11:06 am G/L Listing Page: 1 BERGEN CARPET CO. General Ledger Listing as of 28 Feb 2022 G/L listing for account for department for fiscal period sorted by [ 110 to [ 110 ] [ ] to [222 ], [ 2], | Account] [2] 0 Last posting sequence number: 4 Acct. Dept. Posting Entry Net Change/ Balance Batch Entry Pd Date Srce 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 2,782.00 CHQ 404 1007 1008 CHQ 424 02-05 CHQ 425 1009 CHQ 426 1011 CHQ 427 CHQ 428 CHQ 429 CHQ 430 CHQ 431 CHQ 432 CHQ 433 CHQ 434 1012 CHQ 435 CHQ 436 02-22 4,559.11 6,829.28 25.00 121.75 111.14 94.66 1,091.40 100,00 2,169.96 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 110 GL-GJ GL-GJ GL-GJ GL-G) GL-GJ GL-G] GL-G] GL-G] GL-GJ GL-GJ GL-G] GL-G] GL-G) GL-G] GL-GJ GL-G] GL-GJ GL-GJ GL-GJ GL-G] GL-GJ GL-G) GL-GJ GL-G) GL-G] GL-G] GL-G] GL-GJ GL-G] GL-G] GL-GJ GL-G) GL-GJ GL-GJ GL-G] GL-GJ GL-GJ GL-G] GL-GJ GL-G) GL-G] GL-G] GL-G] 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 08 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 LITEMORE 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 WOOD'S 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. 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 02-23 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 697.35 697.35 601.87 695.20 404.46 112.50 2,010.40 993,04 0.00 802.50 246.10 909.50 3,610.18 40.00 1013 CHQ 437 CHQ 438 CHQ 439 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 4,068.68 2,569.07 697,35 697.35 240,00 3,456.10 1,218.20 1,786.90 1,950.90 1,213.20 76.15 9.429.09 Acct 110 - Balance, Feb 28, 2022 17,575.29 Account Statement ROYAL BANK MAIN BRANCH 10107 JASPER AVENUE EDMONTON AB T5J 1W9 Account No. 124-629-7 03749 BERGEN CARPET CO. BAY 215 10620 - 104 AVENUE EDMONTON AB T5J 3G2 Period From To Jan 27/22 Feb 26/22 Enclosures Page 1 Date Cheques & Debits Deposits & Credits Balance 8,364.02 10,940.05 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,922.65 7,200.35 7,066.60 15,211.98 8,145.38 5,291.15 434 100.00 Feb 05 Feb 06 20,403.13 21,372.14 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 21,260.37 Feb 08 2,169.96 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 8,745.55 12,355.73 3,610.18 4,068.68 Feb 18 Feb 18 429 441 442 16,399.41 15,596.91 25.00 802.50 246.10 404.46 15.00 697.35 697.35 Feb 21 Feb 24 14,946.35 14,931.35 444 445 13,536.65 Feb 25 2,569.07 439 993.04 15,112.68 Feb 26 4,674.30 446 240.00 18.45 19,528.53 No. of Credits No. of Debits 30 Total Amount 26,095.71 Total Amount 37,260.22 11 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 $ 28.30 1,043.25 1,722.30 2,793.85 $ 8,146.20 Date: 11 Mar. 2022 11:06 am G/L Listing Page: 1 BERGEN CARPET CO. General Ledger Listing as of 28 Feb 2022 G/L listing for account for department for fiscal period sorted by [ 110 to [ 110 ] [ ] to [222 ], [ 2], | Account] [2] 0 Last posting sequence number: 4 Acct. Dept. Posting Entry Net Change/ Balance Batch Entry Pd Date Srce 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 2,782.00 CHQ 404 1007 1008 CHQ 424 02-05 CHQ 425 1009 CHQ 426 1011 CHQ 427 CHQ 428 CHQ 429 CHQ 430 CHQ 431 CHQ 432 CHQ 433 CHQ 434 1012 CHQ 435 CHQ 436 02-22 4,559.11 6,829.28 25.00 121.75 111.14 94.66 1,091.40 100,00 2,169.96 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 110 GL-GJ GL-GJ GL-GJ GL-G) GL-GJ GL-G] GL-G] GL-G] GL-GJ GL-GJ GL-G] GL-G] GL-G) GL-G] GL-GJ GL-G] GL-GJ GL-GJ GL-GJ GL-G] GL-GJ GL-G) GL-GJ GL-G) GL-G] GL-G] GL-G] GL-GJ GL-G] GL-G] GL-GJ GL-G) GL-GJ GL-GJ GL-G] GL-GJ GL-GJ GL-G] GL-GJ GL-G) GL-G] GL-G] GL-G] 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 08 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 LITEMORE 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 WOOD'S 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. 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 02-23 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 697.35 697.35 601.87 695.20 404.46 112.50 2,010.40 993,04 0.00 802.50 246.10 909.50 3,610.18 40.00 1013 CHQ 437 CHQ 438 CHQ 439 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 4,068.68 2,569.07 697,35 697.35 240,00 3,456.10 1,218.20 1,786.90 1,950.90 1,213.20 76.15 9.429.09 Acct 110 - Balance, Feb 28, 2022 17,575.29 Account Statement ROYAL BANK MAIN BRANCH 10107 JASPER AVENUE EDMONTON AB T5J 1W9 Account No. 124-629-7 03749 BERGEN CARPET CO. BAY 215 10620 - 104 AVENUE EDMONTON AB T5J 3G2 Period From To Jan 27/22 Feb 26/22 Enclosures Page 1 Date Cheques & Debits Deposits & Credits Balance 8,364.02 10,940.05 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,922.65 7,200.35 7,066.60 15,211.98 8,145.38 5,291.15 434 100.00 Feb 05 Feb 06 20,403.13 21,372.14 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 21,260.37 Feb 08 2,169.96 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 8,745.55 12,355.73 3,610.18 4,068.68 Feb 18 Feb 18 429 441 442 16,399.41 15,596.91 25.00 802.50 246.10 404.46 15.00 697.35 697.35 Feb 21 Feb 24 14,946.35 14,931.35 444 445 13,536.65 Feb 25 2,569.07 439 993.04 15,112.68 Feb 26 4,674.30 446 240.00 18.45 19,528.53 No. of Credits No. of Debits 30 Total Amount 26,095.71 Total Amount 37,260.22 11
