You can identify slow-moving and obsolete inventory by accessing the Aged Stock Report, which shows how long products have been in stock without selling. This report helps retail operators make clearance decisions, identify markdown candidates, and optimize inventory mix by replacing slow sellers with faster-moving products, improving inventory turnover and cash flow.
Using the Aged Stock Report regularly helps retail operators reduce inventory carrying costs, identify products requiring promotional support or markdown pricing, and maintain fresh, desirable product assortments that drive sales velocity.
The Aged Stock Report is designed to provide a Company level view of stock holdings and the current financial liability being incurred by the business.
The Aged Stock Report is global, meaning it reports on a sum total for all Outlets. To view details on stock for individual Outlets we recommend using the Stock Value vs Sales Report.
📋
Note: Package Items will not be displayed on this report
Using the Aged Stock Report
To use the Aged Stock Report:
- Navigate to Reports > Finance Reports > Aged Stock Report
- Use the Filters as required
- Click Search
- The Results will be displayed (see below for more detail on each of the columns)
The results will only include products with an Available quantity
- Click View Legend to see a detailed explanation of the data
- Click the column headings to sort the data
- Export the report to Excel by using the buttons in the top right-hand corner
Back to top
Understanding the Results
To assist with understanding the results, please find below details on each of the columns:
| Column | Details |
| Supplier | The default supplier for the product. Where the product has been ordered and received from multiple suppliers they will be grouped together in the report results under the default supplier. |
Time Periods
(<30, 30-60, 60-90 and 90+) |
The number of products matching that age according to the "Date Received" on a Purchase Order.
|
| Unknown COGS/Unknown Avail |
Any Available quantities entered using methods other than Purchase Orders (Stock Adjustment, Mass Upload etc) will be displayed as "Unknown"
|
| Avail |
The results will only include products with an Available quantity. Products with no Available quantity are automatically excluded and any Allocated quantities are also excluded.
|
| COGS |
The Cost of Goods Sold - the weighted average price
|
Related Articles
Inventory Management:
Reporting & Analytics: