The bank portion of the bank reconciliation for Oriole Company at October 31, 2022, is shown below. ORIOLE COMPANY Bank Reconciliation October 31, 2022 Cash balance per bank Add: Deposits in transit $12.617.90 1,530.20 14,148.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 427.80 1,050.00 4,266.90 $9,881.20 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following checks and deposits. Checks Number 2470 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 2471 2474 2475 2476 2477 2479 2480 2481 SC 2483 2486 Total Bank Statement Deposits Amount Date Amount $ 684.20 11-1 $ 1,530.20 844.50 11-4 1.211.60 1,050.00 11-8 990.10 1,640.70 11-13 2,575.00 2,830.00 11-18 1,472.70 600.00 11-19 EFT 2,417.00 1,740.00 11-21 2,945.00 1,330.00 11-25 2,567.30 695.40 11-28 1,650.00 88.10 11-30 1,186.00 575.50 Total 18,544.90 940.00 $13,018.40 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 Number 2475 2476 2477 2478 2479 2480 2481 2482 Cash Payments Journal Amount Date Number $1,640.70 11-20 2483 2,830.00 11-22 2484 600.00 11-23 2485 538.20 11-24 2486 1,704.00 11-29 2487 1,330.00 11-30 2488 695.40 Total 612.00 Amount $575.50 826.40 974.80 940.00 398.00 800.00 $14,465.00 Cash Receipts Journal Date Amount 11-3 $ 1,211.60 11-7 990.10 11-12 2,575.00 11-17 1,472.70 11-20 2,954.00 11-24 2,567.30 11-27 1,650.00 11-29 1,186.00 11-30 1,554.00 Total 16,160.70 11-18 The bank statement contained two bank memoranda: 1. 2. A credit of $2,417.00 for the collection from a customer for Oriole Company of an electronic funds transfer. A debit for the printing of additional company checks $88.10. Using the steps in the reconciliation procedure, prepare a bank reconciliation at November 30, 2017. (List items that increase balance as per bank and books first.) ORIOLE COMPANY Bank Reconciliation $ Prepare the adjusting entries based on the reconciliation. (Note: The correction of any errors pertaining 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.) (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Debit Credit Date Account Titles and Explanation Nov 30 (To record electronic funds transfer received by bank) Nov 30 To record charge for printing company checks) Nov 30 (To correct error in recording check) Nov 30 (To correct error in deposit) The bank portion of the bank reconciliation for Oriole Company at October 31, 2022, is shown below. ORIOLE COMPANY Bank Reconciliation October 31, 2022 Cash balance per bank Add: Deposits in transit $12.617.90 1,530.20 14,148.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 427.80 1,050.00 4,266.90 $9,881.20 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following checks and deposits. Checks Number 2470 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 2471 2474 2475 2476 2477 2479 2480 2481 SC 2483 2486 Total Bank Statement Deposits Amount Date Amount $ 684.20 11-1 $ 1,530.20 844.50 11-4 1.211.60 1,050.00 11-8 990.10 1,640.70 11-13 2,575.00 2,830.00 11-18 1,472.70 600.00 11-19 EFT 2,417.00 1,740.00 11-21 2,945.00 1,330.00 11-25 2,567.30 695.40 11-28 1,650.00 88.10 11-30 1,186.00 575.50 Total 18,544.90 940.00 $13,018.40 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 Number 2475 2476 2477 2478 2479 2480 2481 2482 Cash Payments Journal Amount Date Number $1,640.70 11-20 2483 2,830.00 11-22 2484 600.00 11-23 2485 538.20 11-24 2486 1,704.00 11-29 2487 1,330.00 11-30 2488 695.40 Total 612.00 Amount $575.50 826.40 974.80 940.00 398.00 800.00 $14,465.00 Cash Receipts Journal Date Amount 11-3 $ 1,211.60 11-7 990.10 11-12 2,575.00 11-17 1,472.70 11-20 2,954.00 11-24 2,567.30 11-27 1,650.00 11-29 1,186.00 11-30 1,554.00 Total 16,160.70 11-18 The bank statement contained two bank memoranda: 1. 2. A credit of $2,417.00 for the collection from a customer for Oriole Company of an electronic funds transfer. A debit for the printing of additional company checks $88.10. Using the steps in the reconciliation procedure, prepare a bank reconciliation at November 30, 2017. (List items that increase balance as per bank and books first.) ORIOLE COMPANY Bank Reconciliation $ Prepare the adjusting entries based on the reconciliation. (Note: The correction of any errors pertaining 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.) (Credit account titles are automatically indented when amount is entered. Do not indent manually.) Debit Credit Date Account Titles and Explanation Nov 30 (To record electronic funds transfer received by bank) Nov 30 To record charge for printing company checks) Nov 30 (To correct error in recording check) Nov 30 (To correct error in deposit)