Hi. How can we help?

Net sales report

Beta disclaimer: At this time, Advanced Insights is available in public beta for Lightspeed Restaurant customers in North America. If you meet this criterion and want to help test this feature, contact your Sales Account Manager or Lightspeed Support.

The Net sales tab gives you an overview of net sales for a specified period of time. This is a customizable report. Your data can be displayed by day or week for either a single location or all locations.

Table of contents

Accessing the Net sales report

Advanced Insights organizes your net sales data in a graph and table. To get started, choose your location and time frame.

  1. Sign in to your Advanced Insights dashboard.
  2. In the main navigation menu, click Sales. On the Sales page, select the Net sales tab.
  3. At the top of the navigation menu, click the Location drop-down and select whether to run the report for a particular location or for All locations.
  4. By default, the report displays data for the last 28 days. To choose a different time frame, click the calendar drop-down in the upper right corner.  Optionally, click Custom to specify the time period using a calendar, but you cannot select a date range longer than three months.

Filtering the report

After running the report, you can filter your data or compare it for two different time periods.

  1. To filter your results, use the View by drop-down and select Day or Week.
    view-net-sales-by-day.png
  2. To compare two time periods, use the Compare to drop-down and select from Previous period, Previous year, or Daily averages.
    Net-sales-previous-period.png

For a description of each comparison type, see the table below.

Comparison type descriptions

Report Description
Previous period Compares the selected time period with the prior time period. For example, if you are viewing sales for the last 14 days, the report compares these sales to sales from the 14 days prior.
Previous year Compares the selected time period with the same time period from the previous year. For example, if you are viewing sales for June 22, 2022, the report compares these sales to sales for June 22, 2021.
Daily averages Calculated by taking the average values for that specific day of the week, using all historical data up to that point. For example, the daily average for Friday, May 20, 2022, is calculated from the sales for all Fridays until the 20th.

Understanding the Net sales graph

The Net sales graph is a visual representation of your net sales data. You can view a summary of your net sales data in the left corner or hover over the graph for a detailed breakdown of your daily or weekly sales. 

The breakdown organizes your data in Net sales, Tax, Guest checks, Average check total, Covers, and Weather. If you compare the amounts to another period of time, the breakdown also shows the percentage increase or decrease in net sales. For a description of metrics unique to the breakdown, see the table below.

net-sales-graph-hover.png

Net sales metrics

Metrics Description
Net sales The total gross sales of items after taxes and discounts.
Tax The total sales tax.
Guest checks The total number of guest checks closed during the specified time period.
Average check The average check total for net sales. This is calculated by dividing your net sales by the total number of guest checks.
Covers The total number of customers on a ticket (or check). For example, a table of five customers counts as five covers.
Weather If you are viewing by day, the net sales breakdown includes that day’s weather. The weather types are sunny, partially cloudy, cloudy, rainy, and snowy.

Understanding the Net sales table

The Net sales table can be filtered by day or week and by location for a specified period of time. If you are comparing time periods, the table also displays the percentage increase (in green) or decrease (in red) in net sales. For a description of each column, see the table below.

Net-Sales-Table.png

Net sales columns

Column Description
Date or Location When viewing net sales data for a single location, the table organizes your data by days or weeks for the specified time period. If you view net sales data for all locations, the table lists the net sales totals by location.
Net sales The total gross sales of items after taxes and discounts.
Guest checks The total number of guest checks closed during a given day or week, or at a specific location.
Average check The average check amount. This is calculated by dividing the total net sales by the total number of guest checks for that day, week, or location.
Covers The total number of customers on a ticket (or check). For example, a table of five customers counts as five covers.

Was this article helpful?

0 out of 0 found this helpful