The Aging analysis report shows the length of time that inventory has been in a particular warehouse. It can be used to understand how long stock has been around and make appropriate decisions as it how it should be treated (e.g. marked down or liquidated).

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. However, you can import stock history to begin using it sooner. Learn more about importing stock history here.

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

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:

The metrics available on the Aging analysis report are: