Aging analysis report

Learn more about the Inventory Aging report

Jansen avatar
Written by Jansen
Updated over a week ago

The Aging analysis report shows the length of time that inventory has been in a particular warehouse. The report assumes first in-first out inventory management.

Inventory Planner maintains a stock audit trail, where each intake increases the value of new stock in the corresponding time window. In order to compute the age of a product for the aging analysis, Inventory Planner walks through the historical stock backwards, subtracting intakes from the current stock until it reaches zero.

Since the aging report is computed based on historical stock, it won't populate with information immediately after connecting your store to Inventory Planner.

To access the aging analysis report, click on Reports in the left menu, then Aging analysis.

Filtering the Aging analysis report

As with other reports, you can use the dropdown menus on the top left-hand side to filter the Year on Year report by warehouse and dimension such as categories, vendors, products, variants, etc.

The columns on the Aging analysis report are groups of time periods. The values in each column correspond to the stock whose age falls into that group. For example, if the report lists 10 units in the 31-60 days column, there are 10 units which are between 31 and 60 days old.

The groups are:

  • Current (total)

  • 0 - 30 days

  • 31 - 60 days

  • 61 - 90 days

  • 91 - 180 days

  • 181 - 365 days

  • > 365 days

Aging analysis metrics

The metrics available on the Aging analysis report are:

Metric

Description

Stock

The number of units

Stock cost

The cost of the units of stock

Stock retail

The retail value of the units of stock

Did this answer your question?