Prepare a tabular analysis for the adjustments required to reach the adjusted cash balance per books. 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.)

Mary Sells is unable to reconcile the bank balance at January 31. Mary's reconciliation is shown as follows. $3,687.20 Cash balance per bank Add: NSF check 460.00 33.00 Less: Bank service charge Adjusted balance per bank $4,114.20 $3,985.20 Cash balance per books Less: Deposits in transit 585.00 Add: Outstanding checks 780.00 Adjusted balance per books $4,180.20 What is the proper adjusted cash balance per bank? Proper adjusted cash balance per bank $ What is the proper adjusted cash balance per books? Proper adjusted cash balance per books $ Prepare a tabular analysis for the adjustments required to reach the adjusted cash balance per books. 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.) Assets Liabilities Accts. Rec. Cash Rev. Stockholders' Equity Rev. Exp. Sales revenue Opening cash balance Bank charge expense Cash over and short