Inventory Aging Report: Find Cash Stuck in Old Stock

Your inventory total can look reasonable while one product absorbs cash month after month. The warehouse count shows how many units remain. It does not show whether those units arrived last week or before your last seasonal campaign.

An inventory aging report adds that missing clock. It groups the units you still own by time held, then shows their cost value. You can see which SKUs need another sales cycle and which ones need a deliberate exit plan.

A useful aging report starts with current on-hand inventory. For each SKU and location, it traces those units back to a receipt date and places them in buckets such as 0 to 30, 31 to 60, 61 to 90, 91 to 180, and more than 180 days.

Show both units and value at cost. Unit counts reveal storage and sell-through pressure. Cost value reveals how much purchasing cash sits in each bucket. Fifty old units at a $70 cost need more attention than fifty units at a $4 cost, even though the warehouse count looks the same.

The report looks backward. It answers how long the current stock has been held. Days of inventory remaining looks forward by comparing the stock balance with a recent sales rate. Shopify documents that forward-looking measure as ending quantity divided by average units sold per day. Use both views, but do not treat them as substitutes.

Use the date a unit was received and became available to sell. A purchase-order date starts too early when production and freight take weeks. A product-created date gives every future replenishment the same age. The receipt date follows the physical inventory you are deciding about.

Lot or batch tracking makes the match direct. When a SKU contains units from several receipts, apply a consistent inventory-layer rule. FIFO assigns sales to the oldest available layer first, leaving the newest layers on hand. Your warehouse and accounting system may use another method, but the report needs one documented rule so the age does not change with each export.

Keep locations separate until the action stage. A canvas tote can be 150 days old at one 3PL and 20 days old at a retail location. Combining the balances hides a transfer opportunity and may push the team into an unnecessary storewide discount.

Thirty-day buckets provide a practical starting point for many DTC catalogs. The right thresholds still depend on the product. A trend-led accessory may need attention after 60 days. A stable replacement part can sit longer without losing demand. Food, cosmetics, and other dated goods also need expiry or best-before fields beside inventory age.

Set the thresholds before reviewing the results. If the team changes the definition of old stock for every SKU, the report becomes a negotiation. Product role can still shape the action: a seasonal item, an evergreen bestseller, and a discontinued color should not receive the same treatment at 120 days.

Calculate each bucket's value as on-hand units x unit cost. Use the inventory cost basis that finance uses for the balance sheet or management reporting. Do not multiply by retail price. Revenue has not been earned, and markdowns may reduce what the units eventually bring in.

Consider a hypothetical accessories brand holding 600 canvas totes at one 3PL. Each unit carries an $18 inventory cost, so the full balance is worth $10,800 at cost.

The receipt layers place 100 units in 0 to 30 days, 140 in 31 to 60, 160 in 61 to 90, 150 in 91 to 180, and 50 beyond 180 days. The last two buckets contain 200 units worth $3,600. One-third of the units have been held for more than 90 days.

That result does not prove the tote should be cleared. The operator checks product role and forward demand. The tote may sell steadily during holiday gifting, or the old units may belong to a color that lost demand while newer colors still move. The age report identifies where to investigate. Sales pace, margin, seasonality, and product status determine the action.

The operator also checks inbound purchase orders. Another 500 units due next month can turn an old-stock warning into a purchasing problem. Pausing or reducing that order may protect more cash than discounting the units already received.

An aging report earns its place when it creates an action queue. Start with the oldest, highest-cost rows. Confirm that the receipt history and inventory count are correct, then assign one next move and a review date.

A healthy evergreen item may need a smaller next purchase order. Stock split across locations may need a transfer. A product with good margin but weak discovery may need a merchandising placement or a focused campaign. A discontinued variant may need a bundle, markdown, wholesale offer, or write-off decision. Pick the action that fits the cause instead of applying one clearance rule to every old SKU.

Keep the result visible on the next report. Record units moved, realized selling price, and remaining cost value. If a promotion sold 80 units but required a margin-destroying discount, the team needs that fact before repeating the tactic. If no units moved, close the failed action and choose another one.

Read aging beside inventory turnover and GMROI. Turnover shows sales speed across a period. GMROI shows gross profit against average inventory cost. Aging shows exactly where today's stock has been sitting. Together they turn a broad inventory concern into a SKU-level decision.

ShopDucky can gather on-hand inventory, receipt history, unit cost, recent sales, and inbound purchase orders into a recurring aging review. An AI employee can flag the oldest high-value SKU-location pairs and prepare the next action while your purchasing, merchandising, or finance owner approves it. See the store operations workflow or the Reporting OS.