Prepare bank reconciliation statement

Question 29 15 pts 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. Using the Excel template for question number 29 that you downloaded prior to starting this exam, prepare a bank reconciliation for Bart Starr Sports as of July 31. When finished answering this question, upload your completed worksheet containing your answer. Upload Choose a File