Hi. How can we help?

Sales Reports

Advanced Insights 2.0 is currently available to Lightspeed Restaurant customers in Europe. To get access to this feature, contact your Sales Account Manager or Lightspeed Sales. For Lightspeed Restaurant customers in North America, Australia, and New Zealand, please visit our Advanced Insights page.

Advanced Insights’ Sales reports help you identify sales trends and give you an overall snapshot of the financial state of your business. Discover your busiest days of the week, peak service hours, and popular times for repeat customers.

Your sales data is organized into three reports for granular insights: Sales totals, Hourly sales, and Daily sales.

Accessing the Sales reports

To access the Sales reports, follow the steps below:

  1. Log in to the Back Office with your Lightspeed credentials.
  2. Navigate to Advanced Insights > Open Advanced Insights.
  3. In the sidebar navigation menu, click Sales totals, Hourly sales, or Daily sales.

Sales totals: View your net sales for a specified period of time. Hourly sales: View this report to discover your busiest hours. Daily sales: View this report to discover your busiest days.

Sales Totals

Applied filter settings will carry over to other reports until changed.

Understanding the Sales totals reports

The Sales totals report summarizes your sales over a given time period. Use this report to get an overview of your sales and analyze your best days. Click each column on the graph to display that day's Gross or net sales, Covers, Orders, and Average order amount.

Sales Total Selected

Understanding the Hourly sales reports

The Hourly sales report summarizes your busiest and slowest hours of each day and displays the information in a heat map. Darker colors indicate higher sales. Use this report to plan staffing schedules and adjust turn time.

Hourly Sales

Understanding the Hourly sales graph

This report breaks down your most popular times of day over a 7-day period. Hover over a time of day to view an hourly breakdown of Average gross or net sales, Average check count, Average total labor hours, and Average order amount.

Hourly Sales Selected

Changing the calendar span will average out the data over the selected period. For example, if choosing to filter by This Month, the heat graph will display the average hourly breakdown over four periods, or weeks.

Hourly Sales Monthly

For a description of each metric, see below.

Time of day metrics

  • Average net sales: The sales during an hour, including service charges but deducting discounts and voids, averaged over the selected time period.
  • Average gross sales: The sales during an hour, including service charges but deducting voids, averaged over the selected time period.
  • Average check count: The number of checks cleared during an hour, averaged over the selected time period.
  • Average total labor hours: The total amount of labor hours put in by all servers on shift during an hour, averaged over the selected time period.
  • Average order amount: The average order amount per check during an hour, averaged over the selected time period.

Understanding the Daily sales reports

The Daily sales report displays average sales over a 7-day period, compared to the number of hours your staff is clocked in to the POS. Use this report to plan staffing schedules and identify which days might benefit from special offers.

Daily Sales

Understanding the Daily sales graph

This report displays a chart of your sales data organized over the course of a week, including Average labor hours and a breakdown of Sales per labor hour. Hover over a bar to view the breakdown of Total gross or net sales, Total check count, Average check amount, and % of weekly sales for a given day. For a description of each metric, see the table below.

Daily Sales Selected

Changing the calendar span will average out the data over the selected period. For example, if choosing to filter by This Month, the bar graph will display the average hourly breakdown over four periods, or weeks.

Daily Sales Monthly

Daily average metrics

  • Total net sales: The sales during a day, including service charges but deducting discounts and voids, averaged over the selected time period.
  • Total gross sales: The sales during a day, including service charges but deducting voids, averaged over the selected time period.
  • Average check amount: The average amount paid per check, calculated from all checks paid during a single day.
  • % of weekly sales: A day’s sales as a percentage of the average weekly sale amount for the selected time period.

Filtering reports

The reports are generated using the default settings. Those settings can be changed using different filtering settings. Whether it's the time period covered or the type of data being shown, you can use our flexible filters to generate exactly the reports you need.

Filtering by date

After running a report, you can filter your data or compare it for different time periods by using the drop-down menus in the top right. See the Filtering Reports page for more details.

What's next?

Menu Reports

Learn more about Menu reports in Advanced Insights.

Menu reports

Staff reports

Learn more about Server reports in Advanced Insights.

Staff reports

Was this article helpful?

0 out of 0 found this helpful