Using the following information, prepare a bank reconciliation for Sheridan Company for July 31, 2022. a. The bank statement balance is $3,520. b. The cash account balance is $3,960. C. Outstanding checks totaled $1,270. d. Deposits in transit are $1,650. e. The bank service charge is $51. f. A check for $87 for supplies was recorded as $78 in the ledger. Sheridan Company Bank Reconciliation July 31, 2022 Cash Balance Per Bank Add Deposit in Transit Less Outstanding Checks Adjusted Cash Balance Per Bank Cash Balance Per Books Less Check for Supplies Error Bank Service Charge Adjusted Cash Balance Per Books $ 3,520 1,650 5170 3,960