Stratified sample selector by dollar threshold.

How many items do I need to look at, and which ones?

Paste a population, test every item above a threshold, and pick the rest at random by stratum. See the items, the dollars and the coverage you get.

  • Runs in your browser
  • Nothing stored or sent
  • Free, no sign-up
Population
Strata and sample
Same seed and inputs give the same selection. Keep the seed in the workpaper.
Items selected
9 of 15
60% of items
Dollar coverage
90.8%
$389,221 of $428,756
Not selected
$39,535
Remaining population value
Strata and coverage
StratumRangeItemsValueSelectedSelected valueValue covered
Stratum 1: key items (100%)$50,000 and over3$334,6613$334,661100%
Stratum 2: middle$5,000 to under $50,0006$88,1753$51,90058.9%
Stratum 3: low value$0 to under $5,0006$5,9203$2,66044.9%
Total15$428,7569$389,22190.8%
Items selected
Stratum 1  INV-1001  $184,200.00
Stratum 1  INV-1002  $96,450.50
Stratum 1  INV-1005  $54,010.00
Stratum 2  INV-1008  $18,900.00
Stratum 2  INV-1011  $7,600.00
Stratum 2  INV-1014  $25,400.00
Stratum 3  INV-1009  $1,350.00
Stratum 3  INV-1013  $980.00
Stratum 3  INV-1015  $330.00

Lists the first 500 rows; the CSV holds every selected item.

How this was worked out
Work shownrecomputed as you type
Each item goes to the highest stratum whose starting amount is at or below its absolute value.
Stratum 1: all 3 items selected. Strata 2 and 3: a seeded simple random sample without replacement (capped at the stratum size).
Dollar coverage = selected value ÷ population value = $389,221 ÷ $428,756 = 90.78%

Selecting every item above a threshold and sampling the rest is the approach AU-C 500 describes for items that are individually significant or high risk, and AU-C 530 describes stratification as a way to make the remaining population more homogeneous. Coverage is not an evaluation: sample results still need to be projected to the stratum they came from. Sample sizes per stratum are your judgment or come from your sampling plan.

Stratification and key items in the audit file

Stratifying a population means splitting it into groups so that each group is more uniform than the whole. In a dollar-based split the largest items form a stratum the auditor tests in full (key items), and smaller items are sampled. AU-C 500 describes selecting all items when the population is made up of a small number of large items or when an item is individually significant, and AU-C 530 describes stratification as a way to improve efficiency and to direct the sample toward the larger or riskier items.

Coverage is reported two ways. Item coverage is the share of items you will touch. Dollar coverage is the share of the population value in the selected items, which is usually the number a reviewer asks about. Each stratum other than the top one is drawn at random without replacement from a seed you can record. Results from a sample must be projected to the stratum it came from, and the key-item stratum is tested with no sampling risk. How many to take from each stratum is your judgment or comes from your sampling plan.

Common questions

What is stratified sampling in an audit?

The population is divided into strata, here by dollar amount, and each stratum is tested differently. Typically all of the largest items are examined and the smaller strata are sampled, which gives high dollar coverage from a manageable number of items.

Why test every item above a threshold?

Large items carry the most risk of material misstatement and are cheap to cover by item count. Examining them all removes sampling risk for that part of the population, so the sample only has to represent the rest.

How many items should I take from each stratum?

This tool does not set sample sizes. Use your firm's sampling plan, or the audit sample size and monetary unit sampling calculators, and enter the number you decided for each stratum.

How are credits and negative amounts treated?

By absolute value, so a credit counts toward its stratum and the dollar total instead of netting against debits. Check the strata against how your population was defined.

Do I project results from each stratum separately?

Yes. Misstatements found in a sampled stratum are projected to the population of that stratum, and the projections are added to the misstatements found in the key items. The total is then compared with tolerable misstatement.

Runs in your browser. The figures you type are not sent to CORAA or stored. Check the result against your firm's methodology before relying on it.

Related audit calculators

For US CPA firms

Join the CORAA waitlist

CORAA AI drafts audit working papers from your client’s QuickBooks books and does the first pass: lead schedules, tie-out, memos, draft notes and letters. CORAA Network reviewers clear every finding. Your firm reviews and signs.

  • First audit free, so you can judge the quality on a real file
  • Flat fee by entity size; messy books included
  • We work only with CPA firms, never their clients
See how it works →

* required