TL;DR
- Aged inventory is stock that has sat past its expected sell-through window, typically bucketed into 0-30, 31-60, 61-90, 91-180, and 180+ days.
- The formula is (Average Inventory ÷ COGS) × 365, expressed in days. The lower the number, the faster inventory capital completes its cycle from stock to sales.
- A healthy average age is 60–90 days across most ecommerce categories; stock older than 180 days is usually considered dead stock.
- Inventory carrying cost runs 20-30% of inventory value annually per APQC benchmarks, which means a $50,000 aged-stock pile burns $10,000–$15,000 a year just sitting still.
- An inventory aging report buckets every SKU by age and value, exposing where capital is trapped so disposition decisions can be prioritized.
- Reducing aged stock means better forecasting, FIFO discipline, ABC analysis, planned discounting strategies, and clean returns management.
Every warehouse holds two kinds of stock: units that move and units that sit. Aged inventory is the second category, and it quietly compounds into one of the most expensive problems an e-commerce operation can carry. Carrying costs accumulate. Working capital ties up. And the discount the business needs to offer to sell aging inventory and remove it from stock grows month by month, until the math no longer works.
A good understanding of the above starts with measuring how long each SKU has actually been on the shelf. This guide walks you through measuring inventory age, reading an aging report, and the disposition tactics operators use to clear slow-moving stock before it becomes dead weight.
What Is Aged Inventory?
Aged stock is inventory that has remained unsold beyond the timeline the business expected when it was purchased or produced. The threshold is industry-specific. A fast-fashion SKU might be considered aged after 45 days, while industrial parts might run a 12-month cycle without concern.
In any case, the mechanic is the same: the longer a unit sits, the more it costs to hold, and the lower the price it will eventually command.
Aged stock vs. dead stock
Aged stock is not the same as dead stock. Aged stock is still moving, just slowly. Dead stock has stopped moving altogether. Most operators treat anything beyond 180 days as dead and route it to liquidation, donation, or write-off. The longer the delay, the larger the eventual hit to net income.
How To Calculate Aged Inventory
There are two complementary calculations operators rely on: a portfolio-level metric (average age of inventory) and a SKU-level metric (days on hand by item, summarized in an inventory aging report).
The Average Age of Inventory Formula
The standard formula, used in financial analysis and described by sources like the Corporate Finance Institute, is:
Average Age of Inventory = (Average Inventory Balance ÷ COGS) × 365
Three inputs are needed:
- Average Inventory Balance: typically (beginning inventory + ending inventory) ÷ 2 across the period being measured.
- Cost of Goods Sold (COGS): the direct cost of producing or acquiring the units sold during the period.
- Days in Period: 365 for an annual view, 90 for a quarterly view.
The result is the average number of days a unit of inventory sits before being sold. It is also referred to as Days Sales in Inventory (DSI). The two metrics are mathematically identical and are used interchangeably across finance and operations. For a deeper breakdown of the DSI variant, see our guide on how to calculate days sales in inventory.
📌 Note: Average age is a starting signal, not a verdict. Cross-check it against gross profit margin and inventory turnover ratio before drawing conclusions. A high figure can indicate a problem, or it can reflect a deliberate strategy of carrying more stock for volume discounts or long lead-time categories.
What Is An Inventory Aging Report?
An aging inventory report (also called an aged inventory report or aged stock report) is a tabular view of every SKU in the warehouse, bucketed by how long each unit has been on hand.
Looking only at the total inventory average, though, can be misleading. Even if your average is 75 days, some products may still be stuck in storage for 200+ days, and you will only catch that by reviewing each SKU separately. That visibility is why aging reports are one of the most important documents in the inventory management process.
Inventory Aging Report Example
SKU | Description | On Hand | 0–30 Days | 31–90 Days | 91–180 Days | 180+ Days | Total Value |
|---|---|---|---|---|---|---|---|
LIP-001 | Matte Lipstick – Red | 4,200 | 2,800 | 1,400 | 0 | 0 | $42,000 |
PAL-014 | Holiday Eye Palette | 1,800 | 0 | 0 | 600 | 1,200 | $36,000 |
FND-022 | Foundation – Shade 4 | 2,500 | 1,000 | 1,000 | 500 | 0 | $25,000 |
Total | 8,500 | 3,800 | 2,400 | 1,100 | 1,200 | $103,000 |
In this snapshot, the holiday palette is the obvious problem. 67% of its units are over 180 days old. $24,000 are trapped capital that generates no revenue and accumulates carrying costs daily.
✅Tip: The aging report does not tell you what to do, but it tells you where the money is stuck. Disposition tactics come next.
6 Tactics To Reduce Aged Inventory
Once the aging report exposes where capital is trapped, the work shifts to disposition. No single tactic fits every SKU, which is why operators deploy many of them depending on the case.
1. Tighten Demand Forecasting
The best defense against aged inventory is smarter buying before the inventory arrives. When forecasting is accurate, brands can keep stock levels closer to real demand and avoid letting slow movers sit past the 60–90 day mark.
Monthly forecast reviews should account for SKU-level sales, seasonality, promotions, and supplier lead times. A modest improvement in forecast accuracy can create a much larger reduction in aged inventory six months later.
2. Run ABC Analysis to Prioritize Attention
ABC analysis sorts SKUs into three classes by revenue contribution.
- A items typically represent 70–80% of revenue from 10–20% of SKUs;
- B items sit in the middle.
- C items contribute the smallest revenue share but often consume disproportionate storage and labor.
Slow-moving stock clusters in the C class, and that is where audit and disposition energy should concentrate first.
3. Enforce FIFO Picking Discipline
First In, First Out is the simplest defense against aging stock for non-perishable goods, and FEFO (First Expired, First Out) is the equivalent for time-sensitive categories like cosmetics, supplements, or food and beverage.
Pick paths, slotting logic, and WMS rules all have to support it. Otherwise, pickers default to whatever is closest. For a fuller breakdown of when each rotation method applies, see our comparison of FIFO vs LIFO vs FEFO.
👉 At LOT-controlled facilities, rotation is enforced at the system level so aging never compounds quietly.
4. Create a Clear Inventory Clearance Strategy
A clearance strategy pre-defines how discounts deepen as stock ages, so the decision is not made under pressure each quarter. A typical e-commerce clearance plan looks like this:
Age Bucket | Disposition Tactic | Expected Recovery |
|---|---|---|
0–60 days | Full price, normal merchandising | 100% of margin |
61–90 days | Light promotion or bundle | 85–95% |
91–180 days | Targeted discount (15–30%) | 60–80% |
180–270 days | Deep discount or liquidation channel | 25–50% |
270+ days | Donation, write-off, or scrap | 0–15% |
Exact percentages vary by category and margin structure, but committing to a plan in advance prevents the most expensive outcome: letting stock sit indefinitely while management deliberates.
5. Bundle Slow Movers With Fast Movers
Kitting a slow-moving SKU with a fast-moving complementary product lets the slow mover ride the velocity of the fast mover. The bundle price reflects a soft discount on the slow item without forcing a sales campaign on the listed SKU.
This action protects the original price point for future single-unit sales, and it works best for categories with natural cross-sell logic, like cosmetics, supplements, apparel accessories, electronics, and consumables.
6. Clean Up Reverse Logistics
Returns that sit unprocessed in a holding area silently become aged stock. A clean return management process (inspect, grade, restock, or dispose) within a defined SLA keeps returned units from becoming a problem.
Disciplined returns management closes a gap that most aging reports do not surface directly, but shows up in the numbers regardless. Slotting and warehouse design also matter; different warehouse types support rotation discipline very differently.
✅Tip: Review aging reports weekly so slow-moving SKUs are addressed as soon as they enter a higher-risk age range, not months later.
Move Aging Stock Before It Moves Against You
Aged stock is definitely not a back-office accounting concern; it is an operations problem that shows up on the income statement. Brands that keep inventory age under control use clear, repeatable processes. They track stock in real time, move older inventory first, review aging reports weekly, and follow a planned discounting strategy instead of deciding on a case-by-case basis.
At NovEx, our job is to make yours easier, which means owning that operating cadence end-to-end so the only inventory decisions you make are the strategic ones.
👉 With 99.8% order accuracy, bicoastal coverage from Salt Lake City and Memphis, and proactive reporting, we treat inventory health as part of the service. Request a quote
FAQs
What is considered aged inventory?
Stock is considered aged once it sits past its expected sell-through window, typically anything older than 90 days for ecommerce categories. Items aged beyond 180 days are usually treated as dead stock and prioritized for clearance.
What is a good average age of inventory?
An average age between 60 and 90 days is considered healthy for most e-commerce and retail businesses. Industrial goods, automotive parts, and seasonal categories operate on different cycles, so always benchmark against your own industry rather than a universal target.
How do you calculate aged inventory?
Use the formula (Average Inventory ÷ COGS) × 365 for the portfolio-level average age. For SKU-level tracking, build an aging report that buckets each item into age bands (0–30, 31–60, 61–90, 91–180, 180+ days) and shows the value trapped in each bucket.
How to make an inventory aging report?
To make an inventory aging report, list every SKU, group units by days on hand, add total value, and review which products are trapping capital in older age buckets.
How often should an inventory aging report be reviewed?
Most operators run an aging report at least monthly, with a focused review on items crossing into the next age band. Faster-moving categories benefit from weekly reviews, while industrial or B2B operations with longer cycles may run quarterly cadences.