Excel + Google Sheets · Free version available · No macros

Quality & Audit Pack: Internal Audit, CAPA, FMEA, Supplier Scoring (Excel Templates)

The Quality & Audit Pack is a 9-workbook Excel and Google Sheets bundle for quality managers: an ISO 9001-style internal audit checklist with an automatic per-clause conformity score, an audit plan, NC/CAPA and complaint registers with automatic status and aging, a quality risk register with a 5x5 matrix, a document control register, a weighted supplier scorecard, an FMEA with RPN, and a requirements traceability matrix. Every formula is tested to the cent before release.

Clause-by-clause internal audit checklist with an automatic conformity score
NC/CAPA register that computes status, aging and overdue flags for you
Every formula tested to the cent in both Excel and Google Sheets builds

Buy now — $49 Try the free version

14-day money-back guarantee · Instant download · Free updates · Tested to the cent before release

What's inside

Internal Audit Checklist workbook

120 checklist rows across clauses 4-10 (46 audit questions pre-filled) + per-clause conformity score and findings chart

Audit Plan & Schedule workbook

30 audits (internal, supplier, external, certification) with automatic Planned / Overdue / Done status and a dashboard

NC / CAPA Register workbook

100 non-conformance rows: severity, root cause, corrective action, automatic status and age in days, open-by-severity dashboard

Quality Risk Register workbook

60 risks scored probability x impact with High / Medium / Low levels, residual risk and a live 5x5 count matrix

Document Control Register workbook

150 controlled documents with next-review date computed from your review interval and REVIEW DUE flags

Supplier Scorecard workbook

30 suppliers rated on 4 weighted criteria (weights you set), automatic Approved / Conditional / Not approved rating

Complaint Register workbook

100 complaints with category, severity, resolution days and an average-resolution dashboard

FMEA workbook

50 failure modes: Severity x Occurrence x Detection RPN, action priority, revised RPN after actions

Traceability Matrix workbook

100 requirements linked to up to 3 tests each, automatic Covered / GAP flags and coverage % by priority

What's Included: 9 Workbooks That Cover the Quality Loop

Most quality template packs sold online are Word documents or flat PDF checklists - you still do the counting, scoring and status-chasing by hand. This pack is built the other way around: every workbook is a real spreadsheet where the quality math is wired in. You record findings, non-conformances, risks and complaints; the files compute conformity scores, aging, overdue flags, RPN and coverage for you.

The nine workbooks follow the loop a quality system actually runs: plan audits (Audit Plan & Schedule), run them (Internal Audit Checklist), record what you find (NC/CAPA Register), manage the risks and documents behind the findings (Quality Risk Register, Document Control Register), keep suppliers and customers in view (Supplier Scorecard, Complaint Register), and go deeper on prevention and verification (FMEA, Traceability Matrix).

The Internal Audit Checklist Scores Conformity by Clause

The flagship workbook holds 120 checklist rows organized by the seven ISO 9001:2015 clause families (4 Context through 10 Improvement), with 46 audit questions pre-filled so you are not starting from a blank page. For each row you pick a result from a locked dropdown - Conformity, Minor NC, Major NC, Observation or N/A - and record evidence, owner and due date.

The Summary sheet counts results per clause automatically and computes a conformity score: conformities divided by all scored findings, excluding N/A. You see in one glance which clause is dragging the system down, with a findings chart ready for the management review. The dropdowns reject typos, so a misspelled result can never silently drop out of the counts.

CAPA, Complaints and Audits Track Their Own Status

Three registers share the same discipline: you set a report date once in Settings, and every row computes its own status against it. A non-conformance with no closure date and a passed due date shows Overdue; a closed one shows Closed with its real resolution time. No TODAY() formulas that shift under you, no manual status column that goes stale.

The NC/CAPA Register tracks 100 non-conformances with source, severity, root cause and corrective action, and its dashboard shows open items by severity and average age. The Complaint Register does the same for 100 customer complaints with resolution days per complaint and an average for closed ones. The Audit Plan tracks 30 audits - internal, supplier, external or certification - and flags the ones past their planned date.

Risk, FMEA and Traceability: the Prevention Side

The Quality Risk Register scores 60 risks as probability times impact on a 1-5 scale, assigns High / Medium / Low levels automatically, and tracks residual scores after mitigation. A live 5x5 matrix counts how many risks sit in each probability-impact cell - the picture auditors ask for.

The FMEA workbook computes RPN (Severity x Occurrence x Detection, each 1-10) for 50 failure modes, assigns action priority at the usual 100/200 thresholds, and recomputes a revised RPN after your actions. The Traceability Matrix links 100 requirements to up to three tests or verifications each and flags every uncovered requirement as a GAP, with coverage percentage broken down by priority.

Built for Both Excel and Google Sheets, Tested to the Cent

Each workbook ships in two builds - one for Microsoft Excel, one to upload into Google Sheets - using no macros, so they behave identically on Windows, Mac and in the browser. Input cells have a pale yellow background; everything else is calculated and protected, so a stray keystroke cannot wipe a formula.

Before release, every build passes an automated test harness that injects scenario data and compares the computed conformity scores, statuses, ages, weighted scores, RPN and coverage figures against hand-calculated expected values, to the cent. That is the same testing rule applied to every paid file in this shop.

Who This Pack Is For

It fits quality managers, QMS coordinators, operations managers and consultants in small and mid-size companies who run their quality system in spreadsheets - preparing for or maintaining an ISO 9001-style certification, running internal or supplier audits, or standing up a CAPA process without buying QMS software.

It is a set of working spreadsheet tools, not a documentation kit: it does not include quality manual text or procedure documents, and buying it does not certify you to any standard - your auditors assess your system, not your templates.

Free vs premium

Feature	Free	Premium ($49)
Internal audit checklist (clauses 4-10)	Included, 15 rows visible	120 rows, 46 questions pre-filled
Per-clause conformity score + findings chart	Included	Included
Audit Plan & Schedule (30 audits, auto status)	Not included	Included
NC / CAPA Register with aging dashboard	Not included	100 rows
Quality Risk Register + live 5x5 matrix	Not included	60 risks
Document Control Register with review-due flags	Not included	150 documents
Supplier Scorecard (weighted, 4 criteria)	Not included	30 suppliers
FMEA with RPN and revised RPN	Not included	50 failure modes
Traceability Matrix with coverage %	Not included	100 requirements

Get the free Quality & Audit Pack template

No spam — template updates and new free templates only. Unsubscribe anytime.

Our guarantee

Every build passes an automated test harness that verifies calculated totals to the cent before release — and you get 14 days to change your mind, no questions asked. Questions before buying? support@tabletemplates.com.

Buy now — $49

Frequently asked questions

Does this pack work in Google Sheets as well as Excel?

Yes. Every workbook ships in two builds - a native Excel file and a build prepared for Google Sheets import. There are no macros, so formulas behave identically in both.

Is the internal audit checklist aligned with ISO 9001:2015?

The checklist is organized by the ISO 9001:2015 clause structure (clauses 4 to 10) with 46 generic audit questions pre-filled, and you can edit or extend them to your scope. It paraphrases common audit points; it does not reproduce the text of the standard, and using it does not certify you to it.

How do the automatic statuses work without TODAY() formulas?

Each register has a Report date cell in its Settings sheet. Statuses (Open, Overdue, Closed) and ages are computed against that date, so the file is deterministic: it shows the same picture until you update the report date, which makes month-end snapshots and audits reproducible.

Can I change the supplier scorecard weights or the risk thresholds?

The four scorecard weights (quality, on-time delivery, price, responsiveness) are input cells you can set to your own split. Risk levels use the common 5x5 thresholds (High at 15+, Medium at 8+); the FMEA uses the usual 100/200 RPN action thresholds.

What exactly is in the free version?

The free version is the Internal Audit Checklist workbook with 15 checklist rows visible and the same per-clause Summary and conformity score. The other eight workbooks - audit plan, NC/CAPA, risk register, document control, supplier scorecard, complaints, FMEA, traceability - are premium only.

Does it include quality manual or procedure documents?

No. This is a pack of working spreadsheet tools - registers, checklists, scorecards and matrices with the calculations wired in. It does not include quality manual text, procedure documents or other written QMS documentation.

What does "tested to the cent" mean?

Before release, an automated harness injects test scenarios into each build and compares every computed value - conformity scores, statuses, ages, weighted scores, RPN, coverage percentages - against hand-calculated expected values. Both the Excel and Google Sheets builds must pass, or the file does not ship.

Related templates

$24