← The Aegis Quality Resource Library
Corrective Action Aging and Program Health Dashboard
See at a glance how many corrective actions are open, how old they are, which are late, where they are stuck and how many of the closed ones were shown to work, from one plain CAPA log.
Free to use, change and copy inside your own organization. Editable Excel, plus a fillable PDF you can complete on screen.
The problem it solves
Most shops can say how many corrective actions they have open. Few can say how old they are, which are stuck and where, or how many of last quarter's closures were ever shown to work. The log exists, but nobody counts it until an auditor or a customer asks, and by then the oldest actions are a year old. This workbook turns a one-line-per-action CAPA log into a dashboard of plain counts: open by age band, overdue against the due date, open by stage and by owner, closed versus shown effective, and a twelve-month trend of opened against closed.
Who uses it, and when
Quality directors and managers who run the corrective action program, and the plant leaders who review it. Update the log as actions move, look at the Dashboard before every CAPA review, and take the Dashboard and Monthly trend to management review.
Part of
CAPA Command Kit, Quality Performance Kit.
Clause references: 10.2, 9.1.3 (with 9.3.2). Clause numbers only; the standards text is not reproduced, use your own licensed copy.
A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.
Page 1 of the PDF. Every resource includes a worked example.
Related resources
worksheet · Excel · fillable PDFCAPA Effectiveness Verification Worksheet
Prove a corrective action worked, not just that it was done: separate containment, correction and corrective action, set a measurable criterion before the action goes in, and hold the record open until the evidence is in.
Free with your email →
workbook · Excel · fillable PDFRepeat Finding Analysis Register
Link nonconformances, audit findings and complaints that share a failure mode, part family or process, flag the repeats inside a window you set, and see which corrective actions failed to prevent them.
Free with your email →
guide · Word · fillable PDFCAPA Escalation Criteria and Owner Accountability Guide
When a corrective action moves up, to whom, and what the escalation asks for; who owns each part of a corrective action; and a meeting rhythm that keeps actions moving without a chase.
Free download →
workbook · Excel · fillable PDFRoot Cause Analysis Worksheet
A structured investigation in one place: problem statement, is / is-not, every candidate cause tested against the data, a 5 Whys chain with evidence, the six root cause tests, the escape cause, and a conclusion that reads Not yet until the work is done.
Free download →
workbook · Excel · fillable PDFNonconformance Management Log
One line per NCR, from the moment it is found to the moment it is closed: the part, the requirement, where it was found, the disposition and who authorized it, customer approval, cost, the corrective action link and how long it has been open.
Free with your email →
These tools help you run the work by hand. When you want the whole picture of your quality system from the records you already keep, that's what the AeroAssure Audit Defense Pack and the IA9100 Transition Gap Analysis do.