K Points: o of 3 Save The December cash records of Duffy Insurance follow (Click the icon to view the checkbook.) Duffy's Cash account shows a balance of $16,500 at December 31. On December 31, Duffy Insurance received the following bank statement BEE (Click the icon to view the December bank statement) Additional data for the bank reconciliation follow (Click the icon to view the additional Information.) Read the requirements Requirement 1. Prepare the bank reconciliation of Duffy Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Duffy Insurance Bank Reconciliation December 31, 2024 Bank: Help od K 2BA (open response) Part 1 of 8 HW Score: 0% 0 of 10 points O Points: 0 0 The December cash records of Duffy Insurance follow (Click the icon to view the checkbook.) Data Table Additional data for the bank (Click the icon to view count shows a balance of $16.500 at A information) - Data table X requirements Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,230 1416 $ 790 17 31 9447733 530 1417 210 14 550 1418 710 2,050 1419 1,090 1,850 1420 1,480 1421 1,400 1422 630 nber 31, 202- f the reconci ar all K The December cash records of Duffy Insurance follow (Click the icon to view the checkbook.) Dub's Cash account shase a balance of $16.500 Data table Bank Statement for December Beginning Balance Deposits and other Credits: Additional das for the (Cck the 13.600 -X Dec 1 EFT $ 500 Dec. 5 4,230 Dec. 10 530 Dec. 15 550 Dec. 18 2,050 Dec. 2,200 22 BC 10,060 Checks and other Debits: Dec 8 NSF 1,100 The 1, 2024 econcilia K The December cash records of Duffy Insurance follow (Click the icon to view the checkbook.) Duffy's Cash account shows a balance of $16,500 at December 31. On December 31, Duffy Insurance received the following bank statement Additional data for the back conton follow (Click the icon to view the additional information) Read the requirements More info a. The EFT credit was a receipt of rent. The EFT debit was an insurance payment b. The NSF check was received from a customer. c. The $2,200 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $1,900 Duffy's controller mistakenly recorded the check for $1,090. Print Done -X st K The December cash records of Duffy Insurance follow BEE (Click the icon to view the checkbook.) Duffy's Cash account shows a balance of $16.500 at Requirements Additional data for the bank reconcilia (Click the icon to view the addition information A 1. Prepare the bank reconciliation of Duffy Insurance at December 31, 2024. 2. Journalize any required entries from the bank reconciliation. ints Cancel Bank: Print Done DecembCT 91, 202Y 24 Ciliation