Exercise 221 The cash balance per books for Crane Company on November 30, 2022, is $10,640.90. The following checks and receipts were recorded for the month of December 2022: No. 17 18 19 20 Checks Amount No. $351.87 22 600.64 23 159.00 24 589.52 25 236.17 Amount $580.86 1,689.52 923.32 248.05 Receipts Amount Date $845. 12/5 943.56 12/21 810.60 12/27 1,369.00 12/31 Balance In addition, the bank statement for the month of December is presented below: Balance Deposits and Credits Checks and Debits Last No. Total Amount No. Total Amount $5,406.86 5 $9,580,38 10 $3,634.21 Checks and other debits Deposits This statements $11,353.03 Date Balance No Amount No Amount No Amount 14 150,31 12 381.82 22 58086 5,486.40 12/1 18 609.64 24 923.32 845.35 12/8 19 159.00 25 248.05 943.56 12/23 236.17 17.00 SC 810.60 12/29 252.00 NS! 1,520.00 CM 12/31 Symbols: NSF (Not sufficient funds) SC (Service charge) CM (Credit Memo) $9.872.15 $9,221.05 $9,543.60 $10,103.03 $11,353.03 Check No. 15 was incorrectly written for $690.64 for a payment on account Check No. 14 was the only outstanding check at the end of November. There was also one deposit in transit at the end of November The NSF check was from S. Johnson, a customer, in settlement of an account receivable. An entry has not been made for the NSF check. The credit memo is for the collection of a note recevable including interest of $62.00 that has not been accrued. The bank service charge is $17.00 CES Prepare a bank reconciliation at December 31. (Enter answers to 2 decimal places, e.g. 25.20.) CRANE COMPANY Bank Reconciliation December 31, 2022 udy Cash Balance Per Bank Statement 11,353.03 Add Deposit in Transit 1,369.00 Less $ $ $ V A ( 4 ( ( LINK TO TEXT Prepare the adjusting journal entries required by the bank reconciliation. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. Foster answers to decimal places, ..25.20.) Date Account Titles and Explanation Debit Credit (To correct recording error) 31 (To record collection of note and interest) 31 (To record bank service charge for the month of December) 31 (To record NST ded) Click if you would like to show Work for this questions Open Show Work