Internal audit plan template (Excel).
Build a risk-based annual audit plan: score your audit universe, see which areas are High risk or due, and plan the year with dates, team and hours. Free, no sign-up.
The columns, and what goes in each.
The workbook has two tabs. Audit universe lists every auditable area and scores it on five risk factors; the total and the rating calculate themselves. Annual plan turns the High and due areas into audits, with a total of budgeted hours to check against your team's capacity.
| Column | Tab | What to write |
|---|---|---|
| Auditable area, Owner | Audit universe | Each process, function or location you could audit, and who is accountable for it. |
| Financial, Regulatory, Fraud, Change, Control environment | Audit universe | Five risk factors, each scored 1 (low) to 5 (high). |
| Total score, Risk rating | Audit universe | Calculated: the sum of the factors, then High from 18, Medium from 11, else Low. |
| Audit every (months), Last audited | Audit universe | The audit cycle (12, 24 or 36 months) and when the area was last audited, to show what is due. |
| Ref, Audit, Auditable area, Risk rating | Annual plan | Each planned audit, linked to its area in the universe. |
| Quarter, Planned start, Planned end | Annual plan | When the audit runs. |
| Lead auditor, Team, Budget (hours) | Annual plan | Who does it and how many hours it may take. The hours total at the bottom. |
| Scope | Annual plan | What is in and out: period, locations, processes. |
| Status, Actual start, Actual end | Annual plan | Planned, Planning, Fieldwork, Reporting, Closed or Cancelled, with the real dates. |
| Change reason | Annual plan | After approval, why the plan changed and who approved it. |
One row, filled in.
Area: Procurement · Owner: Head of Procurement
Risk factors: financial 5, regulatory 3, fraud 5, change 3, control environment 4 · Total: 20 · Rating: High
Planned audit: IA-2027-01 Procurement and vendor management · Q1, 11 Jan to 19 Feb 2027 · 160 hours · Scope: vendor onboarding, purchasing and goods receipt, all sites.
How to build a risk-based audit plan in five steps
- List every auditable area in the Audit universe tab, with its owner.
- Score each area on the five risk factors, with input from management.
- Put every High area, and every area past its audit cycle, into the Annual plan.
- Add dates, the team and budgeted hours, and check the total against your capacity.
- Have the audit committee approve the plan, then record every change with its reason.
About internal audit plans.
What is a risk-based internal audit plan?
A plan that decides which areas to audit, and when, from an assessment of risk across the whole organisation (the audit universe), instead of auditing every area on a fixed rotation. The IIA Standards expect the chief audit executive to base the plan on a documented risk assessment and have it approved by the board.
What is an audit universe?
The list of everything internal audit could audit: processes, functions, locations, systems and projects, each with an owner and a risk rating. The annual plan is chosen from it.
How do you rate risk in the audit universe?
Score each area on a few factors, such as financial size, regulation, fraud exposure, recent change and the strength of controls, then add them up. This template uses five factors scored 1 to 5, so totals run from 5 to 25.
How often should each area be audited?
A common cycle is every 12 months for High risk areas, every 24 months for Medium and every 36 months for Low. Adjust it to your resources and to what your audit committee expects.
Is this audit plan template free?
Yes. Download it, change it and share it. No sign-up is needed.
Run the plan, not just the spreadsheet.
In Scrutive the universe, the approved plan and every audit's status stay connected, with a change log the committee can see.