# Receiving Inspection Lot Disposition Log (Excel) > Source: https://netray.co/tools/receiving-inspection-lot-disposition-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable log that records each inspected lot and automatically flags the ones that exceed the acceptance number. ## Category quality ## Audience - Incoming inspector - Supplier quality - Receiving clerk ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Lot / PO **Key:** lot **Type:** text #### Supplier **Key:** supplier **Type:** text #### Part number **Key:** part **Type:** text #### Date received **Key:** received **Type:** date #### Lot qty **Key:** lot_qty **Type:** number #### Sample size **Key:** sample_qty **Type:** number #### Defectives found **Key:** defects **Type:** number #### Accept no. Ac **Key:** ac **Type:** number #### Sample defect % **Key:** rate **Type:** number **Expr:** defects / sample_qty * 100 **Format:** decimal #### PPM **Key:** ppm **Type:** number **Expr:** defects / sample_qty * 1000000 **Format:** integer #### Reject flag (1 = reject) **Key:** reject **Type:** number **Expr:** if(gt(defects, ac), 1, 0) **Format:** integer #### Disposition **Key:** action **Type:** select **Options:** - Accept - Reject - return - Reject - screen - Use as is (deviation) - Hold **Rows:** **Lot:** PO4471-1 **Supplier:** Alpha Castings **Part:** CS-2210 **Received:** 2026-10-05 **Lot qty:** 800 **Sample qty:** 80 **Defects:** 1 **Ac:** 3 **Action:** Accept **Lot:** PO4475-1 **Supplier:** Beta Fasteners **Part:** FX-0815 **Received:** 2026-10-06 **Lot qty:** 5000 **Sample qty:** 200 **Defects:** 8 **Ac:** 7 **Action:** Reject - screen **Lot:** PO4480-2 **Supplier:** Gamma Plastics **Part:** PL-3340 **Received:** 2026-10-08 **Lot qty:** 1200 **Sample qty:** 125 **Defects:** 0 **Ac:** 3 **Action:** Accept **Lot:** PO4486-1 **Supplier:** Alpha Castings **Part:** CS-2211 **Received:** 2026-10-12 **Lot qty:** 600 **Sample qty:** 80 **Defects:** 4 **Ac:** 3 **Action:** Reject - return **Lot:** PO4490-1 **Supplier:** Delta Wire **Part:** WR-0092 **Received:** 2026-10-14 **Lot qty:** 3000 **Sample qty:** 200 **Defects:** 5 **Ac:** 7 **Action:** Accept **Totals:** #### Total pieces received **Key:** lot_qty **Agg:** sum **Format:** number #### Total pieces sampled **Key:** sample_qty **Agg:** sum **Format:** number #### Total defectives found **Key:** defects **Agg:** sum **Format:** number #### Lots flagged for rejection **Key:** reject **Agg:** sum **Format:** integer **Summary:** #### Overall sample defect rate (%) **Key:** overall **Expr:** sum_defects / sum_sample_qty * 100 **Format:** decimal **Primary:** true #### Overall PPM **Key:** overall_ppm **Expr:** overall * 10000 **Format:** integer #### Lot rejection rate (%) **Key:** reject_rate **Expr:** sum_reject / count * 100 **Format:** percent **Primary:** true **Notes:** Sample sizes and acceptance numbers shown are examples. Take yours from your sampling plan (for example ANSI/ASQ Z1.4) and your supplier agreement. The reject flag is a prompt, not a disposition; the disposition column records the decision. ## Content **Intro:** Every receiving dock needs a running record of what was inspected and what happened to it. This worksheet is that record: enter each lot once, and it calculates the defect rate, PPM and reject flag, with totals you can paste straight into a supplier review. **Sections:** #### How to use it **Body:** Add one row per inspected lot. Enter the lot or PO number, supplier, part number, date, lot quantity, the sample size you actually inspected, the defectives found and the acceptance number from your plan. The calculated columns show the sample defect rate, the PPM and a reject flag when defectives exceed the acceptance number. Then record the disposition. Export to Excel to keep a monthly archive or to feed a supplier scorecard. **Bullets:** - Delete the example rows before you start. - Record the actual sample taken, even if the plan said otherwise. - Use Hold for lots waiting on engineering review. #### What the columns mean **Body:** The sample defect rate is defectives divided by sample size, expressed as a percent. PPM scales the same ratio to a million, the unit most supplier contracts use. The reject flag is 1 when defectives found exceed the acceptance number Ac, and 0 otherwise. Totals and the overall rate at the bottom pool all lots, which is useful for a quick supplier trend but should not mix different parts with different criticality without care. #### Reading the summary **Body:** In the example, five lots show two flagged rejects and a lot rejection rate of 40 percent, yet the pooled defect rate is around 2.7 percent. These two numbers say different things: one tells you how often lots fail, the other how bad the failures are. A supplier with few but severe rejects needs a different conversation from one with frequent marginal ones. #### Common mistakes **Body:** Do not overwrite the sample size with the lot size when screening a rejected lot, or the defect rate will look artificially low. Keep sampling and screening results on separate rows. Also remember that a lot accepted by sampling still contains defects; the log shows the sample, not the whole lot. **Cta:** If this log lives in a spreadsheet today but your ERP already receives the goods, we can help feed it automatically from inspection lots. Ask for a short review. **Faq:** #### Can I use this for AQL sampling? **Answer:** Yes. Enter the sample size and acceptance number from your AQL table for each lot. The worksheet does the comparison and flags lots with more defectives than the acceptance number. #### How do I record a lot that was 100 percent screened? **Answer:** Add a second row for the screening, with the screened quantity as the sample size and the defectives found. Set Ac to 0 if you want any defective to flag, and mark the disposition accordingly. #### Does it replace my ERP receiving inspection? **Answer:** No. It is a lightweight record for sites without a quality module, or a working sheet beside one. Where an ERP inspection lot exists, treat the ERP as the system of record. #### How many rows can I log? **Answer:** As many as you like in the browser, and everything exports to Excel. For long histories, export monthly and start a fresh log to keep it fast. ## Search terms receiving inspection log excel, incoming inspection lot log, lot acceptance record template, incoming material inspection register, supplier lot defect log, inspection results spreadsheet, receiving inspection record, lot reject flag worksheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json