Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ending Bank Balances: Oct. 31 = 15000 Nov. 5 = 12600 Nov. 10 = 8400 Nov. 15 = 9700 Nov. 20 = 10300 Nov. 25
Ending Bank Balances:
Oct. 31 = 15000
Nov. 5 = 12600
Nov. 10 = 8400
Nov. 15 = 9700
Nov. 20 = 10300
Nov. 25 = 14100
Nov. 30 = 16028
Ending Book Balances:
Oct. 31 = 15000
Nov. 5 = 11400
Nov. 10 = 12100
Nov. 15 = 9100
Nov. 20 = 10700
Nov. 25 = 15300
Nov. 30 = 16127
Cash Interest:
Aug. = 31, Sept = 24, Oct = 22, Nov = 37
Nov Bank Fee:
CPE = 35
Service Fee = 15
Wire Transfer Fee = 14
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 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 August September October November Outstanding Checks at Nov. 30 $100 Wire Transfer Fees Check #1203 Check #1278 $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 No. 1203 and Check No. 1278 are outstanding checks as of November 30. Bank Reconciliation November 30 Book balance Add: Bank statement balance Add: Deduct: Deduct: Adjusted bank balance Adjusted book balance
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