prepare bank reconciliation statment

The following information pertains to Bart Starr Sports, Inc. Cash balance per bank, July 31, $7,763 July service charge indicated on bank statement, $28 Cash balance per Bart Starr's general ledger, July 31, $9,284 Deposits in transit, July 31, $1,500 Note collected by the bank for Bart Starr Sports, $900, plus interest earned $36. Outstanding checks, July 31, $591 NSF check from the Philadelphia Eagles for $1,020 was indicated on the bank statement. A check written by Peyton Manning for $500 was incorrectly charged to Bart Starr's account by the bank