PLEASE WRITE AN EXPLANATION...

The accounting department prepares a bank reconciliation at the end of each month. The following Tableau Dashboard is provided to assist in our reconciliation for the month of November. Bank Statement Balance $20,000 $15,000 $10,000- $5,000 -- $0 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 November 30 Cash Interest Received on Bank Total Deposits in Transit Balance November 30 $250$40 November Bank Fees $30 $20 Service Check Printing Fees Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Wire Transfer Fees Check #1278 $78 tableau Prepare the company's bank reconciliation using information from the Tableau Dashboard. Assume the following: . The company has not yet recorded the bank fees. . The company has not yet recorded cash interest received for November. . Deposits in transit on November 30 were placed in the bank's night depository after banking hours and were not recorded on the November 30 bank statement. . Check No. 1203 and Check No. 1278 are outstanding checks as of November 30.