--- title: "Profit and Loss" slug: "profit-and-loss" description: "View income and expenses by GL account across selected locations for a period, with multiple report types and comparisons." updated: 2025-08-27T22:24:56Z published: 2025-08-27T22:24:56Z canonical: "docs.restaurant365.com/profit-and-loss" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt > Use this file to discover all available pages before exploring further. # Profit and Loss The P&L report compares the total income and expenses at specified locations, as of a specific date, based on either their fiscal or operational calendar structures. With this report, users can see how all GL accounts and account types have directly impacted net profits of their company. In addition, the report types offered provide different ways to view the data and can be exported as a spreadsheet, allowing users to save this data for deeper analysis. > Although multiple download options are available, R365 recommends downloading the report as a spreadsheet file (such as a CSV) so that formatting can be adjusted if needed. Specific Report Types can benefit users with certain user roles: - [Comp and Non-Comp Period vs Prior Year](/doc/docs/profit-and-loss#comp-and-noncomp-period-vs-prior-year) - Compares both non-comp and comp stores for a specified period to the same period the prior year. Many first year companies use this view since there isn't a year to compare to yet. Click here to learn more about [Comparable Stores](/doc/docs/comparable-stores) and implementing Comparable Start Dates. - [Operations Statement with YTD](/doc/docs/profit-and-loss#operations-statement-with-ytd) - Provides a clear picture of how the company is growing by analyzing Week Ends in the same period and comparing it to the Period to Date and Year to Date budgets. - [Period and YTD vs Budget and Prior Year](/doc/docs/profit-and-loss#period-and-ytd-vs-budget-and-prior-year) - Shows the current period compared to the same period and budget from last year. - [Legal Entity Side by Side](/doc/docs/profit-and-loss#legal-entity-side-by-side) - Compares income and expenses by legal entity. - [Location Side by Side](/doc/docs/profit-and-loss#location-side-by-side) - Compares income and expenses by location. > The P&L and AvT reports are not intended to tie back perfectly to each other, but they can be more closely aligned by [following these steps](https://help.restaurant365.net/en/support/solutions/articles/12000077659). --- ## Navigation The My Reports search bar can be used to search R365's entire catalog of reports. 1. Open the **Reports** app. 2. Navigate to **My Reports**. 3. Enter all or part of the report name in the **search bar**. 4. The **Results** tab will open with the list of search results. 5. From beneath the report name, click **Run** to run the report with the selected report view. -OR- Click **Customize** to adjust the report parameters and run the report. ![Overview of report options in Restaurant365 with highlighted run and customize buttons.](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/report.png) --- ## Report Parameters ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-AFRSM7O3.png) | **Field** | **Description** | | --- | --- | | Cutoff | Level of access to the P&L accounts. This option only appears for Full Access users. Options include: - Full - GL Detail access to all P&L Accounts - Controllable - GL Detail access to all Controllable P&L Accounts - Prime Cost - GL Detail access to all Prime Cost P&L Accounts | | Report Type | Allows the user to select how the report is organized. Options include - Comp and Non-Comp Period vs Prior Year - Legal Entity Side by Side - Period - Legal Entity Side by Side - YTD - Location Side by Side - Period - Location Side by Side - Qtr - Location Side by Side - Week - Location Side by Side - YTD - Location Side by Side Budget Only - Period - Location Side by Side Budget Only - Qtr - Location Side by Side Budget Only - Week - Location Side by Side Budget Only - YTD - Operations Statement - Operations Statement with YTD - Period and YTD - Period and YTD vs Budget and Prior Year - Period and YTD vs Prior by Location - Period vs Budget - Period vs Prior - Periods Side by Side Budget Only - Periods Side by Side with Forecast - Qtr and YTD vs Budget and Prior Year - Trailing 12 Periods - Trailing 12 Periods vs Prior - Trailing 12 Weeks - Week and YTD - Week vs Prior - Week vs Same Last Year - YTD Periods Side by Side vs Budget | | Detail Level | If Detail is selected, parent accounts are broken down to display data for each child account. If Summary is selected, only the parent accounts are shown. | | Filter By | Location 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](/doc/docs/system-preferences-location-reporting-categories) and [Location Record: Reporting Categories](/doc/docs/legal-entities-location-record). | | Filter | Allows 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](/doc/docs/system-preferences-location-reporting-categories) and [Location Record: Reporting Categories](/doc/docs/legal-entities-location-record). | | Calendar | Allows the user to choose whether the report is run based on the fiscal or operational calendar. | | As Of | Date for which to run the report. The report displays sales data ranging from the selected date to today's date. | | Hide $0 Balances | If Yes is selected, the report hides zero balances. | | Show Unapproved | If No is selected, the report does not include data for unapproved transactions. | | Rounding | Allows the user to choose whether data is shown with decimals or rounded to the nearest whole number. | | Account View | Allows the user to choose whether GL accounts are organized by name or by number. | | Metrics | If Show if selected, the report displays the Guest Check Average and Guest Count. | | Variance Percent | These options refer to the details of the variance, with '% of Sales' providing a more precise variance percent. | | Location View | Allows the user to choose whether locations are organized by name or by number. | | Custom Fields | A list of Custom Fields that have been added to R365. Both active and inactive custom fields are available for selection, and only one custom field can be selected at a time. > [!TIP] > To include all values without filtering by the custom field, select ‘None’. > Learn more about [Custom Fields](/doc/docs/custom-fields). | | Custom Field Options | A list of options associated with the selected Custom Fields. Both active and inactive custom field options are available for selection. Report results are filtered to include only transactions with the selected options assigned. Selecting the ‘blanks’ options includes transactions where the custom field is present but no option is assigned, as well as transactions without the custom field. > Learn more about [Custom Fields](/doc/docs/custom-fields). | | View options | Provides the user with options to select, save, edit, or delete a report view. For more information about these controls, see [My Reports: Using My Reports](/doc/docs/my-reports-using-my-reports#report-views). | | Run | Generates the report. The green arrow button opens a drop-down from which users can Export, Email, or Print the report.![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/7cf37415-53db-4de0-abc2-5d9192d3d1bf.png) | --- ## Report Type Variations Report columns vary depending on the Report Type that is selected in the report parameters. ### Comp and Non-Comp Period vs Prior Year ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/48c19c97-62df-4b59-b417-34959567a382.png) | **Column** | **Description** | | --- | --- | | GL Accounts and Account Types | A list of GL accounts and account types. If the Metrics parameter is set to Show, this column also displays the Guest Check Average and the Guest Count. | | Non-Comp Actual | A non-comp location's profits and losses for the selected period. This includes non-comp locations that are recently opened and are still developing their historical sales. If locations have grown to have more of a variability in sales, they are typically set to be [Comparable Stores](/doc/docs/comparable-stores) in the [Location Record](/doc/docs/legal-entities-location-record). Next to each amount provided is a variance percentage calculated based on the setting in the report parameters. | | Non-Comp Prior Yr | A non-comp location's profits and losses for the same period of the previous year. This includes non-comp locations that are recently opened and are still developing their historical sales. If locations have grown to have more of a variability in sales, they are typically set to be [Comparable Stores](/doc/docs/comparable-stores) in the [Location Record](/doc/docs/legal-entities-location-record). Next to each amount provided is a variance percentage calculated based on the setting in the report parameters. | | Variance B/-W | The difference between the Actual and the Prior Yr for both Non-Comp and All Stores. Next to each variance is a variance percentage calculated based on the setting in the report parameters. | | All Actual | Both a comp and non-comp locations' profits and losses for the selected period. If all stores included on the report do not have a Comp Start Date in their [Location Record](/doc/docs/legal-entities-location-record), the numbers will be the same as the Non-Comp Actual column. | | All Prior Yr | Both a comp and non-comp locations' profits and losses for the same period of the previous year. If all stores included on the report do not have a Comp Start Date in their [Location Record](/doc/docs/legal-entities-location-record), the numbers will be the same as the Non-Comp Actual column. | ### Operations Statement with YTD ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/2ce40f1d-5d04-4281-b3b2-6044b244f299.png) | **Column** | **Description** | | --- | --- | | GL Accounts and Account Types | A list of GL accounts and account types. If the Metrics parameter is set to Show, this column also displays the Guest Check Average and the Guest Count. | | Week End Selected | Income and expenses for the Week End Date selected in the report parameters. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | Week End Comparisons | The income and expenses for all Week End Dates in a period of the Week End selected and leading up to the Week End selected. In the example above, the As Of date selected in the report parameters was the final day in its period, so three Week End Dates were included to compare it to. If the As Of date was the third Week End rather than the final Week End in a period, only two comparable Week End Dates would be displayed. Next to each amount provided in these columns is a variance percentage calculated based on the setting in the report parameters | | Period to Date (PTD) | Total income and expenses for the period to date. Next to each amount provided is a variance percentage calculated based on the setting in the report parameters. | | Prior Year PTD | Total income and expenses for the period to date from the previous year. Next to each amount provided is a variance percentage calculated based on the setting in the report parameters. | | Variance B/-W | The difference between the Period to Date (PTD) and the Prior Year PTD, the Period to Date (PTD) and the PTD Budget, the YTD Actual and the YTD Prior, and the YTD Actual and the YTD Budget, respectively. Next to each variance is a variance percentage calculated based on the setting in the report parameters. | | PTD Budget | Budget set for the period to date. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | YTD Actual | Income and expense totals for the year to date. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | YTD Prior | Income and expense totals from the previous year. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | YTD Budget | Budget set for the year to date. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | ### Period and YTD vs Budget and Prior Year ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image(373).png) | **Column** | **Description** | | --- | --- | | GL Accounts and Account Types | A list of GL accounts and account types. If the Metrics parameter is set to Show, this column also displays the Guest Check Average and the Guest Count. | | Actual | Income and expenses for the selected period. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | Budget | Budget set for each account. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | Variance B/-W | The difference between the Actual and Budget, the Actual and Prior Year, the YTD Actual and the YTD Budget, and YTD Actual and YTD Prior, respectively. Next to each variance provided is a variance percentage calculated based on the setting in the report parameters. | | Prior Year | Income and expenses for the same period of the previous year. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | YTD Actual | Income and expense totals for the year to date. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | YTD Budget | Budget set for the year to date. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | | YTD Prior | Income and expense totals from the previous year. Next to each amount is a variance percentage calculated based on the setting in the report parameters. | ### Legal Entity Side by Side ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/561ed659-9510-4866-a0c9-cf7b6e2ff80c.png) | **Column** | **Description** | | --- | --- | | GL Accounts and Account Types | A list of GL accounts and account types. If the Metrics parameter is set to Show, this column also displays the Guest Check Average and the Guest Count. | | Legal Entity columns | Amounts for each account by legal entity. Next to each amount provided is a variance percentage calculated based on the report parameters. | | Total | Total sum of all amounts across the row. | ### Location Side by Side ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/160f880f-3950-4517-a87f-d9a346634664.png) | **Column** | **Description** | | --- | --- | | GL Accounts and Account Types | A list of GL accounts and account types. If the Metrics parameter is set to Show, this column also displays the Guest Check Average and the Guest Count. | | Location columns | Amounts for each account by location. Next to each amount provided is a variance percentage calculated based on the report parameters. | | Total | Total sum of all amounts across the row. | --- ## Profit and Loss with Custom Fields When [Custom Fields](/doc/docs/custom-fields) and Custom Field Options are selected, they are displayed at the top of the Profit and Loss report. The report is filtered to only include transaction lines that have the selected custom field options assigned. Totals reflect only the amounts from those filtered lines. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-H8HI1CWZ.png) --- ## Email, Export, or Print the Report This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Learn more about how to [send, export, or print this report](/doc/docs/my-reports-send-export-or-print-reports). ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-U3S8UCR9.png)