Free template

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.

Download the template (.xlsx)

What is inside

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).

ColumnPartWhat to write
Ref, Audit, Finding, RatingThe findingIts number, the audit that raised it, a short title, and High, Medium or Low.
CriteriaThe findingThe policy, standard or expectation that applies.
ObservationThe findingWhat you found, with numbers: how many, how much, which sample.
Root causeThe findingWhy it happened.
ImplicationThe findingWhat could go wrong if it is not fixed.
RecommendationThe findingWhat should be done.
Management response, Action owner, Target dateThe actionThe agreed action in management's words, one named owner and a due date.
StatusFollow-upDraft, Open, Implemented, Closed or Risk accepted.
Evidence, Verified by, Verified onFollow-upWhat the owner provided, and the auditor (not the owner) who checked it.
Days overdueFollow-upCalculated for open findings past their target date.
Worked example

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

  1. Write each finding with criteria, observation, root cause and implication, using facts and numbers.
  2. Agree the action, one owner and a realistic date with management before the report is final.
  3. Ask owners to report when an action is done, and set the status to Implemented.
  4. Check the evidence yourself, then close the finding and record who verified it and when.
  5. Before every audit committee meeting, filter on Days overdue and escalate what is late.
Questions and answers

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.

WhatsApp