The December cash records of Harry Insurance follow EEB(Click the icon to view the checkbook.) Harry's Cash account shows a balance of $17,780 at December 31. On December 31, Harry Insurance received the following bank statement: E(Click the icon to view the December bank statement.) Requirement 1. Prepare the bank reconciliation of Harry Insurance at December 31, 2018 Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation Harry Insurance Bank Reconciliation December 31, 2018 Bank: Balance, December 31, 2018 17780 Deposit in transit ADD: Outstanding checks LESS: Adjusted bank balance, December 31, 2018 Books: Balance, December 31, 2018 Books: Balance, December 31, 2018 EFT collection of rent ADD: Bank collection of note receivable NSF check LESS: EFT payment of insurance Service charge Correction of book error Adjusted book balance, December 31, 2018 i Data Table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,260 $ 1416 840 500 1417 190 690 14 530 1418 17 2,400 1419 790 1,830 31 1420 1,450 900 1421 1422 580 Print Done Data Table Bank Statement for December $ 13,700 Beginning Balance Deposits and other Credits: Dec EFT $ 150 1 Dec 5 4,260 Dec 10 500 Dec 15 530 Dec. 18 2,400 2,100 22 BC Dec. 9,940 Checks and other Debits: 1,100 Dec. 8 NSF 11 (check no. 1416) Dec. 840 Dec 19 EFT 620 Dec 22 (check no. 1417) 190 29 (check no. 1418) Dec 690 Dec 31 (check no. 1419) 970 10 (4,420) Dec 31 SC $ 19,220 Ending Balance Explanations: BC-bank collection; EFT-electronic funds transfer Print Done Begin with the EFT collection Date Accounts and Explanation Debit Credit Cash Dec. 31 Rent Revenue To record rent collection by EFT Journalize the collection of the note. Date Accounts and Explanation Debit Credit Cash Dec. 31 Notes Receivable Note receivable collected by bank. Journalize the NSF check. Accounts and Explanation Date Debit Credit Accounts Receivable Dec. 31 Cash NSF check returned by bank Journalize the EFT payment. Accounts and Explanation Date Debit Credit Insurance Expense Dec. 31 Cash Journalize the service charge Accounts and Explanation Date Debit Credit Bank Expense Dec. 31 Cash Journalize the entry to correct the error. Date Accounts and Explanation Debit Credit Rent Expense Dec. 31 Cash