Using the inventory turns report

The inventory turns report helps you to better assess your inventory performance and get a comprehensive view of which brands and categories have been driving your business.

To access this report, navigate to Reporting > Inventory reports and click the Inventory turns tab.

By default, the Report type is set to Product category. You can select a different report type:

• Product
• SKU name
• Brand
• Outlet
• Supplier

You can also change the Measure:

• All inventory
• On-hand inventory
• Low inventory
• Out of stock

Use the Date range calendar picker to select the date range you'd like the report to include.

Benefits of the inventory turns report

The inventory turns report includes the measures for days cover, gross profit, cost of goods sold, GMROI, and inventory turns. With this information, you can:

• Optimize inventory planning and strategy by understanding how quickly your inventory turns, sells, and how profitable it is.
• Use the data to gauge how effective your overall inventory investment was at driving profitability during specific date ranges.
• Maintain effective inventory spending and investments by identifying which categories of your inventory are best driving your business and desired outcomes.
• Make informed inventory purchasing decisions and optimize the targets you set for your business to help achieve your goals.

Understanding the report columns

The report columns include historical measures:

• Product category: Lists top-level categories. In the product cells, use the double arrow icon to expand and display, or collapse and hide, subcategories in the report. Products without an assigned category are displayed together in the No product category group.

  

• Closing inventory: Your inventory at the end of your selected date range.
• Days cover: The number of days before your closing inventory will run out based on items sold per day.
• Cost of goods sold (COGS): Total cost of products sold based on average cost at the time of each sale.
• Gross profit: Total revenue less the total cost of goods sold over the reporting period.
• Gross Margin Return on Investment (GMROI): How efficiently gross profit is generated from the inventory held over the reporting period, calculated as gross profit divided by average inventory value.
• Inventory turns: Number of times inventory has been sold and replaced over the reporting period, calculated as costs of goods sold divided by average inventory value. Assesses the velocity of sales to show inventory health and contributions to gross profit.

Using the inventory turns report

By default, the inventory returns report is set up like a category report, and it highlights GMROI and Inventory turns. The report displays top-level categories, for example, apparel. You can also click the double arrow icon in the Product category column for top-level products and view the sub-categories. This helps you to learn more about which product categories are best driving your business and profitability.

These are some tasks you can accomplish with the inventory turns report:

• Use the top-level categories to compare how your inventory categories are performing overall.
• Click the double arrow icon in the Product category column for top-level products, and view the sub-categories.
• Track the performance of specific sub-categories, for example, knitwear and socks.
• Track which products and sub-categories aren't selling as quickly as others.
• Change the date range to compare how categories sell during different times of the year.

After creating a new category or changing the category a product is assigned to, it can take up to 24 hours for the update to display. Until then, the product's data will remain under its previous category.

What's next?

Understanding Insights and advanced reporting

Learn more about the measures and different reports in advanced reporting.

Learn more

Using the sell through inventory report

Track how much of your inventory is selling during a specified date range.

Learn more