← All resources

INVENTORY GUIDE

Read your stock ageing report with context

Turn ageing buckets into questions and practical stock reviews.

STEP 1

Start with reliable dates

Use each item's receipt date and current balance. Check duplicate codes, negative quantities and missing categories before importing.

STEP 2

Separate the age buckets

Review 0–30, 31–90, 91–180, 181–365 and 365+ days separately. Age is a signal to investigate, not a complete measure of demand.

STEP 3

Compare like with like

Compare similar categories and branches over the same period. Consider seasonality, new launches and special-order stock.

STEP 4

Record each movement

Keep receipts, issues, adjustments and reconciliations traceable. A correction should explain who changed the balance and why.

STEP 5

Assign the next review

Agree whether the next step is display, staff training, supplier discussion or further analysis. Track the decision and review the result.

Put it into practice