This feature is only available for Lightspeed Retail merchants on select pricing packages.

Sales by Item Report

The Sales by Item report allows you to track the business’s sold items. See which items sell best, discover which are most profitable, and view other types of sales data on an item-by-item basis.

Table of Contents

Run the Report

From BackOffice, run the Sales by Item report for an overview of individual inventory item sales.

  1. Click 'Reports' and select 'Items'.
    Click to Enlarge
  2. Click the date icon to choose a preset or custom range, then click 'Retrieve'.
    Click to Enlarge
  3. (Optional) Click the drop-down to select whether to run the report for the current location only or for all linked locations.

    This setting is available to merchants with multiple linked locations and is only visible to the Business Owner. Visit our New Store Setup article to learn how to create a new linked location or our Multi-Store Management guide to learn how to link existing locations.

    Click to Enlarge

Read the Report

The Sales by Item report can show you which stock items are in demand and which are not. Learn to read this report to understand its data and discover new insights about the business.

Bar Charts

The charts show top items by Quantity Sold and Sales Amount as percentages for the selected date range.

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

Click to Enlarge

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

  1. Hover over or tap on a bar to see the quantity/amount and percent of total for that item.
    Click to Enlarge

Table View

The table view provides detailed information about all items sold over the selected date range. The first row, Totals, gives the total for each column.

Click to Enlarge

Item | Name of the item sold as it is currently entered in BackOffice. Shipping, delivery, and pickup charges for supported Lightspeed eCom (E) orders, as well as new sales run in Lightspeed Pocket and Lightspeed Pay, will appear in reporting as an item named ‘Custom amount’.

Department | Name of the department the item is currently assigned to.
See which departments generate the most sales using the Sales by Department report.

Category | Name of the category the item is currently assigned to.
See which categories generate the most sales using the Sales by Category report.

Quantity Sold | Total item quantity sold.

Sales Amount | Total item sales amount before discounts, returns, gratuity, and tax.

Important: Sales tax figures in reporting are estimates based on how you have configured your tax rates and tax groups in BackOffice. For official filings, always verify your current local rates, then manually calculate tax using net taxable and non-taxable revenues. Be aware that tax laws can change at any time and you should contact a tax professional for specific tax advice regarding your business. To learn how tax is calculated in Lightspeed Retail, visit the Sales by Tax Rate Report article.

Quantity Returned | Total item quantity returned.

Returns Amount | Total item amount refunded before tax, gratuity, and discounts.

Costs | Cost of all sold items minus the cost of returned items.
By default, Cost is calculated using the weighted average cost at the time of sale for each item.

Discounts | Discounts on all sold items minus discounts on returns.
Want to see more detail on discount usage? Check out the Sales by Discount report.

Gross Margin | Percentage of Net Sales left after accounting for Costs.

Gross Profit | Net Sales minus Costs.

Net Sales | Sales Amount, minus Returns Amount, and minus Discounts.

  1. Click any header with arrows to sort the table.
    Click to Enlarge
  2. Click an underlined item to see the modifiers or variants sold for that item.

    Modifiers and variants appear with the names currently entered in BackOffice for them.

    Click to Enlarge

    Example of an item with modifiers:

    Click to Enlarge

    Example of an item with variants:

    Click to Enlarge

Looking for more detail on modifier and variant usage? Visit the Modifiers and Variants report.

Filter the Report

Filter the report by column to customize which table columns appear on the report. Filter by item to hide or show individual items or all of the items in specific departments and categories.

  1. Click 'Filter'.
    Click to Enlarge
  2. Select a filter option.

    Show/Hide Columns | Show or hide table columns.
    Items | Show or hide individual items.
    Departments | Show or hide all items in specific departments.
    Categories | Show or hide all items in specific categories.
    Column filters apply to the Table View and Print View. Item, department, and category filters apply to the Bar Charts, Table View, Export, and Print View.

    Click to Enlarge
  3. Check (show) or uncheck (hide) boxes to filter the report.

    Use the filter controls to search for a specific item, department, or category.

    Click to Enlarge
  4. (Optional) Repeat steps 2 - 3 to add additional filters.

Export the Report

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

  1. On the Table View, click 'Export' and select 'Sales by Item', 'Variants', or 'Modifiers'.

    Sale by Item | Sales information for every item sold over the time period. See sample report.
    Variants* | Shows all sold items and displays details for individual variants. See sample report.
    Modifiers | Breaks down modifier usage for items with modifiers. See sample report.

    *This export has ‘Product Name’ and ‘Line Item Name’ columns. For basic items, the item name is listed in both columns (i.e. Toaster | Toaster). For items with variants, the item name is listed in the first column and the variant name in the second (i.e. Pants | Large Blue)

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

Have questions about BackOffice reporting? Visit our Reporting FAQ for help.