Ace's Hockey Superstore has the following information related to cash for the month ending, October 31, 2020. Cash on hand, not yet deposited at the bank EFT for monthly utility bill not yet recorded by the company Note collected by the bank, not yet recorded by the company Interest collected by the bank from the note above, not yet recorded by the company Debit card used to purchase supplies not yet recorded by the company Checks written by the company but not processed by the bank Service fee charged by the bank but not yet recorded by the company Customer check determined to be NSF by the bank Bank balance, 10/31/20 Cash balance (prior to reconciliation), 10/31/20 $3,600 1,200 10,000 1,000 800 3,100 100 2,700 17,300 11,600 Required: In Excel, prepare a bank reconciliation as of 10/31/20. Prepare any required journal entries to update the company's cash balance