Need help with this question.

Weekly homework assignment Q Search Sheet Home Draw Page Layout Formulas Data Review View "+ Share Insert C4 fx ALT-EZ-BANK-RECON K L M N P A B D E F G H J STATUS: THIS EXERCISE IS NOT DONE When you are finished with this exercise, change the status to "DONE!" ALT-EZ-BANK-RECON BALANCE PER BOOKS BALANCE PER BANK ERROR ON CHECK DEPOSITS IN TRANSIT 10 11 BANK FEES OUTSTANDING CHECKS 12 13 NCE PER BOOKS ADJUSTED BALANCE PER BANK 14 15 16 The following data were accumulated for use in reconciling the bank account of Fillmore Company for April. 17 1. Cash balance according to the company's journal at April 30 was $21,950. 18 2. Cash balance according to the bank statement at April 30, $23,240. 19 3. The outstanding checks amounted to $4,460. 20 4. There was a deposit in transit of $3,580. 21 5. A check for $270 in payment of an account was erroneously recorded as $720. 22 6. Bank fees amounted to $40. 23 Can you prepare the bank reconciliation? 24 25 26 27 28 29 30 32 33 34 35 36 37 38 39 40 41 42 1. PERIODIC IS 2. FIFO-T 3. BANK RECON 5. FIN STMTS 7. MULTIPLE CHOICE + D 4. INT. CONTROL 6. INTEREST CALCS 8. YOUR THOUGHTS + 100% Ready