Custom Labor Report

The Custom Labor Report provides a single, customized view of labor data in R365.

The labor data shown on the Custom Labor Report is customizable. The data shown is based on the attributes and metrics selected when setting up report parameters. Attributes are fixed data points from R365 that give a report context and scope, such as location, employee name, date, and ID numbers. Metrics are variables whose values and measurements are calculated based on the context of the attributes. They include calculated values such as hours, wages, and tips.

While the metrics available remain available for all report levels, the attributes available to add to the report are determined by the reporting level selected. The report can be run only at the location summary, employee summary, or employee detail level. The report output is determined by the selections made.

This report supports operators, accounting, analysts, and HR or payroll roles that need a centralized source for labor information across the organization. It consolidates all labor data points into one customizable view to support daily monitoring and detailed labor cost analysis.

Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

Open the Reports app.
Navigate to My Reports.
Enter all or part of the report name in the search bar.
The Results tab will open with the list of search results.
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.

Report Parameters

Parameter	Description
Filter By	A list of all filter categories. Filter categories will vary based by report.
Filter	A list of filter options determined by the 'Filter By' category selected.
Start	First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates. The available date range for this report is dependent on the level selected. Location Summary - has no date range cap. Employee Summary - Can look at up to 6 months. Employee Details - Can look at up to 60 days.
End	Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for the data generated. The report then displays data for all dates within the date range, including the start and end dates. The available date range for this report is dependent on the level selected. Location Summary - has no date range cap. Employee Summary - Can look at up to 6 months. Employee Details - Can look at up to 60 days.
Level	The level of data available for the report and the way the data is organized. The following options are available: Location Summary - Groups data by location. Employee Summary - Groups data by employee and then by location. Employee Details - Groups data by employee and then by location. The Employee Details includes an additional parameter to include employee details.
Metrics	The labor metrics or values the report calculates and displays. They represent the measures selected when running the report, such as labor hours, tips and dollar amounts. Metrics show what the report measures once the Attributes set the context.
Location Attributes	Location Attributes are the subset of attributes that identify and describe a specific location. These fixed data points define the location scope for the report and determine how labor data is grouped and filtered by location. Location attributes include the following: Legal Entity Number Legal Entity Name Location Number Location Name
Employee Attributes	Employee Attributes are the subset of attributes that identify and describe an employee. These fixed data points define the employee scope for the report and determine how labor data is grouped and filtered by employee. Employee attributes include the following: Employee Name Payroll ID Employee ID Job Code Job Title Age Hire Date This parameter is only available when the Level selected is Employee Summary or Employee Details.
Employee Detail Attributes	Employee Detail Attributes are additional data points that provide more specific information about an employee. These attributes extend the employee scope with extra context to support deeper labor analysis. Employee detail attributes include the following: Date Worked Day of the Week Start Time End Time Scheduled Start Date Worked Scheduled End Date Worked Scheduled Day of the Week Scheduled Start Time Scheduled End Date This parameter is only available when the Level selected is Employee Details.
Show Grand Total	Show or hide the grand total row, which displays totals of all the values from each column.
Show Location Total	Show or hide the location total. This parameter is only available when the Level selected is Employee Summary or Employee Details.

Report Layout

Because the report metrics and attributes are customizable, the report columns and data are dependent based on the selections made. Attribute columns are listed before metric columns.

The report header contains:

The date range selected for the report.

Column	Description
Grand total (row)	The total for all values in each column.
Location total (row)	The totals of column values for each location.
Location Attributes
Legal Entity Number	The number associated with the legal entity.
Legal Entity Name	Name of the legal entity.
Location Number	Number associated with the location.
Location Name	Name of the location.
Employee Attributes
Employee Name	Name of the employee.
Payroll ID	Employee’s Payroll ID.
Employee ID	Employee’s assigned Employee ID.
Job Code	Code associated with the job title.
Job Title	Job worked by the employee.
Age	Age of the employee.
Hire Date	Employee’s official date of hire.
Employee Detail Attributes
Date Worked	Date worked associated with the labor data.
Day of the Week	Day of the week associated with the labor data.
Start Time	Employee shift start time.
End Time	Employee shift end time.
Sch Start Date Worked	Scheduled start date worked.
Sch End Date Worked	Scheduled end date worked.
Sch Day of the Week	Scheduled day of the week.
Sch Start Time	Employee’s scheduled start time.
Sch End Time	Employee’s scheduled end time.
Metrics
Regular Hours	The total number of regular hours worked by employees. This excludes OT and DT hours.
Penalty Hours	Hours paid at a penalty rate. Typically used when rule violations or missed breaks trigger penalty pay.
OT Hours	The total amount of overtime hours worked by employees.
DOT Hours	The total amount of double-time hours worked by employees.
Penalty Amount	The total dollar amount paid for penalty hours.
Regular Wage Amount	The total dollar amount of regular wages paid to employees.
OT Amount	The total dollar amount of overtime wages paid to employees.
DOT Amount	The total dollar amount of double-time wages paid to employees.
Total Wage Amount	The total dollar amount of all wages, including regular, OT, and DT wages.
Scheduled Hours	The total number of scheduled hours for employees including regular, OT, and DT scheduled hours.
Scheduled Regular Amount	The total dollar amount of regular wages scheduled to be paid to employees based on scheduled regular hours.
Scheduled Total Amount	The total dollar amount of all scheduled wages including regular, OT, and DT wages.
Scheduled OT Hours	The total number of overtime hours scheduled for employees.
Scheduled OT Amount	The total dollar amount of overtime wages scheduled to be paid to employees.
Scheduled Break Minutes	The number of minutes employees are scheduled for breaks.
Payroll Tax Burden	Employer’s estimated payroll tax cost calculated by applying the location’s configured Payroll Tax % Estimate to all taxable labor dollars. This includes hourly labor, manager salary, declared tips, and credit card tips. The resulting amount represents the employer-paid payroll taxes associated with total labor activity.
Payroll Benefit Burden	The employer’s estimated cost of providing employee benefits, calculated by applying the location’s configured Benefit Burden % Estimate to all eligible labor dollars. This burden typically includes employer-paid health insurance, retirement contributions, paid leave programs, and other benefit-related costs. The resulting amount represents the employer’s benefit expenses associated with total labor activity.
Payroll Other Estimate	Additional estimated employer labor costs outside tax and benefit burden.
Payroll Burden Total	Total labor burden including taxes, benefits, and other employer costs.
Total Hours	The total hours worked including regular, OT, and double-time hours.
Declared Tips	The dollar amount of tips declared by employees.
Charge Tips	The total dollar amount of credit card tips collected.

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.