Requirement 1. Prepare the bank reconciliation of Donald Insurance at December 31, 2018 Donald Insurance Bank Reconciliation December 31, 2018 Bank: Balance, December 31, 2018 $ 19,705 1,800 ADD: Deposit in transit 21,505 LESS: Outstanding checks 1420 $ 1421 1,480 900 610 1422 2,990 $ 18,515 Adjusted bank balance, December 31, 2018 Books: Balance, December 31, 2018 ADD: EFT collection of rent Bank collection of note receivable $ 100 1,300 LESS: NSF check EFT payment of insurance Service charge Correction of book error Adjusted book balance, December 31, 2018 A Data Table - X * Data Table Bank Statement for December $ 14,400 EFT $ 100 4,260 480 540 2,000 Cash Receipts Date Cash Debit Dec. 4 $ 4,260 480 540 2,000 311,800 Cash Payments Check No. Cash Credit 1416 $ 790 1417 150 1418 640 1419 680 1420 1,480 1421 1422 610 900 BC 1,300 8,680 Beginning Balance Deposits and other Credits: Dec. 1 Dec. 5 Dec. Dec. 15 Dec. 18 Dec. 22 Checks and other Debits: Dec. 8 Dec. 11 (check no. 1416) Dec. 19 Dec 22 (check no. 1417) Dec. 29 (check no. 1418) Dec. 31 (check no. 1419) Dec. 31 Ending Balance NSF 200 Print Done EFT 700 150 640 SC_ 35 (3,375) 19,705 Explanations: BC-bank collection, EFT-electronic funds transfer, NSF-nonsufficient funds checks; SC-service charge