Quality & InspectionFree worksheetPDF, Excel, Word export

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.

Download:

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

Total cost impact

$8,949

Total days overdue

Total units rejected

2,935

Average days open

24.8

Average cost per SCAR

$1,790

Average days overdue per SCAR

2.8

Average days open

24.8

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.

Talk to an Expert Explore More Free Tools

Related Tools

Quality & Inspection

More Quality & Inspection tools

See all

Back to All Tools