Tableau DA $6-2($Static$)$: Exercise, Preparing a bank reconciliation LO P$3$

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

Book Balance

Cash Interest Received on Bank

Total Deposits in Transit Balance 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 Number $1203$ and Check Number $1278$ are outstanding checks as of November $30.$ 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 Number $1203$ and Check Number $1278$ are outstanding checks as of November $30.$