K The December cash records of Duffy Insurance follow: (Click the icon to view the checkbook.) Duffy's Cash account shows a balance of $17,110 at December 31. On December 31, Duffy Insurance received the following bank statement: (Click the icon to view the December bank statement 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. Bank: Balance, December 31, 2024 ADD: Deposit in transit Duffy Insurance Bank Reconciliation December 31, 2024 LESS: Outstanding checks Adjusted bank balance, December 31, 2024 Books: Balance, December 31, 2024 ADD: LESS: NSF check Service charge CID Data table Cash Receipts Date Cash Debit Dec. 4 $ 9 14 17 31 4,200 510 530 2,300 1,780 Print Cash Payments Check No. Cash Credit 1416 $ 1417 1418 1419 1420 1421 1422 Done 890 190 720 1,590 1,500 900 620 - X he checkbook.) 3 ck charge Data table Beginning Balance Deposits and other Credits: Dec. 1 Dec. 5 Dec. 10 Dec. Dec. 15 18 Dec. 22 Checks and other Debits: Dec. 8 Dec. Dec. Dec. Dec. Dec. 11 (check no. 1416) 19 22 (check no. 1417) 29 (check no. 1418) 31 (check no. 1419) Dec. 31 Print EFT $ BC NSF EFT SC Done 250 4,200 510 530 2,300 2,200 100 890 275 190 720 1,950 40 C 14,200 9,990 Additional data f (Click the icc X (4,165) -