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...
-
Python Company leased equipment from Hope Leasing on January 1, 2011. Hope purchased the equipment at a cost of $222,666. There is no expected residual value. Required: Prepare appropriate journal...
-
The number of hours 9 students spent studying for a test and their scores on that test (a) x = 3 hours (b) x = 6.5 hours (c) x = 13 hours (d) x = 4.5 hours Find the equation of the regression line...
-
What are some incentives or pressures to misappropriate assets?
-
(a) Given the product structure and master production schedule (Figure 14.14 below), develop a gross requirements plan for all items. (b) Given the preceding product structure, master production...
-
$3,000,000.00 is invested at the beginning of April. On April 9, $80,000.00 is withdrawn from the same account. At the end of April the account is worth $2,850,000.00. The cash-flow adjusted rate of...
-
Three employees in the maintenance department are responsible for repairing the video games at Pinball Wizard, a video arcade. A maintenance worker can fix one video game machine every B hours on...
-
All these thermodynamic calculations can make you very hungry, right? Why don t you prepare yourself a little bit of yummy ramen...? As you stand on your Q = 2 kW stove watching the water boil at tc...
-
If the fuel efficiency of an automobile is 22 miles per gallon, what is its fuel efficiency in Kilometers per liter? ( 1Km=0.621 mile, 1.00 L=1.057 quarts and 4 quarts = 1 gallon)
-
Preble Company manufactures one product. Its variable manufacturing overhead is applied to production based on direct labor-hours and its standard cost card per unit is as follows: Direct materials:...
-
How does a local host learn the MAC address of its default gateway router? Explain.
-
Analyse the market/industry by using key statistics like size and growth of the market. Include at least two key external trends (at least one opportunity and at least one challenge) which may have...
-
3. You are driving your car at 12 m/s when a deer jumps in front of your car. What is the shortest stopping distance for your car if your reaction time is 0.80 s and your car brakes at 6.0 m/s? 4. A...
-
Gasoline with a density of 6 8 0 kg / m ^ 3 and a dynamic viscosity of 2 . 9 2 x 1 0 - 4 kg / m s flows through a long straight pipe. The pressure drop is measured along a section of pipe of length L...
-
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.
-
Imagine that you have \($10,000\) to invest. Use a newspaper, the Internet, or other source to select a mutual fund. Use the same source to fi nd out how much gold you could buy for \($10,000\)....
-
Animation art, hand-painted images from which cartoons used to be made, is a popular collectible.
-
The PBS television program, Antiques Roadshow, has generated enormous interest among viewers to find out the value of the furniture, art, jewelry, and collectibles they own.
Study smarter with the SolutionInn App