Supply Chain & InventoryFree worksheetPDF, Excel, Word exportChemicals & Process Manufacturing

Raw Material Lot Release and Retest Tracker Worksheet

Material that is not yet released, past its retest date or rejected must never reach a batch. This tracker keeps lot status, retest dates and stock value visible in one place, ready to export.

Download:

Lot number	Material	Supplier	Received date	Retest / expiry date	Status	Qty on hand (kg)	Cost per kg	Stock value	Location
								$3,680
								$2,997
								$1,050
								$2,016
								$1,040

Lots tracked

Total quantity (kg)

7,090

Total stock value

$10,783

Largest lot value

$3,680

Average value per lot

$2,157

Largest lot value

$3,680

Illustrative data. Retest periods come from supplier specifications and your own stability data. Keep quarantined and rejected lots physically segregated and mirrored in your ERP lot status.

Retest alerts from ERP lot data

Optional: discuss automatic retest and expiry alerts built from your ERP.

Optional. The tool and every export work without this. No spam.

How to use the tracker

Add each incoming lot as soon as it is received and set its status to quarantine. Update to released after the certificate of analysis has been reviewed and any incoming tests pass. Enter the retest or expiry date from the supplier label or your own policy. The sheet calculates stock value from quantity and unit cost. Export to Excel and sort by retest date to plan retesting before material becomes unusable.

Retest versus expiry

An expiry date means the material should not be used after that date. A retest date means the material may still be usable if it passes testing, after which a new retest date is assigned. Many chemical raw materials have retest dates, not hard expiry. Use the status field to separate the two situations and record the test used for the retest.

Quarantine: received, not yet approved
Released: approved for use in production
Retest pending: date reached, awaiting result
Rejected: failed, awaiting return or disposal
Expired: past date and not retested

Reading the totals

The stock value total helps finance understand what is tied up in quarantine, retest pending or rejected status. A growing value in rejected or expired material points to supplier quality problems or over-ordering. Compare the quantity on hand with your ERP on-hand balance during cycle counts to find lots that moved without being recorded.

Common mistakes

Typical failures are using material while its status is still quarantine, missing a retest date because the label was not scanned, mixing lots in a tank without recording both, and not blocking rejected stock in the ERP. Enforce status through the ERP's lot status or inspection lot functions rather than relying on this sheet alone.

Frequently Asked Questions

What is the difference between quarantine and rejected?

Quarantine is a temporary hold pending review or testing. Rejected means the material failed and must be returned, reworked under a deviation or disposed of. Keep them in separate locations.

How do I set a retest date?

Use the supplier's stated retest period, or your own stability data and policy. Count from the manufacture date unless the supplier specifies otherwise, and record the basis.

Can I use expired material?

Generally not without a documented assessment, retest and approval. Many quality systems require a deviation. Never use material past expiry simply because stock is short.

Should this replace ERP lot control?

No. Use it as a quick register or a staging sheet. The authoritative status should live in your ERP or warehouse system so transactions are blocked automatically.

Netray can help build alerts from ERP lot data that warn planners before retest dates are reached.

Talk to an Expert Explore More Free Tools

Related Tools

Quality & Inspection

More Supply Chain & Inventory tools

See all

Back to All Tools