Prepare the companys 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 banks 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.

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 Balance $40 $30 $20 $10 $0 August September October November Service Fees Outstanding Checks at Nov. 30 Check \#1203 Check \#1278 Total Deposits in Transit November 30$250 November Bank Fees Check Printing Fees $100 Bank Reconciliation November 30