
The manager opens the sampling working paper and asks a perfectly reasonable question: “How were these items chosen?”
Silence.
The person who ran the selection is on another engagement. The workbook offers a column of reference numbers and a tab that has been renamed “Sheet4”. Everyone is keen to help. The evidence, sadly, has left the building, rather like the last biscuit in the tin.
Nobody was careless. The selection was made on a busy Tuesday and reviewed three weeks later, and a sample turns out to be only as defensible as the memory of the person who picked it.
That is the situation ISA 230 has in mind. An experienced auditor with no previous connection to the engagement should be able to see how the items were selected from the file alone. If the reviewer has to take it on trust, well, trust is lovely, but it is not audit evidence.
So, what can you do?
Keep a short record with every selection that the population agrees to the trial balance: where the population came from, which method you used and why, the sample size and any seed or threshold, and who ran it and when. Then try the colleague test: could someone who wasn’t there regenerate the same list from that page? If the answer involves phoning someone on leave, the record isn’t finished.
None of this needs specialist software. It just needs doing before the reviewer asks, not after.
This is where the Sampling Tool in the Audit Toolbar comes in.
It produces a dedicated sheet recording the inputs used for the selection, so the reviewer finds the answer on the page and not in someone’s head. J.P. Theron, Audit Senior at bk plus, put it this way:
“The sampling tool has been very useful, especially from a reviewer’s perspective, as it produces a sheet with all of the inputs used to select the sample. This is something we didn’t have previously and it has made reviewing much easier.”
And when the sample goes to the client, Email Sample sends only the selected items, with no inputs such as materiality. Prefer to check the sample first? Simply skip that step.
Of course, the sheet records what was done. Whether the method and sample size were right for the test is still the reviewer’s call, as it should be.
Interim audits are under way and year-end planning is next, so now is a good time to agree one sampling record for every team, well before the January rush. A template is much easier to settle in November than a mystery is in February.
Because the best answer to “how was this sample selected?” is the one the file gives before anyone asks.
Next week, we look at what happens once the sample is selected and the rows have to reach the client.
Until next time,
Christiaan
When the selection record lives in someone’s memory, the review depends on that person being available.
The Audit Toolbar’s Sampling Tool:
The auditor remains in control of the population, method and sample size, and judges whether they were appropriate. The tool simply makes the record more consistent and easier to review.
See the Sampling Tool run on a population like yours.
.png)


















































































.png)
.png)
.png)


.png)
.png)
.png)


Help your team work faster in Microsoft Excel without
sacrificing control, traceability, or audit quality.
Inspiration not perspiration with tips and insights to audit smarter, straight to your inbox.
You can unsubscribe at any time. We respect your information and won’t share your data with any 3rd parties. Learn more about our privacy policy.