The Inventory Turnover Report shows how quickly your products are selling. If you track inventory in ConnectStock, this report gives you accurate details on how your inventory is doing.
How to run it
Go to Reports, click Inventory, then click Inventory Turnover Report.
Pick a store.
Pick a date range (for example, Last Year).
Click Run Report.
How inventory turnover is calculated
We track each item from the moment it is bought (based on the bill date) until it is sold. Because of this, the turnover rate in the report is a real calculation from your data, not a rough estimate.
Formula
Turnover Rate = Total Sales Qty ÷ Average Inventory
Average Inventory = Sum of daily units on hand (only days in stock) ÷ Number of days in stock
This is much more accurate than just averaging the starting and ending inventory, which many systems do.
More metrics included
Days in Stock: If an item is out of stock, we track it and leave those days out of the average.
Score: A performance score we calculate as Turnover Rate × ROI. The higher the score, the better the item is doing.
The Score shows which products truly bring in value, so you know which items to restock, promote or stop selling.
Make the report work for you
You can:
Add, remove or move columns (for example, Sales Qty)
Filter items, for example by a minimum sales quantity
Export the report to study it further or share it
We recommend looking at your turnover over a full year for a more reliable picture of how your products are doing.
Important notes
This report only works from the date you started tracking inventory in ConnectStock.
Inventory tracking starts on the date you enter the bill for the item.
Sales in this report are based on the shipped date. When you compare it to the standard P&L report, use the shipped date and the same cost type.
Why it matters
The Inventory Turnover Report helps you:
Avoid having too much or too little stock
Make smarter restocking choices
Improve cash flow by focusing on items that sell fast and have a high ROI
In short, it turns your inventory data into a tool for making better decisions.
Frequently asked questions
Why doesn't the report match my P&L report?
This report uses the shipped date. In the P&L report, use the shipped date and the same cost type to compare.
Why is an item missing data from before a certain date?
The report only works from the date you started tracking inventory in ConnectStock. Tracking for an item starts on the date you enter its bill.
What is a good Score?
Higher is better. Score = Turnover Rate × ROI.