--- title: "Advanced Weekly Sales and Labor" slug: "advanced-weekly-sales-and-labor-report" description: "View consolidated weekly sales and labor KPIs by location and day, including actual net sales and prior year comparisons." updated: 2025-08-26T17:00:05Z published: 2025-08-26T17:00:05Z canonical: "docs.restaurant365.com/advanced-weekly-sales-and-labor-report" --- > ## 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. # Advanced Weekly Sales and Labor The Advanced Weekly Sales and Labor report provides managers with a consolidated view of sales and labor KPIs in one, easy-to-access report. The report provides daily data and weekly totals for the selected week, for the selected locations. This allows high level users, such as district managers, to gauge productivity across locations. --- ## 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-QLHQKZ6Q.png) | **Parameter** | **Description** | | --- | --- | | 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). | | Date Range | Determines the date range for the report. **No** - Date range is determined by the Week setting (#4). **Yes** - Date range is set as a start date and an end date. ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-9H36A8JB.png) > Start dates and end dates align with R365 business days as defined by the location’s [start of day configuration](/doc/docs/start-of-day-overview). | | Week | Week for which to run the report. Options include: - **Current** - Reporting week that includes today's date. - **Previous** - Week prior to the reporting week that includes today's date. - **Week** - Opens the week menu where users select a reporting week based on the last day that is included in the reporting week. | | Week Total | If Show is selected, the report includes a summary section that displays totals for each location for the selected week. | | Sales Forecast | If Show is selected, the For Net Sales and For v Actual Sales Var columns appear in the report. | | Include Optimal Labor | If Show is selected, the report includes two additional columns, allowing users to compare optimal labor to actual labor. - Opt Labor Hrs - Sum of optimal labor hours, as reported by the Operations Dashboard. - Opt v Act Labor Var - Amount of variance between actual labor hours and optimal labor hours, as reported by the Operations Dashboard. | | Scheduled Labor | Show or hide scheduled labor data. When Show is selected, the Sch Labor Hrs and Act v Sch Labor Var columns appear in the report. | | Labor Forecast | Show or hide labor forecast data. When Show is selected, the For Labor Hrs and Sch v For Labor Var columns appear in the report. | | Show Entree Count | Show or hide entree count information. When Yes is selected, the Entree Count column appears in the report. | | Show Key Metrics | Show or hide columns with additional key metrics. When **Yes** is selected, the following columns will appear on the report: - Check Count - Guest Count - Avg Check - Avg Per Guest - Sales Per Labor Hour | --- ## Report Columns ![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/0435f535-e658-4e8b-aac0-c1429a10516d.png) | **Column** | **Description** | | --- | --- | | Location Name | Name of the location. | | Check Count | Number of checks. | | Guest Count | Number of guests. | | Day Part | Amounts by day part. A separate column appears for each day part configured for your organization. | | For Net Sales | Expected amount of net sales, as determined by the published forecast > This column appears when Sales Forecast is set to Show. | | Total Act Net Sales | Actual amount of net sales. | | For v Act Sales Var | Amount of variance between forecasted and actual net sales. > This column appears when Sales Forecast is set to Show. | | PY Sales | Net sales for the same day or week of the previous year. | | Avg Check | Average dollar amount per guest check. This is calculated by dividing the total actual net sales by the check count. | | Avg Per Guest | Average dollar amount per guest. This is calculated by dividing the total actual net sales by guest count. | | Labor Percent | Percent of labor usage for the day or week, for the location. | | Labor Goal | Goal for the percent of daily or weekly labor usage for the location, as set on the [Location record](/doc/docs/legal-entities-location-record). | | Sales Per Labor Hour | The dollar amount of sales per each hour worked. This is calculated by dividing the total actual net sales by actual labor hours. | | Opt Labor Hrs | Sum of optimal labor hours, as reported by the Operations Dashboard. > This column appears when Include Optimal Labor is set to Show. | | Act Labor Hrs | Actual number of hours worked. | | Opt v Act Labor Var | Amount of variance between actual labor hours and optimal labor hours, as reported by the Operations Dashboard. > This column appears when Include Optimal Labor is set to Show. | | Sch Labor Hrs | Number of hours scheduled to be worked. > This column appears when Scheduled Labor is set to Show. | | Act v Sch Labor Var | Amount of variance between scheduled and actual labor hours. > This column appears when Scheduled Labor is set to Show. | | For Labor Hrs | Number of labor hours expected to be worked, as determined by the published forecast. > This column appears when Labor Forecast is set to Show. | | Sch v For Labor Var | Amount of variance between the number of scheduled and forecasted labor hours. > This column appears when Labor Forecast is set to Show. | | Entree Count | Total number of entrees ordered. | | Entree Avg | Total number of entrees ordered divided by the total sales amount. | | Act OT Hrs | Actual number of overtime hours worked. | | Sch OT Hrs | Number of overtime hours scheduled. | > [!NOTE] > Labor Hours and Labor $ values will not consider any hours or dollars associated with employees who have the **Exclude Labor Hours** and **Exclude Labor $** checkboxes checked on their [employee record](/doc/docs/employee-record-employment-tab). --- ## 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) Restaurant365 A database entry that contains detailed info about an employee, including personal details and employment history.