Requirements 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018. 2. Journalize any required entries from the bank reconciliation. Print Done Additional data for the bank reconciliation follow. A (Click the icon to view the additional information.) The December cash records of Devin Insurance follow: E (Click the icon to view the checkbook.) Devin's Cash account shows a balance of $17,530 at December 31. On December 31, Devin Ins statement: (Click the icon to view the December bank statement.) i Data Table Requirement 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018 Data Table - X Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. 13,600 4,270 Cash Receipts Date Cash Debit Devin Insurance Bank Reconciliation December 31, 2018 Bank: Balance, December 31, 2018 ADD: Deposit in transit Dec. 4 $ 18885 9 4,270 510 500 2,150 14 Cash Payments Check No. Cash Credit 1416 $ $ 800 1417 210 1418 670 1419 690 1420 1,500 9,580 Bank Statement for December Beginning Balance S Deposits and other Credits: Dec. 1 EFT S 250 Dec 5 Dec. 10 510 Dec. 15 500 Dec 18 2,150 Dec 22 BC 1,900 Checks and other Debits: Dec. 8 NSF 1,000 Dec. 11 (check no. 1416) 800 Dec 19 EFT Dec 22 (check no. 1417) 210 Dec 29 (check no. 1418) 670 Dec. 31 (check no. 1419) 960 Dec 35 31 SC S Ending Balance 17 LESS: 31 1,830 1421 800 1422 660 620 Print Done More Info - X (4,295) 18,885 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 $960. Devin's controller mistakenly recorded the check for $690 Explanations: BC-bank collection, EFT-electronic funds transfer, NSF-nonsufficient funds checks; SC-service charge Print Done Print Done