How to Build an Inventory Aging Report That Drives Action
An aging report should do more than list old stock. Connect age, velocity, value and storage footprint to a specific owner and next action.
Direct answer: An inventory aging report should show how long each unit has been in stock and connect every age band to a specific decision. The useful question is not “How much inventory do we have?” It is “Which inventory is consuming cash and space without earning its keep?”
What an aging report should measure
At minimum, group on-hand units by SKU and receipt date. Common bands are 0–30, 31–60, 61–90, 91–180 and more than 180 days. For each SKU, include:
- Units and cost value in each age band
- Available, reserved, damaged and quarantine quantities
- Trailing 30- and 90-day unit sales
- Expected weeks of supply
- Storage footprint or location count
- Next inbound quantity and date
- Product constraints such as expiry, season or packaging version
Use the oldest receipt date for units that can be traced by lot or license plate. If your system cannot preserve receipt layers, document the assumption—such as first-in, first-out—and avoid pretending the result is exact.
Aging is not the same as slow-moving
A new product can be slow-moving after two weeks if the launch forecast was aggressive. A spare part can be healthy at 180 days if customers need long-term availability. Age is a signal; velocity and business purpose explain it.
Use three questions together:
- How old is it? Time since receipt or production.
- How fast is it moving? Recent demand, adjusted for seasonality and promotions.
- What does it cost to keep? Storage, handling, insurance, obsolescence and tied-up cash.
A hypothetical aging decision
Assume an ecommerce brand has 1,000 units of a product with a landed cost of CAD $18. The units occupy four pallet positions at CAD $28 per position per month. Sales have fallen to 50 units per month.
The basic picture is:
- Inventory value: 1,000 × CAD $18 = CAD $18,000
- Weeks of supply: 1,000 ÷ 50 × 4.33 = 86.6 weeks
- Direct pallet storage: 4 × CAD $28 = CAD $112 per month
Suppose the brand can sell 300 units with a CAD $6 markdown. The gross markdown cost is CAD $1,800. If that promotion removes one pallet position and improves cash recovery, it may be rational even though it lowers per-unit margin. But the recommendation changes if demand is predictably seasonal and the next selling window is close, or if a deep discount would damage a premium price position.
The calculation must also include selling fees, pick-and-pack, parcel transportation and returns. A markdown that generates revenue but loses cash on every fulfilled order is not inventory relief.
Give every age band an action rule
| Age band | Default review | Possible action |
|---|---|---|
| 0–30 days | Receiving accuracy and launch pace | Correct content, ads or availability errors |
| 31–60 days | Sales versus plan | Adjust replenishment and channel allocation |
| 61–90 days | Velocity and margin | Test bundles, merchandising or targeted offers |
| 91–180 days | Cash and footprint | Stop inbound, mark down, move channel or negotiate return-to-vendor |
| 180+ days | Obsolescence and final value | Liquidate, donate, recycle, dispose or retain with written rationale |
These are planning defaults, not universal thresholds. Products with shelf-life, regulatory or warranty constraints need tighter controls. Products held for spare-parts obligations may need longer ones.
Separate physical age from commercial status
Old inventory often hides behind system labels. Reserved stock may belong to an expired order. Quarantine may contain units no one has inspected. Damaged stock may still occupy a prime pick face. Add an owner and deadline to every non-available status.
Physical accuracy comes first. If on-hand quantities are unreliable, use the inventory cycle-counting routine before making markdown or disposal decisions. The warehouse slotting guide can then help move slow inventory out of expensive forward-pick locations.
Run a monthly aging meeting
Keep the meeting short and decision-based. Review the largest cost values, the largest space users and the items whose age band changed. Each decision should record:
- SKU and quantity
- Chosen action
- Owner and due date
- Expected cash or space outcome
- Condition that would change the decision
Do not order more of a SKU simply because an automated reorder point was reached while older units are unavailable, misplaced or reserved incorrectly. Pair the aging report with the assumptions in the reorder-point guide.
Questions to ask your 3PL
- Can reports show receipt date, lot and status by SKU?
- Which storage charges are driven by pallet positions, bins, cubic volume or units?
- Can aged stock be consolidated without losing traceability?
- What are the fees and controls for return-to-vendor, donation, liquidation or disposal?
- Can slow SKUs be removed from forward pick while remaining orderable?
247 Fulfillment can help turn inventory data into a practical action queue. The goal is not zero old stock. It is a deliberate reason for every unit that continues to consume space and working capital.
