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.

  1. In BackOffice, click 'Reports' and select 'Discounts'.
    Click to Enlarge
  2. 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.

Discounts appear with the names currently entered in BackOffice for them.

Click to Enlarge

The term Other is a combination of all discounts outside the top 10.

  1. 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.

Click to Enlarge

The following columns display by default:

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.

  1. 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.

  1. Click 'Filter'.
    Click to Enlarge
  2. To hide a discount, uncheck its box.
    • To show the discount again, re-check the box.
    • Use the filter controls to search for a discount, select all discounts, and clear all selections.

    Discount filters apply to the Bar Charts, Table View, Export, and Print View.

    Click to Enlarge
  3. To show a table column, click 'Show/Hide Columns' and check each box.
    • To hide a column, uncheck its box.

    Column filters apply to the Table View and Print View.

    Click to Enlarge

Export the Report

Download a copy of the Sales by Discount report to analyze and filter the data using spreadsheet software.

  1. On the Table View, click 'Export'.
    Click to Enlarge
  2. Wait for the export to be generated. Check the box to be notified by email when exports are ready for download (optional).

    Exports ready in a few seconds will automatically download to your computer. Click ‘Close’ to close the message box.

    Click to Enlarge

    Exports that take more than a few seconds to generate are downloadable via the Export Center when ready. Click ‘OK’ to close the message box.

    Click to Enlarge
  3. After downloading, the export is ready to open in any spreadsheet software.
    Click to Enlarge

Use the Print feature to generate the report in a printer-friendly format that can be printed or saved.

  1. Click 'Print'.
    Click to Enlarge
  2. Wait for the report to open in a new browser tab.
    Click to Enlarge
  3. Click 'File' on the web browser’s menu and select 'Print'.

    Or choose to save the print view as a PDF for easy sharing.