# Obsolete Inventory (Excess and Obsolete Stock)

> Source: https://netray.co/glossary/obsolete-inventory
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Glossary

## Short answer

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.

## Aliases

- E&O Inventory
- Dead Stock
- Excess and Obsolete
- Slow-Moving Inventory

## Category

erp-core

## Full Definition

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.

## Faq

### What is the difference between obsolete and excess inventory?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

obsolete inventory, excess and obsolete inventory, E&O inventory reserve, dead stock, slow moving inventory, obsolete inventory write off, identify obsolete inventory ERP, inventory obsolescence reserve

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json