Complete the excel worksheet as required in audit program

Assignment Help Accounting Basics
Reference no: EM131584974

Instructions and Deliverables

1. The sales journal, sales orders, shipping documents, invoices and price list are available on in canvas

2. An Audit Program has been prepared for you by the Audit Partner.  You are asked to determine materiality based on total sales.  This is a judgment so you must defend your choice in the memo. 

3. Complete the working papers (memo and worksheet) requested by the partner.  For every deviation noted, explain it fully in a referenced note so that a person who does not have access to the original documents can follow and understand what the deviation is.  Do not replicate the documents in what you turn in. 

4. As you may recall from auditing classes at university, it is very important for you to understand the internal controls over the sales process. From the tests of transactions in the sales journal, identify any control deficiencies for this company that might impact your assessment of control risk (we are conducting DUAL tests, i.e. tests of controls and balances for these items). Recommend internal control procedures that could be implemented to address any deficiencies you noted. You can find the definitions of control deficiencies, significant deficiencies and material weaknesses under authoritative standards on the AICPA's web site. In general, how does the assessment of control risk impact the extent of an auditor's substantive tests of transactions?  (Include in the memo.)

5. Based on the transactions you select, use the Excel spreadsheet provided to test of the sales account and calculate a proposed audit adjustment. You cannot statistically evaluate your results as you would on an actual audit engagement.

6. Prepare a final memo that contains the items from the audit program:

a. A description in detail of what controls appear to be missing based on the work you conducted.  Please provide a numbered list

b. A recommendation of how to fix those controls.

c. A description of how your sample was selected.

d. A detailed description of problems noted and why you do or do not think this supports or does not support the receivable and or revenue balance.

e. A determination of whether revenue is fairly stated.

f. A recommendation of an audit adjustment - Please think carefully about the adjustment.  You can only adjust A/R if you know which customer was affected. 

g. Make a recommendation on what to do - audit more - ask the client to review transactions, issue an opinion, withdraw from the engagement. Explain why your recommendation is the best option.

7. Step back and determine whether the worksheet by itself has enough evidence to support the conclusion you have in step 6.  Remember, your work may be reviewed by a third party..  Make sure you adequately explain the sample selection method, the source, conclusion, etc.  This should all be consistent with the evidence documented in the worksheet.   

Deliverables:

1. Complete the excel worksheet as required in the audit program. 

2. Complete a memo summarizing the tests conducted (on the worksheet).

Attachment:- Assignment Files.rar

Reference no: EM131584974

Questions Cloud

How supply objectives align with the organizational mission : The operational and strategic objectives of the supply and purchasing department. How above supply objectives align with the organizational mission and goals.
What are design patterns : What are design patterns? Why do we use them?
Dedicated application-specific firewall : Give the pro's and con's and describe what situation each of your chosen firewalls is best for.
Discuss levels of assurance that can provide on audit report : Discuss the levels of assurance that can be provided on audit reports. Explain how the internal controls of a company can impact the overall business.
Complete the excel worksheet as required in audit program : The sales journal, sales orders, shipping documents, invoices and price list are available on in canvas. Complete excel worksheet as required in audit program
Discuss evolving theme of awareness regarding discrimination : Discuss evolving themes of awareness regarding discrimination and the social divide that separated/separates Black US citizens from White US citizens.
Riders from various countries : A bicycle race, the Tour de Florida, which will have riders from various countries. Each rider will also be on a team. The teams will have a name
How much did her company pay for the blood pressure cuffs : A central supply clerk ordered 14 blood pressure cuffs. After 8% tax and $8.65 shipping, how much did her company pay for the blood pressure cuffs?
How much is magdalena basis in the inventory received : When Magdalena's outside basis is $58,000, she receives a liquidating distribution of $15,000 cash, How much is Magdalena's basis in the inventory received

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd