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