Cash Receipts Cash Payments Date Cash Debit Check No. Cash Credit Dec. 4 $ 4,210 1416 $ 790 470 1417 140 570 1418 2,400 1419 690 1,090 1,500 1,700 1,800 1420 1421 1422 650 Bank Statement for December $ 13,700 Beginning Balance Deposits and other Credits: Dec. EFT $ 100 4,210 Dec. Dec 470 Dec. 570 2,400 Dec. 18 BC_2,100 9,850 Dec. Checks and other Debits: BC 2,100 9,850 Dec. 22 Checks and other Debits. Dec. NSF 1,000 8 11 (check no. 1416) Dec. 790 Dec. 19 EFT 375 Dec. 140 Dec. 22 (check no. 1417) 29 (check no. 1418) 31 (check no. 1419) 690 Dec. 900 20 Dec. SC (4,915) 31 18,635 Ending Balance Explanations: BC-bank collection; EFT-electronic funds transfer, NSF-nonsufficient funds checks; SC-service charge 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,100 bank collection was for a note receivable. d. The correct amount of check number 1419, for rent expense, is $1,900. Devin's controller mistakenly recorded the check for $1,090. 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2016. 2. Journalize any required entries from the bank reconciliation. Additional data for the bank reconciliation follow (Click the icon to view the additional information.) The December cash records of Devin Insurance follow (Click the icon to view the checkbook.) Devin's Cash account shows a balance of $16,590 at December 31 On December 31, Devin Insurance received the following bank statement: !!(Click the icon to view the December bank statement) Read the requirements Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation Devin Insurance Bank Reconciliation December 31, 2016 Bank: ADD: ADD: LESS