What Is Obsolete Inventory (Excess and Obsolete Stock)?
Also known as: E&O Inventory, Dead Stock, Excess and Obsolete, Slow-Moving Inventory
Definition
Obsolete inventory is stock with little or no expected future sales or usage because of design changes, end-of-life products, demand decline, or shelf-life expiry. Excess inventory is stock above forecast need. Together they are called E&O.
Obsolete Inventory (Excess and Obsolete Stock) Explained
Obsolete stock is inventory the company does not expect to sell or consume at full value. Typical causes are engineering changes that replace a component, a product reaching end of life, over-ordering against a forecast that did not materialize, canceled customer orders on made-to-order material, and expired shelf-life material. Excess is related but different: the item is still useful, but the on-hand quantity exceeds demand for a long horizon.
Identification in an ERP starts with usage data. Compare on-hand quantity against the last transaction date, trailing 12 month issues, and forward demand from open orders and the forecast. SyteLine inventory aging reporting and item last-activity fields, NetSuite saved searches on last transaction date, and Infor LN warehouse inventory history can all feed a simple rule such as no usage in 12 months and no demand in the next 12. Then segment by item type and reason code, since the action differs for a raw material that another product can use than for a dedicated finished good.
Accounting follows the substance. Under US GAAP and IFRS inventory is carried at the lower of cost and net realizable value (IFRS) or lower of cost and market or net realizable value (US GAAP depending on method). Most companies book a reserve for E&O as a contra-inventory account, based on aging buckets (for example 25 percent at 12 months, 50 percent at 18, 100 at 24) or item-level review, and write off stock on actual disposal. Scrap, sale to a broker, return to vendor, rework or engineering reuse are the usual dispositions.
Prevention matters more than cleanup. Review planning parameters, minimum order quantities, engineering change effectivity and last-time-buy decisions. Coordinate engineering change orders with purchasing so open purchase orders and stock for replaced parts are consumed or canceled.
Why It Matters
- E&O ties up cash and warehouse space, and is a common source of surprise write-downs at year end or during due diligence.
- Auditors test reserve methods, so the policy needs to be written and applied consistently.
- Spotting aged stock early gives time for return to vendor, rework to a live part, or sale before value disappears.
- Reserve and write-off decisions flow straight into gross margin and tax, so finance and operations must agree on rules.
In Practice
Example: a quarterly E&O review lists items with on-hand value above 5,000, no issues in 12 months, and no demand in the next 12. Of 140 items, 30 get reserved at 100 percent, 60 at 50 percent, and 50 are cleared by engineering as reusable. Purchasing then cancels 18 open PO lines for the 30 reserved items.
Frequently Asked Questions
What is the difference between obsolete and excess inventory?
Obsolete stock has little or no expected future use. Excess stock is still usable but exceeds forecast demand over a long horizon. Both are reviewed together as E&O.
How do you identify obsolete inventory in an ERP?
Compare on-hand with last transaction date, trailing usage and forward demand from open orders and forecasts. A common rule is no usage in 12 months and no demand in the next 12.
How is an E&O reserve calculated?
Usually as a percentage of cost by aging bucket or by item-level review, booked to a contra-inventory account. The percentages are a company policy that auditors review.
Can obsolete stock be reduced without a write-off?
Often. Options include return to vendor, rework or substitution into a live bill of materials, selling to a broker or customer service, and cancelling open purchase orders.
Related Terms
Inventory Write-Down
An inventory write-down reduces the recorded value of inventory when its net realizable value falls below cost, because of obsolescence, damage or falling prices. A write-off removes the remaining value entirely.
Inventory Turnover
Inventory turnover is the number of times a company sells and replaces its inventory in a period, calculated as cost of goods sold divided by average inventory value. Higher turns mean less cash tied up in stock.
ABC Analysis
ABC analysis is an inventory classification method that ranks items by annual consumption value and groups them into A, B, and C classes, so planning attention, counting frequency, and control effort are concentrated where the money is.
Cycle Counting
Cycle counting is the practice of continuously verifying inventory accuracy by counting a small subset of items each day or week, rather than shutting down for one annual wall-to-wall physical inventory.
Days Inventory Outstanding (DIO)
Days inventory outstanding (DIO) is the average number of days inventory sits before being sold, calculated as average inventory divided by cost of goods sold, multiplied by the days in the period. Lower DIO releases cash.
Go Deeper
Inventory Carrying Cost Calculator
Build your true annual carrying cost from capital, storage, insurance, and obsolescence components - and see what an inventory reduction target is worth.
Free ToolInventory Turnover Calculator
Convert your COGS and average inventory into turns and days on hand, then see how much working capital a realistic turns target would release.
How to Manage Inventory Aging in SyteLine
Step-by-step guide to managing inventory aging in Infor SyteLine CloudSuite Industrial, including aging reports, obsolescence reserves, and disposition workflows.
AI Inventory Optimization for Manufacturers
AI inventory optimization for manufacturers: cut stock 15-30% while raising service levels, with ML-driven safety stock and reorder policies inside your ERP.
Working with Obsolete Inventory (Excess and Obsolete Stock) in a live environment? Our engineers do this every day - and our AI agents automate most of it.