On July 31, 2017. Crane Company had a cash balance per books of $6,245.00. The statement from Dakota State Bank on that date showed a balance of $7.795.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $16.00. 2. The bank collected $1,625.00 for Crane Company through electronic funds transfer. 3. The July 31 receipts of $1,307.30 were not included in the bank deposits for July. 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 $384.00 that cleared the bank in July was incorrectly entered in the cash payments record on July 10 for $348.00. 5. Checks outstanding on July 31 totaled $1.965.10. 6. On July 31, the bank statement showed an NSF charge of $680.00 for a check received by the company from W. Krueger a customer, on account. Your answer is correct. Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.) CRANE COMPANY Bank Reconciliation July 21, 2017 7795.80 Cash balance per bank statement Add Deposits in transit 1307.30 910310 Less : Outstanding chadas 1965.10 i Adjusted cash balance per benk 7138.00 Cash balance per books 6245.00 Add : Electronic funds transfer received 1625.00 7870.00 Bank service charge 16.00 3600 i i Error in recording check No. 2480 NSF check BADOO 722.00 i 7138.00 Adjusted cash balance per books + $ 6245.00 Cash balance per books Add 4: Electronic funds transfer received 1625.00 767000 Bark service charpe $ 16.00 Error in recording check No. 2480 3600 i NSF check 690.00 i 732.00 i Adjusted cash balance per books 7138.00 e Textbook and Media List of Accounts Attempts: 2 of 3 used - Your answer is partially correct. Prepare a tabular analysis for the necessary adjustments at July 31. Include margin explanations for the changes in revenues and expenses. (If a transaction results in a decrease in Assets, Liabilities or Stockholders' Equity place a negative sign (or parentheses) in front of the amount entered for the particular Asset, Liability or Equity item that was reduced. Round answers to 2 decimal places, eg. 52.75.) Assets Stockholders' Equity Liabilities Accts Acets. Cash Pay. e Textbook and Media List of Accounts