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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage 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 Bank Statement Balance $20,000 $15,000 $10,000 $5,000- $0 October 31 November 15 Book Balance $20,000 $15,000 $10,000 $5,000- November 30 $0 October 31 November 15 November 30 $40 $30 $20 $10 Cash Interest Received on Bank Balance Total Deposits in Transit November 30 $250 $0 August September October November Outstanding Checks at Nov. 30 Check #1203 Check #1278 +ableau November Bank Fees Check Printing Fees Service Fees $100 $78 Wire Transfer Fees TE 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 Check #1278 +ableau 578 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. Bank statement balance Add: Deduct Bank Reconciliation November 30 Book balance Add: Deduct Adjusted bank balance 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. Bank Statement Balance $20,000 $15,000 $10,000 $5,000- $0 October 31 $20,000 $15,000 $10,000 $5,000 $0 November 15. November 30 Book Balance October 31 November 15 November 30 Cask Intent Dealed an Dank Total Danneite in Traneit $40 $30 $20 30 $10 $0 $0 October 31 Cash Interest Received on Bank Balance August September October November 15 November Outstanding Checks at Nov. 30 Check #1203 Check #1278 +ableau November 30 Total Deposits in Transit November 30 $250 November Bank Fees Check Printing Fees Service Fees $100 $78 Wire Transfer Fees K & P Dronare the comennus han nennellistian urina information from the Tahina Dachhaard Accume the following < Prev 5 of 5 Next Outstanding Checks at Nov. 30 Check #1203 Check #1278 +ableau $100 Wire Transfer Fees $78 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. Bank statement balance Add: Bank Reconciliation November 30 Book balance Add: Deduct 0 0 Deduct 0 0 0 0 Adjusted bank balance $ 0 Adjusted book balance $ 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Financial Accounting and Reporting

Authors: Barry Elliott, Jamie Elliott

14th Edition

978-0273744535, 273744445, 273744534, 978-0273744443

More Books

Students also viewed these Accounting questions

Question

How should items such as profit and asset values be measured?

Answered: 1 week ago

Question

Who are the users of financial accounting information?

Answered: 1 week ago