Supplier Quality Audit Checklist Excel: Free Template & Guide

Supplier Quality Audit Checklist Excel: Free Template & Guide

!Packaging Engineering

A verbal assurance from a packaging supplier is not a quality system. When a 32 ECT corrugated run ships at 28 ECT, or mono-material film arrives with a 4% PVC content that tanks your recyclability grade, the cost lands on your line — line stops, rejects, and EU/US non-compliance penalties under PPWR and state EPR laws. A structured supplier quality audit checklist Excel file is the cheapest risk-mitigation tool in your procurement stack. This guide shows the sheet architecture, scoring weights, and the 2026 compliance gates that separate audit-ready suppliers from risky ones.

Why Excel Still Beats SaaS for Supplier Audits

PLM and QMS platforms (MasterControl, ETQ) add traceability, but Excel remains the transactional workhorse for mid-volume B2B buyers: it is universally editable, supports weighted scoring formulas natively, and travels as an email attachment into supplier NCR workflows. Best practice is a master workbook with four tabs:

1. Cover & Scoring — supplier profile, audit date, auditor, weighted total.
2. Checklist — 60–90 line items grouped by category.
3. Test Data Log — ECT, Mullen burst, GSM, Cobb, thickness measurements.
4. CAPA Tracker — findings, severity, owner, due date, closure evidence.

Each checklist line gets a score column (0/1/2 or 0–5), a Critical / Major / Minor severity flag, and a weighted contribution. A `SUMPRODUCT` on the score × weight columns yields the total. Conditional formatting turns totals below 75% red and flags any failed Critical item as an automatic CAPA trigger regardless of the total.

The Core Checklist Categories

1. Quality Management System (Weight: 15%)

• Valid ISO 9001:2015 certificate (verify expiry and scope on the issuing body’s register — certificate fraud is rising).
• Documented CAPA process with closure rate above 90% in 12 months.
• Calibration records for test equipment (ECT tester, burst tester, micrometers) traceable to national standards.
• Internal audit schedule with last audit within 12 months.

2. Material & Product Specifications (Weight: 30%)

This is where packaging audits differ from generic supplier audits. Verify against your spec sheet, not theirs:

Request three recent COAs and cross-check against your spec. A supplier quoting “48 ECT” for a 44×36 double-wall box without a TAPPI T 811 test report is a finding, not a clarification. For custom formats, cross-reference the structural spec in our Custom Packaging guide.

3. Process & Equipment Capability (Weight: 25%)

• Cpk ≥ 1.33 on critical dimensions (scored via SPC charts, not assumption).
• Preventive maintenance logs for converting equipment (die-cutters, folder-gluers, extruders).
• Documented setup/first-article inspection procedure with retained first-article samples.
• Waste/rework rate below 3% with segregation of nonconforming stock.

4. Compliance & Sustainability Documentation (Weight: 30% in 2026)

This category has grown fastest in the 2026 regulatory environment:

• PPWR (EU): packaging must meet recyclability grades — 2030 targets require design-for-recycling compliance statements for all EU-bound SKUs.
• US EPR states (CA SB 54, CO, OR, MN, ME): supplier must provide material composition data sufficient for PRO fee reporting.
• Chain-of-custody: FSC or PEFC certs for fiber; GRS for recycled content claims above 30%.
• Food contact where applicable: FDA 21 CFR or EU 10/2011 declarations of compliance (DoC), refreshed per formulation change.
• PFAS statements for paper/fiber-based packaging, per state bans now active in 10+ states.

Our Materials & Processes reference maps each substrate to the documentation you should demand.

Scoring Logic That Actually Works

Avoid a 50/50 average — it lets a glossy facility tour mask a failing test lab. Use this structure:

• Critical gate items (ISO cert validity, calibration traceability, PPWR/food-contact DoC): pass/fail. One fail = audit failure + CAPA within 30 days.
• Weighted items: score 0–5, multiplied by category weight, summed to 100.
• Grade bands: ≥90 Approved; 75–89 Conditional (CAPA required); <75 Disapproved.

In Excel, protect the weight column and use data validation on severity dropdowns so auditors in the field cannot fudge formulas. Lock the CAPA tab with unique IDs linking each finding to its checklist row number.

Re-Audit Cadence

Full audit annually for Approved suppliers, semi-annually for Conditional. Trigger off-cycle remote audits on any material substitution, equipment change, ownership change, or two consecutive COA deviations. Suppliers with Cpk data and PPWR documentation will clear in one day; expect two days on-site for first-time flexible converters.

A disciplined Excel checklist costs you one afternoon to build and prevents five-figure rejection events. Build it once, version it, and hold every supplier to the same number.