help please

Excel File Edit View Insert Format Tools Data Window Help $ $ 100% Z-7 Sat 3:42 PM Q AutoSave . OFF YOU MUST RENAME AND UPLOAD THIS FILE - 1P91 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 10 AA 9 Wrap Text v Accounting Insert v Ev Ex Delete AY- O. Paste BIUV FE Merge & Center v $ 208 Conditional Format Cell Find & ideas Formatting as Table Styles Format v Sort & Sensitivity Filter Select F18 X V fx B C DE G H The ABC company has an ending cash balance at October 31, 2020 in its general ledger of 24,510.00 The balance per the bank statement at October 31, 2020 was 24,045.00 PART 1: BANK RECONCLIATION The accounting has identified the following information related to the month of October: Cash balance per bank statement $ 24,045.00 A deposit totaling $4,000 was made on Oct 31 via the ATM machine, after the bank had already closed. Outstanding cheques of $2,000 on October 31 Cheque for advertising expense, $340, was incorrectly recorded in the books as $430. An EFT deposit of $1,500 from Customer C was received but not yet recorded. The bank teller accidentally entered the deposit total as $850 instead of $805. Bank service charges of $100, per bank statement Adjusted cash balance per bank statement Using the following worksheet to record your answers, prepare the following: Cash balance per books $ 24,510.00 1. A bank reconciliation for ABC company at October 31, 2020. 2. Any necessary journal entries resulting from the bank reconciliation bank service charge (100.00) (90.00) Adjusted cash balance per books PART 2: JOURNAL ENTRIES No General Journal Debit Credit 1 INSTRUCTION Part 1 Part 2 Part 3 + Ready + 114% You can ask 5 questions (will expire o) Help Our average answer time for Accounting questions is ~45 m A 10 S H W X PINSON