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...
-
Tyler Kirsch has recently been hired as the manager of Dark Canyon Coffee. Dark Canyon Coffee is a national chain of franchised coffee shops. During his first month as store manager, Tyler...
-
In 2022, Alexandria is a single mother with a 17-year-old dependent child. Alexandrias adjusted gross income in 2022 is $78,000. What is the total amount of Alexandrias child tax credit and other...
-
Examine how the rank of the stoichiometric matrix can be used to reduce the number of equations to be solved. For example, if there are \(n_{\mathrm{s}}\) components and \(n_{\mathrm{r}}\) equations...
-
You are given the following sample data for variables y and x : a. Develop a scatter plot for these data and describe what, if any, relationship exists. b. (1) Compute the correlation coefficient....
-
Staples sells CDs ( $ 2 , 0 0 ) and box s of computer Paper ( $ 3 ) . If total sales Were $ 1 , 5 6 0 and customers bought 5 times as many CDs as boxes of compute paper how many obs were sold?,
-
Comment upon each of the following statements you heard in a conversation between two newly- hired staff auditors. a.Of course, Im qualified to be assigned to this engagement. I have an accounting...
-
Consider a line at y = L to 2L. It contains electric charge of density PL = PLO(Y/L) for some constant Pro in C/m. Find the total charge of this line.
-
Lieu Company is a specialty print shop. Usually, printing jobs are priced at standard cost plus 50 percent. Job 631 involved printing 500 wedding invitations with the following standard costs: Direct...
-
Maurizio Inc. has manufactured stage clothes for rock stars for the past century. His apparel has been worn by the Beatles, Rolling Stones & Elvis Presley. Perfect fit and glitter is what makes them...
-
Consider the following information: Rate of Return if State Occurs State of Economy Boom Bust Probability of State of Economy .72 .28 Stock A .10 .29 Stock B .04 Stock C .40 .35 -.20 a. What is the...
-
A consumer has a budget of $50 to spend on either hamburgers or hot dogs. Hamburgers cost $5 each, and hot dogs cost $2 each. If the consumer's marginal utility for hamburgers is 10 and for hot dogs...
-
Evaluate the three mutual funds using Sharpe and Treynor measure. Given the risk-free rate is 5%. Financial Assets Average Return Standard Beta Deviation Fund A 22% 25% 1.2 Fund B 10% 8% 0.4 Fund C...
-
use the above data table to solve the question Irvin Chemical Corporation has three divisions. Following is division information from the most recent year. (Click the icon to view the information.)...
-
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...
-
2019. Peabody Energy Company and Arch Resources, Inc., are two titans in a now-dwindling industry. Peabody operates three mines in the Southern Powder River Basin (SPRB) in Wyoming, one of which is...
-
Beginning around 1915, Natural Products Refining Corporation (NPRC) operated a chemical plant in Jersey City, New Jersey, at which it turned chromite ore into chromium chemicals (primarily sodium...
-
When GTE Sylvania discovered it was losing market share to other television manufacturers, it developed a franchise plan that limited the number of retailers selling its product in each area....
Study smarter with the SolutionInn App