Food traceabilityLabels and stock
FEFO stock reviews: make the date basis and exceptions visible
A first-expire-first-out review needs reliable product identity, date information and stock location. A sorted list is useful only if staff understand the date used and can recognise blocked, unidentified or otherwise restricted stock.
At a glance
A first-expire-first-out review needs reliable product identity, date information and stock location. A sorted list is useful only if staff understand the date used and can recognise blocked, unidentified or otherwise restricted stock.
Define the decision behind the record
Define the relevant date fields and status rules for the operation. Avoid mixing different date meanings in one unlabeled column. Keep recorded exceptions visible so rotation instructions do not accidentally promote stock that requires review.
Compare relevant date information and keep exceptions visible
Define which product group, locations and type of date information the stock review covers. Identify lot, quantity, current status and the basis for ordering stock. Dates with different meanings should not be mixed into a single unexplained sortable field.
Review actual identified stock against the intended sequence and record exceptions under the site procedure. Held or restricted material should remain distinguishable from stock available for use. Keep missing labels, uncertain dates and inventory differences as explicit findings instead of assigning an assumed date to complete the sort.
Test the review with two date types, held stock and a transfer between locations. A colleague should understand the intended order and why particular stock was excluded or referred for decision. Preserve the observation and authorised exception so a later reviewer can explain the action, not merely see that the spreadsheet was sorted.
Worked example
A stock check finds two lots of the same product and a container with unclear identification. The team reviews the known dates and locations while routing the unidentified item through the appropriate procedure rather than placing it first in the picking order.
Build a usable record
Use the fields below to capture the facts needed for this particular decision. Keep the actual observation separate from any later correction or approval.
- Product and lot
- Relevant date and its meaning
- Quantity and location
- Restrictions or unresolved identity
- Review and resulting action
Example record and review decision
Fictional record example: LOT-A and LOT-B: applicable date information, quantities and locations; EXCEPTION-01: reason and authorised decision.
Compare the same type of date information and make held, restricted or otherwise exceptional stock visible.
Sorting an unidentified mixture of date types can create a misleading priority order even if the spreadsheet sorts correctly.
Test the review, not just the form
Walk the storage area using the list. Confirm that it leads to the actual containers and reflects recorded restrictions. Investigate differences between physical stock and the register instead of assuming a sorted screen establishes correct rotation.
A few useful answers
Is FEFO the same as oldest receipt first?
Not necessarily. Receipt date and the relevant expiry or use information can differ; define the basis explicitly.
Does sorting all dates automatically produce a valid FEFO order?
Only if the underlying date basis, product identity and stock status are appropriate and understood. A correct spreadsheet sort can still produce a misleading sequence when unlike dates or restricted stock are mixed together.
Sources and further reading
MarkdownExplore starter templates
Start with a useful checklist
English
