The December cash records of Harvey Insurance follow: (Click the icon to view the checkbook.) Harvey's Cash account shows a balance of $17,160 at December 31. On December 31, Harvey Insurance received the following bank statement: (Click the icon to view the December bank statement.) Additional data for the bank reconciliation follow: (Click the icon to view the additional information.) Read the requirements. 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. 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. Journalize the collection of the note. Journalize the NSF check. Journalize the EFT payment. Data table Data table \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Cash Receipts } & \multicolumn{3}{|c|}{ Cash Payments } \\ \hline Date & Cash Debit & Check No. & & Credit \\ \hline Dec. 4$ & 4,270 & 1416 & $ & 860 \\ \hline 9 & 520 & 1417 & & 200 \\ \hline 14 & 570 & 1418 & & 650 \\ \hline 17 & 2,150 & 1419 & & 1,690 \\ \hline \multirow[t]{3}{*}{31} & 1,800 & 1420 & & 1,510 \\ \hline & & 1421 & & 1,000 \\ \hline & & 1422 & & 640 \\ \hline \end{tabular} 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 $1,900 bank collection was for a note receivable. d. The correct amount of check no. 1419 , for rent expense, is $1,960. Harvey's controller mistakenly recorded the check for $1,690. Print Done Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge Print Done