Monetary unit sampling Excel template: free download
This monetary unit sampling Excel template is free and needs no sign-up. Paste the population, type tolerable misstatement, expected misstatement and confidence, and the workbook works out the sample size, the sampling interval, the selected items and, once you enter the differences found, the upper misstatement limit. Its results match the AuditSampler Pro engine.
Updated 10 November 2026
What the template includes
| Sheet | What you do | What it works out |
|---|---|---|
| Instructions | Read the six steps | – |
| Population | Paste ID and amount | Cumulative totals, top-stratum items and excluded items (amount ≤ 0) |
| Parameters | Tolerable and expected misstatement, confidence and random start | Book value, confidence and expansion factors, size, interval and checks |
| Selection | Nothing | Selection points, the item holding each point, repeats and top stratum |
| Evaluation | Book and audited value of items with differences | Tainting, projection, basic precision, incremental allowance, upper limit and conclusion |
Input cells are yellow with blue text; everything else is a formula. It only uses Excel 2007 functions (COUNTIF, INDEX, LARGE, CHIINV), so it behaves the same in Microsoft 365, in older versions and in LibreOffice.
How to use it, step by step
- Paste the population on the Population sheet from row 2: ID in column A and amount in column B, replacing the example. Items with a zero or negative amount are excluded and tested separately.
- Agree the book value on the Parameters sheet to the ledger. The check on row 12 says OK when the cumulative total matches.
- Type the parameters: tolerable misstatement, expected misstatement and confidence (90, 95 or 99 %, or another level from the expansion factor table). The sheet works out the confidence factor, expansion factor, size and interval.
- Fix the random start. In a spare cell type
=RAND()*interval, copy the result and paste it as a value on Parameters. Record it in the working paper: with it anyone can re-perform the selection. - Review the selection. The Selection sheet lists the points and the item holding each one, and flags repeats and top-stratum items.
- Evaluate. Enter the items with differences on the Evaluation sheet. It projects each one, works out the upper misstatement limit and compares it with tolerable misstatement.
The example in the template
The template comes filled in with the 12 invoices from the audit sampling in Excel guide, so you can see the format before pasting your data:
| Item | Value |
|---|---|
| Book value | 144,600 |
| Tolerable / expected misstatement | 70,000 / 5,000 |
| Confidence; confidence and expansion factors | 95 %; 3.00 and 1.6 |
| Sample size: 144,600 × 3.00 ÷ (70,000 − 5,000 × 1.6) | 7 |
| Sampling interval | 20,657.14 |
| Random start | 7,413 |
| Selection points / distinct invoices | 7 / 6 |
| Basic precision (3.00 × interval) | 61,971.43 |
| Projected overstatement | 713.14 |
| Incremental allowance | 309.86 |
| Upper misstatement limit | 62,994.43 |
Invoice INV-005 (52,300) gets two points and, like INV-011, exceeds the interval: both are top-stratum items and their differences count as they are, without projection. INV-002 has a 2 % tainting, projected over the interval. INV-007 is an understatement: it is projected and reported (631.44) but not deducted from the limit. Since 62,994.43 does not exceed tolerable misstatement of 70,000, the result is acceptable.
What it does the same as the program, and what it can't
We checked the template against the AuditSampler Pro statistics engine with the example and with a random population of 4,000 items that included zero and negative amounts: the size, the interval, the selected items and every evaluation figure match. What a workbook cannot do is record who changed a cell, or stop the random start from being regenerated until a convenient sample comes up. That is why the start is pasted as a value and recorded, and why it is worth protecting the sheet before handing it over. What should be on file is covered in the audit sampling documentation guide.
The template is provided as is, without warranty. The auditor is responsible for the design, performance and conclusion of the sample under ISA 530.
Frequently asked questions
Where can I download a monetary unit sampling Excel template?
On this page, with the Download the template button. It is a free .xlsx with no sign-up and five sheets: instructions, population, parameters, selection and evaluation.
Does the template work out the sample size?
Yes. From book value, tolerable misstatement, expected misstatement and confidence it works out the AICPA confidence factor (3.00 at 95 %), the expansion factor and the size: book value × confidence factor ÷ (tolerable − expected × expansion factor), rounded up.
Does it work in older Excel or LibreOffice?
Yes. It only uses functions available since Excel 2007, with no XLOOKUP or dynamic arrays, and it recalculates in LibreOffice without errors.
How does the template stop the selection from changing by itself?
There is no RAND in its formulas: the random start is generated once, pasted as a value on the Parameters sheet and recorded in the working paper. As long as that cell and the population stay the same, so does the selection.
Can I use it for attribute sampling?
No, it is for monetary unit sampling only. For attribute sampling, the attribute sampling guide has a calculator for sample size and the upper deviation limit.
- AICPA, Audit Guide: Audit Sampling (confidence and expansion factors)
- IAASB, ISA 530 Audit Sampling
- IAASB, ISA 230 Audit Documentation
The same sample, with a working paper
AuditSampler Pro runs these steps on the same Excel or CSV file, keeps the starting point of every selection and produces the working paper as a PDF.