Supplier corrective action tracker (8D)
Track supplier complaints from containment to closure using the eight disciplines, with target dates by severity, days open, a containment check and a summary per supplier.
- Free Excel file, no sign-up
- D1 to D8 in one row
- Targets by severity
- Summary per supplier
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 4 | Case | Supplier | Severity | Days open | Status |
| 5 | 8D-2026-031 | Brianza Plastics | Major | 26 | Verifying |
| 6 | 8D-2026-034 | Kestrel EMS | Critical | 9 | Root cause found |
| 7 | 8D-2026-029 | Ostrava Polymer | Minor | 71 | Overdue |
What is inside
4 sheets, ready to use.
Yellow cells are yours to fill in. Grey cells calculate. Every sheet has a worked example so you can see the expected format.
Read me
Purpose, steps, colour legend and assumptions.
8D tracker
One row per case through D1 to D8, with target close date, days open, containment check and status.
Supplier summary
Open, overdue and closed cases, average days to close and containment on time, per supplier.
Settings
Containment, root cause and closure targets per severity.
How to use it
Four steps from download to a decision.
No macros, no add-ins. It works in Excel, Google Sheets and LibreOffice.
01
Log one row per complaint and fill in the dates as each discipline is completed.
02
Target close date, days open, containment check and status are calculated.
03
Use the Supplier summary to see who is late and how fast cases close.
04
Do not close a case until the effectiveness check (D7) is done.
Spreadsheet or platform
Start in Excel. Move when the volume or the stakes grow.
The template and the platform use the same structure, so nothing you set up here is wasted.
This spreadsheet is enough when
- You handle a few supplier complaints a month
- Suppliers send 8D reports as attachments
- One quality engineer owns every case
Move it into EvaluationsHub when you need to
- Open corrective actions automatically when a score or KPI drops
- Let suppliers submit root cause and evidence in a supplier portal
- Chase overdue actions with owners and due dates on both sides
- Feed closure performance straight into the supplier scorecard
Questions
Before you download
What are the eight disciplines of 8D?
D1 form the team, D2 describe the problem, D3 contain it, D4 find the root cause, D5 choose corrective actions, D6 implement and verify them, D7 prevent recurrence, D8 close and recognise the team.
Is the template really free?
Yes. The file downloads directly, with no form and no email address.
When should we move this out of Excel?
When several people rate the same suppliers, when suppliers need to see their results, or when actions get lost between file versions. That is usually the point where a shared platform pays back. Signs you have outgrown the spreadsheet → Automated supplier CAPA compared →
Related templates
Next steps in the supplier lifecycle.
Templates that pick up where this one ends.
Weighted supplier scorecard with segment presets
Six dimensions, weights by segment, tiers and next actions.
View template →
Automotive supplier self-assessment aligned with IATF 16949
38 questions in 8 sections for automotive suppliers, scored automatically.
View template →
Supplier business review (QBR) pack
Agenda with timings, RAG scorecard, action log and decisions.
View template →
Run it live
Run this process with your suppliers, not just in a file.
Start a free sandbox and set it up yourself: send requests and surveys to real suppliers, collect answers and see scores in one place.
