Exercise 5-9 This information relates to the Cash account for Crane Company. Balance September 1-$17,380; Cash deposited-$64,000 Balance September 30-$18,580; Checks written-$62,800 The September bank statement shows a balance of $17,480 at September 30 and the following memoranda. Debits Credits $840 Collection of electronic funds transfer $2,110 NSF check: H. Kane Interest earned on checking account Safety deposit box rent 85 70 At September 30, deposits in transit were $5,043 and outstanding checks totaled $2,688 Prepare the bank reconciliation at September 30, 2017. (List items that increase balance as per bank & books first.) CRANE COMPANY Bank Reconciliation I Prepare a tabular analysis for the adjustments at September 30, assuming the NSF check was from a customer on account. Include margin explanations for the changes in revenues and expenses. (r a transactien results in a decrease in Assets, Liabilities or Stockholders' Equity, place a negative sign (er parentheses) in frent of the amount entered for the particular Asset, Liability or Equity item that was reduced.) cterkhaldere Eault t iabititieg Acrete Prepare a tabular analysis for the adjustments at September 30, assuming the NSF check was from a customer on account. Include margin explanations for the changes revenues and expenses. (If a transaction results in a decrease in Assets, Liabilities or Stockholders' Equity, place a negative sign (or parentheses) in front the amount entered for the particular Asset, Liability or Equity item that was reduced.) Assets Liabilities + Stockholders' Equity Accts. Cash Rec. Rev. Exp. Sept. 30 30 30 I 30 Click if you would like to Show Work for this question: Open Show Work