The Product Turnover report

The Product Turnover report shows how fast each product moves through your stock. It groups every product into one of four velocity bands, Fast, Medium, Slow and Dead, so you can see where your money is sitting still.

Product Turnover is included in the Pro plan and above. On another plan, the page shows what the report does and an invitation to upgrade.

Open the report

1. Open Reports in the top navigation bar.
2. Select Product Turnover.
3. Choose a period using Quick Dates, or set Start Date and End Date yourself.
4. Narrow the list with the Category, Supplier and Velocity filters if needed.

The report opens on This Year, from 1 January to today. Choose a different Quick Dates selection or set the dates yourself to change the period.

Reports only appears in the navigation bar if your account has the reports permission. If you cannot see it, ask an administrator to grant it.

Understand the calculations

Two numbers drive the report:

Monthly Usage is the product's consumption in the selected period, scaled to a 30-day month. It is calculated as consumption divided by the period's length in days, times 30.

Turnover is that usage over a year divided by the stock you hold now. A turnover of 4.00x means you sell or consume roughly four times your current stock level over a year.

Days Inv. shows how many days your current stock will last at that consumption rate.

Changing the period changes Monthly Usage, Turnover, Days Inv., Velocity and Total Stock Out. A short period reacts quickly to a change in demand; a longer one smooths out a single large order.

Click a row to open the Turnover Calculation window. It shows the exact input values for the product and works through the arithmetic step by step, making it the fastest way to understand a figure that looks wrong. Click anywhere except the product name or supplier name: the product name opens the product's Quick Preview, and the supplier name opens the supplier.

Understand velocity bands

The bands use fixed thresholds, not a ranking against your other products.

Fast means a turnover of 6 or more times a year, or less than 30 days of stock on hand. Medium means 2 or more turns a year, or under 90 days. Slow is everything below that which still moves. Dead means the product had no consumption in the selected period.

A slow mover is capital standing still. If a product has low turnover and several hundred days of inventory, you have bought far more than demand justifies; reduce the next order quantity rather than repeating it. A fast mover is the opposite risk: high turnover with very few days of inventory means you are close to running out, so check the lead time with that supplier before demand catches you short.

The Turnover Calculation window shows the product's band, but not the thresholds.

Which movements are counted?

Movements are classified by their reason, never by whether the quantity is positive or negative. Moving goods between your own warehouses (transfers in, transfers out and transfers) is excluded entirely. A transfer is not demand: nothing left the business, and across all your warehouses the two halves cancel out. Counting them would inflate how fast a product appears to sell, in some cases by more than half.

Stock written off as defective is also excluded. It leaves as a supplier claim, not as consumption, so it does not indicate demand. Stock corrections made through an adjustment are included.

Total Stock Out is the consumption of the products listed in the selected period: stock-outs, stock used in assemblies and negative adjustments. Transfers, defective stock and stock coming in are not counted.

Filter the results

The summary cards ignore the Velocity filter: they count every product in every band for the selected dates, Category and Supplier. Changing Velocity changes the rows and the results count above the table, but not the counts, averages or Top Mover. Changing Category or Supplier does change the summary cards.

Missing products and capped values

A product is missing from the report if it is inactive, deleted or set not to show in inventory, or if its supplier has been deleted. If your account is restricted to particular departments, you only see products belonging to those departments.

Days Inv. is capped at 999. A product that holds stock but has no recorded consumption shows 999+ in the table, and the cell is empty in the export. This does not mean the stock will last exactly 999 days.

Export the results

Click Export above the table to download the rows shown as a CSV file. All filters are applied, including Category, Supplier and Velocity. The button is unavailable when the table has no rows to export.