el Data table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,210 1416 $ 840 9 460 1417 160 14 540 1418 680 17 2,350 1419 1,290 31 1,870 1420 1,470 1421 900 1422 680 Print Done Data table Bank Statement for December Beginning Balance Deposits and other Credits: $ 14,000 ed Dec. 1 EFT S 600 Dec. 5 4,210 Dec. 10 460 Dec. 15 Dec. 18 540 2,350 2,200 Dec. 22 BC 10,360 Checks and other Debits: Dec 8 NSF 100 Dec. 840 11 (check no. 1416) 19 Dec. EFT 375 Dec. 160 Dec. 680 22 (check no. 1417) 29 (check no. 1418) 31 (check no. 1419) 31 Dec. . 1.920 15 Dec. SC (4,090) Ending Balance 20,270 Explanations: BC-bank collection: EFT-electronic funds transfer; Print Done Requirements 1. Prepare the bank reconciliation of Harvey Insurance at December 31, 2024. 2. Journalize any required entries from the bank reconciliation. Print Done More info X 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,920. Harvey's controller mistakenly recorded the check for $1,290. Print Done Bank Reconciliation December 31, 2024 Bank: ADD: LESS: Books: ADD: LESS: Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, ther Begin with the EFT collection. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the collection of the note. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the NSF check. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the EFT payment. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the service charge. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the entry to correct the error. Date Accounts and Explanation Debit Credit Dec. 31 The December cash records of Harvey Insurance follow: (Click the icon to view the checkbook.) Harvey's Cash account shows a balance of $17,410 at December 31. On December 31, Harvey Insurance received the following bank statement: BE! (Click the icon to view the December bank statement.) Requirement 1. Prepare the bank reconciliation of Harvey Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation