← The Aegis Quality Resource Library
CAPA Intake and Prioritization Tool
Log every incoming problem in one place, rank it with a method you can see and change, decide correction or corrective action on purpose, and know who owns it and when the response is due.
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
Problems arrive from six directions: NCRs, customer complaints and returns, internal and external audits, suppliers, SPC signals and people on the floor. Each lands in a different inbox and gets ranked by whoever shouts loudest. Some get a full corrective action they did not need; others, including repeats, get a quick fix and come back. This tool puts every incoming problem on one log, ranks it with three plain levels and weights you control, suggests a route, records the decision and the reason, and sets the containment and response dates so nothing waits unseen.
Who uses it, and when
Quality managers and whoever triages NCRs, complaints, audit findings and supplier issues. Log each problem the day it arrives, decide the route within a day or two, and review the log and the Summary at the weekly quality meeting.
Part of
CAPA Command Kit.
Clause references: 10.2, 10.2.1 (with 8.7, 9.1.3). 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
workbook · Excel · fillable PDF8D Problem-Solving Workbook
One tab per discipline, D0 to D8, rolled up to a status page: an is / is-not table, containment that is verified, root and escape causes confirmed with data, an effectiveness criterion set before the actions go in, and prevention carried to similar processes.
Free with your email →
guide · Word · fillable PDFRoot Cause Analysis Decision Tree
Which method fits the problem in front of you, how far to dig, and the tests that tell a root cause from a convenient stopping point.
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 →
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 →
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.