Free Template · from the makers of NominalQC, QC software for small manufacturers
Free ISO 9001:2015 internal audit checklist for Excel
Your whole internal audit program in one workbook: a schedule that numbers audits and counts their open findings live, a printable checklist whose 19 questions are written the way a working auditor actually asks them (trace one job, walk the red bins, pick one order), and a findings tracker that carries every NC to verified closure.
Related: Layered process audits (LPA) — the practical CQI-8 guide
This log, without the spreadsheet
NominalQC runs layered process audits on a cadence — rotating assignments, email reminders, owned findings, and a live compliance dashboard.
Try the live demoOpens on the real app with seeded data · no signup, no email · read-only · from $29/mo when you’re ready.
Free template — no email, no signup.
Prefer it in your inbox, with two short notes on using it?
What’s in the download
- Annual schedule with auto audit numbers (IA-0001…), clause coverage, auditor/auditee, and status
- Live open-findings count per audit, pulled from the findings sheet automatically
- 19-question printable process-audit checklist with ISO 9001:2015 clause references — written as working auditor questions, not standard-parroting
- Result dropdowns (Conforms / Minor NC / Major NC / OFI) with color coding and an objective-evidence column
- Findings tracker: classification, owner, CAPA reference, due dates, OVERDUE flags, closure and verification
- Auditor and process lists editable on CONFIG — with the §9.2.2c reminder that auditors don’t audit their own work
- 100% macro-free — works in Excel 2010+ on Windows and Mac, no security prompts
The zip contains the workbook (.xlsx) and a README quick-start. Sample audits and findings are included so you can see it working.
Where this spreadsheet breaks
A yearly audit finds what a yearly look can find. The gaps live in the other 51 weeks:
1.The audit is an annual event, not a habit
One deep audit a year means problems get up to twelve months of head start — and audit week becomes theater everyone prepares for.
NominalQC runs layered process audits — short, frequent, rotating checks by supervisors and managers on a cadence — so auditing becomes a weekly rhythm instead of an annual siege.
2.Findings fade after the report
The findings sheet is honest in April and forgotten by June. Verification "when someone gets to it" is how repeat findings happen.
In NominalQC audit findings are records with owners: creation emails the work-center owner, aging findings escalate automatically, and closure requires verified corrective action.
3.Scheduling and nagging is a job nobody has
The schedule sheet doesn’t remind anyone. Audits slip quietly, and coverage gaps only show when the registrar asks.
NominalQC assigns audits by rotation, emails reminders when they come due, and shows schedule adherence per layer on the compliance dashboard.
Who built this
I spent 16 years in manufacturing quality — machining, fabrication, assembly — and in every shop I ended up building the same Excel tools with macros because the software budget went elsewhere. These workbooks are the ones I kept rebuilding. Eventually I stopped rebuilding spreadsheets and built NominalQC instead — but the spreadsheet is still the right starting point for a lot of shops, so here they are, cleaned up and free.
Questions
Is it really free?
Yes. You get the full workbook and the setup guide in exchange for an email address. Two short follow-up emails about running the process, then silence — unsubscribe anytime.
Does it work on Mac or older Excel?
Yes — this workbook is 100% macro-free, so there’s no "Enable Content" prompt and it works in Excel 2010 or later on Windows and Mac.
Do I have to audit every clause every year?
No — ISO 9001 §9.2 requires a program at planned intervals that covers the QMS over time, weighted by importance and prior results. Most small shops audit process-by-process across the year (that’s what the schedule sheet models) with each audit sampling the clauses that matter to that process. Trouble areas get audited more often; that risk-based weighting is exactly what a registrar wants to see.
Can I change the lists and dropdowns?
Yes — every dropdown pulls from the CONFIG sheet (your people, work centers, categories), and it’s all editable with no code involved. That’s the point: it should match your process, not ours.
More free templates
Ready to skip the spreadsheet stage?
Inspections, NCRs, CAPAs, LPAs, and gauge calibration — from $29/month flat, unlimited users.
Start your free trial