on: 7 pts Data Table 1 Data Table er cash record icon to view account show k statement aloon to view $ 14,300 nt 1. Prepare the Cash Receipts Date Cash Debit Dec. 4$ 4,230 9 500 14 520 17 2.000 31 1.880 200 Cash Payments Check No. Cash Credit 1416 $ 860 1417 1418 870 1419 1,510 1421 1422 Bank Statement for December Beginning Balance Deposits and other Credits: Dec EFT $ 150 Dec. 4.230 Dec. 10 500 Dec. 15 520 Dec 18 2,000 1.900 bank portion of 790 1420 1.400 640 Dec 9,300 800 6 More Info 860 Checks and other Debits: Dec. Dec 11 (check no. 1416) Dec 19 Dec 22 (check no. 1417) Dec 29 (check no. 1418) Dec 31 (check no. 1410) Dec 31 930 200 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,000 bank collection was for a note receivable. d. The correct amount of check no. 1419, for rent expense, is 5070. Devin's controller mistakenly recorded the check for $790. 670 970 SC 20 (4,450) $ 19,150 Ending Balance Print Done Print Done se from any list or enter any number in the input fields and then continue to the next d mber 31, 2018 of the reconciliation Requirements 1. Prepare the bank reconciliation of Devin Insurance at December 31, 2018. 2. Journalize any required entries from the bank reconciliation. Print Done