How are the estimated audit hours calculated?

Questions planned x minutes per question / 60 x (1 + overhead and delay allowance), with the minutes and the allowance set on Setup. It is the Internal Audit Planning Time calculator's formula, where 5 minutes per question is a review rate of 0.2 questions per minute: the calculator's default example of 120 questions with a 10 percent allowance gives 11.0 hours in both. The example's eight-question production audit is estimated at 0.7 hours. The time standard is your own estimate, so the hours are a planning figure, not a measured time.

How is a finding's response due date set?

The audit's actual date plus the response days of the finding's grade on Setup: 30 days for a Major NC, 60 for a Minor NC and 90 for an OFI in the example. The minor NC raised in the design audit on 8 July 2026 was due on 6 September; with no closed date at the 9 October status date it reads Overdue. A finding due within the due-soon window (14 days) reads Due soon, and one with a closed date reads Complete, with Closed on time Yes or No.

How is programme completion measured?

Audits done with a planned date up to the status date, divided by all audits planned up to that date that are not cancelled. Audits planned later in the year do not count against you, and a postponed audit keeps counting against you until it is done or you re-plan its date. In the example 9 of the 10 audits due by 9 October are done, 90 percent against a 90 percent target, and the postponed CAPA audit planned for 22 September reads Overdue.

Does the template check auditor impartiality?

It checks the conflict a spreadsheet can see. Each process on Setup has an owner, and the Audit Programme's Check column reads 'Auditor owns this process' when the lead auditor is that owner. ISO 9001 asks for auditors to be selected so audits are objective and impartial, and ISO 19011 gives guidance on auditor selection; other conflicts, such as auditing your own manager's process, are not detected, so review the programme as well.

Are OFIs tracked like nonconformities?

Yes. An OFI is a grade with its own response time, 90 days in the example, so it gets a due date and counts in open findings, actions overdue and findings closed: 2 of the example's 4 overdue actions are OFIs. If your procedure does not ask for a response to OFIs, set a long response time for the OFI grade on Setup. Only Conforms results count as conforming, so an OFI also lowers the questions-conforming share.

What does conformance by clause section tell me?

The share of questions audited in each ISO 9001 clause section, 4 Context to 10 Improvement, that were marked Conforms; Not audited rows are left out. It shows where your checklist finds problems, not how effective the system is: a section with two questions swings between 50 and 100 percent on one result, and a checklist that avoids weak areas scores well. In the example 7 Support conforms on 14 of 19 questions, and three of its five findings concern gauges and calibration.

Does this replace a CAPA or NCR log?

No. The checklist records each finding, its owner, its due date and when it was closed. The root cause analysis and the action plan belong in your CAPA or NCR log, such as the CAPA and 8D Tracker or the Nonconformance (NCR) Log template; put the CAPA or NCR number in the checklist's Notes column to link them.

Quality Systems and Compliance

ISO 9001 Internal Audit Planner Excel Template

Plan the year's internal audits, record every question asked and its result, and see programme completion, conformance by clause section, open and overdue corrective actions and the audit hours still to plan.

Overview

This internal audit planner is a working Excel workbook for quality managers, management representatives and internal auditors who run an ISO 9001 internal audit programme, or one for IATF 16949 or AS9100, which build on ISO 9001. It ships with example data for Wexford Components, a fictional metal components maker: ten processes, four internal auditors, fourteen audits planned for 2026 and 54 checklist questions with 14 findings from the nine audits done by the status date, so the dashboard and charts are populated the moment you open it. The questions are written for this template and keyed to ISO 9001 clause numbers; the standard's text is not reproduced.

The Audit Programme holds one row per audit and the Audit Checklist one row per question asked. The workbook counts each audit's questions and findings from the checklist, estimates its hours as questions x minutes per question / 60 x (1 + allowance), the same formula as the Internal Audit Planning Time calculator on this site, and gives every finding a response due date from its grade. Everything is judged against a status date you type on Setup, never TODAY, so the file does not change between reviews. Programme completion is the share of audits planned up to the status date that are done, leaving out cancelled ones; findings closed is closed over raised, the Nonconformance Clearance Ratio calculator's ratio.

In practice, add checklist rows as you audit, type the closed date when an action is verified, and move the status date forward before each review. The example tells a typical story: 9 of the 10 audits due are done, with the CAPA audit postponed and now overdue; 74 percent of questions conform; and only 8 of 14 findings are closed, below the 80 percent target, with 4 actions past their response date. The radar shows which clause sections find problems, the findings-by-process chart shows where findings come from, and the by-process table shows when each process was last audited and what it raised, the history you need when you weight next year's programme by importance and earlier results.

What this template includes

Audit Programme table with one row per audit: audit number, process, lead auditor, planned and actual dates, status (Planned, Done, Postponed, Cancelled) and the number of questions planned
Per audit: the process owner from Setup, questions asked, major NCs, minor NCs and OFIs counted from the checklist, estimated audit hours and a due status in words (Complete, Overdue, Due soon, OK, Cancelled)
Audit Checklist table with one row per question asked: clause section, clause number, the question, the evidence seen and the result (Conforms, Minor NC, Major NC, OFI or Not audited)
Each finding gets an action owner, a response due date from its grade (30, 60 and 90 days in the example, set on Setup), an action status in words and whether it was closed on time
Check columns that name problems in words: an auditor auditing a process they own, a Done audit with no actual date or no checklist rows, a finding with no owner, a closed date before the audit or after the status date, a duplicate audit number
Dashboard with eight KPI tiles: audits done to date and findings closed against your own targets, actions overdue, audits overdue and open major NCs against a limit of zero, plus open findings, questions conforming and estimated audit hours still to do
Two native charts: conformance by ISO 9001 clause section (4 to 10) as a radar, and major NCs, minor NCs and OFIs by process as stacked bars, with clause-section and by-process tables that show when each process was last audited
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference (Self-check: PASS)
A CSV with live formulas of the Audit Checklist for any spreadsheet app; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to run the internal audit programme ISO 9001 clause 9.2 asks for, to record each audit's checklist and findings as you go, and to report programme status and open corrective actions at management review or to your certification body's auditor.

How to use it

On Setup, type the status date, your completion and findings-closed targets and the minutes per question, then replace the example processes (each with its owner), auditors and finding grades with their response days.
On Audit Programme, list the year's audits: audit number, process, lead auditor, planned date and the number of questions you plan to ask.
During each audit, add one row per question on Audit Checklist with the clause, the question, the evidence seen and the result, and give each finding an action owner.
Mark the audit Done with its actual date, type the closed date when each finding's action has been verified, and fix anything the Check columns report.
Before each review, move the status date forward and open the Dashboard for completion, overdue actions and conformance by clause section.

Frequently Asked Questions

How are the estimated audit hours calculated?: Questions planned x minutes per question / 60 x (1 + overhead and delay allowance), with the minutes and the allowance set on Setup. It is the Internal Audit Planning Time calculator's formula, where 5 minutes per question is a review rate of 0.2 questions per minute: the calculator's default example of 120 questions with a 10 percent allowance gives 11.0 hours in both. The example's eight-question production audit is estimated at 0.7 hours. The time standard is your own estimate, so the hours are a planning figure, not a measured time.
How is a finding's response due date set?: The audit's actual date plus the response days of the finding's grade on Setup: 30 days for a Major NC, 60 for a Minor NC and 90 for an OFI in the example. The minor NC raised in the design audit on 8 July 2026 was due on 6 September; with no closed date at the 9 October status date it reads Overdue. A finding due within the due-soon window (14 days) reads Due soon, and one with a closed date reads Complete, with Closed on time Yes or No.
How is programme completion measured?: Audits done with a planned date up to the status date, divided by all audits planned up to that date that are not cancelled. Audits planned later in the year do not count against you, and a postponed audit keeps counting against you until it is done or you re-plan its date. In the example 9 of the 10 audits due by 9 October are done, 90 percent against a 90 percent target, and the postponed CAPA audit planned for 22 September reads Overdue.
Does the template check auditor impartiality?: It checks the conflict a spreadsheet can see. Each process on Setup has an owner, and the Audit Programme's Check column reads 'Auditor owns this process' when the lead auditor is that owner. ISO 9001 asks for auditors to be selected so audits are objective and impartial, and ISO 19011 gives guidance on auditor selection; other conflicts, such as auditing your own manager's process, are not detected, so review the programme as well.
Are OFIs tracked like nonconformities?: Yes. An OFI is a grade with its own response time, 90 days in the example, so it gets a due date and counts in open findings, actions overdue and findings closed: 2 of the example's 4 overdue actions are OFIs. If your procedure does not ask for a response to OFIs, set a long response time for the OFI grade on Setup. Only Conforms results count as conforming, so an OFI also lowers the questions-conforming share.
What does conformance by clause section tell me?: The share of questions audited in each ISO 9001 clause section, 4 Context to 10 Improvement, that were marked Conforms; Not audited rows are left out. It shows where your checklist finds problems, not how effective the system is: a section with two questions swings between 50 and 100 percent on one result, and a checklist that avoids weak areas scores well. In the example 7 Support conforms on 14 of 19 questions, and three of its five findings concern gauges and calibration.
Does this replace a CAPA or NCR log?: No. The checklist records each finding, its owner, its due date and when it was closed. The root cause analysis and the action plan belong in your CAPA or NCR log, such as the CAPA and 8D Tracker or the Nonconformance (NCR) Log template; put the CAPA or NCR number in the checklist's Notes column to link them.