Advanced Reporting provides simple, customizable metrics for users who want to get detailed information on how their restaurant is performing.

With Advanced Reporting, you can:

• Create and save custom reports from preexisting templates or build your own.
• Quickly see how your restaurant is performing with intuitive graphs and tables.
• Easily export any report to PDF and/or Excel. Some of the sections can also be exported to CSV.

Advanced Reporting is an additional module that must be enabled on your account by Lightspeed.

To access Advanced Reporting

To access Advanced Reporting, click Reports > Advanced Reporting.

To create a new report

1. Click Create New report.
2. Give the report a name. 
3. Optionally filter by floors, tables, users and/or shifts. 
4. Click Create. 
5. Drag report sections from the list to the Drag any component here box. See Available Report Sections for full descriptions.
   • To move a section within the report, hover over the section and hold the move icon while dragging the section upwards or downwards.
   • To adjust section specific settings, click the settings icon in the top-right of that section. Select or deselect individual settings and then click Save.
   • To delete a section from the report, click the delete icon in the top-right of the section. Click Yes to confirm.
6. Click Save in the top-right of the window to save the report.

To open a saved report

1. Access the Advanced Reporting section in Restaurant Manager. 
2. Select and click the saved advanced report from the list. 

To set the date range

1. Click the date bar at the top-left of the report window.
2. Select a date range by clicking a start and end date.
3. Specify the time of day.
4. Click Apply.

To download and export a report

1. Save a new report or open a saved report.
2. Click the download icon in the top-right corner.
3. Select a download format.
   • Export as PDF - Portrait
   • Export as PDF - Landscape
   • Export as Excel

Available report sections

Creating a Custom Table section

The Custom section can be a great tool to help you create an individualized report to match your Restaurant's specific needs.

1. Drag and drop the Custom Table section from the sections list.
2. Click the Settings button to open the Custom Section Settings popup.
3. Give the section a title.
4. Select an Aggregate interval criterion from the drop-down menu:
   1. Aggregate per receipt
   2. Aggregate per day
   3. Aggregate per month
5. Select a Sort by criterion from the drop-down menu:
   1. Receipt date - displays report in chronological order.
   2. Receipt ID - organizes content by receipt ID.
   3. Total amount of receipts
   4. Total amount of items
   5. VAT total
   6. Discount total
6. Create the dynamic columns.
   1. Click Add Column. 
   2. Select the Column Type from the drop-down.
   3. Give the field column a header name.
      1. Select one of the following options if you Column Type is a Field:
         1. Receipt date
         2. Receipt ID
         3. Total amount of receipts
         4. Total amount of items
         5. VAT total
         6. Discount total
      2. OR: Select one of the following if your Column Type is an Aggregate. An aggregate is the sum of certain characteristics or fields.
         1. Category Tax Incl.
         2. Category Tax Excl.
         3. Payments Total (Payments Amount + Payments Tips)
         4. Payments Amount
         5. Payments Tips
         6. Number of payments
         7. Net per tax rate
         8. Tax per tax rate
         9. Total per tax rate
   4. In the Filter on box, you can opt to narrow down the data to specific product categories. For example, Drinks.
   5. Click Ok to add your column.
7. Click Save in the top-right corner of the Advanced Reporting window.