The December cash records of Duffy Insurance follow (Click the icon to view the chackbook) Duffy's Cash account shows a balance of $17,210 at December 31. On December 31, Duffy Insurance received the following bank statement (Click the icon to view the December bank statement) Additional data for the bank reconcilation follow (Click the icon to view the additional information) Read the kemente Requirement 1. Prepare the bank reconcilation of Duffy Insurance at December 31, 2018. Prepare the bank portion of the reconciliation, followed by the book portion of the reconcilation. Dutty Insurance Bank Reconciliation December 31, 2018 Requirements 1. Prepare the bank reconciliation of Duffy Insurance at December 31, 2018. 2. Journalize any required entries from the bank reconciliation. Bank: ADD LESS Data table Cash Receipts Cash Payments Date Dec. 4 $ 9 Cash Debit 4220 1416 $ 450 1417 Check No. Cash Credit 800 190 14 530 1418 770 17 2200 1419 580 31 1,780 1420 1,440 1421 1,400 1422 540 Print Done More info Print Done The EFT credit was a receipt of rent. The EFT debit was an insurance payment b. The NSF check was received from a customer The $2,000 bank collection was for a note receivable. d. The correct amount of chock no. 1419, for rent expense, is 5060. Duffy's controller mistakenly recorded the check for $650 Print Done Data table Bank Statement for December Beginning Balance Deposits and other Credits 13,900 DOC 1 EFT S De: 5 150 4,220 Doc. 10 450 Dec 15 530 Dec. 18 2,200 Dec. 22 BC 2,000 9,550 Chacks and other Di Dec. 8 NSF 100 Dec 11 (check no. 1416) 800 Dec. 19 EFT 700 Dec 22 (check no. 1417) 190 Dec 29 (check no. 1418) 720 Doc. 31 (check no. 1419) 850 10 Doc 31 SC (3,380) 20,070 Ending Balance Explanations BC-bank collection, EFT-electronic funds transfer, NSF-consulent funds checks, SC-rvice dige Print Done