P7-27A (similar to) Question Help 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,310 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 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 Choose from any list or enter any number in the input fields and then click Check Answer. 7 parts Clear All Check Answer remaining Read the requirements Data Table -X December 31, 2018 x Data Table on of the reconciliation. 13,700 Cash Receipts Date Cash Debit Bank Statement for December Beginning Balance $ Deposits and other Credits: Dec. 1 EFT $ 100 Dec. 5 4,230 Cash Payments Check No. Cash Credit More Info Dec. 4 $ 4,230 1416 $ 790 9 460 1417 190 Dec. 10 460 14 500 1418 670 Dec. 500 15 18 17 2,200 1419 1,490 Dec. 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 no. 1419, for rent expense, is $1,940. Devin's controller mistakenly recorded the check for $1,490. 2,200 2.100 31 1,790 1420 1,520 Dec. 22 BC 9,590 1421 1,300 1422 610 NSF 200 Checks and other Debits: Dec. 8 Dec. 11 (check no. 1416) Dec. 19 Print Done 790 Print Done EFT 1,000 Dec. 190 Dec. 22 (check no. 1417) 29 (check no. 1418) 31 (check no. 1419) 670 Requirements Dec. - X 1,940 20 Dec. 31 SC (4,810) $ 18,480 Ending Balance 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018. 2. Journalize any required entries from the bank reconciliation Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge Print Done n click Check Answer. Print Done