Tableau DA 6-2: Exercise, Preparing a bank reconciliation LO P3 [similar to EX 6-12]

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.

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 Number 1203 and Check Number 1278 are outstanding checks as of November 30.

tableau link: https://public.tableau.com/views/WILD_FAP_Ch08_A/Dashboard?:language=en-US&:display_count=n&:origin=viz_share_link

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 Total Deposits in Transit November 30 $250 $40 November Bank Fees $30 $20 Check Printing Fees Service Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Wire Transfer Fees Check #1278 $78 Bank Reconciliation November 30 Book balance Add: Bank statement balance Add: Deduct: Deduct: Adjusted bank balance Adjusted book balance