Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Stock is not expired, but can the customer still accept it?

Calculate remaining shelf life at customer receipt, match eligible lots to demand, and identify stock that needs another sales route before it becomes unusable.

By Institution5 minute readPublished View sources
In this guide

Evaluate eligibility at the customer's required point

A batch can be physically present, within its printed date, and still unsuitable for a particular customer order. The customer may require a minimum number of usable days when it receives the goods. Begin with the actual commercial requirement and the expected receipt date. Looking only at today's warehouse date can overstate the quantity available to fulfill the order.

Microsoft's shelf-life planning documentation explicitly considers customer sellable-day requirements and the requested receipt date. That illustrates a practical limitation of simply shipping the earliest-expiring lot first. A first-expire, first-out approach needs to operate within the lots that meet the order's requirements. The oldest batch is not automatically the correct batch for every destination.

Keep the applicable product-date definitions clear. Expiration, best-before, release, and retest dates can have different meanings depending on the product and governing rules. Have the responsible quality or compliance owner establish what the business may ship. This inventory-planning procedure does not authorize the sale of a product after a safety or legal restriction, and a customer's concession cannot override such a restriction.

References: Microsoft Learn: Planning for customer shelf-life requirements

Build an order-specific date calculation

Record the lot identifier, relevant date, customer requirement, expected dispatch date, transit time, and expected receipt date. Use an agreed convention for counting days and the applicable time zone where it matters. If the requirement is expressed as a percentage of original shelf life, retain the production date and the permitted calculation. Do not convert it into a fixed number of days without checking the agreement.

Consider a hypothetical product that expires on November 30. A customer expects to receive it on November 20 and requires at least fourteen remaining days. Under a simple date-difference convention, the lot has ten days remaining and is ineligible for that order. A different customer receiving it on November 18 with a seven-day requirement may be eligible, subject to the product's other release and shipping conditions.

Allow for realistic delivery uncertainty. A plan based on the fastest possible transit can create a rejection when a routine delay occurs. Decide whether the allocation process uses the promised date, a conservative transit estimate, or another approved basis. Show that assumption in the planning record. If the delivery date changes, rerun eligibility rather than assuming the original reservation remains valid.

Match the eligible lots to actual demand

Build a matrix of lots and orders rather than relying on one total available-stock number. A lot may be suitable for a local customer and unsuitable for a distant distributor. Reserve stock against demand that it can actually serve, while considering other conditions such as packaging, certificates, or customer-specific approvals. The result should explain why some stock remains unallocated even when total demand exceeds total quantity.

Suppose the business has 800 units in an older lot and 500 in a newer lot. A strict customer needs 600 units that only the newer lot can satisfy. A local customer needs 400 units and can accept either lot. Assigning the newer lot to the local customer first would leave only 100 eligible units for the strict customer. Using the older lot locally preserves all 500 eligible newer units and makes the remaining 100-unit shortage explicit.

Do not solve the shortage by silently changing the customer's requirement. If a commercial exception is possible, obtain the required written approval before shipment and confirm that quality and legal conditions still permit it. Keep the exception tied to the order and lot. A one-time acceptance should not become a permanent customer-master change that affects future deliveries without review.

Separate stock at risk from stock already unusable

Create an aging view based on the last feasible dispatch or receipt date for relevant demand, not only the final product date. An item may have weeks remaining physically but no confirmed customer who can accept it. That is an early operating signal to investigate alternative demand, production rescheduling, supplier arrangements, or an approved disposition before the remaining options narrow.

Keep proposed actions distinct from completed recoveries. A planned promotion does not prove that the stock will sell, and a possible transfer to another market does not prove it can legally or commercially be sold there. Record the expected quantity, net recovery, additional handling, and decision deadline for each option. Give the accounting reviewer this evidence for any valuation assessment under the business's reporting policy.

Avoid counting the same demand more than once across scenarios. A local customer order used to justify recovery of the older lot cannot simultaneously support sale of another aging lot unless the quantity genuinely covers both. Reconcile planned allocations to confirmed orders and credible forecasts, identifying the portion that remains speculative. This keeps the recovery case from becoming a collection of individually plausible but incompatible assumptions.

Feed the result into buying and customer service

Use repeated eligibility shortages to adjust purchasing and production decisions. Buying a larger quantity at a lower unit price may increase the stock that loses access to the strictest customers before it is sold. Compare the proposed receipt dates and lot life with actual demand patterns. A quantity discount is not a saving if it creates an unsupported recovery assumption for the excess units.

Give customer service a clear explanation when stock exists but cannot fulfill an order. Show the eligible quantity, the reason for exclusion, and the next feasible supply date. Avoid presenting all on-hand inventory as immediately available and then reversing the promise after warehouse picking. A precise availability message prevents avoidable expedites, returns, and disputes about delivery commitments.

Retain the final lot-to-order allocation and the assumptions used at approval. Review material changes in transit, customer requirements, or product status before dispatch. The successful outcome is specific: each shipped lot meets the applicable conditions, and every unallocated quantity has a realistic next action while time remains to take it.

References: Microsoft Learn: Planning for customer shelf-life requirements; IRS: Supporting business documents and asset records

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.