The December cash records of Dunlap Insurance follow HE (Click the icon to view the checkbook.) Dunlap's Cash account shows a balance of $15,000 at December 31. On December 31, Dunia Insurance received the following bank statement (Click the icon to view the December bank statement) Additional data for the bank reconciliation flow. (Click the icon to view the additional information) Read the wirements More Info Requirement 1. Prepare the bank reconciliation of Dunia Insurance at December 31, 2024. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation Dunlap Insurance Bank Reconciliation December 31, 2024 Bank: 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.500 bank collection was for a note receivable d. The correct amount of check no 1419. for rent expense, is 31,940. Dunia's controller mistakenly recorded the check for $1,450. ADO Done LESS: The December cash records of Dunlap Insurance follow (Click the icon to view the checkbook) Dunlop's Cash account shows a balance of $15,960 at December 31. On December 31, Dunlap Insurance received the following bank statement Click the icon to view the December bank statement) Additional data for the bank reconciliation folow. (Click the icon to view the additional information) Read the requirements Data Table 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 Dunlap Insurance Bank Reconciliation December 31, 2024 Bank: Cash Receipts Cash Payments Date Cash Debit Check No Cash Credit Dec. 45 4.250 1416 $ 840 9 470 1417 210 14 560 700 17 2.000 1419 1,490 31 1.800 1420 1.520 1.200 ADD LESS 1422 660 Print Done i Data Table The December cash records of Dunlap Insurance follow: (Click the icon to view the checkbook) Dunlap's Cash account shows a balance of $15,960 at December 31. on December 31, Dunlap Insurance received the following bank statement: (Click the icon to view the December bank statement) 13.500 Bank Statement for December Beginning Balance $ Deposits and other Credits: Dec 1 EFT S 400 Dec 5 4.250 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 Dunlap Insurance Bank Reconciliation Dec. 470 10 15 Doc December 31, 2024 Dec 18 560 2,000 1,500 Bank: Dec 22 BC 9,180 ADD: NSF 1,100 840 LESS Checks and other Debits: Dec 8 Dec. 11 (check no. 1416) Dec 19 Dec 22 (check no. 1417) Dec 29 (check no. 1418) Dec 31 (check no. 1419) 210 700 1.900 25 Dec 31 SC (5.745 $ 16.935 Finn Ral The December cash records of Dunlap Insurance follow: (Click the loan to view the checkbook) Durtap's Cash account shows a balance of $15,960 at December 31. on December 31, Dunlap insurance received the following bank statement: (Click the icon to view the December bank statement) Dec 1 EFT S 400 Dec 5 4,250 Dec 10 470 560 Dec 15 Dec 18 2.000 1,500 Dec 22 BC 9.180 Requirement 1. Prepare the bank reconciliation of Dunlap Insurance at December 31, 2024. Prepare the bark portion of the reconciliation, followed by the book portion of the reconciliation Dunlap Insurance Bank Reconciliation December 31, 2024 Bank NSF 1,100 140 900 EFT Checks and other Debits: Dec 8 Dec 11 (check no. 1416) Dec 19 Dec 22 (check no. 1417) Dec 29 check no. 1418) Dec 31 (check no. 1419) Dec 31 210 ADO 700 LESS SC (5.745) 16,935 $ Ending Balance Explanations: BC-bank collection EFT-electronic funds transfer NSF consuficient and checks SC-service charge