Supplier Corrective Action Request (SCAR) Tracker Worksheet
A SCAR that sits open for months teaches the supplier nothing. This worksheet is a simple log you can fill in, with cost impact and overdue days calculated for every row, so you can see which requests need escalation and which suppliers carry the biggest exposure.
| SCAR no. | Supplier | Part number | Severity | Qty rejected | Unit cost | Cost impact | Days open | Target days to close | Days overdue | Status | Response due | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
$2,590 | 4 | |||||||||||
$484 | 0 | |||||||||||
$4,440 | 7 | |||||||||||
$735 | 0 | |||||||||||
$700 | 3 |
Update days open weekly, or enter the issue date elsewhere and compute the age before logging. Remove closed rows after reporting if you want only open exposure in the totals.
Automate SCAR tracking from your ERP
Optional: a review of how NCRs, SCARs and supplier history can be pulled into one dashboard.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Add one row per SCAR. Enter the supplier, part, severity, rejected quantity and unit cost, then the days the request has been open and the target in days from your supplier quality agreement. The sheet computes cost impact as quantity times unit cost and days overdue as open days beyond target. Set the status to the current stage, and use the response due date for follow-up. Export to Excel for your weekly supplier quality review.
- One SCAR per issue, not per shipment
- Use the same severity scale as your NCR process
- Set different target days by severity
- Review overdue items every week
What to track and why
Corrective action standards such as AS9100 and IATF 16949 expect evidence that nonconformities are contained, root causes found and actions verified. Tracking the stage, age and cost in one place gives you that evidence and a basis for escalation. Cost impact only covers the rejected material value here; add sorting, expedite and downtime in a separate column if you want a fuller view, or use the supplier cost of poor quality calculator.
Reading the totals
Total days overdue and average days overdue show how well suppliers respond to your deadlines. A supplier that appears on several rows with growing cost is a candidate for a formal improvement plan, probation or a second source. In the sample data, Ridge Electronics has a critical SCAR a week past target, which should be escalated to its quality director, while the closed Delta Coatings row can be archived.
Common mistakes
Closing a SCAR when the supplier replies instead of when the fix is verified is the classic failure. Another is leaving old items open without a decision, which hides the real backlog. Do not mix customer complaints and supplier issues in one log. Keep the full 8D or root-cause report as an attachment to the ERP quality record, and use this sheet as the management summary.
Frequently Asked Questions
What is a SCAR?
A supplier corrective action request is a formal demand that a supplier investigate a nonconformance, contain it, find the root cause, and implement and verify a permanent fix. It is typically tied to an NCR and often uses an 8D report format.
What target days should I set?
Many agreements ask for containment within 24 to 48 hours, a root cause and plan within 10 to 15 days, and full closure within 30 to 60 days, shorter for critical issues. Use the terms in your supplier quality agreement.
Should every reject trigger a SCAR?
No. Use thresholds: repeat issues, major or critical severity, or a cost above a set limit. Minor one-off issues can be handled through a lighter notice, otherwise suppliers stop responding to the process.
Can I filter by supplier?
Export to Excel and use a pivot table or filter on the supplier column. For a quick view, enter only one supplier in the sheet at a time and compare the totals across exports.
Netray can help connect SCARs, NCRs and receiving history in your ERP so this log fills itself and flags overdue items automatically.
Related Tools
Supplier Cost of Poor Quality Calculator
Turns a supplier's reject rate into an annual cost of poor quality, including handling, expedites and line-down time, with a what-if chart.
Quality & InspectionSupplier Lot Acceptance Probability Calculator
Calculates the chance an incoming lot is accepted for a given supplier defect rate and sampling plan, and plots the operating characteristic curve.
Quality & InspectionSupplier Process Change Notification Request Template
A fill-in form a supplier completes before changing a process, material, site or tooling, with validation evidence and customer approval lines.
Field Service & QualitySupplier Quality Scorecard
Rate a supplier across defect rates, delivery, corrective action, certifications, and risk to get a clear classification and recommended actions.
More Quality & Inspection tools
See all- SAP QM Process Capability Cp Cpk Calculator
- SAP QM Lot Rejection Rate, PPM and Sigma Level Calculator
- SAP QM Gauge R&R Study Calculator
- SAP QM Cp and Cpk Capability Calculator
- Job Shop Material Certification Log Worksheet
- Job Shop First Piece Inspection Sign-Off Template
- Job Shop Scrap and Rework Cost Calculator
- Master Data Audit Sample Size Calculator
- Data Quality Sigma Level Calculator
Keep exploring
Free tools
- Supplier Corrective Action Request (SCAR) TemplateReady to send SCAR with defect description, required response times, supplier response sections and closure sign-off.
- Aerospace Supplier Corrective Action Request TemplateIssue a SCAR with defect details, required containment, root cause and effectiveness verification fields, then export to PDF or Word.
- China Supplier Corrective Action Request TemplateA clear SCAR form for Chinese suppliers with containment, root cause, corrective action and verification sections, in plain bilingual-friendly wording.
ERP fixes and how-tos
- How to Issue a Supplier Corrective Action Request (SCAR) Using ERP Receiving and Reject DataBuild supplier quality records from ERP data: receipt rejects, PPM, on-time delivery, and when to trigger a SCAR. Includes query shapes and scorecard pitfalls.
- How to Complete an Operation in Epicor Kinetic (Plus Time Entry and Corrective Action)Complete an operation in Epicor Kinetic through MES or Labor Entry, plus time and expense entry, customer managed inventory and corrective action, with what to check first.
- How to Link a CAPA to ERP Lots and Serial Numbers for Containment and EffectivenessUse ERP lot and serial genealogy to scope containment for a CAPA, record affected jobs and shipments, and verify effectiveness with real data instead of opinion.
Guides
- SyteLine Corrective Action Request (CAR/CAPA) Configuration GuideConfigure SyteLine corrective and preventive action workflows. Set up CAR/CAPA tracking, root cause analysis, and effectiveness verification in CloudSuite Industrial.
- SyteLine Supplier Quality Management Configuration GuideConfigure SyteLine supplier quality management for vendor quality scoring, incoming inspection tracking, and supplier corrective actions in CloudSuite Industrial.
- How to Manage Corrective Actions and CAPA in SyteLineComplete guide to managing CAPA (Corrective and Preventive Actions) in Infor SyteLine. Configure root cause analysis workflows, action tracking, effectiveness verification, and 8D problem-solving integration.
AI on your ERP
- AI for ComplianceQuest: Connecting QMS Records to ERP, Suppliers and Shop FloorPrivate AI for ComplianceQuest QMS: CAPA, supplier quality and audits read via Salesforce APIs and joined to ERP data, with human approval and audit trails.
- AI for NCR, CAPA, and 8D Drafting in AS9100 and ISO 9001 Quality SystemsAI drafts NCR, CAPA, and 8D reports from ERP quality data for engineer review, cutting drafting time under AS9100 and ISO 9001 without changing sign-off.