Inventory Aging Report: How To Reduce Aged Stock (2026)

When products sit on shelves for too long, it can create a major cash flow and profitability problem. Using an inventory aging report helps you see where your money is stuck in old stock. 

Did you know pillows have expiration dates? So do running shoes. You may have thought only perishable food items had shelf lives, but many unexpected items have best-by dates.

Items that take up valuable storage space for years can have hidden costs. That’s why it’s important that retailers understand the concept of inventory aging and how it’s reflected in an inventory aging report.

Learn more about what an inventory aging report is, how to calculate inventory aging, and tips for reducing it.

What is aged inventory?

Aged inventory, or aging inventory, includes products in stock with low demand that sell slowly or not at all. As items languish on shelves, they lose relevance and increase storage costs. Tracking aging inventory is important for retailers because it impacts cash flow and profit margins. 

What is an inventory aging report?

An inventory aging report, also known as an inventory aged report, is a strategic tool that provides a snapshot of the age distribution of products in stock. 

It categorizes inventory by how long your business has held items, typically in brackets such as 0–30 days, 31–60 days, and 61–90 days. In practice, the optimal bracket is dependent on the characteristics of the products. 

For example, fast fashion inventory is often evaluated in weekly windows, because styles reveal performance within the first few weeks. Time-to-peak sales is defined and tracked in weeks as an overstock warning signal. 

Perishable goods have even day-level aging timelines. Many items have one to two days refrigerated windows, and replenishment cycles run on daily ordering and delivery rhythms. 

By visualizing how long products have been in inventory, you can gain insights into potential issues, such as slow-moving items, too much inventory, and obsolete inventory. 

Aged inventory reports can also indicate when merchandise might be due for a markdown, which could, in turn, prompt a sale.

These reports will contain:

• Your various stock keeping units (SKUs) or individual product types (In a clothing retail context, this would be a single combination of garment model, size, and color.)
• Number of units available per SKU
• Average inventory age of those units

You can generate an inventory aging report manually using spreadsheets, but this process can be time-consuming and error-prone. Many retailers use inventory management software that can automatically generate inventory aging reports in real time. 

How to calculate inventory aging: 4 key calculations

• Average inventory cost
• Cost of goods sold (COGS)
• Inventory turnover ratio (ITR)
• Average inventory age

Calculating inventory aging involves three distinct calculations performed in stages. But it all starts with accurate inventory data. 

The four inventory aging report calculations you’ll need to know are average inventory cost, cost of goods sold (COGS), inventory turnover ratio (ITR), and average inventory age.

Average inventory cost

Average inventory cost refers to the value of a business’s inventory over a set period. Although inventory balances can rise and fall with the retail seasons or with shipping schedules, average inventory cost gives you a sense of overall inventory valuation despite these fluctuations.

To calculate average inventory cost, you can use the following formula:

Cost of goods sold (COGS)

COGS refers to the price of producing the goods a business sells. COGS covers expenses that arise directly from production, like raw materials or labor costs, and indirect costs, like overhead. 

The COGS figure impacts profit calculations because it’s subtracted from total revenue to determine your gross profit. A higher COGS also reduces your business’s taxable income. 

To calculate COGS for input into your average inventory cost calculation, use the following formula:

Beginning inventory is the amount of inventory you still have from the previous reporting period (a month, a quarter, etc.). Ending inventory refers to inventory you didn’t sell during that same period.

Inventory turnover ratio (ITR)

Your ITR refers to how often your business sold and replaced inventory during a set period, usually one year. 

Calculating ITR can help you make informed decisions on merchandise pricing, discount marketing, and inventory purchases. It also helps you spot inventory issues early, allowing for adjustments before stock ages out and loses its value. 

The formula for calculating ITR is:

A slow inventory turnover ratio usually indicates excess inventory or weak sales. A faster turnover ratio indicates the opposite: insufficient inventory levels, but sometimes also strong sales.

Average inventory age

Finally, you can input your average inventory cost and COGS into a formula to calculate the average inventory age. 

This reflects the average number of days it takes to sell certain SKUs, or individual inventory units. This calculation is sometimes known as days sales in inventory (DSI). The formula is as follows:

Average inventory age example

Now that you understand how an inventory aging report works, let’s walk through the numbers over the course of a year, using a clothing store business as an example.

First, derive your inputs. To find the average inventory cost, add your beginning inventory—let’s say $250,000—to an ending inventory—let’s say $300,000—and divide by two. The result is $275,000.

Next, total your inventory purchases and adjust for remaining stock, and your COGS is, say, $750,000. 

Using the above formula, your average inventory age would be:

Average inventory age = ($275,000 / $750,000) x 365 days

Average inventory age = Approximately 134 days

The higher your average inventory age, the longer it takes for any given product to sell, and the higher your inventory carrying costs will be. But the lower your average inventory age, the higher customer demand, so you need to be extra vigilant about reordering stock on time.

Once you have your number, compare it against historical data and industry benchmarks to gauge your operational efficiency. Generally speaking, an ideal average inventory age is between 60 and 90 days, but an item typically isn’t considered dead stock until it hits 180 days.

Tips for reducing aging inventory

• Take early action based on inventory age
• Generate accurate demand forecasts
• Master strategic inventory planning
• Optimize retail prices
• Invest in inventory tools
• Optimize warehouse management

Once you understand your inventory aging report key metrics, you might realize you need more efficient inventory management practices. Here are a few tips for reducing aging inventory:

1. Take early action based on inventory age

As you know, aging inventory is generally looked at in buckets. Within each bucket, there are different steps you can take to protect margins before deep discounting becomes your only option. 

Early aging (0-30 days)

Goal: Prevent items from becoming slow movers.

The first 30 days are important because the product is still fresh. To get this group moving, you can use tactics that increase visibility and improve distribution.

A few light interventions to make can include:

• Adjust search and category placement on your site
• Update Product Detail Page (PDP) content to include better images or more clear fit notes 
• Create non-discounted product bundles or cross-sells 
• Move units from low-demand locations to higher-demand stores to rebalance inventory 
• Freeze reorders to reduce inbounds immediately 

Mid-aging (31-90 days)

Goal: Correct course through markdowns and clear shelves for newer arrivals. 

Here the SKU will undergo a price reduction. Introduce planned price cuts and move inventory to secondary channels like outlets, marketplaces, or wholesale partners. Only discount specific sizes, colors, or locations that are aging.

Late aging (90+ days) 

Goal: Convert remaining stock to cash and clean up financial exposure. 

Once inventory hits this stage, it means it’s dead or severely declined in market price. Under inventory accounting standards like IAS 2, inventory is valued at whichever number is lower—cost or current market value: 

• Cost: what you originally paid for it.
• Net realizable value (NRV): what you can get for it in the current market after expenses. 

If the inventory cannot be sold for its cost value, write-downs are recognized in the current period.

2. Generate accurate demand forecasts

Implementing accurate demand forecasting is key to preventing excess inventory—and the aging stock that follows. 

By analyzing your own historical data—or, if your business is new, market trends—businesses can align their procurement strategies with projected demand, reducing the risk of overstocking and other inventory inefficiencies.

You can get at some of this valuable historical data by conducting frequent inventory audits. Audits of this sort are a tool for identifying slow-moving inventory items before they become aged inventory. 

Reconcile your inventory aging report with physical counts and the general ledger during the process. This ensures you won’t base a big strategy move on inaccurate or phantom inventory data. 

Regular checks allow businesses to adjust stock levels promptly, minimizing holding costs and optimizing warehouse space.

3. Master strategic inventory planning

Developing a comprehensive inventory management strategy is crucial for avoiding aging inventory. This includes planning inventory for foreseeable challenges such as low demand, excess stock, and slow-moving products. 

For example, swimwear is in the highest demand in the months immediately preceding summer and for most of June and July. To capitalize on the trend, you’ll want your biggest procurement shipments to hit the dock in early spring so you’re ready for the rush.

As mid-summer approaches, taper your purchase orders. This keeps your stock levels lean as the season ends so you don’t end up with a surplus. 

Proactively incorporating inventory patterns like this can help prevent the accumulation of aged inventory.

4. Optimize retail prices

Regularly review and adjust retail prices based on market demand and product life cycle to help prevent inventory from aging and to offload obsolete inventory. 

The longer an item sits, the more aggressive your tactics need to be. If a SKU just started slowing down, a quick competitive price match might be all you need. But once that inventory starts aging toward obsolescence, it’s time to pull out the inventory liquidation discounts and bundling. 

Here are some ways to approach it:

• Discount and bundled pricing. Offering sales and marketing promotions is one of the more common ways to offload obsolete inventory. You can temporarily discount a particular SKU or put it on clearance, or you can bundle slow-moving SKUs with top-performing ones.
• Competitive pricing. Set your prices based on what the competition charges for similar products.
• Penetration pricing. In a competitive market, penetration pricing involves setting prices low at entry and raising them as customers become more familiar with your brand. 

If you’re not in a financial position to adjust prices just yet, you can also consider improving your product listings. Make slight changes to a product’s photos and description copy to prompt sales. 

You can also add social proof, such as reviews and testimonials, or implement cross-selling to prompt shoppers to buy complementary products already in their cart. 

5. Invest in inventory tools

Investing in advanced inventory management tools that provide real-time insights for your aging inventory report is a proactive step toward a better inventory control strategy. 

Investing in Shopify and its inventory tools helps you better understand slow-moving stock. For example, you can:

• Track inventory states and review adjustment history to keep quantities accurate over time 
• Review inventory reports like sell-through rate and products by percentage sold
• Use the Stocky app to add workflows for demand forecasting, stocktakes, low stock reports, and ABC analysis to act on aging inventory 

6. Optimize warehouse management 

Efficient warehouse management is integral to minimizing storage costs (like long-term storage fees) and preventing aging inventory. Proper storage practices maximize shelf life and facilitate easy access to high-demand products. For businesses handling perishable goods, incorporating a first-expired, first-out (FEFO) practice guarantees stock with the earliest expiration dates is moved first.

You can enhance warehouse management through real-time inventory tracking and supply chain management software. Radio-frequency identification (RFID) tags, for example, enable precise inventory tracking, helping prevent both stockouts and overstock. 

Smart sensors can monitor storage equipment health, predicting maintenance needs to reduce downtime. Automated retail technology can optimize picking routes to improve overall warehouse efficiency.