Answer all parts please !!

Question 2 On July 31, 2017, Widhorse Co, had a cash balance per books of $6,345.00. The statement from Dakota State Bank on that date showed a balance of $7,895.80. A comparison of the bank statement with the Cash account revealed the following facts 1. The bank service charge for July was $18.00. 2. The bank collected $1,620.00 for Wildhorse Co. through electronic funds transfer 3. The July 31 receipts of 1,300.30 were not included in the bank deposits for luly. These receipts were deposited by the company in a night deposit vault on July 31 4 Company check No. 2480 issued to L. Taylor, a creditor, for $374.00 that deared the bank in July was incorrectly entered in the cash payments journal on Juy 1o for $347.00. 5. Checks outstanding on July 31 totaled $1,951.10 6. On July 31, the bank statement showed an NSF charge of $675.00 for a check received by the company from w. Krueger, a custome, on account. Prepare the bank recondiliation as of July 31. (List items that increase balance as per Iank & books first.) WILDHORSE CO. Bank Reconciliation