# China Factory Inspection Defect Log with AQL Pass/Fail > Source: https://netray.co/tools/china-factory-inspection-defect-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Record sample size and defects by lot, compare them with your AQL accept numbers and get a pass or fail flag and defect rate per lot. ## Category quality ## Region China ## Industry Manufacturing ## Audience - Supplier quality engineer - QC inspector - Sourcing agent - Buyer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Lot / PO line **Key:** lot **Type:** text #### Part number **Key:** part **Type:** text #### Lot quantity **Key:** lot_qty **Type:** number **Format:** integer #### Sample size **Key:** sample **Type:** number **Format:** integer **Help:** From the Z1.4 table for your inspection level. #### Critical defects **Key:** critical **Type:** number **Format:** integer #### Major defects **Key:** major **Type:** number **Format:** integer #### Minor defects **Key:** minor **Type:** number **Format:** integer #### Major Ac **Key:** ac_major **Type:** number **Format:** integer **Help:** Accept number for your major AQL. #### Minor Ac **Key:** ac_minor **Type:** number **Format:** integer **Help:** Accept number for your minor AQL. #### Total defects **Key:** defects **Type:** number **Expr:** critical + major + minor **Format:** integer #### Defect rate **Key:** rate **Type:** number **Expr:** if(gt(sample,0), defects / sample * 100, 0) **Format:** percent #### Pass (1) / Fail (0) **Key:** pass **Type:** number **Expr:** if(and(eq(critical,0), and(lte(major,ac_major), lte(minor,ac_minor))), 1, 0) **Format:** integer #### Inspector **Key:** inspector **Type:** text #### Date **Key:** date **Type:** date **Rows:** **Lot:** PO7712-1 **Part:** HSG-220 **Lot qty:** 5000 **Sample:** 200 **Critical:** 0 **Major:** 6 **Minor:** 9 **Ac major:** 10 **Ac minor:** 14 **Inspector:** Li Wei **Date:** 2026-10-12 **Lot:** PO7712-2 **Part:** HSG-221 **Lot qty:** 2400 **Sample:** 200 **Critical:** 0 **Major:** 11 **Minor:** 8 **Ac major:** 10 **Ac minor:** 14 **Inspector:** Li Wei **Date:** 2026-10-12 **Lot:** PO7730-1 **Part:** CBL-14 **Lot qty:** 1200 **Sample:** 125 **Critical:** 0 **Major:** 3 **Minor:** 6 **Ac major:** 7 **Ac minor:** 10 **Inspector:** Chen Hua **Date:** 2026-10-13 **Lot:** PO7741-1 **Part:** PCB-A9 **Lot qty:** 800 **Sample:** 80 **Critical:** 1 **Major:** 1 **Minor:** 2 **Ac major:** 5 **Ac minor:** 7 **Inspector:** Chen Hua **Date:** 2026-10-14 **Lot:** PO7755-1 **Part:** BRK-30 **Lot qty:** 9000 **Sample:** 315 **Critical:** 0 **Major:** 9 **Minor:** 15 **Ac major:** 14 **Ac minor:** 21 **Inspector:** Li Wei **Date:** 2026-10-15 **Totals:** #### Total lot quantity **Key:** lot_qty **Agg:** sum **Format:** integer #### Total defects found **Key:** defects **Agg:** sum **Format:** integer #### Lots passed **Key:** pass **Agg:** sum **Format:** integer **Summary:** #### Lot acceptance rate **Key:** pass_rate **Expr:** if(gt(count,0), sum_pass / count * 100, 0) **Format:** percent **Primary:** true #### Average defect rate **Key:** avg_rate **Expr:** avg_rate **Format:** percent **Notes:** Sample sizes and Ac numbers in the examples follow common ANSI/ASQ Z1.4 / ISO 2859-1 single sampling, normal inspection, general level II, with AQL 2.5 for major and 4.0 for minor and zero critical defects accepted. Always read the values from the current standard table for your lot size and AQL before inspecting. This sheet applies the accept numbers you enter; it does not choose them. ## Content **Intro:** Whether the QC is done by your own engineer, a third-party inspection firm or the supplier, you need a single log of what was sampled, what was found and whether the lot passes. This worksheet records defects by severity and gives an immediate pass or fail per lot. **Sections:** #### How to use the log **Body:** Add one row per lot. Enter the lot quantity, the sample size read from the sampling table, and the number of critical, major and minor defects found. Enter your accept numbers for major and minor defects from the AQL table. The sheet computes total defects, defect rate and a pass flag that is 1 only when there are no critical defects and major and minor counts are within their accept numbers. Export to Excel or PDF and attach it to the inspection report. #### The method behind it **Body:** Attribute sampling plans such as ANSI/ASQ Z1.4, equivalent to ISO 2859-1, give a sample size from the lot size and inspection level, and an accept (Ac) and reject (Re) number from the acceptance quality limit. If the defects found are at or below Ac the lot is accepted, if at or above Re it is rejected. Defects are classified by severity: critical affects safety or legal compliance, major affects function or use, minor is cosmetic or small deviation. Define the classes in a written defect list before inspection starts. #### Reading the results **Body:** A pass means the sample evidence supports accepting the lot at your AQL, not that the lot is defect free. A lot with many defects just under the Ac number is a warning sign and should trigger tightened inspection or supplier feedback. The summary shows lot acceptance rate and the average defect rate. Track them by supplier over time and use a change to tightened or reduced inspection according to your plan. **Bullets:** - Any critical defect fails the lot in this sheet - Failed lots: sort, rework or reject by agreement, then re-inspect - Repeated failures: raise a corrective action request #### Mistakes and ERP links **Body:** Typical errors include inspecting the first cartons only, mixing batches in one sample, not recording the sample draw method and changing the AQL after seeing results. Define random carton selection in advance. In an ERP, an inspection lot with results recording (SAP QM, Infor, Epicor or Oracle quality modules) can hold the same data and drive usage decisions. Use this sheet where the supplier's factory has no access to your system. **Cta:** If inspection results from Chinese suppliers arrive by email and spreadsheet, Netray can help bring them into your ERP quality module so usage decisions and supplier ratings update automatically. **Faq:** #### What AQL should I use? **Answer:** A common starting point for consumer and industrial goods is 0 for critical, 2.5 for major and 4.0 for minor defects. Safety-critical, medical or aerospace parts need tighter limits or 100% inspection. Set AQL by risk and agree it in the supply contract. #### How do I find the sample size? **Answer:** Use the lot size and inspection level (general level II is common) to find a sample size code letter in the Z1.4 table, then read the sample size and accept number for your AQL. Many buyers publish a one-page table for suppliers to avoid disagreements. #### Is this the same as a pre-shipment inspection report? **Answer:** It is the data record that sits inside one. A full pre-shipment inspection report also covers quantity, packing, marking, function tests and photos. Use this sheet for the defect results and our pre-shipment inspection template for the full report. #### What if the lot fails? **Answer:** Agree the action in the contract: 100% sorting by the supplier at its cost, rework, or rejection. After correction the lot is re-inspected, usually under tightened inspection. Record the disposition and the reason, and raise a corrective action request if the cause is repeated. ## Search terms factory inspection checklist china, inspection defect log excel, aql inspection report template, china qc inspection record, critical major minor defects log, incoming inspection log template, pre shipment inspection worksheet, aql 2.5 4.0 inspection sheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json