***Please answer question #3-4 below:

Balance per bank statement $18,453.25 Additions by depositor not on bank statement: 9/30 Deposit in Transit 1,682.75 Deductions by depositor not on bank statement: #5893 Oustanding Check From 8/31 #5906 #5908 (494.25) (982.30) (388.00) Bank errors: Adjusted balance $18,271.45 Balance per books $17,404.20 Additions by bank not recorded by depositor: Note Collected by less a $15 Fee. Calculation: 1,500 - 15 Interest Eamed 1,485.00 12.50 Deductions by bank not recorded by depositor: 9/17 NSF Check Error (Check #5904) Calculation: 2,090 - 2,060 (600.25) (30.00) Depositor's errors: Adjusted balance $18,271.45 Difference between adjusted balances $0.00 3. Manipulate the Data. On a new tab that you create called October, copy over the bank reconciliation you just completed for September. Then erase the September data and use the worksheet to complete the following bank reconciliation for the October 31, 2018 bank reconciliation statement: $ 7,608 $ 7,950 ? Adjusted Balance Balance per bank Balance per books Checks outstanding Deposits in Transit Service Charges $ 547 ? 16 $ Compute the missing items using basic math principles. Save your work as 9 #4 o List at least two reasons why the discrepancy between book and bank balances may have existed at July 31? 1 2 1 3 4 2 5 6 7 8 9 List two reasons why the discrepancy may have existed at August 31? 0 1 1 2 2 3 4 July 31 Aug. 31 Sep. 30 Oct. 31 Nov. 30 Chart Data Table Book 7712.38 8046.99 $17,404.20 9996.61 7608.09 Bank 9080.25 7264.47 $18,453.25 11157.57 7950.88