There are no more data sheet and requirements.

Requirements - X 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018 2. Journalize any required entries from the bank reconciliation Print Done Data Table -X Cash Receipts Date Cash Debit Dec. 4 $ 4,140 9 500 14 580 17 2,050 31 1,840 Cash Payments Check Cash No. Credit 1416 $ 850 1417 120 1418 680 1419 1,290 1420 1,450 1421 1,700 1422 590 Print Done Data Table -X 13,900 BC_2,200 9,720 Bank Statement for December Beginning Balance $ Deposits and other Credits: Dec. 1 EFT $ 250 Dec. 5 4,140 Dec. 10 500 Dec. 15 580 Dec. 18 2,050 Dec. 22 Checks and other Debits: Dec. 8 NSF 1,100 Dec. 11 check no. 1416) 850 Dec. 19 EFT 275 Dec. 22 (check no. 1417) 120 Dec. 29 (check no. 1418) 680 (check no. Dec. 31 1419) 1,920 Dec. 31 SC 25 Ending Balance (4,970) 18,650 Explanations: BC-bank collection; EFT-electronic funds transfer NSF-nonsufficient funds checks; SC-service charge Print Done More Info - X 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 $2,200 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is $1,920. Devin's controller mistakenly recorded the check for $1,290. Print Done 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: ADD: LESS: Books: ADD: LESS: Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Begin with the EFT collection. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the collection of the note. Accounts and Explanation Debit Credit Date Dec. 31 Journalize the NSF check. Date Accounts and Explanation Debit Credit Dec. 31 Journalize the EFT payment. Date Accounts and Explanation Dec. 31 Debit Credit Journalize the service charge. Accounts and Explanation Debit Credit Date Dec. 31 Journalize the entry to correct the error. Date Accounts and Explanation Debit Credit Dec. 31 Devin Insurance Bank Reconciliation December 31, 2018 Bank: Adjusted bank balance, December 31, 2018 Adjusted book balance, December 31, 2018 Balance, December 31, 2018 ADD LESS: Bank collection of note receivable Correction of bank error Correction of book error Deposit in transit EFT collection of rent EFT payment of insurance Books: NSF check Outstanding checks ADD: Service charge LESS: 1416 Books: 1417 1418 1419 ADD: 1420 1421 1422 LESS: Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, then credits. Select the explanation on Begin with the EFT collection. Date Accounts and Explanation Debit Credit Dec. 31 Accounts Receivable Bank Expense Cash Insurance Expense Notes Receivable Rent Expense Rent Revenue Journalize Date Debit Credit Dec. 31 Requirement 2. Journalize any required entries from the bank reconciliation. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Begin with the EFT collection. Accounts and Explanation Debit Credit Date Dec. 31 Debit Credit Journalize Note receivable collected by bank. Date NSF check returned by bank. Dec. 31 To record account receivable collected by bank. To record bank service charges incurred. To record error on check 1419. To record payment of insurance bill by EFT. To record rent collection by EFT