Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started