(Click the icon to view the additional data for the bank reconciliation) The cash data of Donald Automotive for November 2016 follow (Click the icon to view the checkbook) Donald Automotive received the following bank statement on November 30, 2016 Click the icon to view the bank statement) Read the requirements Requirement 1. Prepare the Donald Automotive bank reconciliation at November 30, 2016. Prepare the Bank side of the bank reconciliation, then prepare the Book side of the bank reconciliation (include the balances at November 30 in each of the additionat not select a label or enter a zero ) Donald Automotive Bank Reconciliation November 30, 2016 Bank Add Subtotal Less Cash Account No. 101 Date Item Jrnl. Ref. Debit Credit Balance November 1 Balance 7,500 30 CR6 9,376 16,876 30 CP 11 9,380 7,496 Cash Receipts (CR) Cash Payments (CP) Date Cash Debit Check No. Cash Credit November 2 $ 2,949 3113 $ 1,465 8 544 3114 1,180 10 1,638 3115 1,730 16 862 3116 43 22 410 3117 844 29 869 3118 152 2,104 30 3119 438 $ 9,376 Total 3120 967 3121 199 2,362 3122 $ 9,380 Total Bank Statement for November 2016 Beginning balance $ 7,500 Deposits and other additions: November 1 $ 775 EFT 4 2,949 9 544 12 1,638 17 862 22 410 1,250 BC 23 8,428 Checks and other deductions: November 7 $ 1,465 13 1,370 14 419 US 15 1,180 18 43 21 308 EFT 26 844 30 152 30 30 SC (5.811) $ 10.117 Ending balance Explanation: BC-bank collection of note receivable from customer, EFT - electronic funds transfer. US - unauthorized signature, SC -service charge