# Nadcap Special Process Supplier Approval Tracker (Excel Export) > Source: https://netray.co/tools/nadcap-special-process-supplier-approval-tracker > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable worksheet for tracking special process suppliers, their Nadcap or customer approvals, scope and days to expiry. ## Category aerospace-defense ## Industry Aerospace ## Audience - Supplier quality - Purchasing - Quality manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Supplier **Key:** supplier **Type:** text #### Special process **Key:** process **Type:** select **Options:** - Anodize - Chemical processing - Heat treat - Plating - Welding - NDT - Shot peen - Coatings - Non-conventional machining #### Approval type **Key:** approval **Type:** select **Options:** - Nadcap - Prime direct - Customer specific - Pending #### Process spec in scope **Key:** spec **Type:** text #### Approval expiry **Key:** expiry **Type:** date #### Days left (enter) **Key:** days_left **Type:** number **Help:** Days remaining to expiry on the date you review the list #### Lots shipped, 12 months **Key:** lots **Type:** number #### Lots rejected **Key:** rejects **Type:** number #### Reject rate **Key:** reject_rate **Type:** number **Expr:** if(gt(lots,0), rejects / lots * 100, 0) **Format:** percent **Rows:** **Supplier:** Apex Finishing LLC **Process:** Anodize **Approval:** Nadcap **Spec:** MIL-A-8625 Type II **Expiry:** 2027-03-31 **Days left:** 162 **Lots:** 48 **Rejects:** 1 **Supplier:** Heartland Thermal Inc **Process:** Heat treat **Approval:** Nadcap **Spec:** AMS 2770, AMS 2759 **Expiry:** 2026-12-15 **Days left:** 57 **Lots:** 30 **Rejects:** 0 **Supplier:** Clearview NDT **Process:** NDT **Approval:** Prime direct **Spec:** ASTM E1417 FPI **Expiry:** 2027-06-30 **Days left:** 253 **Lots:** 62 **Rejects:** 3 **Supplier:** Summit Plating Co **Process:** Plating **Approval:** Pending **Spec:** QQ-P-416 **Expiry:** 2026-11-01 **Days left:** 13 **Lots:** 12 **Rejects:** 2 **Totals:** #### Total lots shipped **Key:** lots **Agg:** sum **Format:** integer #### Total lots rejected **Key:** rejects **Agg:** sum **Format:** integer #### Soonest expiry (days) **Key:** days_left **Agg:** min **Format:** integer **Summary:** #### Overall reject rate **Key:** overall_reject **Expr:** if(gt(sum_lots,0), sum_rejects / sum_lots * 100, 0) **Format:** percent **Primary:** true **Notes:** Sort by days left each month and open a review for any supplier under 90 days. Verify scope against the current Nadcap or prime approval listing, not a supplier-supplied copy. ## Content **Intro:** AS9100 clause 8.4 expects you to control external providers, and special process suppliers carry the most audit risk. This tracker keeps approvals, scope, expiry and reject history in one list you can export to Excel for the auditor. **Sections:** #### How to use the tracker **Body:** Add one row per supplier and process pair. Record the approval type, the specifications covered by their scope, and the expiry date. Update the days-left column when you review the list, then sort to bring the nearest expiry to the top. Enter lots shipped and rejected from your receiving data so the reject rate shows which approved suppliers still perform poorly. **Bullets:** - Separate rows for each process a supplier performs - Record the exact spec and revision in scope - Review monthly and before each purchase order release - Export to Excel for audit evidence #### Why approval is not enough **Body:** A valid Nadcap certificate shows a supplier passed an audit for a defined scope on a defined date. It does not guarantee every lot is good. Pairing approval status with your own reject rate gives a more honest view. A supplier at three percent rejects with a valid approval still deserves a corrective action request. #### Reading the summary **Body:** The overall reject rate is total rejected lots divided by total lots shipped across all suppliers. The soonest expiry total shows the supplier you must act on first. If a supplier shows Pending, treat it as not approved until written evidence arrives, and block purchase orders for that process in your ERP approved vendor setup. #### Common mistakes **Body:** Teams often track the supplier but not the scope, so a supplier approved for anodize gets chromate conversion work it is not qualified for. Others forget sub-tier processes performed by the supplier's own subcontractors. Check the scope line against each purchase order and require the supplier to flow down approval requirements. **Cta:** If your approved vendor list lives in the ERP, we can help sync approvals and expiry dates so purchasing is blocked automatically when an approval lapses. **Faq:** #### Is Nadcap required for every special process? **Answer:** No. Nadcap accreditation is common and often mandated by primes, but some customers accept their own direct approval or audit. Your purchase order flow-downs state what is required, so check them for each program. #### How often should I review approvals? **Answer:** Review at least monthly and before issuing orders. Many teams use a 90 day warning window so renewals or alternate sources can be arranged before an expiry creates a stock-out. #### What should the reject rate threshold be? **Answer:** There is no universal number. Set a limit in your supplier performance procedure, such as a fixed percent of lots, and trigger corrective action when a supplier exceeds it over a rolling period. #### Can I import my existing list? **Answer:** You can paste or retype rows into the editable table and export back to Excel. Keep your ERP vendor master as the source of record. ## Search terms Nadcap supplier tracker excel, approved special process supplier list, AS9100 approved supplier list template, special process approval expiry tracker, Nadcap accreditation tracking, aerospace approved vendor list excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json