Skip to content
Shop | Excel tracker

Internal Audit Program Planner

Score every process for risk, let class and frequency calculate, plan the audits of the year with a chart per month and keep the findings with grades, owners and dates in one list.

Screenshot of the Internal Audit Program Planner workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: the site, the size of the program, the hours per audit, the internal rate and the thresholds for the risk classes.
  2. 03 Processes: one row per process of the scope. Score five criteria from 0 to 4. Class and frequency calculate.
  3. 04 Program: place every audit in a month, name the lead and the second auditor, check independence.
  4. After each audit: status Done, the number of findings, and the findings themselves in 05 Findings.
  5. 06 Status every quarter with the program owner and once a year with management.

Definitions used in the workbook

  • Internal audit: A planned, independent comparison between how a process is supposed to work and how it works today, based on evidence.
  • Risk score: Customer impact, defect history, change activity, complexity and last audit result, each 0 to 4, added to 0 to 20.
  • Nonconformity: A requirement of the criteria is not met, and the evidence shows it.
  • Observation: The requirement is met, but the way it is met depends on luck, memory or one person.
  • Opportunity: Nothing is wrong. Something could be simpler, faster or safer.

Sheets in the workbook

  1. Start
  2. Setup
  3. Processes
  4. Program
  5. Findings
  6. Status

Who it is for

Quality and operations managers who want an audit program with a reason behind every audit.

The method behind the numbers

This workbook is part of the Internal Audits toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.