Prepare the bank reconciliation for problem A.

The bank portion of the bank reconciliation for Sunland Company at October 31, 2022, is shown below. SUNLAND COMPANY Bank Reconciliation October 31, 2022 Cash balance per bank Add: Deposits in transit $12,647.90 1,530,20 14,178.10 Less: Outstanding checks Check Number Check Amount $ 1.260.40 684.20 2451 2470 2471 2472 844.50 427.80 2474 1,050.00 4,266.90 $9.911.20 Adjusted cash balance per bank 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 Date 11-1 11-2 11-5 11-4 11-8 11-10 2470 2471 2474 2475 2476 2477 2479 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.432.00 1,750.00 11-21 2.945.00 1.330.00 11-25 2,567.30 695.40 11-28 1.650.00 89.25 11-30 1.186.00 18.559.90 575.50 Total 940.00 $13,029.55 11-15 11-18 2480 2481 SC 11-27 11-28 11-30 11-29 2483 2486 Total The cash records per books for November showed the following. Cash Payments Journal Date Number 2475 Amount 11-1 Number 2483 11-2 2476 2484 Date 11-20 11-22 11-23 11-24 11-29 2477 11-2 11-4 Amount $1,640.70 2,830.00 600.00 538.20 1,705.00 1,330.00 695.40 612.00 2478 2479 2485 2486 2487 $575.50 825.25 974.80 940.00 398.00 800.00 $14,464.85 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,584.00 Total 16,190.70 11-8 11-10 11-30 2480 2481 2488 11-15 Total 11-18 2482 The bank statement contained two bank memoranda: 1. Acredit of $2.432.00 for the collection from a customer for Sunland Company of an electronic funds transfer. A debit for the printing of additional company checks $89.25. 2. At November 30, the cash balance per books was $11.756.60 and the cash balance per bank statement was $18.297.80. The bank did not make any errors, but Sunland Company made two errors. ta) Using the steps in the reconciliation procedure, prepare a bank reconciliation at November 30, 2022 (lise items that increase balonces per how and boks forst. Renswers to 2 decimal places $.275. 50 SUNLAND COMPANY Bank Reconcist on VA $ : $ : $