Excess Inventory (2026): Causes, Carrying Cost, How to Find It and How to Stop Reordering It

TL;DR

• Excess inventory is stock above what you expect to sell or use within a normal planning horizon, after allowing for safety stock. It ties up cash, takes space, and risks write-downs if it ages or loses value.
• Find it with days of supply and aging by SKU, not with total inventory value. A healthy total can hide one category with a year of stock.
• Most excess is created by buying, not by selling: reorders placed against a stale forecast, a cancelled customer order nobody passed on, or bulk buys agreed for a discount.
• Sentra joins ERP stock and open purchase orders with the emails, chats and meetings that change demand, and flags a reorder for stock already in surplus to the buyer before it is placed.

What excess inventory is

Excess inventory is stock that exceeds what a business needs to meet expected demand within its normal selling or usage horizon, after allowing for planned safety stock. ControlHub defines it as unsold products that surpass anticipated demand for a specific period, and notes it ties up capital that could otherwise support financial flexibility.

Three terms are often mixed up.

Excess becomes obsolete if you leave it long enough. The point of tracking excess is to act while the stock still has full value.

What causes excess inventory

ControlHub and Katana list the usual causes: inaccurate forecasts, sudden demand shifts, over-buying, cancelled orders, shipping delays that prompt extra purchasing, early deliveries, and poor visibility across systems. In practice they group into four patterns.

• Forecast that stayed high after demand fell. A product was discontinued by a key customer, a promotion ended, or a competitor launched. The forecast kept last quarter's run rate.
• Reorders placed against stale information. The replenishment system saw stock below the reorder point and raised a purchase order. It did not know that a large customer had cancelled, or that 2,000 units were sitting in returns waiting to be put away.
• Panic buying after a shortage. A stockout last quarter leads buyers to double the next order and raise safety stock. Supply recovers, demand does not change, and both orders land.
• Buying for the discount. A volume discount or a price increase notice triggers a bulk buy sized to the price break, not to demand.

The second pattern is the most common and the most preventable. The information that would have stopped the reorder usually exists. It sits in an email, a sales call or a planning meeting, not in the field the reorder logic reads.

The cost of carrying excess inventory

Carrying cost is the annual cost of holding inventory, expressed as a percentage of average inventory value. Cleverence gives the standard formula:

Carrying cost % = (capital cost + storage cost + service cost + risk cost) / average inventory value × 100

• Capital cost. The financing cost or opportunity cost of cash tied up in stock. Many finance teams use their cost of capital.
• Storage cost. Warehouse space, handling equipment and labor.
• Service cost. Insurance, inventory taxes and administration.
• Risk cost. Shrinkage, damage, obsolescence and expiry.

Cleverence notes many organizations fall between 15% and 35% a year, with a wide range, and recommends building your own rate rather than relying on a benchmark. Do that. Your capital cost and your obsolescence history drive most of the number.

Excess stock also carries an accounting risk. Under US GAAP, ASU 2015-11 requires inventory measured using FIFO or average cost to be carried at the lower of cost and net realizable value, where net realizable value is the estimated selling price less reasonably predictable costs of completion, disposal and transportation. Under IFRS, IAS 2 measures inventories at the lower of cost and net realisable value. If excess stock has to be discounted to clear, the write-down lands in the period you discover it.

How to identify excess inventory

Total inventory value and the overall turnover ratio are too coarse. Katana suggests watching inventory turnover for sharp drops, which is a good alarm. To find the specific stock, work at SKU and location level.

1. Calculate days of supply per SKU. On-hand units plus open purchase orders, divided by average daily demand over the forecast horizon. Include open purchase orders. Stock you have already ordered is stock you will have to carry.

2. Set an excess threshold. For example, anything above your target days of supply plus safety stock. One simple starting rule is to flag SKUs with more than 2 times their target days of supply.

3. Age the stock. Bucket on-hand units by receipt date: 0 to 90 days, 91 to 180, 181 to 365 and over 365. Old buckets on slow movers are your write-down risk.

4. Check for zero movement. List SKUs with no sales or consumption in 90 or 180 days.

5. Price the excess. Excess units times unit cost, then times your carrying cost rate for the annual holding cost.

6. Check open purchase orders against the excess list. Any SKU on the excess list with an open purchase order is the first thing to fix. It is the cheapest excess to prevent.

Excess inventory review template

How to reduce excess inventory

Work from the cheapest action to the most expensive.

1. Stop the inflow. Cancel, reduce or push out open purchase orders on excess SKUs. Check supplier terms for cancellation windows.

2. Rebalance across locations. Move stock to sites where the same SKU is short.

3. Sell it at full price first. Offer it to customers who buy similar items, bundle it with faster movers, or use it as a substitute where specifications allow.

4. Return to the supplier. Some suppliers accept returns or credits, often with a restocking fee.

5. Discount or liquidate. Clear through promotions, outlet channels or bulk resellers once the value is falling.

6. Donate or dispose. For stock with no recoverable value, record the write-off properly.

Then fix the cause, or the next review will find the same SKUs. A short root cause analysis on the ten largest excess positions usually shows two or three repeated failures.

Reorder discipline: stop buying stock you already have too much of

The single most effective control is a check before each purchase order is released.

• Check days of supply including open orders. A reorder point that looks only at on-hand stock will reorder against units already on the water.
• Check recent demand changes. Has a customer cancelled, reduced or moved an order in the last 30 days? Has sales mentioned a product change?
• Check returns and unreceived stock. Units in returns, quarantine or another location are still yours.
• Size the order to demand, not to the price break. If a volume discount pushes days of supply past the threshold, the buyer and a finance approver decide together, with the carrying cost in view.
• Review safety stock after a shortage ends. Temporary increases after a stockout should have an end date.
• Approval for orders on excess SKUs. Any purchase order for a SKU on the excess list needs a second approver. This is also a useful maverick spending control.

The opposite failure is just as costly. Cutting stock too hard, or trusting a record that shows stock you do not have, leads to stockouts and phantom inventory. Both problems share a cause: the system acts on a number that the people closest to the stock know is wrong.

Worked example: a reorder for stock already in surplus

Assumptions, illustrative only. A distributor sells SKU 4471 to about 30 customers. Its largest customer usually takes 40% of volume. Average daily demand was 85 units. Target days of supply is 60. Unit cost is $14. Carrying cost is 25% a year.

On the 3rd, the customer's buyer tells the account manager on a call that they are switching to a different part from next month. The account manager notes it in the call summary and mentions it in the sales team channel. The demand forecast is not updated.

On the 18th, on-hand stock falls to 3,000 units, below the reorder point. The replenishment system raises a purchase order for 6,000 units, sized to the old demand of 85 a day.

• What the system believes. Demand is 85 a day. The 9,000 units of on hand plus the new order equal about 106 days of supply, reasonable once lead time is counted.
• What is true. Demand is now about 50 a day. The same 9,000 units equal about 180 days of supply, three times the 60-day target.
• Excess created. About 6,000 units over target, or $84,000 of stock, costing about $21,000 a year to hold, with write-down risk if the part is superseded.
• Cost if caught before release. Zero. The buyer sizes the order to 50 a day, or skips it.

Nothing in the ERP was wrong on the day the order was raised. The forecast was simply out of date, and the only record of why sat in a call summary and a chat message.

Common mistakes

• Measuring total inventory only. Excess hides in specific SKUs and locations.
• Ignoring open purchase orders. Stock on order becomes stock on hand.
• Fixing the stock, not the cause. Liquidating excess without changing how reorders are approved guarantees a repeat.
• Leaving post-shortage safety stock in place. Temporary buffers become permanent.
• Treating demand changes as a sales matter. A customer cancellation agreed in a call is a supply event and needs to reach the planner.

How Sentra catches this automatically

Sentra understands how a company really runs, and acts on it before anyone asks. It reads email, chat, meetings and documents alongside ERP, CRM, HRIS and BI data, and works out what is true now and why.

For excess inventory, Sentra sees the stock position, the open purchase orders and the replenishment order in the ERP. It also reads the call summary where the customer said they were switching parts and the message in the sales channel. Because Sentra knows when a fact became true and when it stopped being true, it treats the customer's old volume as no longer current. When a purchase order is raised against the old demand, Sentra flags the contradiction to the buyer and the planner with the evidence: the customer's statement, the date, the open order and the days of supply it creates.

A named person approves each finding before it reaches anyone else, and before Sentra acts or sends anything. Permissions follow each source. Sentra replaces none of your systems. The ERP and replenishment tool stay in charge of the stock and the order. Sentra holds SOC 2 Type II and ISO 27001 and runs in the cloud, in an isolated VPC or air-gapped on premises.

The same join catches the opposite problem. At Lenskart, a retailer with 3,200 stores, a top product line showed about 95% in stock in reports while shelves had 12.8% availability, and about $860K of sales were lost in the two weeks before the fix. Excess and shortage are two sides of the same gap between the record and what people know. Related reading: supply chain risk management and variance analysis for when excess shows up as a margin miss.

To see Sentra stop a reorder for stock you already have too much of, book a demo.

FAQ