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 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 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 # tableau C T o Prepare the company's bank reconciliation using information from the Tableau Dashboard. Assume the following: The company has not yet recorded the bank fees. 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 recorded on the November 30 bank statement. Check Number 1203 and Check Number 1278 are outstanding checks as of November 30. Bank Reconciliation November 30 Bank statement balance Book balance 16,127 Add: Add: Nov. 30 deposit in transit 250 Interest earned 37 250 37 250 16,164 Deduct: Deduct: Check #1203 Check printing fees 35 Check #1278 Service fees 15 Wire transfer fees 14 0 64 Adjusted bank balance 250 Adjusted book balance $ 16,100

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

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

Recommended Textbook for

ISE Managerial Accounting Creating Value In A Dynamic Business Environment

Authors: Ronald Hilton, David Platt

12th Edition

1260566390, 9781260566390

More Books

Students also viewed these Accounting questions

Question

Describe the characteristics of a 360-degree performance appraisal.

Answered: 1 week ago