# PPAP Checklist Excel Template: 18 Elements, Levels 1 to 5 and Status Tracking > Source: https://netray.co/tools/ppap-checklist-excel-18-elements-status-tracker > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Editable PPAP requirements checklist: all 18 AIAG elements, what to submit or retain at each level, and a status, owner and due date for every row. ## Category quality ## Industry Automotive ## Audience - Supplier quality engineer - APQP team leader - Quality manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### No. **Key:** no **Type:** number #### PPAP element **Key:** element **Type:** text #### Level 1 **Key:** l1 **Type:** select **Options:** - S - R - * #### Level 2 **Key:** l2 **Type:** select **Options:** - S - R - * #### Level 3 **Key:** l3 **Type:** select **Options:** - S - R - * #### Level 4 **Key:** l4 **Type:** select **Options:** - S - R - * #### Level 5 **Key:** l5 **Type:** select **Options:** - S - R - * #### Status **Key:** status **Type:** select **Options:** - Not started - In progress - Complete - Approved by customer - Not applicable #### Owner **Key:** owner **Type:** text #### Due date **Key:** due **Type:** date #### Evidence / notes **Key:** notes **Type:** text **Rows:** **No:** 1 **Element:** Design records **L1:** R **L2:** S **L3:** S **L4:** * **L5:** R **Status:** Complete **Owner:** Design eng. **Due:** 2026-11-02 **Notes:** Ballooned drawing Rev C **No:** 2 **Element:** Authorized engineering change documents **L1:** R **L2:** S **L3:** S **L4:** * **L5:** R **Status:** Not applicable **Owner:** Design eng. **Due:** 2026-11-02 **Notes:** No ECN since last approval **No:** 3 **Element:** Customer engineering approval **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** In progress **Owner:** Program mgr **Due:** 2026-11-06 **Notes:** Waiting on customer sign-off **No:** 4 **Element:** Design FMEA **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** Not applicable **Owner:** Design eng. **Due:** 2026-11-06 **Notes:** Customer is design responsible **No:** 5 **Element:** Process flow diagram **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** Complete **Owner:** Process eng. **Due:** 2026-11-04 **Notes:** PFD-1048 Rev B **No:** 6 **Element:** Process FMEA **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** In progress **Owner:** Process eng. **Due:** 2026-11-09 **Notes:** RPN review pending **No:** 7 **Element:** Control plan **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** In progress **Owner:** Quality eng. **Due:** 2026-11-09 **Notes:** Aligned to PFMEA **No:** 8 **Element:** Measurement system analysis studies **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** Not started **Owner:** Metrology **Due:** 2026-11-11 **Notes:** Gauge R&R on 4 key gauges **No:** 9 **Element:** Dimensional results **L1:** R **L2:** S **L3:** S **L4:** * **L5:** R **Status:** Not started **Owner:** CMM lab **Due:** 2026-11-12 **Notes:** Minimum 6 pieces per cavity **No:** 10 **Element:** Records of material and performance test results **L1:** R **L2:** S **L3:** S **L4:** * **L5:** R **Status:** Not started **Owner:** Quality eng. **Due:** 2026-11-12 **Notes:** Material certs, hardness, plating **No:** 11 **Element:** Initial process studies **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** Not started **Owner:** Quality eng. **Due:** 2026-11-13 **Notes:** Cpk/Ppk on special characteristics **No:** 12 **Element:** Qualified laboratory documentation **L1:** R **L2:** S **L3:** S **L4:** * **L5:** R **Status:** Not started **Owner:** Quality eng. **Due:** 2026-11-13 **Notes:** Lab scope and accreditation **No:** 13 **Element:** Appearance approval report (AAR) **L1:** S **L2:** S **L3:** S **L4:** * **L5:** R **Status:** Not applicable **Owner:** Quality eng. **Due:** 2026-11-13 **Notes:** No appearance items **No:** 14 **Element:** Sample product **L1:** R **L2:** S **L3:** S **L4:** * **L5:** R **Status:** Not started **Owner:** Production **Due:** 2026-11-16 **Notes:** Labelled with cavity IDs **No:** 15 **Element:** Master sample **L1:** R **L2:** R **L3:** R **L4:** * **L5:** R **Status:** Not started **Owner:** Quality eng. **Due:** 2026-11-16 **Notes:** Retained and signed **No:** 16 **Element:** Checking aids **L1:** R **L2:** R **L3:** R **L4:** * **L5:** R **Status:** Not started **Owner:** Tooling **Due:** 2026-11-16 **Notes:** Fixture calibration records **No:** 17 **Element:** Customer-specific requirements **L1:** R **L2:** R **L3:** S **L4:** * **L5:** R **Status:** In progress **Owner:** Quality eng. **Due:** 2026-11-16 **Notes:** Check portal for CSR updates **No:** 18 **Element:** Part submission warrant (PSW) **L1:** S **L2:** S **L3:** S **L4:** S **L5:** S **Status:** Not started **Owner:** Quality mgr **Due:** 2026-11-18 **Notes:** Sign after all elements **Totals:** #### Elements listed **Key:** no **Agg:** count **Format:** integer **Summary:** #### Total PPAP elements tracked **Key:** n_elements **Expr:** count **Format:** integer **Notes:** Key: S = supplier submits to the customer and retains a copy; R = supplier retains and makes available on request; * = as specified by the customer for Level 4. Level 5 requires all items to be available for review at the supplier's site. The status and owner columns are for your own tracking. Always confirm the exact requirement with your customer, since customer-specific requirements can add or change items. Defaults follow the pattern in the AIAG PPAP manual; check the current edition. ## Content **Intro:** This PPAP checklist lists all 18 production part approval process elements, shows which ones you submit or retain at each of the five submission levels, and gives you status, owner and due date columns. Edit it in the browser and export to Excel to use as your project tracker. **Sections:** #### How to use the checklist **Body:** First confirm the submission level in your purchase order or customer portal. Level 3 is the default when the customer does not state one. Then use the columns for that level to see what to send and what to keep on file. Delete or mark rows not applicable, such as design FMEA when the customer holds design responsibility, and assign each remaining row an owner and a date. Work backwards from the customer's due date so the part submission warrant is signed last. Export to Excel and share it with your APQP team. **Bullets:** - Confirm level and customer-specific requirements first - Mark inapplicable items with a reason - Sign the PSW only after all other elements are complete #### The five submission levels **Body:** Level 1 is the warrant only, plus an appearance approval report where relevant. Level 2 adds product samples and limited supporting data. Level 3 adds samples and complete supporting data, and is the most common. Level 4 is a warrant plus whatever the customer defines. Level 5 is a warrant with samples and complete data reviewed at the supplier's location. Regardless of level, you must be able to produce everything retained, because the customer can ask for any element at any time. #### Reading the status columns **Body:** Use status to show where each element stands. A good habit is to review the tracker at a weekly APQP meeting and flag any element not started with fewer than ten working days to go. Typical long lead items are MSA studies, initial process studies that need production-intent runs, and dimensional results from the CMM, which depend on tooling being finished. Late PPAP can delay launch and trigger premium freight, so link the tracker to your launch plan. #### Common mistakes **Body:** Common errors include submitting at the wrong level, signing the PSW before data is complete, using samples from a non-production process, and missing customer-specific requirements stored in a portal. Another is storing PPAP evidence in many places, which makes retrieval slow when the customer asks. Keep one folder per part number and revision, and update it when a change occurs. **Cta:** If PPAP evidence is spread across ERP, quality software and shared drives, Netray can build a private AI layer that finds and assembles it inside your own network. **Faq:** #### How many elements are in a PPAP? **Answer:** The AIAG PPAP manual lists 18 elements, from design records to the part submission warrant. Not every element applies to every part, and what you submit depends on the submission level and customer-specific requirements. #### What is the default PPAP submission level? **Answer:** Unless the customer specifies otherwise, Level 3 is the default: a warrant with product samples and complete supporting data. Check the purchase order or supplier portal, because many customers set their own level per part. #### What do S and R mean in the checklist? **Answer:** S means the supplier submits the item to the customer and keeps a copy. R means the supplier retains the item and provides it on request. An asterisk means the customer defines the requirement, which is the case for Level 4. #### Is this the official AIAG form? **Answer:** No. It is an independent checklist built from the structure of the PPAP elements and levels. Use the current AIAG PPAP manual and your customer's requirements as the authority. ## Search terms ppap checklist excel template, ppap checklist template, ppap checklist excel, ppap checklist aiag, ppap requirements checklist, ppap template excel, ppap format in excel, ppap form template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json