Make Bank Reconciliation Statement 1 2 3 4 5 6 7 8 9 10 11 12 13
Fantastic news! We've Found the answer you've been seeking!
Question:
Make Bank Reconciliation Statement
Transcribed Image Text:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Given Information: 1 Cash on hand at the company and not yet deposited at the bank. 2 EFT for monthly utility bill not yet recorded by the company. 3 Note collected by the bank and not yet recorded by the company. 4 Interest collected by the bank from note in # 3 not yet recorded by the company. 5 Debit card used to purchase supplies not yet recorded by the company. 6 Checks written by the company but not yet processed by the bank. 7 Service fee charged by bank but not yet recorded by the company. 8 Customer checks determined by the bank to have nonsufficient funds. Bank balance at the end of the period. Checkbook at the end of the period. Answers: (a) Bank Reconciliation Per statement Deposits outstanding Checks outstanding Bank balance per reconciliation ? ? ? ? (b) Reconciled? *Use a conditional statement to return a value of 'Yes' or 'No' Bank Balance: ? Per Checkbook EFT for utilities Note collected Interest earned Supplies purchased Service fee NSF checks Checkbook per reconciliation Checkbook Balance: ? ? ? ? ? ? ? ? 5,475 1,200 8,800 1,000 975 2,500 100 2,500 15,800 13,750 Enter a formula in the place of each "?" Make sure to use a conditional statement in cell D33. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Given Information: 1 Cash on hand at the company and not yet deposited at the bank. 2 EFT for monthly utility bill not yet recorded by the company. 3 Note collected by the bank and not yet recorded by the company. 4 Interest collected by the bank from note in # 3 not yet recorded by the company. 5 Debit card used to purchase supplies not yet recorded by the company. 6 Checks written by the company but not yet processed by the bank. 7 Service fee charged by bank but not yet recorded by the company. 8 Customer checks determined by the bank to have nonsufficient funds. Bank balance at the end of the period. Checkbook at the end of the period. Answers: (a) Bank Reconciliation Per statement Deposits outstanding Checks outstanding Bank balance per reconciliation ? ? ? ? (b) Reconciled? *Use a conditional statement to return a value of 'Yes' or 'No' Bank Balance: ? Per Checkbook EFT for utilities Note collected Interest earned Supplies purchased Service fee NSF checks Checkbook per reconciliation Checkbook Balance: ? ? ? ? ? ? ? ? 5,475 1,200 8,800 1,000 975 2,500 100 2,500 15,800 13,750 Enter a formula in the place of each "?" Make sure to use a conditional statement in cell D33.
Expert Answer:
Answer rating: 100% (QA)
Answer Deposits outstanding EFT for utilities 1200 needs to be subtracted from the checkbook balance ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The Language is Java Problem: Card Shuffle Write a program that generates a deck of card which is initially ordered, and then shuffles the deck so that on each run the cards appear in random order....
-
example given below Tasks: 1. Using the residual income model, prepare a valuation of the common stock of Best Buy as of Year 2 under the following assumptions (use Exhibit 9.6 in the textbook as an...
-
8. Reselect all cases. Then select only those cases for which X < 2, Y < 2, and Z < 2. Report the mean value of M for this sub-sample. O 1.31 O 0.375 O 840 3.36 Question 9 Q09. Reselect all cases....
-
Consider the function f(x) = sin(x). (a) Give the Taylor polynomial Ps(r) of degree 5 about a = /6 of this function. Note: use the exact values of sin(7/6)= 1/2 and cos(/6)= 3/2. (b) Give the nested...
-
Get supplier numbers for suppliers supplying some project with part P1 in a quantity greater than the average shipment quantity of part P1 for that project J1?
-
Looking at the charts presented earlier in this chapter, select a product that members of a particular nation consume very lightly. Research the countrys culture and geographic location and describe...
-
Assume that ABC Corp. just paid a dividend of $1 a share and that all future dividends are expected to grow at the rate of 9 percent per year. If the required rate of return for this stock is 15...
-
For your job as the business reporter for a local newspaper, you are given the task of putting together a series of articles that explain the power of the time value of money to your readers. Your...
-
K Assume that Tom's Tree and Landscape Service charges $200 for consultation fee plus $20 per hour for labor. a) Write a system of equations to represent the cost of the two lar b) Graph both...
-
You are working on a free-form Packet Tracer challenge activity as seen in Figure 1, you have been given the London Railways network.' The purpose of this EMA question is to build upon each of the...
-
Crosshill Company's total overhead costs at various levels of activity are presented below: Total Overhead Month Machine-Hours Cost April 70,000 $210,000 May 60,000 $178,200 June 80,000 $234,000 July...
-
Nieto Co. elects to use the percentage-of-sales basis in 2008 to record bad debts expense. It estimates that 2% of net credit sales will become uncollectible. Sales are \($800,000\) for 2008, sales...
-
In conducting a fraud investigation, the internal auditor should first: a. Identify the perpetrator. b. Get the facts. c. Obtain a confession. d. Notify a law-enforcement agency. e. Obtain...
-
An internal auditor has reason to believe a fraud is being committed in the bill-paying unit of the Controller's Department. Which of the following actions best describes the way the internal auditor...
-
As soon as he or she becomes suspicious of potential management fraud, the Chief Executive Officer should: a. Suspend the suspect. b. Notify the police. c. Treat the matter as a legal problem. d....
-
Certain frauds are almost impossible to detect through normal audit routines. These are: a. Collusion. b. Lapping. c. Forgery. d. a. and c. e. None of the above.
-
. Week 12 - Bank Reconciliation Homework Assignment - Excel simranjit singh rakhra ($5 X File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell me what you want to do Cut Arial -...
-
2.) Find the Laplace transform of f(t) 7e-St cos 2t +9 sinh2 2t. Use Laplace Table. %3D
-
Most projects seem to finish late and over budget. But why should this happen, when there are many tools to help and a lot of experience and knowledge in the area? Find some examples of particularly...
-
A company can introduce only one new product from three available. If it estimates the following data, which product would you recommend?
-
Do the following figures follow a Normaldistribution? Weight in grams) observations in grams observations Number of Weight Number of less than 5 5 5 to 19.99 43 20 to 34.99 74 35 to 49.99 103 50 to...
-
Why does this chapter provide an explanation of the development of mutual funds?
-
What conditions are necessary for a risk-free asset to be free of risk? Provide an example. Is it really risk-free?
-
Will very wide diversification eliminate specific risk? And market risk?
Study smarter with the SolutionInn App