The accounting department prepares a bank reconciliation at the end of each month. The following Tableau...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 Book Balance November 30 $40 $30 $20 $10 $0 Cash Interest Received on Bank Balance August September October November Outstanding Checks at Nov. 30 Check #1203 Check #1278 $100 $78 Total Deposits in Transit November 30 $250 November Bank Fees Check Printing Fees Wire Transfer Fees Service Fees H 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 statement balance Add: Nov. 30 deposit in transit Deduct: Check #1203 Check #1278 Adjusted bank balance 00 $ 250 Answer is not complete. Bank Reconciliation November 30 $ 250 250 0 250 Book balance Add: Interest earned Deduct Check printing fees Service fees Wire transfer fees. Adjusted book balance 000 $ 21 Ⓒ $ 35 15 140 $ 16,127 21 16,148 64 16,084 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 $20,000 $15,000 $10,000 $5,000 $0 October 31 November 15 Book Balance November 30 $40 $30 $20 $10 $0 Cash Interest Received on Bank Balance August September October November Outstanding Checks at Nov. 30 Check #1203 Check #1278 $100 $78 Total Deposits in Transit November 30 $250 November Bank Fees Check Printing Fees Wire Transfer Fees Service Fees H 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 statement balance Add: Nov. 30 deposit in transit Deduct: Check #1203 Check #1278 Adjusted bank balance 00 $ 250 Answer is not complete. Bank Reconciliation November 30 $ 250 250 0 250 Book balance Add: Interest earned Deduct Check printing fees Service fees Wire transfer fees. Adjusted book balance 000 $ 21 Ⓒ $ 35 15 140 $ 16,127 21 16,148 64 16,084
Expert Answer:
Answer rating: 100% (QA)
BANK RECONCILATION STATEMENT FOR THE MONTH ENDING NOVEMBER 30 PARTICULA... View the full answer
Related Book For
Financial and Managerial Accounting the basis for business decisions
ISBN: 978-0078111044
16th edition
Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello
Posted Date:
Students also viewed these accounting questions
-
The following balance sheets at the end of each of the first two years of operations indicate the following: Total current assets: 2010- $600,000 2009- $560,000 Total investments: 2010- 60,000 2009-...
-
The Consumer Confidence Index published at the end of each of the past 20 months showed the following consumer confidence levels: 87, 89, 88, 91, 88, 90, 86, 87, 91, 90, 86, 91, 90, 87, 88, 88, 89,...
-
At the end of each year, Threads Crafts Inc. pays $1000 into a savings account. If interest earned on the account is 3.24% compounded monthly, what would the account balance be in four years?
-
Jontil Co. began the current period with a $14,000 balance in the Peter Jontil, Capital account. At the end of the period, the company's adjusted account balances include the following temporary...
-
Following are selected transactions carried out by Blakely Company this year. Jan. 12 Sold merchandise on account to G. Hardin; 3/10, n/30; $ 2,450. 22 Received a check from G. Hardin for the sale of...
-
Dunder Miffl in Companys chart of accounts includes the following selected accounts. 101 Cash 157 Equipment 120 Inventory 201 Accounts Payable 130 Prepaid Insurance 306 Owners Drawings On November 1,...
-
This appeal involves the validity of a will executed in contravention of an earlier contract to make mutual wills. A husband and wife signed a contract to make mutual wills and then executed those...
-
Knotts Industries manufactures standard and super premium backyard swing sets. Currently it has four identical swing-set-making machines, which are operated 250 days per year and 8 hours each day. A...
-
2. In the system below, the coefficient of friction between the block and the table is 0.2. T2 2 kg 5 kg Find the acceleration of the system and the tensions T1 and T2. 10 kg [8]
-
Several years ago, management at Tuglar Corporation established a grievance committee composed of employees who volunteered to work toward the amicable resolution of disputes between Tuglar...
-
b. A short-course meter pool is 25 meters long. A short-course yard pool is 25 yards long. Which one is longer and by how much (in feet)? Round to two decimal places.
-
1) We have started the process to extradite the people responsible for the OPM incident. We need to cross all of our Ts and dot all of our Is. So, you need to use the information from your readings...
-
It is easier to take in hand, more perilous to conduct, and more uncertain in its success than to take the lead in introducing a new order of things. Because the innovator has enemies in all those...
-
1. What has been today's trend in venue development 2. What are two of the nine core functions of a venue operations. 3. What are the difference between Authorities, Commissions, and Nonprofit...
-
Explain the transaction that took place that resulted in the documents below. Who can complete each of the above transactions? WORLD BANK Banking Corporation Wedgewood NSW Date 15 May 20XX Payee...
-
According to research, how might Millennials resist or respond poorly to the transformational leadership approach and why?
-
Smith Retail has the following purchases and sales for the period. Beginning inventory Purchases Jan 12 Jan 26 Sales Jan 18 Jan 30 Quantity 500 600 160 370 250 Price $4.09 $5.55 $5.72 $ 16.00 $ 16.00...
-
a. What is the cost of borrowing if Amarjit borrows $28 500 and repays it over a four-year period? b. How many shares of each stock would he get if he used the $28 500 and invested equally in all...
-
Going from general to specific, what are the three primary objectives of financial accounting information?
-
Multi-Star, Inc., had sales of $890,000, cost of sales and operating expenses of $450,000 and $200,000, respectively, and 10,000 shares of common stock outstanding. Calculate the amount of earnings...
-
Describe the usual nature of the following features as they apply to a share of preferred stock: (a) Cumulative, and (b) Convertible.
-
Can the Sharpe (reward-to-volatility) ratio, S = [E(rC) rf]/C, of any combination of the risky asset and the risk-free asset be different from the ratio for the risky asset taken alone, [E(rP) ...
-
Suppose that there is an upward shift in the expected rate of return on the risky asset, from 15% to 17%. If all other parameters remain unchanged, what will be the slope of the CAL for y 1 and y >...
-
a. If an investors coefficient of risk aversion is A = 3, how does the optimal asset mix change? What are the new values of E(rC) and C? b. Suppose that the borrowing rate, r fB = 9%, is greater than...
Study smarter with the SolutionInn App