To improve your experience, we’d love your feedback on how and why you use the Support Site!
TAKE THE SHOPKEEP SUPPORT SITE SURVEY NOW>>

Sales by Discount Report

Keep track of discount usage with the Sales by Discount report. See how often a discount is used, the totals for individual discounts, and other related discount metrics.

Table of Contents

Run the Report

From BackOffice, run the Sales by Discount report for an overview of your store’s discount usage.

  1. Click 'Analytics' and select 'Discounts'.
  2. Click the Date icon to choose a preset or custom range, then click 'Retrieve'.

Read the Report

Get familiar with the Sales by Discount report breakdown to maximize its benefits for your business.

Bar Charts

The bar charts show top 10 discounts by Sales Count & total amount discounted.

Click to Enlarge
  • Hover over or tap a bar to see specific details, like sales count and percent of total, for that discount.
  • The term Other is a combination of all discounts outside the top 10.
  • Table View

    The Table View provides detailed information about individual discounts used over the selected time frame.

    By default, only the first 4 columns display on Table View. To enable all of the columns seen below, as seen below, use the Filter feature.

    Click to Enlarge

    Sort the table by clicking any column header with arrows.

    Totals
    The total amount of each column.

    Sales Count
    Number of sale transactions in which the discount was used for the selected time frame.

    Net Discount %
    The percentage of the Sales Amount minus Returns Amount that the discount deducted.

    Net Discounts
    Total amount of the discount applied to sales minus the total amount applied to returns.

    Sales Amount
    Subtotal of all sales where the discount was applied.

    Returns Amount
    Subtotal of all returns where the discount was applied.

    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.
    Cost is calculated using the weighted average cost of an item at the time of sale. If you do not want to use weighted average cost, follow the steps here to disable the feature.

    Gross Margin
    Percentage of Net Sales after accounting for cost.
    Weighted average cost is used in the calculation of gross margin.

    Gross Profit
    Amount of Net Sales after accounting for cost.
    Weighted average cost is used in the calculation of gross margin.

    Filter the Report

    Use the filter tool to hide discounts you don’t want to see or to enable additional table columns.
    1. Click 'Filter'.
    2. To hide a discount, search for it and uncheck the box.

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

    3. To show the discount again, recheck the box.

      Use Select All or Clear to show or hide all discounts at once.

    4. To show a table column, click 'Show/Hide Columns' and check each box.

      Column filters apply to the Table View and Print View.

    5. To hide a table column, uncheck its box.

    Export the Report

    The Sales by Discount report can be easily viewed in any spreadsheet software by downloading a copy via the Export Center. Check out a sample Sales by Discount export here.

    1. Click 'Export'.
    2. Click 'OK' to continue working while the report is prepared.
    3. On the sidebar, select 'Export Center' under 'Analytics'.
    4. Click the icon to download the export when the report is ready.
      Click to Enlarge

    Use the Print feature to prepare the report for printing from any printer connected to your computer.

    1. Click 'Print'.
    2. Wait for the report to open in a new tab in your browser.
      Click to Enlarge
    3. Select 'File' from your browser’s menu and choose 'Print'.