Additional data for the bank reconciliation follow: A (Click the icon to view the additional information.) The December cash records of Dunlap Insurance follow: E: (Click the icon to view the checkbook.) Dunlap's Cash account shows a balance of $17,110 at December 31. On December 31, Dunlap Insurance received the following bank statement: (Click the icon to view the December bank statement.) Read the requirements. Requirement 1. Prepare the bank reconciliation of Dunlap Insurance at December 31, 2018. i Data Table Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Data Table Dunlap Insurance Bank Reconciliation December 31, 2018 $ 13,500 Bank: Cash Receipts Date Cash Debit Dec. 4 $ 4,200 500 ADD: LESS: 550 Cash Payments Check No. Cash Credit 1416 $ 890 1417 220 1418 640 1419 680 1420 1,450 1421 900 1422 610 1,950 1,800 Bank Statement for December Beginning Balance Deposits and other Credits: Dec. 1 EFT $ 150 Dec. 5 4,200 Dec. 500 Dec. 15 550 Dec. 18 1,950 Dec. 22 Checks and other Debits: Dec. 8 NSF 200 Dec. 11 (check no. 1416) 890 Dec. 19 EFT 1,000 Dec. 22 (check no. 1417) 220 Dec. 29 (check no. 1418) Dec. 31 (check no. 1419) 860 Dec. 31 SC 10 BC 1,900 9,250 | TIIMI Books: Print Done ADD: LESS: SC - (3,820) 18,930 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,900 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $860. Dunlap's controller mistakenly recorded the check for $680. Requirements 1. Prepare the bank reconciliation of Dunlap Insurance at December 31, 2018. 2. Journalize any required entries from the bank 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. 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