Sales are shipped FOB shipping point with credit terms n/45. You have verified that the last shipping number used in 2009 was 261,336 and that numbers were used in numerical order. Tolerable materiality is set at $500,000 for account receivable. You have asked for and received the following files related to account receivable, along with a file containing confirmation results.

File Name and Description Data Elements

All unpaid invoices at 12/31/2009 Customer No.

Invoice Number

Invoice Date

Amount

Ship Date

NSG Shipping Invoice Number

(Shipping number for each unpaid invoice) Ship No.

NSG Credit Customer No.

(Credit limit for each customer) Customer No.

Credit Limit

NSG Confirmation

(Results of the confirmation process. Invoice Number

There are four different Confirmed (Amount confirmed)

Confirmation files A, B, C and D) Comment (Explanation of the results of the confirmation

Required:

Use ACL to perform, or help perform, the procedures in the following audit program

Develop and turn in audit documents in the following order (property index each document for cross-referencing purposes):

The audit program with your initial and references filled in for each procedure.

A memo summarizing the results of the procedures (including the dollar impact of actual or potential misstatements) and identifying any additional procedures the results indicate should be performed. Be sure to provide cross- references to supporting printout and other documents

Appropriate printout that contain handwritten narrative explanations of each printout and its significance. Be sure to develop dollar information appropriate to each procedure to help identify the significance of any findings. Do not print out the entire Accounts Receivable or any related file. Extract only the items of significance.

Procedure Done by W/P Ref.

1. Foot the file and agree to the general ledger

2. Check for duplicate invoice numbers in the unpaid invoices and shipping files

3. Age the unpaid invoices and identify any unpaid invoices older than 45 days

4. Identify any customer balances that exceed the credit limit or for which there is no credit limit. (Customer number must be in ASCII format)

5. Perform a sales cutoff test

6. Determine if any customers have a negative balance and consider the need to reclassify those as liabilities.

7. Select a PPS (MUS) sample of unpaid invoices. Use tolerable misstatement (materiality) of $500,00 expected misstatement of $75,000 and a TD risk of 10%. There are four different files of confirmation results: A, B, C, and D. Your instructor will assign files to the class members. Combine the confirmation file with the sample file to determine the results of the confirmation process. Determine any misstatements and project the misstatements to the population.

8. Summarize the results of the above procedures and identify additional procedures those results indicate should be performed.

Posted Date: 11/14/2013 9:03:11 PM | Location : United States

Ask an Expert

Related Discussions:- ACL Case 3, Assignment Help, Ask Question on ACL Case 3, Get Answer, Expert's Help, ACL Case 3 Discussions

Write discussion on ACL Case 3
Your posts are moderated

Write your message here..

Related Questions

Auditors procedures after stock taking, Auditors Procedures After Stock Tak... Auditors Procedures After Stock Taking It is particularly a follow up exercise and it includes: 1) Checking the cut off along with the details of last numbers of stock move

What is an audit and why there is need for an audit, Question: (a) What... Question: (a) What is an audit? Why there is need for an audit? (b) Explain the steps the auditor must take before deciding whether to accept the nomination as auditor. (

Share and deposits, Share and deposits Shares may consist of subscripti... Share and deposits Shares may consist of subscription shares and paid up shares. Interest on shares might be credited to the accounts rather than being paid to ensure proper co

Internal controls and process improvement, how do internal controls affect ... how do internal controls affect or improve the goals of a bussiness firm

Who is wal-mart''s external auditor?, Wal-Mart Locate the 2009 Form 10-K fo... Wal-Mart Locate the 2009 Form 10-K for Wal-Mart in Appendix A and consider the following questions: 1. With respect to the report of the external auditors to "the Board of Directo

Computation of significant ratios, Plz assist me with these questions Th... Plz assist me with these questions The auditors for Weston University are conducting their audit for the fiscal year ended December 31, 2011. Specifically, the audit firm is now

Audit Plan for small service company, only needs to be 2 - 3 pages and I ne... only needs to be 2 - 3 pages and I need help with an audit plan is to look like

Contingencies and provisions, Contingencies and Provisions (i) Receive... Contingencies and Provisions (i) Receive the client's schedule of provisions and seek and contingencies supporting documentation in the form of legal opinions, correspondence

Profesional ethic, Ask quesThe following situations involve a possible viol... Ask quesThe following situations involve a possible violation of the MIA ByLaws (on professional ethics, conduct and practice). For each situation, (1) decide whether or not the Co

Proxy, if a proxy is voted as per his judgement other than member prescribe... if a proxy is voted as per his judgement other than member prescribed to him... what is the action to be taken?