Excess and Obsolete Inventory: How to Identify and Reduce It

Excess and obsolete inventory is stock that the business is unlikely to sell at a profit within a reasonable time, and it is one of the most expensive forms of planning failure because it grows quietly. Each purchase made against an optimistic forecast, each discontinued product that still has stock, each seasonal item left over after the season looks harmless on its own. Added up, they tie up cash, consume warehouse space and eventually surface as write-downs that finance did not expect. This guide defines excess and obsolete stock, shows how to identify it with coverage and no-sales rules, works through an example with checked arithmetic, compares the ways to clear it, explains reserves and prevention, and gives a simple operating routine. It is part of demand planning and inventory optimization, follows inventory carrying cost and ABC analysis, and leads to the cost of stockouts and in-stock rate. The cash and accounting effects are covered in cash flow management and inventory write-downs.

Definitions

Excess inventory is stock beyond what you expect to sell within a defined horizon, such as twelve months of forecast demand, even though the item remains active and sellable. Slow-moving inventory sells, but at a rate that implies a very long time to clear. Obsolete inventory is stock with no realistic prospect of sale at normal prices, because the product is discontinued, expired, out of fashion, superseded or incompatible with current offerings. In practice the lines blur, and companies set their own rules. What matters is that the rules are written down, applied consistently and reviewed regularly.

How to identify it

Use a combination of rules, applied item by item.

1. Coverage rule. Compare on-hand and on-order stock with forward demand. If coverage exceeds, say, twelve months, the part beyond twelve months is excess.
2. No-sales rule. Items with no sales in the last six or twelve months, and no open orders or planned demand, are candidates for obsolete.
3. Lifecycle status. Discontinued or superseded items with remaining stock.
4. Shelf life. Items with less than a set percentage of shelf life remaining.
5. Seasonal leftovers. Items from past seasons not planned for re-sale.
6. Aging. Stock that has sat in the warehouse longer than a threshold. See inventory aging report.

Apply the rules to produce a list with quantities, cost and the reason for the flag. Review it with sales and marketing, who may know of planned demand that the forecast misses, and with finance.

A worked example

Item X has 4,800 units on hand, a unit cost of $14 and a forecast of 3,000 units over the next twelve months (illustrative). Excess = 4,800 - 3,000 = 1,800 units, worth 1,800 × 14 = $25,200 at cost. Item Y, discontinued two years ago, has 600 units at a cost of $20 and no demand in the past twelve months: obsolete, worth 600 × 20 = $12,000. Together, the flagged stock is 25,200 + 12,000 = $37,200. If the carrying cost rate is 18 percent, holding this stock costs about 37,200 × 0.18 = $6,696 a year, before any write-down. In a range with thousands of items, the totals can reach hundreds of thousands of dollars.

Options for clearing it

Illustrating the recovery, suppose the 1,800 excess units of Item X ($25,200 at cost) could be cleared through a discount channel recovering 85 percent of cost, or through a liquidator recovering 30 percent. Recovery is 25,200 × 0.85 = $21,420 in the first case and 25,200 × 0.30 = $7,560 in the second. The $13,860 difference is the price of waiting until the stock has no better option. These recovery rates are assumptions for the example. The lesson is general: recovery falls with age and with urgency, so early action pays.

Reserves and write-downs

Accounting rules require inventory to be carried at the lower of cost and net realizable value. When stock is excess or obsolete, a reserve or write-down is recorded to reduce its value to the amount you expect to recover. The method for setting the reserve, such as a percentage by age band or an item-by-item estimate, should be documented and applied consistently. A reserve does not clear stock. It only recognizes the loss. See inventory write-downs. Share the excess list with finance regularly so that reserves are not a surprise.

Prevention

Excess is cheaper to prevent than to clear. Improve forecasts and remove bias, since over-forecasting is the main source. Tie purchases to the plan, and review large buys against demand. Plan product transitions so that the last buy of an old item matches the sell-down. Manage minimum order quantities, which can force excess. Control seasonal buys with staged commitments and in-season reorders where possible. Review slow items early, when they cross 6 months of coverage and not 12. Set accountability so that a buyer or category owner is responsible for aged stock. Use open-to-buy limits so that purchasing stays within a budget. See open-to-buy planning.

An operating routine

Each month, produce the excess and obsolete report with the flagged items, their value, age and proposed action. Hold a short meeting with planning, sales and finance to decide the action for the top items by value. Track progress: the value cleared, the recovery rate and the value of new additions to the list. Report a trend of excess as a share of total inventory. If the list keeps growing, look upstream at forecasting and buying habits. See reduce inventory without causing stockouts.

Metrics

Track excess and obsolete inventory as a percentage of total inventory, the value added to the list each month, the value cleared, the average recovery as a percentage of cost, and the reserve as a percentage of the flagged stock. A rising share is an early warning of planning problems, long before write-downs hit the income statement.

Common mistakes

1. Waiting until year-end to identify excess.
2. Using one rule for all items, regardless of shelf life and demand pattern.
3. Counting on a promotion that cannot move the full quantity.
4. Reserving without a plan to clear.
5. No owner for aged stock.
6. Repeating the same buying habits that created it.

Setting reserves by age: a worked example

Finance teams often set the reserve for excess and obsolete stock by age band, with a rising percentage as stock gets older. Suppose inventory is $4.4 million and breaks down as follows (illustrative): $3.0 million aged up to 180 days, $0.8 million aged 181 to 365 days, $0.4 million aged one to two years and $0.2 million aged over two years. The company applies reserve rates of 0, 10, 35 and 75 percent to the bands.

• 181 to 365 days: 0.8 × 0.10 = $0.08 million
• One to two years: 0.4 × 0.35 = $0.14 million
• Over two years: 0.2 × 0.75 = $0.15 million
• Total reserve: 0.08 + 0.14 + 0.15 = $0.37 million, or 0.37 / 4.4 = 8.4 percent of inventory

Check: 3.0 + 0.8 + 0.4 + 0.2 = 4.4. The percentages are assumptions for the illustration. The actual policy must follow your accounting framework and be agreed with your auditors. The planning lesson is that the reserve is driven by age, and age is driven by buying decisions. Reducing the $1.4 million aged beyond 180 days by half would cut the reserve by roughly half of the amount attributed to those bands, about $0.18 million, and avoid the cost of holding the stock.

Hold or clear: a simple test

When excess stock might eventually sell at full price, the question is whether to wait or to clear now. Take the 1,800 excess units of Item X ($25,200 at cost). Suppose the item sells 100 units a month, so it would take 18 months to clear at full price. The average stock during that time is about half, 900 units, so the carrying cost at 18 percent of $14 a unit is 900 × 14 × 0.18 × (18 / 12) = $3,402. Compare with clearing now at a 15 percent discount from cost recovery, a cost of 25,200 × 0.15 = $3,780 relative to full recovery. Check: 900 × 14 = 12,600; × 0.18 = 2,268; × 1.5 = 3,402. The two are close, so the decision turns on risk: the chance that the product goes out of fashion or is superseded in the next 18 months, the cash value of $21,420 now, and the warehouse space. If that risk is material, clearing early is better. If the product is staple and demand is stable, waiting is reasonable. Document the logic so that decisions are consistent.

Who owns the problem

Excess usually has no owner. Purchasing says the forecast was high, sales says the customer cancelled, and operations says it was just following the plan. Assign a named owner for each item over a threshold of age or value, ideally the category manager or planner who made the buying decision. Review the list in the monthly meeting and record decisions. Tie the review to the buying process: before a new order is placed for an item with more than a set coverage, require approval. These simple controls change behavior faster than any report.

FAQs

What is excess and obsolete inventory?

Stock beyond expected demand within a set horizon (excess) or with no realistic prospect of sale at normal prices (obsolete).

How do you identify excess inventory?

Compare on-hand and on-order stock with forecast demand over a defined horizon, and flag items with no recent sales, discontinued status, short shelf life or old age.

How do you reduce excess inventory?

Through targeted promotions, bundles, secondary channels, vendor returns, rework, liquidation or donation, and by preventing future excess with better forecasting and buying.

Is a write-down the same as clearing the stock?

No. A write-down recognizes the loss in value in the accounts. The stock still occupies space until sold, returned or scrapped.

How much excess is normal?

It varies by business. Track your own percentage over time and investigate increases.