Sales Reports
Item Sales
A product-by-product breakdown of what you've sold, to spot trends and best-sellers.
Can't find what you need? Contact Cinchio:
About
The Item Sales report breaks down every product sold, so you can see how each item is performing, spot trends, find your best-sellers and make informed menu decisions.
Open it from Reports & Analysis > Sales > Item Sales. What it shows depends on the filters you choose.
Get it by email
Save this report as a saved report and schedule it to be emailed to you regularly.
Filters
Choose these before you run the report.
The sites or site groups to include.
The dates to include sales for.
The product groups to include. Leave blank for all.
Group products by Group, Master Group or Super Group, or choose No Grouping.
How products are ordered in each group: Product (alphabetical), Sale Quantity or Gross (highest first).
The team members to report on. Leave blank for all.
Base the average sale value on Net or Gross.
For Inventory Management users, base the cost on the Average Cost, Last Cost, Min Cost or Max Cost in the date range.
The tills to report on. Leave blank for all.
Report Output
The report is split into sections based on your View Type and Group By filters. If your company uses Inventory Management, it also shows cost, profit and margin.
Which reporting profile does your company use?
Tax Inclusive (UK style)
Does your company use Inventory Management?
No: standard columns
The product's PLU.
The product's name.
The average sale price, based on the Average Sale Type filter.
The total quantity sold. Select it to see the transactions containing the product.
Total gross sales paid by customers.
Total net sales.
Total tax.
Total discount.
Each item's share of sales for the site shown.
Each item's share of sales across the whole report.
See the transactions behind a product
Select a value in the Quantity column to see every transaction the product was sold in.
Yes: with cost and margin
With Inventory Management, the report adds theoretical cost, profit and margin, alongside the standard columns.
Standard columns
The product's PLU.
The product's name.
The average sale price, based on the Average Sale Type filter.
The total quantity sold. Select it to see the transactions containing the product.
Total gross sales paid by customers.
Total net sales.
Total tax.
Total discount.
Each item's share of sales for the site shown.
Each item's share of sales across the whole report.
Inventory Management columns
The item's theoretical net cost, based on the Cost filter. Shown after Average Sale Price.
The gross profit, based on gross sales.
The gross profit margin, based on gross sales and gross profit.
The net profit, based on net sales.
The net profit margin, based on net sales and net profit.
See the transactions behind a product
Select a value in the Quantity column to see every transaction the product was sold in.
Tax Exclusive (US style)
Does your company use Inventory Management?
No: standard columns
The product's PLU.
The product's name.
The average sale price, based on the Average Sale Type filter.
The total quantity sold. Select it to see the transactions containing the product.
Total net sales, before discount.
Total paid by customers for the product.
Total net sales, after discount.
Total tax.
Total discount.
Each item's share of sales for the site shown.
Each item's share of sales across the whole report.
See the transactions behind a product
Select a value in the Quantity column to see every transaction the product was sold in.
Yes: with cost and margin
With Inventory Management, the report adds theoretical cost, profit and margin, alongside the standard columns.
Standard columns
The product's PLU.
The product's name.
The average sale price, based on the Average Sale Type filter.
The total quantity sold. Select it to see the transactions containing the product.
Total net sales, before discount.
Total paid by customers for the product.
Total net sales, after discount.
Total tax.
Total discount.
Each item's share of sales for the site shown.
Each item's share of sales across the whole report.
Inventory Management columns
The item's theoretical net cost, based on the Cost filter. Shown after Average Sale Price.
The gross profit, based on gross sales.
The gross profit margin, based on gross sales and gross profit.
The net profit, based on net sales.
The net profit margin, based on net sales and net profit.
See the transactions behind a product
Select a value in the Quantity column to see every transaction the product was sold in.
Not sure which?
See reporting profiles.