Audit Sampling

An Excel add-in for reproducible statistical sampling: monetary unit sampling and random sampling, each written to a complete, formula-driven workpaper.

Open it in Excel

  1. Open a workbook in Excel for Windows, Mac or the web.
  2. On the Home tab choose Add-ins, then Audit Sampling (under Admin Managed if your organisation deployed it).
  3. Use the Audit Sampling ribbon tab: MUS sample or Random sample.

Read the sampling guidance (PDF)

Audit Sampling

Reproducible statistical selection

Population

Selection

No range selected

Data rows
—
Columns
—
Header row
—
Amount
—

Select the ledger in the worksheet, including its header row.

Method

Opens the parameters. Nothing is written until you draw.