The December cash records of Duffy Insurance follow: (Click the icon to view the checkbook.) Duffy's Cash account shows a balance of $17,620 at December 31. On December 31, Duffy Insurance received the following bank statement: | (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: ADD: LESS: Data table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,250 1416 $ 820 9 460 1417 210 14 570 1418 660 17 2,400 1419 680 31 1,820 1420 1,470 1421 1,000 1422 640 Print Done - - Data table Bank Statement for December - Beginning Balance $ 13,600 Deposits and other Credits: Dec. 1 EFT $ 100 Dec. 5 4,250 Dec. 10 460 Dec. 15 570 Dec. 18 2,400 1,600 Dec. 22 BC 9,380 Checks and other Debits: Dec. 8 NSF 700 Dec. 11 (check no. 1416) 820 Dec. 19 EFT 560 Dec. 22 (check no. 1417) 210 Dec. 29 (check no. 1418) 660 Dec. 31 (check no. 1419) 860 15 Dec. 31 SC (3,825) $ 19,155 Ending Balance Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge Print Done Requirements 1. Prepare the bank reconciliation of Duffy Insurance at December 31, 2024. 2. Journalize any required entries from the bank reconciliation. Print Done