# Approved Supplier List (ASL) Template > Source: https://netray.co/tools/approved-supplier-list-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable approved supplier list worksheet with status, approval basis, certification, expiry and rating. Edit rows in the browser and export to Excel. ## Category supply-chain ## Audience - Supplier quality - Buyer - Quality manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Supplier **Key:** supplier **Type:** text #### Commodity or process **Key:** commodity **Type:** text #### Status **Key:** status **Type:** select **Options:** - Approved - Conditional - Probation - Disqualified - Pending #### Approval basis **Key:** basis **Type:** select **Options:** - On-site audit - Certification review - First article - Customer directed - History #### Certification **Key:** cert **Type:** text #### Cert expiry **Key:** cert_expiry **Type:** date #### Last audit **Key:** last_audit **Type:** date #### Rating (0-100) **Key:** rating **Type:** number **Format:** number **Rows:** **Supplier:** Precision Castings Ltd **Commodity:** Aluminium castings **Status:** Approved **Basis:** On-site audit **Cert:** ISO 9001:2015 **Cert expiry:** 2027-03-14 **Last audit:** 2025-11-06 **Rating:** 92 **Supplier:** Northline Fasteners **Commodity:** Fasteners, grade 8 **Status:** Approved **Basis:** Certification review **Cert:** IATF 16949 **Cert expiry:** 2026-12-01 **Last audit:** 2024-09-18 **Rating:** 88 **Supplier:** Delta Heat Treat **Commodity:** Heat treatment **Status:** Conditional **Basis:** On-site audit **Cert:** AS9100D, Nadcap **Cert expiry:** 2026-11-30 **Last audit:** 2026-02-20 **Rating:** 76 **Supplier:** Quickturn PCB Co **Commodity:** Printed circuit boards **Status:** Probation **Basis:** First article **Cert:** ISO 9001:2015 **Cert expiry:** 2027-06-22 **Last audit:** 2025-05-12 **Rating:** 64 **Supplier:** Harbor Packaging **Commodity:** Corrugated packaging **Status:** Pending **Basis:** History **Cert:** None **Cert expiry:** 2026-12-31 **Last audit:** 2026-08-01 **Rating:** 70 **Totals:** #### Average rating **Key:** rating **Agg:** avg **Format:** number **Summary:** #### Suppliers on the list **Key:** listed **Expr:** count **Format:** integer **Notes:** Keep one row per supplier and commodity or process, because approval is usually specific to what the supplier makes for you. Review dates monthly so expiring certificates are caught before the next purchase order. ## Content **Intro:** An approved supplier list (ASL, also called AVL or qualified vendor list) is the controlled record of who is allowed to supply what. Quality standards such as ISO 9001, IATF 16949 and AS9100 expect you to evaluate, select and monitor external providers, and the list is where that evidence lives. **Sections:** #### How to use the template **Body:** Start from the pre-filled example rows, overwrite them with your suppliers, and add or delete rows as needed. Record one line per supplier and commodity or process, because a company approved for machining may not be approved for plating. Choose the status and approval basis from the dropdowns, and record certificate expiry and last audit dates so you can sort and filter in Excel after export. **Bullets:** - Approved: fully qualified for the listed scope - Conditional: approved with an open action plan - Probation: reduced volumes or extra inspection until performance improves - Disqualified: blocked from new orders #### What a good ASL contains **Body:** At minimum record the legal name, the scope of approval, how the approval was earned, relevant certifications with expiry dates, the date of the last evaluation and a current performance rating. Add the owner in purchasing or quality, special process approvals such as Nadcap where applicable, and any customer directed source flags. Control the list as a document with a revision date and an approver, so an auditor can see who changed it and when. #### Common mistakes **Body:** The most frequent failure is a list that is approved once and never maintained: expired certificates, suppliers nobody has bought from in three years, and buyers placing orders with unlisted vendors. Another is approving by company instead of by scope. Buyers also bypass the list when the ERP does not enforce it, so match the list to a vendor status or approved source list in your system and review exceptions regularly. #### Linking the list to your ERP **Body:** Most ERPs can enforce an approved source: for example source lists and vendor blocks in SAP, approved supplier lists in Oracle, or vendor status fields in SyteLine and Epicor. Use this worksheet as the controlled master and keep the ERP flag aligned. Where you buy from customer-directed sources, record that basis explicitly rather than listing the supplier as audited. **Cta:** If your approved status lives in spreadsheets while buyers work in the ERP, Netray can help compare the two and flag orders placed with unapproved or expired suppliers. **Faq:** #### What is the difference between an ASL and an AVL? **Answer:** They are the same idea. Approved supplier list is the common term in quality systems, approved vendor list is common in purchasing and electronics. Both record who is qualified to supply specified items, often with the scope of that approval. #### How often should the approved supplier list be reviewed? **Answer:** Review certificate expiry and status at least monthly or quarterly, and run a full evaluation of each supplier on a risk-based schedule, typically annually for critical suppliers. Update the list immediately after a failed audit or serious escape. #### Do I need an ASL for ISO 9001? **Answer:** ISO 9001 requires criteria for evaluation, selection, monitoring and re-evaluation of external providers, with documented evidence. It does not mandate a specific format, but an approved supplier list is the standard way to show that evidence. #### Can one supplier have several rows? **Answer:** Yes, and it is often the right approach. If a supplier is approved for machining but still on probation for plating, record separate rows so buyers and receiving know exactly which scope is released. ## Search terms approved supplier list template, approved vendor list excel, ASL template, approved supplier list format, AVL template excel, qualified supplier list template, approved supplier register, supplier approval matrix --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json