The Stock, sales and commitment report lists your historic sales and stock cover, where "commitment" refers to the current stock available for sale plus incoming stock (i.e. everything already ordered/paid for).
This report can help with planning, replenishment and identifying what products are overstocked.
To access the Stock, sales and commitment report, click on Reports in the left menu, then Stock & commitment.
Filtering the Stock, sales and commitment report
You can use the dropdown menus on the top left-hand side to filter the Stock, sales and commitment report by warehouse and dimension such as categories, vendors, products, variants, etc.
You can also run the report for the following time periods:
Yesterday
Last 7/14/30/90/365 days
Last month
Last year
Week to date
Month to date
Year to date
Custom range
Stock, sales and commitment metrics
The metrics available on the Stock, sales and commitment report are:
Metric | Description |
Sales | The number of units sold for the selected period, less returns.
This data is taken from your sales platform. |
Sales % | The percentage of total sales attributed to this field (variant, product, category, etc.).
Sales % = Number of units sold for one variant ÷ Number of units sold for all variants |
Revenue | The revenue received from sales made during the selected period.
|
Return % | The returns as a percentage of sales.
Return % = Returns units / Gross sales |
Profit | The profit made from sales made during the year
Profit = Revenue - COGS - Platform fee |
Margin | The profit as a percentage of the revenue
Margin = Profit ÷ Revenue |
Avg ROS | Average return on sales. Only available on this report.
Avg ROS = Profit ÷ number of units sold |
In stock | The current stock level in the selected warehouse |
Avg cover (in months) | How many months of sales you can fulfill with your current stock level. Only available on this report.
Avg cover = Number of units in stock ÷ Average monthly sales |
On order | The number of units on active purchase orders to vendors. |
Avg PO cover (in months) | How many months of sales you can fulfill with your on order stock level.
Avg PO cover = Number of units in non-closed purchase orders ÷ average monthly sales |
On order overdue | The number of units yet to be delivered after the expected delivery date. |