P&L Comparison

Prev Next

The P&L Comparison compares locations by amount or percentage.

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.

To learn more about the added benefit of this screen, view Tip #6 of R365's 'Back to School' Tips & Tricks.

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.


Navigation

  1. Open the Reporting application.

  2. Click P&L Comparison.


Security

The following permission is required to view the P&L Comparison page.

  • Reporting → Standard Reporting → Can View P&L Comparisons Page


P&L Comparison Parameters


Button/Field

Description

1

Report Type

The P&L report type. Options include:

  • Location Side by Side - Period

    • This is set as default.

  • Location Side by Side - Qtr

  • Location Side by Side - Week

  • Location Side by Side - YTD

2

Detail Level

The amount of detail that will be included in the report. Options include:

  • Detail

  • Summary

3

Calendar

Sets the report to run on the fiscal or operational calendar.

4

As of

Sets the as of date for the report, options include:

  • Period

  • Quarter

  • Week

5

Show Unapproved

Determines if unapproved transactions will be included in the report:

  • Yes: Unapproved transactions will be included in the report.  

  • No: Unapproved transactions will not be included in the report.

6

Rounding

Sets the rounding for the report:

  • Whole numbers: Round the values to whole numbers and does not include decimals.

  • No rounding: Does not round the values in the report to whole numbers and does include decimals.

7

Compare by

Determines how the report will be compared. Options include:

  • Amount

  • Percent

8

View Report

Generates the report.



Anonymized Locations

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.


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.

  1.  Find the GL Account that to be ranked.

  2.  Click once on the GL Account name to sort from 'Least to Greatest'.

  3.  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.