Acl to perform audit procedures in audit program, Auditing

Assignment Help:

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.


Related Discussions:- Acl to perform audit procedures in audit program

Objectivity - external auditor report, Objectivity - External Auditor Repor...

Objectivity - External Auditor Report Many accounting figures are subjective and contain substantial terms of subjective judgment.  Many more business transactions have financ

IDEA auditing software edition 8, The first work you do in IDEA IS SECTION ...

The first work you do in IDEA IS SECTION 2.5. The accounts receivable folder that you are instructed to select on page 25 is a folder that you are to create previously on page 23.

Reserves - audit process, Reserves - Audit Process Movements in reserv...

Reserves - Audit Process Movements in reserves need disclosure in the balance sheet, the loss and profit account, the director's reports or in the notices to the accounts. The

audit tests and recording items in the audit, With reference to the case s...

With reference to the case study business, identify appropriate audit tests to be carried out. Prepare a statement of the work to be carried out and the manner in which it will be

Define master data management, (a) Define each of the following four concep...

(a) Define each of the following four concepts. -Master Data Management -Data Quality -Data Governance -Cloud Computing Explain how they relate to the various Busine

Roles of the auditor, What is the role of the auditor, and what are the key...

What is the role of the auditor, and what are the key duties the auditor must carry out? Role of the Auditor In modern commercial environmental it is desirable that bus

How do internal auditors add to the credibility of financial, How do intern...

How do internal auditors add to the credibility of financial statements?

Higher normal risk, Higher  normal risk Several audit assignments invo...

Higher  normal risk Several audit assignments involve high audit risk and usually in any client there will always be at least one high risk area.  Indications that an audit has

Procedures in computing the work of the expert, Procedures in computing the...

Procedures in computing the work of the expert The auditor must obtain reasonable assurance that the expert's work constitutes appropriate audit evidence in support of the fina

Write Your Message!

Captcha
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