Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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 133 Bank Statement Balance points $20,000 $15,000 $10,000 $5,000 November 15 October 31 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 November Bank Fees Service Check Printing Fees Fees August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Check #1278 $78 Wire Transfer Fees ( ) - H | B 09+ableau Prepare the company's bank reconciliation using information from the Tableau Dashboard. Assume the following: Return to question 3 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. 1.33 coines Answer is not complete. Bank Reconciliation November 30 Book balance $ 16,127 Bank statement balance Add: Nov. 30 deposit in transit Add $ 250 Interest earned e 21 250 16.148 Deduct: Check #1203 Check #1278 Deduct: Check printing fees 35 Service fees Wire transfer fees 14 US Adjusted bank balance $ 250 16.084 Adjusted book balance 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 133 Bank Statement Balance points $20,000 $15,000 $10,000 $5,000 November 15 October 31 November 30 Book Balance $20,000 $15,000 $10,000 $5,000 Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 November Bank Fees Service Check Printing Fees Fees August September October November Outstanding Checks at Nov. 30 Check #1203 $100 Check #1278 $78 Wire Transfer Fees ( ) - H | B 09+ableau Prepare the company's bank reconciliation using information from the Tableau Dashboard. Assume the following: Return to question 3 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. 1.33 coines Answer is not complete. Bank Reconciliation November 30 Book balance $ 16,127 Bank statement balance Add: Nov. 30 deposit in transit Add $ 250 Interest earned e 21 250 16.148 Deduct: Check #1203 Check #1278 Deduct: Check printing fees 35 Service fees Wire transfer fees 14 US Adjusted bank balance $ 250 16.084 Adjusted book balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions