Separate a date on a label from a decision about stock. Use a batch-level review record to hold uncertain supplies, assign the next action and prove what happened to every unit.
A cupboard holds twelve cartons of the same supply. Four have an approaching date, three carry an unclear marking and five belong to a newer batch. A single product total hides the work your stores lead needs to do.
This stock expiry tracker template is a complete inline resource for small internal stores handling ordinary, nonhazardous office consumables. Copy the register into a spreadsheet and the review packet into a document. It includes date checks, calculation rules, action ownership and a worked example; there is no download or account requirement.
Define which date you are tracking
Use this resource only where the responsible person can establish the manufacturer’s instructions for the specific product. A warranty-end date, manufacture date and expiry date are not interchangeable. For example, HP’s guidance on ink-supply date markings distinguishes install-by markings from warranty coverage. That distinction is a reason to verify the date’s meaning—not a rule for all ink supplies or permission to extend shelf life.
The tracker records the resulting decision. It does not determine product suitability, prescribe storage conditions or authorize use after a manufacturer limit. Exclude food, medicines, hazardous chemicals, PPE and safety-critical supplies; those need the applicable specialist procedures.
For this proposed operating design, a cutoff is the documented date on which the batch must return to review before further issue. The accountable product owner establishes it from the applicable instructions, including any opening-related limit. Reaching the cutoff means “review required,” not “automatically dispose.” All review intervals, holds and approval rules below are suggested company choices, not universal requirements.
Copy the review cover before entering stock
Review ID: [unique, never reused] Template version: EX-1 Store and scope: [site, bins, included products] As-of date: [YYYY-MM-DD, store's local date] Snapshot cutoff: [date/time and time zone] Movement control: [pause issues/receipts in selected bins until capture finishes] Prepared by: [stores coordinator] Product/date interpretation owner: [named responsible person] Decision approver and deputy: [names and authority] Action owner and deputy: [names] Review cadence: [calendar-day interval and next review timestamp] Warning window: [whole calendar days per item, approved by owner] Escalation contact: [stores lead and contact] Evidence folder/reference: [controlled location] Stock system of record: [name; person authorized to post changes]
Start with verified quantities. Use the goods received note for arrival evidence. If the shelf and stock record disagree, resolve the quantity using a controlled cycle count rather than inventing a balance inside this tracker.
For a small pilot, review every calendar day and set each item’s warning window long enough for its actual review and action lead time. Record those choices before use. If daily review cannot be staffed, redesign the cadence and warning windows rather than leaving a daily procedure unperformed.
Build one register row per item, batch and location
Keep different lots, storage locations and date conditions on separate rows. If opened and unopened packs have different controlling dates, split them into distinct rows with linked identities. Use stable line IDs such as EX-01; spreadsheet row numbers are not permanent identities.
Create a sheet named Settings. Put the review’s fixed as-of date in B1 as a real spreadsheet date, not text. On a separate sheet named Register, paste this header into row 1 and split it on commas. Columns A–J and M–P are inputs; K, L and Q calculate.
Line_ID,Item_Code,Batch,Location,Unit,On_Hand,Label_Text,Date_Check,Cutoff,Warning_Days,Days_To_Cutoff,Review_Band,Owner,Next_Due,Evidence,Other_Hold,Review_Available
| Fields | Required entry and validation |
|---|---|
| A–E: identity | Unique line ID; exact item code, batch or traceable receiving reference, location and stock unit. Do not mix cartons and individual pieces. |
| F: On_Hand | Whole nonnegative units at the snapshot cutoff. This pilot does not handle fractional or weighed stock. A blank is not zero. |
| G: Label_Text | Transcribe the marking exactly, including its label type. Keep a label photo or manufacturer reference in O. Do not guess an unreadable date. |
| H–I: Date_Check and Cutoff | H is VERIFIED or UNKNOWN. VERIFIED requires the named owner’s interpretation evidence and a real date in I. UNKNOWN leaves I blank and blocks availability. A warranty-only marking is not enough to set an expiry cutoff. |
| J: Warning_Days | Owner-approved whole nonnegative calendar days. Zero is allowed only as a deliberate policy choice; it gives no advance warning. |
| M–O: accountability | Named owner, next due timestamp with time zone, and evidence reference. Evidence includes the date interpretation and quantity baseline. |
| P: Other_Hold | HOLD or CLEAR. HOLD means a separate unresolved condition already blocks this whole row. Split quantities into linked rows before recording a partial hold. |
Before calculating, reject duplicate identities, missing required inputs, negative or fractional quantities, invalid dates and unapproved warning windows. Do not turn an error into a ROUTINE result. Resolve missing date evidence as UNKNOWN; resolve other invalid inputs with the owner while keeping the row unavailable.
Add the calculations after validation
Enter these formulas in row 2 and copy them down through the actual data rows. They use English Excel function names and comma separators; adapt separators to your spreadsheet locale. Format K and Q as numbers and I and Settings!B1 as dates. Microsoft’s DAYS documentation explains that numeric spreadsheet dates can be subtracted to calculate elapsed days.
K2 =IF(OR(H2<>"VERIFIED",NOT(ISNUMBER(I2))),"",I2-Settings!$B$1) L2 =IF(F2=0,"EMPTY",IF(OR(H2<>"VERIFIED",NOT(ISNUMBER(I2))),"CHECK DATE",IF(K2<=0,"DATE REVIEW",IF(K2<=J2,"DUE SOON","ROUTINE")))) Q2 =IF(OR(P2="HOLD",L2="CHECK DATE",L2="DATE REVIEW"),0,F2)
These formulas are a review aid, not an inventory update. Q is the quantity not blocked by this review’s rules; it is not a promise that every other release requirement has passed. Never issue stock solely because Q is positive.
| Band | Interpretation | Action |
|---|---|---|
| EMPTY | Recorded quantity is zero. | Confirm the zero balance; preserve the row’s history. |
| CHECK DATE | Date meaning or a usable cutoff is unresolved. | Hold the row; product owner obtains evidence. Escalate at the recorded due time. |
| DATE REVIEW | Cutoff is today or earlier. | Hold the row pending an authorized decision. Do not silently move the cutoff forward. |
| DUE SOON | Positive days remaining are at or below the warning window. | Assign a timely review and action plan. This band alone does not impose a hold. |
| ROUTINE | Cutoff is beyond the warning window. | Keep the next review date. Other holds still override availability. |
Filter Other_Hold=HOLD separately: a held row can still display ROUTINE because the band describes the date, not the complete release decision. A spreadsheet opened tomorrow still shows the saved as-of date. Start a new review snapshot for tomorrow; do not present yesterday’s calculation as current.
Copy the action journal for quantities under review
Open a case for each CHECK DATE, DATE REVIEW or Other_Hold row, and for any DUE SOON row requiring action. Capture the starting quantity once. Pause ordinary issues against the case quantity until it is resolved; any permitted movement must appear in the journal. A transfer to a holding area changes location, not the case’s remaining quantity.
Case ID: [unique] Review ID and line ID: [linked snapshot] Starting case quantity and unit: [fixed baseline] Reason and date evidence: [what triggered review] Physical hold location and identification: [where and how separated] Proposed action: [verify/release, supplier return, authorized disposal, other] Decision owner, approver and deputy: [names] Next due timestamp and escalation contact: [date/time/time zone, contact] Decision and authority reference: [recorded before execution] Journal columns: Event_ID | Case_ID | Event_Time_Zone | Outcome | Quantity | Executor | Approval_Reference | Evidence | Stock_Posting_Reference | Verified_By Permitted closing outcomes: RELEASED — checked and returned to available stock under applicable instructions RETURNED — physically handed to supplier/carrier, with handoff evidence DISPOSED — completed under the separately authorized applicable procedure
Record only completed quantities as closing outcomes. A return request, a disposal approval or a move to a quarantine shelf is not completion. Log those milestones as notes with zero closing quantity. Returned units awaiting a supplier credit can close this physical-stock case while a linked commercial claim remains open; make that separate owner visible.
Remaining case quantity = starting case quantity − total completed RELEASED − total completed RETURNED − total completed DISPOSED. All three totals use the same stock unit and nonoverlapping units. Never enter an event twice or let the remaining quantity become negative. The closure equation is quantity reconciliation, not an accounting valuation.
Use case states OPEN → DECISION RECORDED → ACTION IN PROGRESS → CLOSED. A missing approval, disputed count or overdue action keeps the case open with a named owner and next due time. Close only when the remaining quantity is zero, evidence is checked and the authorized person confirms the corresponding stock postings. Do not edit the original baseline to make a difference disappear.
Worked example: one batch, two completed actions
Fictional example, not manufacturer guidance: an office print room has twelve unopened packs of label stock in batch LS-A at bin P1. Its product owner has verified a supplier-documented review cutoff of December 10, 2026. The review is dated November 20, 2026, and the chosen warning window is 30 calendar days.
- Days to cutoff: December 10 minus November 20 = 20.
- Band: DUE SOON because 20 is positive and no greater than 30.
- Other_Hold is CLEAR, so review availability is 12; this is not permission to disregard the supplier instructions.
On December 10, six packs remain. A new snapshot has zero days to cutoff, band DATE REVIEW and review availability zero. Stores opens case EX-C01 for six packs and pauses further issues.
| Event | Completed outcome | Quantity | Evidence | Remaining |
|---|---|---|---|---|
| Case opens | None | 0 | Count and date review baseline | 6 |
| E01 | RETURNED | 4 | Approved supplier return and courier handoff | 2 |
| E02 | DISPOSED | 2 | Separate approval and completed disposal record | 0 |
The case stays ACTION IN PROGRESS after E01. It closes after E02 only when evidence and stock postings are verified: 6 − 4 − 2 = 0. This example does not recommend disposal for label stock generally; the fictional owner chose those outcomes for that case.
Handle exceptions without losing the original record
Unknown, conflicting or opening-related dates
Keep UNKNOWN and hold the affected row when a date is unreadable or its meaning is unverified. Record the exact question sent to the supplier or product owner and a response due time. Do not infer the last day of a month from a month-only marking unless the applicable source establishes that interpretation. If opening changes the limit, preserve the opening event and split the stock; do not apply an unopened-pack date to every unit.
Disputed quantities, partial actions and missed reviews
If the count changes before action, stop and reconcile the movement. Add a linked correction with approval and evidence rather than overwriting the signed snapshot. For a partial physical outcome, record only its completed units and retain the remainder’s hold. Escalate overdue cases to the stores lead at their due timestamp; reassignment must name a receiver, not merely copy a shared inbox.
On a missed review, the next owner captures a current snapshot and handles unresolved date/hold cases before relying on old availability. Replenishment remains a separate decision: the reorder point worksheet addresses ordinary non-expiring stock and should not be reused unchanged for expiry-constrained supplies.
Where Workhint fits in the review handoff
The register settles the data and decision rules first. Workhint’s Workflow Engine describes configurable work steps, review routing and required notes or files before work proceeds. Those capabilities are relevant to passing a date exception from stores to its accountable reviewer.
The workflow automation software solution describes custom forms, approval stages, owners and next actions. A useful implementation discussion would start with the case ID, batch evidence, decision owner and completion check defined here. The cited pages establish general workflow capabilities; they do not establish a prebuilt expiry tracker or the specific stock calculations in this resource.
Keep the authoritative quantity record and manufacturer interpretation visible in any implementation. Validate your configured review and release rules with a small test set before anyone relies on them.
Test the tracker before its first live review
- With a 30-day warning window, test cutoffs 31 days away, 30 days away, today and yesterday: expect ROUTINE, DUE SOON, DATE REVIEW and DATE REVIEW.
- Set Date_Check to UNKNOWN and leave Cutoff blank: expect CHECK DATE and zero review availability.
- Set Other_Hold to HOLD on an otherwise ROUTINE row: Q must be zero.
- Enter zero units: expect EMPTY. A blank or negative quantity must fail validation, not become a usable row.
- Against a six-unit case, record four returned: expect two remaining and no closure. Add two completed disposals: expect zero; a third quantity event must be blocked.
- Test duplicate line/event IDs, a missing owner, a missing approval and a return approved but not handed over. None should pass as completed work.
Frequently asked questions
Is a printed date always an expiry date?
No. Record the marking and verify its meaning for the exact product. A manufacture or warranty date alone does not establish a use cutoff.
Does a DATE REVIEW row mean the stock must be discarded?
No. It blocks further issue under this proposed procedure while the responsible person determines the applicable action. The tracker cannot extend a manufacturer’s limit.
Can one batch appear on several rows?
Yes, when locations, opened condition or controlling dates differ. Give each row a unique line ID and reconcile their quantities so the same units are not counted twice.
Does copying the formulas update my stock system?
No. They calculate review results only. Authorized people must execute and verify any stock postings, and each action case must retain its evidence.

Leave a Reply