Additional data for the bank reconciliation follow: (Click the icon to view the additional information.) The December cash records of Harry Insurance follow: (Click the icon to view the checkbook.) Harry's Cash account shows a balance of $17,090 at December 31. On December 31, Harry Insurance received the following bank statement: (Click the icon to view the December bank statement.) Read the requirements. - X Data Table Requirement 1. Prepare the bank reconciliation of Harry Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Cash Receipts Cash Payments Harry Insurance Date Cash Debit Check No. Cash Credit Bank Reconciliation Dec. 4 $ 4,200 1416 $ 790 December 31, 2024 9 490 1417 200 Bank: 14 500 1418 660 17 2,000 1419 790 ADD: 31 1,830 1420 1,430 1421 1,700 LESS: 1422 660 Print Done 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,100 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $970. Harry's controller mistakenly recorded the check for $790. Print Done - Data Table 14,300 Bank Statement for December Beginning Balance $ Deposits and other Credits: Dec 1 EFT $ 100 Dec. 5 4,200 Dec. 10 490 Dec. 15 500 Dec. 18 2,000 2,100 BC 9,390 Dec. 22 Checks and other Debits: Dec. 8 NSF 200 Dec. 790 Dec. 11 (check no. 1416) 19 22 (check no. 1417) EFT 930 Dec. 200 nn Lebenlens 1410 can Data Table 2,000 BC_2,100 9,390 Dec. 18 Dec. 22 Checks and other Debits: Dec. 8 Dec 11 (check no. 1416) Dec. 19 NSF 200 790 EFT 930 200 660 Dec. 22 (check no. 1417) Dec. 29 (check no. 1418) Dec. 31 (check no. 1419) Dec. 31 Ending Balance 970 SC 20 (3,770) $ 19,920 Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge