Resource Library/Corrective Action, Problem Solving and Complaints/Customer Complaint Log and Response Tracker
Customer Complaint Log and Response Tracker
Every customer complaint on one line, from the first call to closure: acknowledged, contained, answered and accepted, each against the customer's own dates, with the lines that need action flagged and the counts management review asks for.
- Excel
- fillable PDF
- Worked example
- Your logo on it
- Aegis Insights
Page 1 of the PDF. Every resource includes a fully worked example.
The problem it solves
Complaints arrive by email, phone, portal and rejection tag, and land with whoever picked them up: a buyer, a salesperson, the quality manager. Some get a fast, good answer. Others wait while the investigation runs, miss the customer's date, or get closed the day the response is sent and are never checked again. Meanwhile the customer is keeping score on its own scorecard, and the first time the supplier sees the pattern is a rating drop. This tracker logs every complaint the day it arrives, measures each stage against the customer's own dates, flags what is late or missing, and counts the year by type so the pattern shows before the customer shows it to you.
Who uses it
Quality managers who own customer complaints, customer service and sales staff who receive them, and the managers who review them.
When
Add a line the day a complaint arrives, update it at each stage, review the open lines every week, and take the Summary and Breakdown to management review.
Free to use, change and copy, in your own organization or with your clients; add your own logo, keep the Aegis credit. Part of: Customer Complaint Response Kit. Clause references: 8.2.1, 9.1.2 (with 8.7, 10.2, 9.3.2) (numbers only; use your own licensed copy of the standard).
A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.
How to put it to work
Chapters of our free guides that use this tool.
- What is in the kitThe Customer Complaint Response Kit Handbook, chapter 2
- The complaint response workflowThe Customer Complaint Response Kit Handbook, chapter 3
- The first twenty-four hoursThe Customer Complaint Response Kit Handbook, chapter 5
- Running the systemThe Customer Complaint Response Kit Handbook, chapter 15
- Setting it up in thirty daysThe Customer Complaint Response Kit Handbook, chapter 16
- Worked example: one escape through the whole kitThe Customer Complaint Response Kit Handbook, chapter 18
Related resources
-
Template
Customer Complaint Response Letter Template
Five letters for the life of a complaint: acknowledgment, containment notice, the response with root cause and actions, the effectiveness and closure update, and the answer when a complaint is not substantiated. Factual, complete, and written from the investigation record.
Word · PDFFree by email -
Workbook
Customer Scorecard and Escape Tracker
How each customer sees you, month by month: their ratings and status next to your own PPM, on-time delivery and complaints, and every escape with where it got through and why, so a falling rating or a repeating escape route shows before the customer raises it.
Excel · PDFFree by email -
Template
Quality Escape Investigation Template
For product that reached a customer: the timeline, every suspect part by location, what the customer was told and when, the detection point that failed and why, and actions at both the cause and the escape point.
Word · PDFFree download -
Workbook
8D 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.
Excel · PDFFree by email -
Worksheet
CAPA 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.
Excel · PDFFree by email -
Workbook
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.
Excel · PDFFree by email
Need more than one resource, or not sure where to start? Book a complimentary 30-minute Aegis Quality Guidance Call. We'll find the tools that fit your situation and a sensible place to start. No sales pressure, no obligation.
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.