The Location Comparison report compares certain operation values on the P&L report from two or more restaurant locations. This report allows the user to view various labor and sales comparisons for the current day, prior day, and the same day for the year prior. Percentages highlighted yellow show whether a location is below average while a non-highlighted number shows that a location met their designated percentage goals.



Navigation

  1. In the Reports section of the left navigation pane, select My Reports.
    The My Reports screen appears.
  2. At the top of the My Reports screen, select Op.Analysis.
    The screen generates a list of reports in alphabetical order.
  3. Locate the Location Comparison report.
  4. Select Customize to adjust the report parameters and run the report.

Report Parameters




FieldDescription
1
Value (Limit 3)Allows the user to select up to three sales and/or labor values to compare against other locations.
2
Date RangeIf set to Yes, the user can select a Start and End date to create a date range for the report.
If set to No, the user can select an As Of date to set a specific date for which to run the report.
3
As Of / Start / EndDates for which to run the report.
If Date Range is set to Yes, the Start and End date fields appear, allowing the user to run the report for a range of dates.
If Date Range is set to No, only the As Of field appears, allowing the user to select a specific date for the report.
4
Filter ByLocation reporting category by which to filter the report.

Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
5
FilterAllows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report.

For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category.

Options that appear in the Filter menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories.
6
Time FrameAllows the user to run the report by day, week, period, quarter, or year.
7
Compare ValueDepending on the selection, the generated report compares actuals, variances, or variance percentages.
8
Subtotal ByIf set to Location, subtotals appear for each location.
If set to Filter By Selection, subtotals appear for each location reporting category, based on the option selected in the Filter By parameter. For example, if the Filter By parameter is set to Business Type and the Subtotal By parameter is set to Filter By Selection, the report displays subtotals by business types. 
9
View optionsSelect, save, edit, or delete a report view.
For more information about these controls, see My Reports: Using My Reports.
10RunGenerate the report.
Select the arrow to Export, Email, or Print the report.



Report Columns



ColumnDescription
LocationLocation for which data appears in the row.
CurrentPercentage of labor for the current day, week, period, quarter, or year, based on the selected date range. 
PriorPercentage of labor for the previous day, week, period, quarter, or year, based on the selected date range.
Prior YrPercentage of labor for the same day, week, period, quarter, or year of the previous year, based on the selected date range.



Email, Export, or Print the Report



This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.