P7.54 (LO 3), AP The bank portion of the bank reconciliation for Bogalusa Company at October 31. 2022, is as follows Prepare a ba adjusting en Bogalusa Company Bank Reconciliation October 31, 2022 Cash balance per bank Add: Deposits in transit $12,367.90 1,530,20 13,898.10 Less: Outstanding checks Check Number 2451 2470 2471 2472 2474 Adjusted cash balance per bank Check Amount $1,260.40 684.20 844.50 426.80 1,050.00 4.265.90 $ 9.632.20 The adjusted cash balance per bank agreed with the adjusted cash balance per books at October 31. All necessary journal entries were made at the end of October. The November bank statement showed the following checks and deposits. Date 11-1 11-2 11-5 11-4 11-8 11-10 11-15 11-18 11-27 11-28 11-30 11-29 Bank Statement Checks and Debits Number Amount 2470 S 684.20 2471 844.50 2474 1,050.00 2475 1,640.70 2476 2,830.00 2477 600.00 2479 1.750.00 2480 1,330.00 2481 695.40 SC 85.00 2483 575.50 2486 940.00 Total $13,025.30 Deposits and Credits Date Amount 11-1 $ 1.530.20 11-4 1,211.60 11-8 990.10 11-13 2,575.00 11-18 1.472.70 11-19 EFT 2,242.00 11-21 2,945.00 11-25 2,567.30 11-28 1.650.00 11-30 1.186.00 Total $18,369.90 The cash records per books for November showed the following: Date 11-1 11-2 11-2 11-4 11-8 11-10 11-15 11-18 Number 2475 2476 2477 2478 2479 2480 2481 2482 Cash Payments Amount Date $1,640.70 11-20 2,830.00 11-22 600.00 11-23 538.20 11-24 1.705.00 11-29 1,330.00 11-30 695.40 Total 612.00 Number 2483 2484 2485 2486 2487 2488 Amount $ 575.50 829.50 974.80 940.00 398.00 800.00 $14.469.10 Date 11-3 11-7 11-12 11-17 11-20 11-24 11-27 11-29 11-30 Total Cash Receipts Amount $ 1.211.60 990.10 2,575.00 1.472.70 2,954.00 2,567.30 1.650.00 1.186.00 1,304.00 $15.910.70 The November bank statement contained two bank memoranda: 1. A credit of $2,242 for the collection for Bogalusa Company of an electronic funds transfer. 2. A debit for the printing of additional company checks $85. At November 30, the cash balance per books was $11,073.80 and the cash balance per the bank statement was $17,712.50. The bank did not make any errors, but Bogalusa Company made two errors. Instructions a. Prepare a bank reconciliation at November 30, 2022. b. Prepare the adjusting entries based on the reconciliation(Note: The correction of any errors pertain ing to recording checks should be made to Accounts Payable. The correction of any errors relating to recording cash receipts should be made to Accounts Receivable.) ed cash bal. $13,176.80