The bank portion of the bank reconciliation for Coronado Company at November 30, 2022, was as follows. Cash balance per bank Add: Deposits in transit Less: Outstanding checks Check Number 3451 3470 3471 3472 Coronado Company Bank Reconciliation November 30, 2022 3474 Check Amount $2,260.40 720.10 844.50 1,426.80 1,056.00 $14,717.90 2,530.20 17,248.10 6,307.80Adjusted cash balance per bank The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December bank statement showed the following checks and deposits. Date 12-1 12-2 12-7 12-4 12-8 Checks Number 3451 3471 3472 3475 3476 Bank Statement Amount $2,260.40 844.50 1,426.80 1,640.70 1,300.00 Date 12-1 12-4 12-8 12-16 $10,940.30 12-21 Deposits Amount $ 2,530.20 1,211.60 2,365.1 2,672.70 2,945.0012-10 12-15 12-27 12-30 12-29 12-31 Date 12-1 12-2 12-2 3477 12-4 3479 3480 3482 3483 3485 Total Number 3475 3476 3477 2,130.00 3478 3,080.00 600.00 475.50 1,140.00 540.80 The cash records per books for December showed the following. $15,438.70 12-26 Amount 12-29 12-30 Total Cash Payments Journal 2,130.00 Date $1,640.70 12-20 1,300.00 12-22 12-23 2,567.30 621.30 12-24 2,836.00 1,025.00 $18,152.90 Number 3482 3483 3484 3485 Amount $475.50 1,140.00 792.00 450.80 Cash Receipts Journal Date 12-3 12-7 12-15 12-20 Amount $1,211.60 2,365.1 2,672.70 2,954.0012-8 12-10 12-17 1. 3479 2. 3480 3481 3,080.00 12-30 600.00 807.40 The bank statement contained two memoranda: Total 3486 889.50 $13,927.20 12-25 12-28 12-30 12-31 Total 2,567.30 2,836.00 1,025.00 1,690.40 $17,322.10 A credit of $2,300 for the collection of an accounts receivable of Coronado Company through an electronic funds transfer. A debit for the printing of additional company checks $91. At December 31, the cash balance per books was $14,335.20, and the cash balance per the bank statement was $19,641.10. The bank did not make any errors, but Coronado Company made two errors.Prepare a bank reconciliation at December 31, 2022. (Round answers to 2 decimal places, e.g. 52.75. List items that increase cash balance first. Reconcile cash balance per bank first.) CORONADO COMPANY Bank Reconciliation $ $$ $$Prepare the adjusting entries based on the reconciliation. (List all debit entries before credit entries. Credit account titles are automatically indented when amount is entered. Do not indent manually. Round answers to 2 decimal places, e.g. 52.75.) No. Account Titles and Explanation Dec. 31 Dec. 31 Dec. 31 (To record collection of electronic funds transfer by bank.) (To record bank service charge) (To correct error in recording check) Debit Credit TDec. 31 (To correct error in deposit)