Requirement 1. Prepare the Donald Automotive bank reconciliation at June 30, 2021. Prepare the Bank side of the bank reconciliation, then prepare the Book side of the bank reconciliation (include the bala Donald Automotivo Bank Reconciliation June 30, 2021 Bank: Add: Subtotal Less: Check No. Conciliation. (Include the balances at June 30 in each of the addition subtotal calculations. If an input field is not used in the table, leave the Data table - X $ Bank Statement for June 2021 Beginning balance 7,950 Deposits and other additions: June 1 $ 800 EFT 4 2,763 9 590 12 1,688 17 850 22 413 23 1,225 BC 8,329 Checks and other deductions: June 7 $ 1,513 13 1,380 14 455 US 15 1,329 18 39 21 307 EFT 26 820 30 125 30 25 SC (5.993) Ending balance $ 10,286 Explanation: BC-bank collection of note receivable from customer, EFT-electronic funds transfer, US - unauthorized signature, SC -service charge $ Print Done SUDU calculations. If an input fie Data table - X Cash Account No. 101 Jrnl. Ref. Debit Credit Date Item June 11 Balance 30 30 CR 6 CP 11 Balance 7,950 17,447 7,701 9,497 9,746 Cash Receipts (CR) Date Cash Debit June 2 $ 2,763 8 590 10 1.688 16 850 22 413 29 878 30 2,315 Total $ 9,497 Cash Payments (CP) Check No. Cash Credit 3113 $ 1,513 3114 1,329 3115 1,830 3116 39 3117 820 3118 125 3119 538 3120 3121 1.046 205 2.301 3122 Total $ 9,746 Print Done