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 $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 Book Balance November 30 $40 $30 $20 $10 $0 Cash Interest Received on Bank Balance August September October November Outstanding Checks at Nov. 30 Check #1203 Check #1278 $100 $78 Total Deposits in Transit November 30 $250 November Bank Fees Check Printing Fees Wire Transfer Fees Service Fees H 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. Bank statement balance Add: Nov. 30 deposit in transit Deduct: Check #1203 Check #1278 Adjusted bank balance 00 $ 250 Answer is not complete. Bank Reconciliation November 30 $ 250 250 0 250 Book balance Add: Interest earned Deduct Check printing fees Service fees Wire transfer fees. Adjusted book balance 000 $ 21 $ 35 15 140 $ 16,127 21 16,148 64 16,084