# Receiving Lot Acceptance Log Worksheet > Source: https://netray.co/tools/receiving-lot-acceptance-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A lot-by-lot log for incoming inspection. Enter sample size, accept number and defects found; accept or reject and defect rate are calculated. ## Category quality ## Audience - Receiving inspector - Supplier quality - Quality technician ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Date received **Key:** date **Type:** date #### PO number **Key:** po **Type:** text #### Supplier **Key:** supplier **Type:** text #### Part number **Key:** part **Type:** text #### Lot qty **Key:** lot_qty **Type:** number #### Sample size **Key:** sample_n **Type:** number #### Accept no. (Ac) **Key:** accept_c **Type:** number #### Defects found **Key:** found **Type:** number #### Accepted (1 = yes) **Key:** accepted **Type:** number **Expr:** if(lte(found, accept_c), 1, 0) **Format:** integer #### Sample defect rate **Key:** rate **Type:** number **Expr:** found / sample_n * 100 **Format:** percent **Rows:** **Date:** 2026-10-12 **Po:** PO-70412 **Supplier:** Northline Castings **Part:** CST-2210 **Lot qty:** 500 **Sample n:** 50 **Accept c:** 1 **Found:** 0 **Date:** 2026-10-13 **Po:** PO-70431 **Supplier:** Apex Fasteners **Part:** FST-0814 **Lot qty:** 2000 **Sample n:** 125 **Accept c:** 3 **Found:** 2 **Date:** 2026-10-14 **Po:** PO-70455 **Supplier:** Northline Castings **Part:** CST-2210 **Lot qty:** 500 **Sample n:** 50 **Accept c:** 1 **Found:** 3 **Date:** 2026-10-15 **Po:** PO-70468 **Supplier:** Meridian Cable **Part:** CBL-3302 **Lot qty:** 300 **Sample n:** 32 **Accept c:** 1 **Found:** 1 **Totals:** #### Lots accepted **Key:** accepted **Agg:** sum **Format:** integer #### Lots received **Key:** po **Agg:** count **Format:** integer #### Defects found **Key:** found **Agg:** sum **Format:** integer **Summary:** #### Lot acceptance rate **Key:** lot_rate **Expr:** sum_accepted / count * 100 **Format:** percent **Primary:** true **Description:** Accepted lots divided by lots received **Notes:** Take sample size and accept number from the sampling plan in your inspection procedure. A lot is accepted when defects found is at or below the accept number. Rejected lots go to the MRB or back to the supplier. ## Content **Intro:** Receiving inspectors need a simple running record of which lots came in, how many were checked and whether they passed. This worksheet logs each lot, decides accept or reject from your accept number, and totals the lot acceptance rate. **Sections:** #### How to use the log **Body:** Add a row for each received lot. Enter the PO, supplier and part, then the lot quantity, the sample size from your sampling plan and the accept number Ac. After inspection, type the number of defective units or defects found. The accepted column returns 1 when found is at or below Ac, and the sample defect rate shows the percentage found in the sample. Export to Excel monthly and use the supplier column to filter by vendor. #### Acceptance logic **Body:** Single sampling by attributes has one rule: inspect n units, accept the lot if defects found are at most Ac, reject if they are at least Re, which equals Ac plus one. This is the same structure used by ANSI/ASQ Z1.4 style plans. The worksheet does not choose n and Ac for you, so take them from the plan your procedure or customer specifies, and apply the same plan consistently for the same part and supplier. **Bullets:** - Row 3 above found 3 against Ac of 1, so the lot is rejected - Row 4 found 1 against Ac of 1 and is accepted - Sample defect rate is not the lot defect rate, it is only an estimate #### Reading the acceptance rate **Body:** The lot acceptance rate is a quick supplier health indicator. Trend it by supplier over a quarter. A supplier falling below your target repeatedly may need tightened inspection under the switching rules in your plan, or a supplier corrective action request. A supplier with a long clean run may qualify for reduced inspection or skip lot treatment, if your procedure allows it. Keep the rejected lot disposition in the same record. #### Common mistakes **Body:** Do not change the sample size after seeing early defects without documenting why. Do not average defects across lots to hide a rejected lot. Do not count a reworked lot as accepted without reinspection under the plan. Always log the PO and part, because without them you cannot trace a rejection back to a receipt in the ERP. Record rejected lots in a quarantine location until the board dispositions them. **Cta:** If lot results are kept in spreadsheets while the ERP receives goods blindly, Netray can help route sampled lots to inspection and post results back. **Faq:** #### Where do I get sample size and accept number? **Answer:** From the sampling plan your quality procedure or customer specifies, such as ANSI/ASQ Z1.4 tables by lot size and AQL, or a fixed customer plan. Some plans use zero acceptance. This worksheet records results, it does not pick the plan. #### What counts as a defect found? **Answer:** Count according to your plan: defective units for percent defective plans, or individual defects for defects per hundred units plans. Define the unit and the defect classification in your inspection instruction so every inspector counts the same way. #### Should I log accepted lots too? **Answer:** Yes. Acceptance history is what supports reduced inspection and supplier ratings. A log of only rejections cannot show a trend or justify a change in sampling level. #### Can I use it for 100 percent inspection? **Answer:** Yes. Set sample size equal to lot quantity and accept number to zero if no defects are allowed, or to the allowed count. The accept logic works the same way. ## Search terms incoming lot acceptance log, receiving inspection log excel, lot acceptance record, incoming inspection register, supplier lot acceptance rate, receiving inspection spreadsheet, accept reject log, lot disposition log --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json