Audit findings tracker template (Excel).
Track every audit finding from observation to verified closure, with the owner, target date and days overdue calculated for you. Free, no sign-up.
The columns, and what goes in each.
One row is one finding. The columns follow how a finding is written (criteria, observation, root cause, implication, recommendation) and then how it is followed up (response, owner, date, status, evidence and verification).
| Column | Part | What to write |
|---|---|---|
| Ref, Audit, Finding, Rating | The finding | Its number, the audit that raised it, a short title, and High, Medium or Low. |
| Criteria | The finding | The policy, standard or expectation that applies. |
| Observation | The finding | What you found, with numbers: how many, how much, which sample. |
| Root cause | The finding | Why it happened. |
| Implication | The finding | What could go wrong if it is not fixed. |
| Recommendation | The finding | What should be done. |
| Management response, Action owner, Target date | The action | The agreed action in management's words, one named owner and a due date. |
| Status | Follow-up | Draft, Open, Implemented, Closed or Risk accepted. |
| Evidence, Verified by, Verified on | Follow-up | What the owner provided, and the auditor (not the owner) who checked it. |
| Days overdue | Follow-up | Calculated for open findings past their target date. |
One row, filled in.
Finding: Overtime paid without line-manager approval · Rating: High
Criteria: Payroll policy 4.2: overtime is paid only with the line manager's approval. Observation: 14 of 40 overtime claims in the sample were paid without approval. Root cause: the payroll system does not block unapproved claims.
Response: Agreed; approval becomes a required field from January · Owner: Finance Controller · Target date: 31 Dec 2026 · Status: Open
How to track findings to closure in five steps
- Write each finding with criteria, observation, root cause and implication, using facts and numbers.
- Agree the action, one owner and a realistic date with management before the report is final.
- Ask owners to report when an action is done, and set the status to Implemented.
- Check the evidence yourself, then close the finding and record who verified it and when.
- Before every audit committee meeting, filter on Days overdue and escalate what is late.
About tracking audit findings.
What should an audit finding include?
Five parts are standard: the criteria (what should happen), the condition or observation (what actually happens), the root cause, the implication or effect, and the recommendation. Add the management response, an action owner and a target date once they are agreed.
Who can close an audit finding?
Internal audit, after checking the evidence. The owner reports that the action is done, but closure should come from someone independent of the owner, so the tracker records who verified it and when.
What does Risk accepted mean?
Management has decided not to act on the finding and accepts the risk. The IIA Standards expect the chief audit executive to discuss it with senior management and, if the risk is beyond the organisation's appetite, to report it to the board.
How do I report overdue audit findings?
Filter the tracker on Days overdue, group by owner or rating, and report the list to the audit committee every quarter with the reason each is late.
Is this findings tracker free?
Yes. Download it, change it and share it. No sign-up is needed.
Stop chasing owners by email.
In Scrutive every agreed action goes to its owner with a one-click confirmation before the date, and only an independent verifier can close it.