Please show formulas, steps, work and answer.

E6-28 (Algo) Preparing Bank Reconciliation and Entries and Reporting Cash LO6-4 The September 30 bank statement for Bennett Company and the September ledger account for cash are summarized here: BANK STATEMENT Checks Deposits $26,050 Balance, September 1 Deposits recorded during September Checks cleared during September NSF checks-Betty Brown Bank service charges Balance, September 30 $26,950 120 43 Balance $ 7,350 33,400 6,450 6,330 6,287 6,287 Cash (A) Sept. 1 Balance Sept. Deposits 29,700 7,350 28,750 Sept. Checks written No outstanding checks and no deposits in transit were carried over from August; however, there are deposits in transit and checks outstanding at the end of September. Required: 1. Reconcile the bank account. 2. Prepare the journal entries that should be made as the result of the bank reconciliation 3. What should the balance in the Cash account be after the reconciliation entries? 4. What total amount of cash should the company report on the September 30 balance sheet? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Reconcile the bank account. Company's Books Ending balance per cash account Additions: BENNETT COMPANY Bank Reconciliation, September 30 Bank Statement $ 7,350 Ending balance per bank statement Additions: $ 7,350 0 7,350 7,350 Deductions: Deductions: Bank service charges NSF check - Betty Brown 43 120 0 163 7,513 Correct cash balance Correct cash balance 3 Journal entry worksheet Record service charges deducted from bank account. Note: Enter debits before credits. Transaction General Journal Debit Credit Record entry Clear entry View general journal Journal entry worksheet