In the Reports → Products section, you will find an overview of which products sell the most and which sell less. This overview helps you quickly identify strong and weak items in your offer, monitor gross revenue, margin, and total costs for each product.
| Note: Chart controls, date range selection, data comparison, and export options are the same across all reports. For a detailed description, see Working with reports and statistics. |
Data in the report
The product overview contains the following indicators.
- Quantity sold – displays the total number of all products sold in the selected period. This is the sum of all items on receipts that were closed and paid.
- Gross takings – represents the sum of sales prices of all sold products without deducting costs. This is revenue before counting purchase prices or ingredients.
- Costs – these are the purchase prices of ingredients and products used for all sold items in the selected period. The value is taken from stock cards and their purchase prices during the accounting period.
-
Margin – expresses the ratio between gross revenue and costs of sold products. If the margin is low or negative, we recommend checking stock card prices, recipes, or the product’s sales price.
Formula: Margin = (Gross takings – Costs) / Gross takings × 100 %
|
Note: The recommended margin should not be lower than 60%. And if the margin is negative, check:
To calculate costs and margin, you must have Stocks enabled. Our extension allows you to track all ingredients and costs easily and reliably — if you don’t have it yet, simply contact our sales team and we’ll be happy to activate it for you. |
Product overview table
The table provides a detailed sales breakdown for the selected period. It includes these columns:
- Menu items – names of sold products
- VAT – current VAT rate of the product (23%, 19%, 5%)
- Sold items – number of units
- Gross revenue – amount before deducting costs
- Gross profit – difference between gross revenue and costs
- Margin (%) – product profitability
- Costs – ingredient consumption according to inventory management
- Category – the category the product belongs to
Additionally, the table can be filtered by product categories, which makes it easier to track the performance of specific groups.
You can easily export table data to Excel by clicking the “Export Table” button in the top right corner.
Grouping by VAT rates
In the table, you can choose:
- Group – all products are displayed together regardless of VAT (default view).
- Do not group – products are divided based on the VAT rate they had during the monitored period.
This is especially useful when a product has different VAT rates — for example, if its sales form changed or it belongs to a different legislative category.