The december cash records of Dunlap insurance follows:

The December cash records of Dunlap Insurance follow: Additional data for the bank EFA (Click the icon to view the checkbook.) (Click the icon to view th Dunlap's Cash account shows a balance of $16,560 at additional information.) December 31. On December 31, Dunlap Insurance received the following bank statement: (Click the icon to view the December bank statement.) Requirement 1. Prepare the bank reconciliation of Dunlap Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Data table Data table Data table Explanations: BC-bank collection: EFT-electronic funds transfer: NSF-nonsufficient funds checks; SC-service charge Data table Explanations: BC-bank collection: EFT-electronic funds transfer: NSF-nonsufficient funds checks; SC-service charge 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,950. Dunlap's controller mistakenly recorded the check for $1,590. Requirements 1. Prepare the bank reconciliation of Dunlap Insurance at December 31, 2024. 2. Journalize any required entries from the bank reconciliation