This is not the document you are looking for? Use the search form below to find more!

Report home > Others

Audit Sampling with ACL

0.00 (0 votes)
Document Description
Audit Sampling with ACL
File Details
  • Added: April, 26th 2011
  • Reads: 650
  • Downloads: 11
  • File size: 147.69kb
  • Pages: 15
  • Tags: english, sampling, acl, audit, software
  • content preview
  • Name: sebestyen
Embed Code:

Add New Comment

Related Documents

REIT Auditor Fees and Financial Market Transparency

by: samanta, 57 pages

This paper examines the relationship between over-investment in audit services, abnormal non- audit fees paid to the auditor, and market-based measures of firm transparency. REITs provide a uniquely ...

Aircraft Corrosion & Engine Inspection

by: Mark Jones, 4 pages

RVI Ltd offers Remote Visual Inspection, Video Borescopes Inspection, Aircraft Maintenance & Engine Inspection and internal audit services with best and up to date equipments.

GAO-09-468 DCAA Audits: Widespread Problems with Audit Quality ...

by: tegan, 153 pages

GAO found audit quality problems at DCAA offices nationwide, including compromise of auditor independence, insufficient audit testing, and inadequate planning and supervision. GAO's conclusions stem ...

Ruminative Self-Focus and Negative Affect: An Experience Sampling Study

by: shinta, 10 pages

The authors conducted an experience sampling study to investigate the relationship between momentary ruminative self-focus and negative affect. Ninety-three adults recorded these variables at ...

Department of Human Resources Payroll Accounting and Processing Audit Final Report : August 2009

by: shinta, 20 pages

The Internal Audit Office performed an audit of Payroll Accounting and Processing as part of our Annual Audit Plan. Payroll processing involves paying county employees for their services ...

The Effects of Endogenous Information Acquisition about Business Risk on Audit Pricing

by: shinta, 25 pages

This paper examines the pricing of business risk by homogeneous auditors in a two-period model. Incumbent auditors optimally determine the amount of information to acquire about the ...

Engagement Risk: Perceptions And Strategies From Audit Partners

by: shinta, 8 pages

The audit function creates several important relationships among the various parties. One of the significant and potentially problematic relationships is between the audit firm and the audit ...

Porter County Destination Audit and Product Positioning Analysis

by: samanta, 7 pages

Similar to destinations around the country, Porter County faces a tourism environment with rapidly escalating competition and an increasingly demanding consumer marketplace. Given this ...

The Impact of Enterprise Risk Management on the Internal Audit Function

by: samanta, 28 pages

This exploratory study provides evidence about factors associated with the overall impact of enterprise risk management (ERM) on the internal audit function's activities. Based on responses from 122 ...

Risk Management and Ethical Environment: Effects on Internal Audit and Accounting Control Procedures

by: samanta, 20 pages

This study examines the impact of the scope of risk management and ethical environment on internal audit activities and the quality of accounting control procedures (ACPQ). The conceptual framework ...

Content Preview
Audit Sampling with ACLWhen and why would you sample in audit?Basically, you can expect to sample whenever you:•need to make an estimate concerning some large set of transactions, and•cannot find a more cost-effective way to arrive at the number.If the data you are using are 100% digital, then typically you can review the entire database using ACL commands in less time than it would take to pull a sample from manual files. Instead of testing 500 transactions by hand, you can get an exact answer for 5,000, 50,000, or 5 million transactions, with far less effort.However, if the data are only available in paper files, or if they require a great deal of processing for each item, such as generating confirmation letters or checking actual inventory, then sampling may be faster and cheaper.The key to this more complex approach is the idea of ‘tolerable errors’.Instead of doing a calculation that only works when no errors are found, ACL can collect some additional information before starting, then compute a sample confidence level that allows for up to a certain number of errors.So long as the tolerable number of errors is not exceeded, the sample confidence level can be treated as the population confidence level.To accomplish this, ACL asks for an estimate of the expected error rate (EER) in the population and for the upper error limit (UEL) that you will accept within your confidence level.For example, you might expect an error rate of 1% and, at the same time, want to be 95% confident that the error rate does not exceed 2%.The key item that ACL delivers using your estimate of the EER and UEL is the number of tolerable errors, the number of errors that a sample can contain without forcing a recalculation of the number of errors in the population based upon the actual number of errors in the sample.In general, the EER can be based on similar sampling projects in the past or interviews with the staff whose data you are sampling. The UEL is more difficult to choose and has a much bigger potential impact on the amount of work you must do. Consider these case parameters:population = 12,000EER = 1%sample confidence level = 95%Given these parameters, if you enter 2% for the UEL into ACL, the required sample size is given as 593 records. If you enter 1.5%, the required sample size is 1,700 records. Clearly, the UEL has a significant impact on the work involved in sampling, so to make choosing a UEL easier, ACL allows you to recalculate various values for the UEL before saving the result. This is sometimes necessary because your first estimates of the sample confidence level and the UEL may lead to an impractical sample size. By helping you choose an appropriate UEL and the sample size required to stay within that limit, ACL can alleviate the need for a recalculation by ensuring the sample and population confidence levels will be the same.ACL does not use the binomial distribution:In general, a binomial equation describing the outcome of n events (or records) will have n + 1 terms, and each term will involve multiplying probabilities to the power n. So the total computations are equal to n(n + 1).As n increases in value, the equation quickly becomes impractical because there are too many terms to compute.As the number of events grows, the number of computations required to solve the theorem increases geometrically.ACL does use the Poisson distribution:approximation to the binomial equation for very large sets that did not depend on the population size, N. Instead, it depended on the total number of expected successes, v, which is obtained by multiplying the population size, N, by the probability of success, p.It must be pointed out, however, that though Poisson is the method of choice, it does have a significant shortcoming.For small data sets, using the Poisson distribution leads to unnecessarily large sample sizes, mainly because it does not consider population size.In extreme cases, for a given sample confidence level, the Poisson distribution might indicate double the number of sample items than the binomial approach.The cost of pulling so many items for review can be substantial.Poisson may even require a sample size greater than the entire population, which is, of course, impossible.It is a fair question to ask why ACL chose Poisson as its formula for sampling given this shortcoming.The main reason is that the Poisson distribution can cover the whole range of possible values, while it becomes impossible to use the binomial distribution beyond a very limited range of cases. If you must choose one method for all statistical sampling, the Poisson distribution is the only available tool.And Poisson’s tendency toward large sample sizes can also be considered an advantage because there are good reasons to exceed minimum sample sizesThe simplest form of sampling, which is called record sampling in ACL, each transaction has an equal chance of being chosen.If there’re many low-value transactions, the resulting sample has a disproportionate number of small items, and you wind up with not enough useful information about the high-value items.The solution is the monetary unit sampling (MUS), sometimes called probability proportional to size (PPS) sampling. The MUS method counts each dollar of each transaction as a sample unit. It ensures that items of high value are given greater weight than items of low value because the high-value items have more dollar-units.Document Outline
  • ÿ
  • ÿ
  • ÿ
  • ÿ
  • ÿ
  • ÿ
  • ÿ

Audit Sampling with ACL



Your download will begin in a moment.
If it doesn't, click here to try again.

Share Audit Sampling with ACL to:

Insert your wordpress URL:


Share Audit Sampling with ACL as:



Share Audit Sampling with ACL.

Enter two words as shown below. If you cannot read the words, click the refresh icon.


Share Audit Sampling with ACL as:

Copy html code above and paste to your web page.