1. Determine the companys (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in 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 No. 1203 and Check No. 1278 are outstanding checks as of November 30.

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 --- Bank Balance October 31: $15,000 $5,000 ---- $0 - 1 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 November 30 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 -- Bank Balance November 5: $12,600 $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 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- Bank Balance November 10: $8,400 $0 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 November 30 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- Bank Balance November 15: $9,700 $0 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 November 30 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- Bank Balance November 20: $10,300 $0 October 31 November 15 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 November 30 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 --- Bank Balance November 25: $14,100 $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 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- Bank Balance November 30: $16,028 $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 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 Book Balance October 31: $15,000 $0 October 31 November 15 November 30 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 Book Balance November 5: $11,400 $5,000 $0 October 31 November 15 November 30 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 Book Balance November 10: $12,100 $5,000 $0 October 31 November 15 November 30 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 Book Balance November 15: $9,100 $0 October 31 November 15 November 30 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 Book Balance November 20: $10,700 $0 October 31 November 15 November 30 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 Book Balance November 25: $15,300 $5,000 $0 October 31 November 15 November 30 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 Book Balance November 30: $16,127 $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 1 Check Printing Fees Service Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Wire Transfer Fees Check #1203 Check #1278 $100 $78 +ableau TO 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 $40 November Bank Fees $30 $20 August: $31 Check Printing Fees Service Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Wire Transfer Fees Check #1203 Check #1278 +ableau $100 $78 K 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? 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 September: $24 $0 August September October November Outstanding Checks at Nov. 30 Wire Transfer Fees Check #1203 Check #1278 +ableau $100 $78 K 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 $40 November Bank Fees $30 $20 Check Printing Fees E Service Fees $10 October: $22 $0 August September October November Outstanding Checks at Nov. 30 $100 Wire Transfer Fees Check #1203 Check #1278 $78 tableau o 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 $40 November Bank Fees $30 $20 Check Printing Fees November: $37 Service Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Wire Transfer Fees Check #1203 Check #1278 # +ableau $100 $78 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 $40 November Bank Fees $30 Check Printing Fees: $35 $20 Check Printing Fees Service Fees $10 $0 August September October November Outstanding Checks at Nov. 30 Wire Transfer Fees Check #1203 Check #1278 + ableau $100 $78 K O 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? 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 Service Fees: $15 Wire Transfer Fees Outstanding Checks at Nov. 30 Check #1203 $100 Check #1278 $78 +ableau K TO 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? 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 Wire Transfer Fees Outstanding Checks at Nov. 30 Check #1203 $100 Check #1278 $78 +ableau Wire Transfer Fees: $14 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. (a) Bank Balance (b) Book Balance 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What is the amount of cash interest received in the month of November? Amount of cash interest received 1. Determine the company's (a) bank balance and (b) book balance on November 30 before the bank reconciliation. 2. What is the amount of cash interest received in the month of November? 3. Which of the bank fees is the largest of those charged to the company in November? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Which of the bank fees is the largest of those charged to the company in November? Which of the bank fees is the largest of those charged to the company in November? ......