NDT Consumable Batch and Shelf-Life Record Template
Consumable records need to connect the actual container to its product, batch and applicable evidence. A shelf-life date copied from a different product or manufacturing region can create a convincing but unreliable stock record.
For: U.S. NDT equipment coordinators, quality staff and inspection business owners
Start with the container that will be issued
An NDT consumable register should answer a practical question: which identified material is available for an approved use, and what evidence supports its disposition? Start with the manufacturer's product name, part number where applicable, batch identifier and packaging. Preserve the original label information before creating an internal stock nickname. A familiar color or abbreviated product description is not enough to distinguish different materials, packaging variants or batches. The record should allow another coordinator to find the same container and the same supporting documents.
Keep this register separate from the equipment calibration schedule. Consumables may have shelf-life, storage, opening and disposition considerations, but those are not instrument calibration events. This guide provides an administrative record structure; it does not select a penetrant system, prescribe chemical mixing or authorize material beyond a stated limitation. Product suitability and use conditions remain governed by the applicable procedure, manufacturer information and authorized technical review. Purchasing and stores can make that review easier by preserving reliable identity and evidence.
Distinguish the product identity from the batch identity
The product name identifies what was supplied; the batch identifier connects it to a particular manufacturing record. Both belong in the register. A purchase order can contain several batches of the same product, and one batch can arrive through several receipts. Do not use the purchase order number as a substitute for the manufacturer batch. Add a separate receipt identifier so quantity movements can be reconstructed without breaking the relationship to the original manufacturing evidence.
Magnaflux's U.S. certification lookup asks for a batch identifier for consumable products and directs users to other locations for products manufactured elsewhere. Its equipment lookup instead uses a product part number. This illustrates why the correct lookup route matters. Record the manufacturing origin or applicable supplier region when it is needed to find the right evidence. A failed lookup does not by itself prove that the material is invalid; it may mean that the wrong portal or identifier was used.
Keep batch certificates and safety data sheets distinct
A batch certificate and a safety data sheet serve different purposes. Preserve both when required, using labels that make their role clear. Magnaflux's safety data sheet page searches by product name, while its consumable certification page uses the batch identifier. A product-level SDS should not be renamed as a batch certificate simply because it was the first available PDF. Likewise, a batch conformity document is not a substitute for the applicable hazard information reviewed by the responsible workplace personnel.
Use separate register columns for the certificate reference and SDS reference. Record the document version or date where available and the location of the retained file. Ask the appropriate owner to review applicability to the product and location of use. The register can help staff find the documents, but it should not summarize handling controls from memory or replace the actual SDS. If the supplier updates a document, preserve the relationship between the current reference and any record relied on for an earlier receipt or job.
Establish the applicable shelf-life basis before calculating dates
Ask which manufacturer statement applies to the exact product and packaging supplied. Record the statement's date or revision and its scope. Magnaflux's March 26, 2025 shelf-life statement defines its stated period for unopened materials, identifies an exception category and explains its batch-date coding. That is a manufacturer-specific policy with conditions. It is not a universal NDT shelf-life rule, and it should not be transferred to another supplier or region without confirming applicability.
If the manufacturer provides a printed expiry or use-by date, preserve that information as received. If an approved process derives a date from a manufacturing code and a published policy, retain the inputs and the source rather than storing only the calculated result. Have the designated reviewer resolve conflicting dates or unclear codes. A spreadsheet formula should implement an approved interpretation; it should not silently decide how to handle exceptions, opened containers or contradictory supplier information. Record the date basis so the calculation can be checked later.
Separate unopened shelf life from opened-container status
A manufacturer statement about unopened stock does not automatically define how long an opened container remains suitable. Record opening information when the applicable process requires it, and direct questions about continued use to the responsible technical owner. Do not restart a manufacturer's shelf-life clock when a container is opened, transferred to a different shelf or entered into a new spreadsheet. Those events change the administrative record, not the original manufacturing date or the scope of the manufacturer's statement.
Use plain status descriptions such as unopened, opened under controlled process, awaiting review, restricted or disposed, as defined by your organization. Keep the status separate from the date field. A container can be within a recorded shelf-life period while a storage or identity concern still requires review. Conversely, a date question should not be concealed by changing the status label to available. The record should make both the known dates and the unresolved condition visible to the person deciding whether the stock may be issued.
Capture receipt differences before stock is combined
At receipt, compare the delivered product, package size, batch identifiers and quantities with the order and accompanying evidence. If several batches arrive, create separate entries even when the product is identical. Record visible packaging damage, unreadable labels or other discrepancies through the normal receiving process. Do not consolidate all containers into one batch row simply because the supplier sent a single invoice. That shortcut can later make it impossible to identify which batch was used or which stock needs attention.
Preserve labels and supporting documents in the organization's approved record system. Photographs can help document an ambiguous marking or mixed shipment, but they do not resolve the technical question by themselves. Ask the supplier for clarification where necessary and retain the response. If the order required a particular remaining shelf life at delivery, compare the actual evidence with that commercial requirement. An acceptance decision should identify whether the delivered stock meets the agreed condition or whether an authorized exception or return is required.
Give stock rotation a visible and limited role
A stock rotation list can help staff see which approved material should be considered for issue first, according to the organization's process. It should include product, batch, quantity, relevant date and disposition. Do not sort solely by the earliest date if the list includes restricted material or different products that are not interchangeable. A useful issue view shows only the appropriate candidates and makes restrictions prominent. The underlying register should still preserve the full history, including held and disposed stock.
Avoid implying that stock rotation establishes technical suitability. It is a logistics aid operating within approved product and condition requirements. If a project requires a specific product or evidence package, that requirement takes priority over clearing an older shelf. Record who reviews stock that is unlikely to be used before its applicable date and what action is chosen. Reordering, returning or disposing of material are different decisions; combining them under a vague obsolete label makes inventory planning and later investigation more difficult.
Preserve identity when quantities are split
A bulk receipt or carton can be divided among several kits or locations. Record the quantity transferred and maintain the original product and batch relationship. If your process permits secondary containers, follow its approved identification and handling requirements rather than inventing a label from this article. The administrative objective is that a later user can identify the material and find the applicable evidence. A transfer should not create a new manufacturer batch or erase the original container's context.
For multi-location stock, use a movement record with date, source, destination, quantity, unit and person responsible. Keep units explicit: containers, liters and pounds are not interchangeable quantity fields. If a count is uncertain, record the uncertainty and reconcile it through the appropriate process. Do not make a spreadsheet balance by silently changing the receipt quantity. An adjustment should have a reason so the record remains useful for purchasing and for identifying what happened to a particular batch.
Link issued material to the work when required
The level of job traceability depends on the applicable requirements. Determine whether the organization needs a batch reference on a job record, a kit issue sheet or another controlled document. If it does, establish how that reference is captured at issue and checked at return or closeout. The stock register should support that link without pretending to be the inspection report. A broad statement that material was available on the shelf does not establish which batch a particular job actually used.
Use a consistent product and batch reference in the chosen job record. If the crew changes batches during the work, preserve the change rather than keeping the first batch number for convenience. The technical process owner should determine the required detail and any review consequences. Administrative staff can provide the identification and evidence trail, but should not infer acceptance of the inspection from material issuance. A reliable link helps authorized reviewers answer later questions without reconstructing events from purchase invoices alone.
Handle missing evidence without rewriting the material history
When a certificate is missing, first verify the product, manufacturing origin and batch identifier used in the request. Preserve the label as received and ask the supplier or manufacturer through the appropriate channel. Record the retrieval attempt, response and next action. Do not assign a certificate for a neighboring batch because its product name matches. The wrong document can create a more serious ambiguity than a clearly recorded missing document, especially when it later appears complete in an audit package.
If the label is unreadable, record that limitation and route the material for disposition under the organization's process. A handwritten guess should not become the official batch identity. If the issuer supplies corrected evidence, retain the relationship between the original discrepancy and the resolution. The person closing the issue should be able to explain what information changed and why it now supports the disposition. Merely attaching an additional file does not demonstrate that the identity problem has been resolved.
Work through a fictional mixed-batch delivery
A hypothetical inspection business orders twelve containers of a fictional approved consumable. Eight arrive from Batch Example A and four from Batch Example B. The packing slip lists only the product and total quantity. Stores creates two batch entries linked to the same receipt, requests the relevant evidence for each, and records their separate date bases. The company does not infer that both batches share the manufacturing date of the first container opened for checking. These names and quantities are fictional administrative examples.
Later, three containers from Example A are transferred to another location and two are issued to a job. The register can show those movements while retaining the same manufacturer batch identity. If a question arises about Example B, the coordinator can identify the affected remaining stock without restricting unrelated Example A merely because both came on one invoice. Whether any particular material or job requires restriction is an authorized review decision. The register's contribution is a precise scope of known identity and movement.
Use the worksheet without treating it as an app import
The downloadable consumable batch worksheet contains identity, receipt, quantity, document references, date basis, exception and disposition fields. Its single example row is marked hypothetical and deliberately leaves unconfirmed dates empty. Replace the example with your own controlled records and adapt the fields to the applicable process. Store documents separately in your approved system and place their references in the worksheet. The file is a generic CSV template; it is not an import format for NDT Connect and does not calculate whether material is acceptable.
NDT Connect's equipment tracker is designed for asset details such as serial number, manufacturer, model, calibration due date, status and notes. It is not a consumable inventory, batch allocation or chemical shelf-life system. Its calibration reminder should not be presented as a stock expiry workflow. Keep consumable records in a tool suited to the required quantities and movements. Use the equipment tracker for the durable instruments and accessories associated with the work, while maintaining the appropriate distinction between equipment evidence and consumable evidence.
Review stock exceptions with a named decision owner
Create a periodic review list from actual unresolved conditions: missing batch evidence, unclear dates, damaged packaging, stock nearing its applicable planning date or unexplained quantity differences. Assign each issue to a person who can obtain information or request the necessary technical decision. Do not automatically extend a date because a project has been delayed or because the material appears unchanged. Any decision about use beyond a stated limitation must follow the applicable requirements and the organization's authorized process.
Close each exception with the evidence reviewed, decision, date and responsible person. Preserve disposal or return records where relevant, and remove the material from the available-stock view without deleting its history. The final register should distinguish what is present, what is approved for issue and what is awaiting a decision. That clarity reduces wasteful searching and prevents an attractive spreadsheet date from standing in for the manufacturer-specific evidence and authorized judgment the material actually requires.
Frequently Asked Questions
Is a consumable batch number the same as a purchase order number?
No. Preserve the manufacturer batch separately from the purchase and receipt references; a single shipment can contain several batches.
Can I apply one manufacturer shelf-life rule to all NDT products?
No. Confirm the applicable product, packaging, manufacturing origin, statement and conditions. Record the date basis used for the actual material.
Does this CSV import into the equipment tracker?
No. It is an optional standalone consumable worksheet. NDT Connect does not provide consumable batch or stock-expiry management.
References & Standards Cited
- Magnaflux: U.S. consumable batch certification lookup View source ↗
- Magnaflux: shelf life statement effective March 26, 2025 View source ↗
- Magnaflux: safety data sheet lookup View source ↗
Related on NDT Connect
Join NDT Connect — free
The free marketplace for the NDT industry — connect inspectors and the companies that need them.
Free to join · Compare provider qualifications and confirm availability directly · Browse providers
By NDT Connect Editorial · Updated
Source-based editorial guidance. Read our editorial policy and disclosures.