Additional data for the bank reconciliation follow: (Click the icon to view the additional information.) The December cash records of Donald Insurance follow: (Click the icon to view the checkbook.) Donald's Cash account shows a balance of $16,800 at December 31. On December 31, Donald Insurance received the following bank statement: (Click the icon to view the December bank statement.) Read the requirements. Data Table Requirement 1. Prepare the bank reconciliation of Donald Insurance at December 31, 2018. i Data Table - X Prepare the bank portion of the reconciliation, followed by the book portion of the reconciliation $ 14,000 Donald Insurance Bank Reconciliation December 31, 2018 Bank: 4,200 Cash Receipts Date Cash Debit Dec. 45 4,200 510 520 2,400 1,870 Cash Payments Check No. Cash Credit 1416 5 800 1417 140 1418 700 1419 1,590 1420 1,520 1421 1,300 510 ADD: Bank Statement for December Beginning Balance Deposits and other Credits: Dec. 1 EFT S 250 Dec. 5 Dec. 10 Dec. 15 520 Dec. 18 2,400 Dec. 22 BC_ 1,500 Checks and other Debits: Dec. 8 800 Dec. 11 (check no. 1416) LESS: 9,380 1422 650 NSF 800 Print Done Dec. 19 EFT Books: Dec 140 700 1,950 i More Info 22 (check no. 1417) Dec. 29 (check no. 1418) Dec. 31 (check no. 1419) Dec. 31 Ending Balance ADD: SC_ 30 (4.980) 18,400 $ LESS: 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,500 bank collection was for a note receivable. The correct amount of check no. 1419, for rent expense, is $1,950. Donald's controller mistakenly recorded the check for $1,590. Explanations: BC-bank collection; EFT-electronic funds transfer; NSF-nonsufficient funds checks; SC-service charge Print Done Print Done Choose from any list or enter any number in the input fields and then continue to the next