This feature is only available for Lightspeed Retail merchants on select pricing packages.
Sales by Discount Report
Use the Sales by Discount report to track how discounts are used at the register. See which discounts are applied most often, view total discount amounts, and discover the impact of discounts on margins and profits.
Visit our Discounts article to learn how to set up discounts and apply them to sales.
Table of Contents
Run the Report
From BackOffice, run the Sales by Discount report for an overview of your store’s discount usage during a specific date range.
In BackOffice, click 'Reports' and select 'Discounts'.
Click to Enlarge
Click the date icon to choose a preset or custom range, then click 'Retrieve'.
Click to Enlarge
Read the Report
The Sales by Discount report can show which discounts are most popular and which cost you the most revenue. Learn to read this report to master its data and make more informed business decisions.
Bar Charts
The charts show top discounts by Sales Count & Amount Discounted as percentages for the selected date range.
The term Other is a combination of all discounts outside the top 10.
Hover over or tap on a bar to see the count/amount and percent of total for that discount.
Click to Enlarge
Table View
The table provides detailed information about all discounts used during the selected date range. The first row, Totals, gives the total for each column.
Discount Name | Name of the discount used as it is currently entered in BackOffice. Discounts and discount coupons applied to Lightspeed eCom (E) orders processed at the register and supported orders marked ‘Paid’ in the eCommerce Dashboard will appear in reporting as a discount named ‘Open Amount’. When invoice reporting is enabled, discounts on paid invoices will also appear as ‘Open Amount’.
Sales Count | Number of sales in which the discount was used.
Net Discount % | Net Discounts expressed as a percentage of the difference between the Sales Amount and Returns Amount.
Net Discounts | Total discount amount applied to sales minus total discount amount applied to returns.
The following columns must be enabled using the filter tool:
Sales Amount | Pre-discount subtotal of the sold items affected by the discount.
Returns Amount | Pre-discount subtotal of the returned items affected by the discount.
Net Sales | Sales Amount minus Returns Amount minus Net Discounts.
Costs | Total business cost of sold items affected by the discount minus the cost of returned items. By default, Cost is calculated using the weighted average cost of each item at the time of sale.
Gross Margin | Percentage of Net Sales left after accounting for Costs.
Gross Profit | Net Sales minus Costs.
Click any header with arrows to sort the table.
Click to Enlarge
Filter the Report
Filter the report by discount to hide discounts you don’t want to see or to display only specific discounts. Filter by column to customize which table columns appear on the report.