The December cash records of Devin Insurance follow: (Click the icon to view the checkbook.) Devin's Cash account shows a balance of $16,880 at December 31. On December 31. Devin Insurance received the following bank statement: (Click the icon to view the December bank statement) Additional data for the bank reconciliation follow: (Click the icon to view the additional information.) Read the requirements Requirement 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018. Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation. Devin Insurance Bank Reconciliation December 31, 2018 Bank: Balance December 31, 2018 18370 ADDI Deposit in transit LESS Outstanding checks 1420 1520 11421 1200 X Data table Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,260 1416 EA 870 9 530 170 580 1418 720 2.100 1419 790 31 1,830 1420 1.520 1421 1.200 1422 650 Print Done Bank Statement for December $ Beginning Balance 13,500 Deposits and other Credits: Dec 1 EFT $ 150 Dec 5 4,260 Dec 530 & 580 Dec 2.100 1.100 Dec 22- BC 8,720 Checks and other Debits. Dec 8 NSF 600 Dec 11 (check no. 1416) 870 Dec 19 EFT 475 Data table LE 122 U 20 Checks and other Debits: Dec. 8 NSF 600 Dec. 11 (check no. 1416) 870 Dec. 19 EFT 475 Dec. 22 (check no. 1417) 170 Dec. 29 (check no. 1418) 720 Dec. 31 (check no. 1419) 970 Dec. 31 SC (3.850) Ending Balance S 18,370 Explanations. BC-bank collection: EFT-electronic funds transfer: NSF-nonsufficient funds checks, SC-service charge More info 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,100 bank collection was for a note receivable d. The correct amount of check no 1419, for rent expense, is $970. Devin's controller mistakenly recorded the check for $790 The December cash records of Devin Insurance follow: 11 HULU 1421 1200 1422 650 3370 Adjusted bank balance, December 31, 2018 Books: ADD: LESS: Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits fi Begin with the EFT collection. Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, then credits. 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 Joumalize the NSF check. stert naar Joumalize the NSF check. Debit Credit Date Accounts and Explanation Dec. 31 Journalize the EFT payment Debit Credit Date Accounts and Explanation Dec. 31 Journalize the service charge. Debit Accounts and Explanation Date Credit Dec. 31 Journalize the entry to correct the error. Date Accounts and Explanation Debit Credit Dec. 31 Etext pages Calculator Type here to search