The December cash records of Duffy Insurance follow: B (Click the icon to view the checkbook.) Duffy's Cash account shows a balance of $17,080 at December 31. On December 31, Duffy Insurance received the following bank statement: E: (Click the icon to view the December bank statement.) 0 Data Table * Requirements 1. Prepare the bank reconciliation of Duffy Insurance at December 31, 2018. 2. Journalize any required entries from the bank reconciliation. 13,600 Bank Statement for December Beginning Balance $ Deposits and other Credits: Dec. 1 EFT $ 300 Dec. 5 4,220 Print Done Dec. 460 i Data Table Dec. 590 2,400 BC 1,100 9,070 Cash Receipts Date Cash Debit NSF Dec. 4 $ Dec. 18 Dec. 22 Checks and other Debits: Dec. Dec. 11 (check no. 1416) Dec. 19 Dec. 22 (check no. 1417) Dec. 29 (check no. 1418) Dec. 31 (check no. 1419) Dec. 31 4,220 460 EFT 800 840 930 160 690 1,900 590 Cash Payments Check No. Cash Credit 1416 $ 840 1417 160 1418 690 1419 1,090 1420 1,470 1421 1,100 1422 680 2,400 1,840 (5,335) SC_ 15 17,335 Ending Balance Print Done Requirement 1. Prepare the bank reconciliation of Duffy Insurance at December 31, 2018. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Duffy Insurance Bank Reconciliation December 31, 2018 Bank: ADD: LESS: Books: ADD: Dall, ADD: LESS: Books: ADD: LESS: Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, then credits. Select the explanation 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 Jourhalize 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