Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,260 1416 $ 820 9 500 1417 160 14 520 1418 720 17 2,300 1419 1,290 31 1,840 1420 1,520 1421 1,300 1422 640 Bank Statement for December Beginning Balance $ 13,700 Deposits and other Credits: Dec. 1 EFT $ 550 Dec. 5 4,260 Dec. 10 500 Dec. 15 520 Dec. 18 2,300 1,800 Dec. 22 BC 9,930 Checks and other Debits: Dec. 8 NSF 200 Dec. 11 (check no. 1416) 820 Dec. 19 EFT 275 Dec. 22 (check no. 1417) 160 Dec. 22 (check no. 1417) 160 Dec. 29 (check no. 1418) 720 Dec. 31 (check no. 1419) 1,920 25 Dec. 31 SC (4,120) $ 19,510 Ending Balance Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge 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 $1,800 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $1,920. Harry's controller mistakenly recorded the check for $1,290. 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. Harry Insurance Bank Reconciliation December 31, 2024 Bank: ADD: LESS: Books: ADD: LESS: Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Begin with the EFT collection. Date Dec. 31 Accounts and Explanation Journalize the collection of the note. Date Dec. 31 Debit Credit Accounts and Explanation Debit Credit Journalize the NSF check. Date Dec. 31 Accounts and Explanation Debit Credit Journalize the EFT payment. Date Dec. 31 Accounts and Explanation Debit Credit Journalize the service charge. Date Dec. 31 Accounts and Explanation Debit Credit Journalize the entry to correct the error. Date Dec. 31 Accounts and Explanation Debit Credit