The P&L Comparison Screen is a report found in the ‘Reports’ subsection of the ‘Operations’ module. Only Users that have been assigned the ‘P&L Comparison Screen’ security role will see and be able to run this report. What makes this report unique, is the ability for your Restaurant Managers to see and compare the P&L numbers to all other Locations in your Restaurant group. This is accomplished without granting those Users access to the other Locations and Data. The data that is returned is anonymized by replacing the Location Name / Number with a generic ‘Location #’ value. This allows for a true comparison, without additional security access, and full disclosure.
Please keep in mind that if you only have two locations, it will not be hard for your Users to determine where the data from ‘Location 1’ is coming from…
Each User that will have access to this screen must be assigned the ‘P&L Comparison Screen’ security role. Click here for more information on Assigning Security Roles. Once assigned, the ‘P&L Comparison Screen’ will appear in the ‘Reports’ subsection of the ‘Operations Module’, as shown below:
P&L Comparison Parameters
- Report Type – Select the P&L Type to run. ‘Location Side by Side – Period’ is set as default. Options include:
- Location Side by Side – Period
- Location Side by Side – Qtr
- Location Side by Side – Week
- Location Side by Side – YTD
- Detail Level – Select ‘Detail’ or ‘Summary’
- Calendar – Select ‘Fiscal’ or ‘Operational’
- As Of – set the Period/Qtr/Week as-of selection
- Show Unapproved – Yes or No
- Rounding – No Rounding or Whole Numbers
- Compare By – Amount or Percent
- View Report button – click to run the report. Must click each time a parameter is changed
For each Location a User has access to (via their assigned Locations on their User Record) they will see the Location name displayed as shown below:
Users that have access to limited locations will see the other Locations listed as ‘Location 1’, ‘Location 2’ etc.
As a reminder, each User will see All Locations regardless of if they have been assigned those Locations. Unassigned Locations will appear as ‘Location 1’, ‘Location 2’ etc. Therefore, if you only have two Locations, it will not be hard for your users to determine that the ‘Location 1’ data is from the other Location in your Restaurant Group. Please use with caution if you only have two Locations.
Location Ranking / Column Sorting
A very neat feature on the P&L Comparison Screen is the ability to rank, or sort, each Location based on the value of the selected Account.
- Find the GL Account that you want to Rank
- Click once on the GL Account name to sort from ‘Least to Greatest’
- Click a second time on the GL Account name to sort from ‘Greatest to Least’
- Notice how the Columns (or Locations) are resorted with each click. This gives a quick ranking of how your Location is doing compared to other Locations in that particular Sales / Expense area