Excel template
IATF 16949 Process Audit System
164-question manufacturing process audit (clause 9.2.2.3) with grade, findings, actions, audit log and programme in Excel
IATF 16949 manufacturing process audit in Excel (clause 9.2.2.3): 164 original questions in 16 process elements, three audit depths, scoring for up to 10 process steps, compliance %, grade A / B / C with the reason, findings linked to actions, a 200-row audit log and a risk-based audit programme. Example and blank file, no macros.
- 164 original questions in 16 process elements, with what-to-look-for hints and IATF clauses
- Three depths: Full (164), Core (about 55, one day) or KEY only (26)
- Scores for up to 10 process steps, compliance %, grade A / B / C with the reason
- Every score of 8 or lower lands in Findings, linked to an action, with a NO ACTION flag
- 100-row action plan, 200-row audit log and a risk-based audit programme
- Example audit with 18 earlier audits in the log, plus a blank file
Secure checkout by Polar. Digital download: at checkout you agree to immediate delivery and waive the 14-day withdrawal right, so downloads are not refunded. Support: info@qmbench.com.
Free alternativeTry the free online tool firstThe free IATF 16949 Internal Audit on QM Bench runs in your browser with a PDF report. The template is for a file you keep, edit and fill with your own data.Open the free toolWhat is inside
- 1
Start Here
How to use, scoring scale, grading rules and how to extend the file.
- 2
Audit Report
Header, audit depth, shifts audited, 10 process steps, automatic result, log line, agenda, summary and sign-off.
- 3
Checklist
164 questions in 16 process elements, 2 spare rows per element, 26 KEY questions, scoring per process step.
- 4
Dashboard
Compliance, grade with reason, Major / Minor / OFI, NC without action, overdue actions, element and step scores, 4 charts.
- 5
Findings
Every question scored 8 or lower, with the linked action and a NO ACTION flag.
- 6
Action Plan
100 rows: pick the Q-ID, add root cause, containment, corrective action, owner, dates and effectiveness. Overdue turns red.
- 7
Audit Log
One line per audit, 200 rows, trend per process.
- 8
Audit Programme
Risk-based annual plan; planned months turn green when the audit is logged; shift coverage and status.
Try the template in your browser
The same scoring and grading rules as the Excel file. Change a score and watch compliance, the grade and the reason for a downgrade.
DemoIllustrative preview with example data, not the template itself. The Excel file has more rows, tabs, charts and checks.
| Element | Question | Score | Result |
|---|---|---|---|
| Input ★ | Incoming material is identified and released before use. | Conform | |
| Set-up ★ | First-part approval is documented before series production. | Conform | |
| Process ★ | Process parameters are monitored against the control plan. | OFI | |
| Gauges | Gauges at the station are calibrated and labelled. | Conform | |
| NOK parts | Rejected parts are segregated and clearly marked. | Minor NC | |
| 5S | The workplace is clean and orderly. | OFI |
The workbook has 164 questions in 16 elements, three audit depths, 10 process steps, findings linked to actions, audit log and programme.
Audit depth to fit the day
Run all 164 questions, the core set of about 55 for a one-day audit, or the 26 KEY questions for a quick check. The result and grade follow the depth you picked.
A grade you can explain
10 met, 8 OFI, 6 / 4 Minor NC, 0 Major NC. Grade A from 90 %, B from 80 %. Any question at 0 caps the grade at B, a KEY question at 4 or lower caps at B, a KEY question at 0 gives C, and the dashboard names the reason.
No finding without an action
Every nonconformity appears in Findings and must be linked to an action by its Q-ID; open findings without an action are flagged, overdue actions turn red.
Programme and log in the same file
Log each audit with one line; the risk-based programme marks the month green and shows shift coverage, so you see what is done and what is behind.
Who it is for
- Process quality engineers and internal process auditors
- Quality managers preparing for IATF 16949 certification audits
- Suppliers running customer or supplier process audits
Not included
- The IATF 16949 or VDA 6.3 standard text (all questions are original wording)
- Certification or consulting
- Macros, VBA or add-ins
Details
- Format
- Microsoft Excel .xlsx, 2 files, 8 tabs
- Works in
- Excel 2010 or newer, Microsoft 365, Excel for Mac, LibreOffice Calc
- Macros
- None
- Questions
- 164 in 16 elements (26 KEY, about 55 core), 2 spare rows per element
- Capacity
- 10 process steps per audit, 100 actions, 200 audits in the log
- Standard
- IATF 16949:2016 clause 9.2.2.3 with ISO 9001:2015 references
- Licence
- Single company or site
- Delivery
- Instant download after payment
Frequently asked questions
›Where do I buy it?
Here on QM Bench with the Buy button: secure card checkout by Polar with a receipt, and the two Excel files arrive by e-mail right after payment.
›Is this a VDA 6.3 audit?
No. It is a manufacturing process audit for IATF 16949 clause 9.2.2.3 with original questions. For VDA 6.3 use the free VDA 6.3 tool on QM Bench.
›How do I run the next audit?
Save a copy, clear the Checklist and Audit Report inputs; the audit log and the programme stay.
›Can I get a refund?
No. It is a digital download: at checkout you agree to immediate delivery and waive the 14-day right of withdrawal, and the file stays with you. If something does not work as described, write to info@qmbench.com and you will get help or a corrected file.
Get the IATF 16949 Process Audit System
Instant download by e-mail after payment. Paste your measurements and read the verdict.
Buy now · €21Or try the free online tool first →