How to Control Excess and Obsolete Stock

AuthorMehul Jagwani
Reviewed ByAjay Savani

Summarize with AI:

How to Control Excess and Obsolete Stock

Summary:

Excess and obsolete inventory usually develops because of inaccurate demand forecasts, bulk purchasing, changing customer preferences, poor stock visibility or delayed action on slow moving items. Businesses can reduce these losses by measuring inventory ageing, improving purchasing controls, setting reorder levels and clearing ageing stock before it loses most of its value.

When businesses have more inventory on hand to sell or use, it is considered to be excess. Obsolete Inventory is Stock that is no longer saleable or usable.

Both inventories block working capital and increase storage costs and decrease profit. To prevent such situations, businesses need to manage them and make timely clearance decisions.

Excess vs Obsolete Inventory

The following table distinguishes between excess inventory and obsolete inventory:

Basis	Excess inventory	Obsolete inventory
Meaning	Stock exceeds expected demand	Stock has lost its normal use or demand
Sale potential	Can usually still be sold	Difficult or impossible to sell normally
Recovery value	Moderate to high if addressed early	Usually low
Main risk	May become obsolete over time	Loss has already occurred
Common action	Discount, transfer, return or stop reordering	Write down, recycle, scrap or dispose

Example: A retailer holding too many winter jackets at the end of the season has excess stock. If those jackets remain unsold for years and go out of fashion, they become obsolete stock.

Simplify Your Business Operations

Designed to give you speed, control, and accuracy in daily accounting tasks.

Save time with automated accounting workflows
Get 35+ detailed business reports easily
Access your business anytime, anywhere

Unlock the Munim Advantage

Common Examples of Obsolete Inventory

Expired food, medicines and cosmetics
Accessories made for discontinued mobile models
Old fashion and seasonal products
Spare parts for discontinued machines
Packaging with outdated branding
Damaged goods that cannot be repaired economically
Products that no longer meet regulatory requirements

What Causes Excess and Obsolete Inventory?

Inaccurate demand forecasts	Purchases are based on optimistic sales estimates
Bulk buying	Extra units are ordered only to receive a discount
High minimum order quantity	Supplier conditions force the business to buy more
Seasonal demand	Unsold festival, monsoon or wedding-season stock remains after demand falls
Changing customer preferences	Styles, colours, features or pack sizes lose popularity
Poor stock visibility	One store orders goods already available at another location
Long supplier lead times	Excess safety stock is maintained to avoid shortages
Department gaps	Sales, purchase and warehouse teams work with different information
Returns and cancellations	Returned or customised goods remain unsold
Weak ageing controls	Slow-moving stock is identified too late

Causes of Obsolescence

Stock may become obsolete due to:

Expiry or physical deterioration
Technological changes
Product discontinuation
New regulatory or labelling requirements
Rebranding or packaging changes
Long periods without sales or internal use

How Excess Inventory Affects a Business

Excess stock costs more than its purchase price.

Business impact	Practical effect
Blocked working capital	Less cash is available for salaries, suppliers and growth
Higher storage costs	More spending on rent, labour, insurance and utilities
Increased borrowing cost	Interest continues on cash credit, overdraft or working-capital loans
Lower profit margin	Old stock may require heavy discounts
Damage and shrinkage	Crowded warehouses increase loss, damage and counting errors
Inaccurate financial position	Stock shown at an unrealistic value can overstate assets and profit
Poor space utilisation	Slow-moving stock occupies space needed for fast-selling products
Operational burden	Teams spend time managing stock that generates little revenue

Key Inventory Formulas

Inventory Carrying Cost Percentage

Annual inventory holding costs ÷ Average inventory value × 100

If annual holding costs are ₹3 lakh and average inventory is ₹30 lakh, the carrying cost is 10%.

Inventory Turnover Ratio

Cost of goods sold ÷ Average inventory

A falling ratio may indicate slow sales or overstocking.

Days Inventory Outstanding

Average inventory ÷ Cost of goods sold × Number of days

A rising figure means stock is taking longer to sell.

Sell-Through Rate

Units sold ÷ Units received × 100

If a business receives 500 units and sells 150, the sell-through rate is 30%.

Reorder Level

Average demand during lead time + Safety stock

Reorder levels should be updated when demand or supplier lead time changes.

How to Identify Excess and Obsolete Stock

1. Review inventory ageing

Group stock by the number of days it has remained unsold:

Up to 30 days
31–60 days
61–90 days
91–180 days
181–365 days
More than 365 days

Ageing determined by you should match the industry standards. Ninety days are acceptable for machinery and its parts but not for the food industry.

2. Find slow-moving and non-moving items

During a normal sales cycle, find products with low or zero sales. If a high-value product shows no movement, it needs to be handled immediately.

3. Compare physical and recorded stock

Verify your stocks regularly. It helps in identifying damaged, missing and unsaleable goods.

4. Use ABC and FSN analysis

Method	Classification	Purpose
ABC	A: high value, B: medium value, C: low value	Focus control on financially important stock
FSN	Fast-moving, slow-moving, non-moving	Measure stock movement

Combining both methods helps identify high-value, non-moving items that block the most capital.

Sample Stock Clearance Policy

Stock age	Suggested action
90 days	Review demand, price and future purchase orders
120 days	Start a targeted promotion
150 days	Transfer stock to a better-performing location
180 days	Request supplier return or exchange
270 days	Consider liquidation, repurposing or scrap sale

These limits should be adjusted for shelf life, seasonality and the product’s normal sales cycle.

Inventory Reports to Review Every Month

The following are reports you must check at regular intervals if you are inventory-heavy business.

Stock ageing report
Slow-moving and non-moving stock report
Expiring batch report
Items above maximum stock level
Negative stock report
Warehouse-wise stock report
Inventory valuation report
Damaged and returned goods report
Open purchase order report
Physical stock difference report
Product-wise inventory turnover
Product-wise gross margin

Every exception should have an owner and action date. Reports alone do not reduce excess stock.

How Munim Helps Control Excess Stock

Munim’s inventory management module helps Indian businesses maintain centralised stock records and monitor inventory movement.

Businesses can use organised stock data to:

Check available quantities before purchasing
Track stock across warehouses
Avoid duplicate or unnecessary orders
Monitor inward and outward stock movement
Make faster purchase and clearance decisions

Frequently Asked Questions on Excess and Obsolete Inventory

What is excess inventory?

Excess inventory is any stock that is available with a business in the more than expected quantity. It remains usable but blocks cash and storage space.

What is obsolete inventory?

Obsolete inventory is any inventory that does not have its normal demand or use. It might be expired, outdated or broken.

Is excess inventory the same as obsolete inventory?

No. Excess inventory can be sold if a business acts quickly. Obsolete inventory has little or no demand and may require write-off.

How is excess inventory calculated?

A practical calculation is:

Available stock + incoming stock − forecast demand − required safety stock

A positive balance may indicate excess stock.

How often should inventory ageing be reviewed?

It’s best to check it once a month for most businesses. Some companies may require weekly reviews if they have an expiry date on their products, seasonal demands, or rapidly evolving products.

Can obsolete inventory be sold as scrap?

Yes, if the sale is legally permitted. The business should issue the required invoice, update stock records and apply the correct GST treatment.

Disclaimer: "This blog post is for informational purposes only. For specific tax advice related to your business, please consult a qualified Chartered Accountant or GST practitioner."

Explore the latest market news, useful resources for business, and Munim updates.