Data table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,230 1416 $ 800 9 450 1417 160 14 580 1418 640 17 2,200 1419 1,590 31 1,780 1420 1,440 1421 1,000 1422 660 Data table Bank Statement for December Beginning Balance $ 14,000 Deposits and other Credits: Dec. 1 EFT $ 300 Dec. 5 4,230 Dec. 10 450 Dec. 15 580 Dec. 18 2,200 Dec. 22 BC 2,100 9,860 Checks and other Debits: Dec. 8 NSF 200 Dec. 11 (check no. 1416) 800 Dec. 19 EFT 840 Dec. 22 (check no. 1417) 160 Dec. 29 (check no. 1418) 640 Dec. 31 (check no. 1419) 1,950 25 (4,615) Dec. 31 SC $ 19,245 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 $2,100 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $1,950. Harvey's controller mistakenly recorded the check for $1,590. 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. Harvey Insurance Bank: Balance, December 31, 2024 ADD: Deposit in transit LESS: Outstanding checks Bank Reconciliation December 31, 2024 Adjusted bank balance, December 31, 2024 Books: Balance, December 31, 2024 ADD: EFT collection of rent Bank collection of note receivable LESS: NSF check EFT collection of rent Service charge Correction of book error Adjusted book balance, December 31, 2024 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 Cash Rent Revenue Accounts and Explanation To record rent collection by EFT. Debit Credit Journalize the collection of the note. Date Accounts and Explanation Debit Credit Dec. 31 Cash Notes Receivable Note receivable collected by bank. Journalize the NSF check. Date Accounts and Explanation Debit Credit Dec. 31 Accounts Receivable Cash NSF check returned by bank. Journalize the EFT payment. Date Accounts and Explanation Debit Credit Dec. 31 Insurance Expense Cash To record payment of insurance bill by EFT. Journalize the service charge. Date Accounts and Explanation Debit Credit Dec. 31 Bank Expense Cash To record bank service charges incurred. Journalize the entry to correct the error. Date Accounts and Explanation Debit Credit Dec. 31 Rent Expense Cash To record error on check 1419.