# Supplier Corrective Action Request (SCAR) Tracker Worksheet > Source: https://netray.co/tools/supplier-corrective-action-tracker-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable SCAR log that computes cost impact and overdue days per request and totals the open exposure by supplier. ## Category quality ## Audience - Supplier quality - Quality manager - Buyer ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### SCAR no. **Key:** scar_no **Type:** text #### Supplier **Key:** supplier **Type:** text #### Part number **Key:** part **Type:** text #### Severity **Key:** severity **Type:** select **Options:** - Minor - Major - Critical #### Qty rejected **Key:** qty **Type:** number #### Unit cost **Key:** unit_cost **Type:** number **Format:** currency #### Cost impact **Key:** impact **Type:** number **Expr:** qty * unit_cost **Format:** currency #### Days open **Key:** days_open **Type:** number **Format:** integer #### Target days to close **Key:** target_days **Type:** number **Format:** integer **Help:** Response and closure target set in your supplier quality agreement. #### Days overdue **Key:** overdue **Type:** number **Expr:** max(0, days_open - target_days) **Format:** integer #### Status **Key:** status **Type:** select **Options:** - Issued - Containment - Root cause - Verification - Closed #### Response due **Key:** due **Type:** date **Rows:** **Scar no:** SCAR-0412 **Supplier:** Northfield Castings **Part:** HSG-2210 **Severity:** Major **Qty:** 140 **Unit cost:** 18.5 **Days open:** 34 **Target days:** 30 **Status:** Root cause **Due:** 2026-10-28 **Scar no:** SCAR-0415 **Supplier:** Apex Fasteners **Part:** BLT-M8-40 **Severity:** Minor **Qty:** 2200 **Unit cost:** 0.22 **Days open:** 12 **Target days:** 30 **Status:** Containment **Due:** 2026-11-09 **Scar no:** SCAR-0418 **Supplier:** Ridge Electronics **Part:** PCB-7741 **Severity:** Critical **Qty:** 60 **Unit cost:** 74 **Days open:** 21 **Target days:** 14 **Status:** Verification **Due:** 2026-10-30 **Scar no:** SCAR-0421 **Supplier:** Northfield Castings **Part:** HSG-2214 **Severity:** Major **Qty:** 35 **Unit cost:** 21 **Days open:** 9 **Target days:** 30 **Status:** Issued **Due:** 2026-11-12 **Scar no:** SCAR-0409 **Supplier:** Delta Coatings **Part:** FIN-9005 **Severity:** Minor **Qty:** 500 **Unit cost:** 1.4 **Days open:** 48 **Target days:** 45 **Status:** Closed **Due:** 2026-10-05 **Totals:** #### Total cost impact **Key:** impact **Agg:** sum **Format:** currency #### Total days overdue **Key:** overdue **Agg:** sum **Format:** integer #### Total units rejected **Key:** qty **Agg:** sum **Format:** integer #### Average days open **Key:** days_open **Agg:** avg **Format:** decimal **Summary:** #### Average cost per SCAR **Key:** avg_impact **Expr:** sum_impact / count **Format:** currency #### Average days overdue per SCAR **Key:** avg_overdue **Expr:** sum_overdue / count **Format:** decimal #### Average days open **Key:** avg_open **Expr:** avg_days_open **Format:** decimal **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the worksheet **Body:** 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. **Bullets:** - 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 **Body:** 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 **Body:** 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 **Body:** 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. **Cta:** Netray can help connect SCARs, NCRs and receiving history in your ERP so this log fills itself and flags overdue items automatically. **Faq:** #### What is a SCAR? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms scar tracker excel, supplier corrective action request log, scar log template, supplier corrective action tracking spreadsheet, open scar report, supplier nonconformance log, scar aging report, supplier quality action tracker --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json