Upd | Vda 6.3 Audit Checklist Excel

| No. | Process Element / Question | Audit Evidence / Documents Reviewed | Findings / Observations | Rating (10-0) | Risk Class (A/B) | Action Required? | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | | P6 PROCESS ANALYSIS | Production Process | | | | | | 6.1 | Are the process sequences/parameters monitored and recorded? | | | | | | | 6.1.1 | Are current drawings/SOPs available at the workstation? | Check for revision status, operator access. | | | | | | 6.1.2 | Are the process parameters (torque, temp, speed) set according to specifications? | Check machine settings vs. setup sheet. | | | | | | 6.1.3 | Are process parameters monitored and logged (manual or automated)? | Review control charts, PLC data logs. | | | | | | 6.1.4 | Are deviations in process parameters reacted to? | Look for reaction plans, scrap tickets. | | | | | | 6.2 | Are work contents/stations suitable for personnel? | | | | | | | 6.2.1 | Are workplaces ergonomically designed? | Observe operator movement, lighting. | | | | | | 6.2.2 | Are the required qualifications for the employee available? | Check training matrix, qualification cards. | | | | | | 6.3 | Are equipment and tools suitable? | | | | | | | 6.3.1 | Are equipment and tools capable for the requirements? | Check Cm/Cmk studies, calibration stickers. | | | | | | 6.3.2 | Are maintenance activities carried out? | Review preventive maintenance logs. | | | | | | 6.4 | Are error-proofing measures effective? | | | | | | | 6.4.1 | Are corrective actions from previous audits implemented? | Review previous audit CAPA log. | | | | | | 6.4.2 | Are Poka-Yoke/error-proofing devices effective? | Perform challenge test on sensors. | | | | | | 6.5 | Is the material correctly stored and identified? | | | | | | | 6.5.1 | Is material identification available and correct? | Check FIFO, batch traceability. | | | | | | 6.5.2 | Are storage conditions adhered to? | Check humidity/temp control for chemicals. | | | | |

It calculates the "Degree of Fulfillment" (E_G) and process element results (E_Pn) automatically.

Since I cannot attach a downloadable .xlsx file directly, I have provided the exact structure, formulas, and column headers you need to copy and paste into Excel immediately. This covers the core section, which is the heart of the VDA 6.3 standard. vda 6.3 audit checklist excel

Built-in formulas can handle the complex "downgrading" logic (e.g., if a *-question is scored at 4, the total result cannot be an 'A').

Make the "Rating" column change color automatically: | | | | | | | 6

You can copy the table below and paste it directly into Excel. This focuses on , specifically P6.1 (Process Implementation) , which is the most common starting point.

Use this formula to auto-generate the overall conclusion based on the average: | Check machine settings vs

⚠️ – The latest VDA 6.3 is Version 4 (2023) . If you find an older checklist (pre-2023), it is outdated . Ensure the Excel file includes changes in: