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...
-
HealthSource, LLC, consists of two doctors, Drew and Moore, who share in all income and losses according to a 2:3 income-sharing ratio. Dr. Mann has been asked to join the LLC. Prior to admitting...
-
1. List at least 5 different marketing opportunities that an organisation might consider when planning new marketing strategies and activities. 2. Explain why you would evaluate these opportunities...
-
The soft-ride suspension system of the mountain bike is pinned at C and supported by the shock absorber BD. If it is designed to support a load of P = 1500 N, determine the factor of safety of pins B...
-
Saturated steam at 100C is heated to 400C. Use the steam tables to determine (a) The required heat input (J/s) if a continuous stream flowing at 100 kg/s undergoes the process at constant pressure...
-
What is the angular diameter (in arcseconds) of a comet nucleus that has a radius of 15.0 km and is located at a distance of 3.00 Astronomical Units.
-
While self-reflection is an essential leadership behavior, you need to establish whether your view of yourself is consistent with those who you aspire to influence. A 360-degree perspective allows...
-
Suppose you started a new company, which is expected to generate a Return on Invested Capital ROIC of 15% per year. The company is all-equity financed and the book value of the Invested Capital...
-
The folks in Accounting seem to have made a serious error in this report. Your Task. When indirectness or tact is required, use passive-voice verbs. Revise the following sentences so that they are...
-
From the following wordy paragraph, create a concise introductory statement plus a bulleted list with category headings. This is to inform you that our on-site GuruGeek computer technicians can...
-
Revise the following dense, wordy paragraph to create an introductory sentence plus a bulleted list. We all know that ATMs are quick and convenient for accessing your money, especially if you are...
-
Who owns non-profit organizations?
-
Use the following facts to construct a coherent paragraph with a topic sentence and appropriate transitional expressions in the supporting sentences. The federal government will penalize medical...
-
You purchase a $1000 par value bond for $960 that has a 5.75% coupon rate and 10 years until maturity. What is your annual return? 2. A City of Tempe muni bond has a yield of 4.3%. For an investor in...
-
If a test has high reliability. O the test measures what the authors of the test claim it measures O people who take the same test twice get approximately the same scores both times O scores on the...
-
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...
-
If a product is produced in high volume by a few large organizations, what phase of the product life cycle is it most likely in?
-
Is a highly standardized product usually produced through a make-to-order or a make-to-stock processing strategy?
-
Does providing customized products generally involve less capital investment or less skilled labor, when compared to more standardized products?
Study smarter with the SolutionInn App