An aged inventory report shows how long your on-hand stock has sat since receipt and how much cash it holds. To find SKUs that have stopped selling, pair that age with recent sales and actual availability.
Old stock can still sell steadily, while newer stock can stall immediately. Start with receipt-level records, then connect each aging bucket to a purchasing or merchandising decision.
Key Takeaways
- Track remaining stock by receipt date, stock-keeping unit, variant, and location, rather than assigning one age to an entire product.
- Combine aging with recent sales, last-sale dates, and availability before declaring inventory deadstock.
- Prioritize cash tied up in old stock, then choose actions based on demand, margin, and remaining selling time.
Build the Report Around Receipts, Not Purchases
Gather the right transaction data
Export the stock-keeping unit code, variant, warehouse, receipt identifier, receipt date, received quantity, remaining quantity, on-hand quantity, and unit cost. Add last-sale date and net units sold over the past 30, 60, and 90 days.
Calculate item age as report as-of date minus receipt date. Divide the result by 30 for approximate months. A purchase-order date measures buying timing, not time physically held.
Keep separate receipt layers when the same product code arrives repeatedly. Assigning every unit the oldest date exaggerates aging; using the newest date hides it.
Also separate sellable, damaged, quarantined, and reserved stock. For shared multichannel inventory, count the warehouse pool once.
Reconstruct historical balances correctly
A November 30 report needs quantities remaining on November 30, not today’s balance attached to November dates.
Start with a dated snapshot, or rebuild the balance using receipts, shipments, received returns, transfers, and adjustments through the cutoff. Then allocate issues against receipt layers using your documented aging method.
Preserve the original receipt date through warehouse transfers. Otherwise, relocating stock can make old inventory appear fresh.
Reconcile totals by SKU and warehouse. Our guide to ERP inventory reconciliation covers common mismatches involving reservations, bundles, and channel records.
Calculate Aging Buckets in Excel or Google Sheets
Use columns A through G for the stock-keeping unit identifier, receipt date, remaining units, unit cost, days held, bucket, and remaining inventory cost. Enter a fixed as of date in J1.
Use this inventory aging report formula to calculate days held in row 2: =$J$1-B2. A fixed date keeps archived reports reproducible; TODAY() changes their results whenever the workbook recalculates.
Assign the bucket with:
=IF(E2<=30,"0-30",IF(E2<=60,"31-60",IF(E2<=90,"61-90",IF(E2<=180,"91-180","181+"))))
Calculate remaining cost with =C2*D2. If K2 contains a bucket name, summarize its value with:
=SUMIF($F$2:$F$1000,K2,$G$2:$G$1000)
Keep bucket labels consistent in your inventory aging report template, including labels such as “0-30 days.”
These sample balances illustrate the result for one SKU costing $20 per unit.
| Age bucket | Remaining units | Inventory value |
|---|---|---|
| 0-30 days | 40 | $800 |
| 31-60 days | 20 | $400 |
| 61-90 days | 10 | $200 |
| 91-180 days | 30 | $600 |
| 181+ days | 0 | $0 |
| Total | 100 | $2,000 |
Here, 30% of inventory value is older than 90 days. That’s a useful purchasing-review signal, but it doesn’t prove the SKU has stopped selling.
The common four-bucket layout ends with “90+.” Label it “91+” when the preceding bucket includes day 90, so boundaries don’t overlap. Reject negative ages and reconcile bucket totals with the stock ledger.
Keep Average Age Separate From Receipt-Level Age
Calculate average inventory age
Average inventory age, often called days inventory outstanding, uses:
Average inventory age = (Average inventory value / annual cost of goods sold) × 365
For example, $100,000 of average inventory and $500,000 of annual COGS produces 73 days.
Use inventory at cost, not retail prices. Beginning and ending balances can work for stable stock; average monthly balances better capture seasonal buying.
This financial measure describes overall inventory movement. It doesn’t identify which physical units remain. Our SKU-level inventory turnover guide explains the related replenishment measure.
Separate quantity allocation from valuation
FIFO aging deducts issued units from the oldest receipt layers first. That determines the quantities left in each bucket.
Valuation is a separate choice. FIFO costing retains remaining layer costs, while average costing applies an average unit cost. Identical aged quantities can therefore show different dollar values.
Microsoft’s inventory aging report examples explain its FIFO deduction logic. Document both your aging allocation and costing method before comparing reports.
Identify SKUs That Have Stopped Selling
Combine old stock with sales activity
Add days since the last sale, recent net unit sales, days in stock, and days available for purchase beside each stock-keeping unit’s aged balance.
Prioritize slow-moving inventory with positive sellable stock, no recent sales, and substantial value in older buckets. A no-sales-for-90-days flag is a practical purchasing-review trigger, with exceptions for launches and seasonal products.
Compare sizes, colors, and locations separately. Strong sales of one variant can conceal stalled stock elsewhere.
Fresh receipts can hide a stalled SKU. Review its oldest remaining stock alongside recent sales before accepting another delivery.
Rule out blocked demand
Zero sales can reflect weak exposure, incorrect availability, missing compatibility information, or a broken purchase path.
Inspect collection placement, product-page traffic, variant selection, cart behavior, and checkout eligibility before discounting. Also compare channels: warehouse inventory may be unavailable to shoppers in a particular market.
Our SKU-level stockout analysis helps separate unavailable selling days from genuine weak demand.
Set Thresholds Around Economics and Selling Windows
Use category thresholds as review triggers, not universal expiration dates. Suggested starting points include 60-90 days for fashion, up to 120 days for electronics, and 180+ days for hard goods. Flag obsolete stock for earlier action.
Those limits need context. A seasonal product with two weeks of selling time left deserves attention before its age reaches a generic threshold.
For a starting KPI, target no more than 15% of inventory value beyond 90 days. Keep the denominator consistent and review exceptions by category. Review more often when aging stock puts pressure on cash flow.
Carrying costs include storage costs, insurance, capital interest, and obsolescence. Planning estimates cited for aging stock include $6-12 per square foot annually for storage and 0.5-1% of inventory value for insurance. Actual costs depend on your contracts.
Finale’s FAQ cites annual carrying costs reaching 25-30% of inventory value. Use your own expenses for decisions, rather than applying that percentage automatically.
Amazon also requires earlier attention. Its published surcharge example quotes $6.90 per cubic foot or $0.15 per unit at 365+ days for long-term storage fees. That example isn’t a universal current tariff; age-based charges can begin earlier. Don’t wait until day 365 to address slow FBA inventory.
Understand What Your Inventory Software Measures
Cin7 Core’s Inventory Aging Report documentation measures age from stock receipt, not purchase. Finished goods use assembly dates, and stock transfers reset the received date.
The first bucket, labeled 0-30, covers stock aged 0-30 days. The other default buckets are 30-60, 60-90, 90-120, 120-150, 150-180, and above 180 days. The grouping can’t change, so use the system’s boundary rules rather than assuming those labels match your spreadsheet.
The quantity-based report doesn’t show inventory value. Cin7’s Stock Value Inventory Aging Report provides value buckets, with a minimum 30-day interval.
Check whether your inventory planning software resets age after transfers. For historical reporting or transfer-distorted ages, export Inventory Movement Details to reconstruct original receipts and cutoff balances. A lookup alone won’t resolve multiple receipt layers.
For large Dynamics 365 outputs, Microsoft recommends the storage version of the report. It’s designed for reports spanning many items and warehouses.
Match the Action to the Reason Stock Is Aging
Recover demand before sacrificing margin
Improve exposure when shoppers rarely encounter the product. Clarify specifications when traffic arrives but conversion remains weak.
Consider a stock transfer when another location or channel has proven demand and freight and delivery timing leave enough margin.
Bundle complementary products when the combination makes sense for customers. Don’t add an unwanted item merely to shift its cost into another SKU.
For a controlled markdown test, consider 15% off stock aged 90+ days and 25% off stock aged 180+ days. These are starting tactics, not guaranteed profit-maximizing discounts. Compare expected recovery after fees and fulfillment with continued holding or liquidation.
Stop replenishing the problem
When excess inventory builds up on stalled SKUs, pause reorders and review outstanding purchase orders. Negotiate smaller batches or staged deliveries when supplier minimums and freight costs permit.
Calculate inventory position using sellable on-hand units plus inbound stock, less unfulfilled commitments. Don’t subtract commitments twice if your sellable balance already excludes them.
Protect healthy variants instead of cutting safety stock across the category. Also account for arrival dates: replenishment landing after the selling window can become the next aged-stock problem.
Give each exception an owner, action, deadline, and follow-up result.
Frequently Asked Questions
How often should I review inventory aging?
Review monthly when demand is stable, every two weeks for seasonal businesses, and weekly during the Q4 holiday rush or cash-flow pressure. Shorten the cycle when markdown deadlines or storage charges approach.
Is old inventory automatically deadstock?
No. Old stock may still sell profitably, especially in seasonal or slow-replacement categories. Deadstock has little realistic selling opportunity. Judge age alongside availability, recent demand, margin, obsolescence, and the remaining selling window.
Can returned goods restart the aging clock?
A return shouldn’t masquerade as a new supplier receipt. Preserve the original receipt or traceable cohort where possible, and record its condition separately. Otherwise, repeated returns can hide aging.
Turn Aging Stock Into a Decision Queue
An inventory aging report becomes useful when receipt-level quantities connect to sales activity and a named next step. Age highlights exposure; availability and demand explain what to do.
Start with the highest-value exceptions. Pause avoidable replenishment, fix selling barriers, and use transfers or markdowns where they offer the strongest recovery.


