The Labor Payroll Review searches the entire system for all labor punches in the selected date range so that the Accounting Manager can ensure that labor is prepared and ready to be sent to the payroll provider. 


This report includes both a summary and detailed version. Access the summary to see an overview of the employee's total hours or view the detailed report for a breakdown of labor punches by job.


Important Note: While R365 provides labor information at no additional charge, your payroll provider might charge service fees. Please check with your provider before transferring data.


Article Topics


  1. In the Reports section of the left navigation pane, select My Reports.
    The My Reports screen appears.
  2. At the top of the My Reports screen, select Labor.
    The screen generates a list of reports in alphabetical order.
  3. Locate the Labor Payroll Review.
  4. Select Customize to adjust the report parameters and run the report.


Back to Top


Report Parameters




FieldDescription
1Filter ByLocation 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 and Location Record: Reporting Categories.
2FilterAllows 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 and Location Record: Reporting Categories.
3StartFirst date to be included in the report. The Start and End date fields create a date range for which to generate data for the report.
4EndLast date to be included in the report. The Start and End date fields create a date range for which to generate data for the report.
5JobJobs for which to generate data. Users can select one or more jobs to include in the report.
6Job TypeLabor operational reporting categories associated with the GL accounts assigned to jobs. Users can select one or more Job Types by which to filter the report.
7Sort ByDetermines whether employees are sorted by First Name or Last Name.
8% of SalesPercentage of sales to be taken for tips.
9Run As
If Summary is selected, the report displays an overview of total hours for each employee.
If Detail is selected, the report breaks down the employee's worked hours by job.
10Identify MinorsIf set to Yes, the word 'Minor' appears next to all employees who are under a certain age.
11Mask Payroll ID to Last 4 Digits
If set to Yes, only the last four digits of the Payroll ID are shown in the report.
12View optionsProvides 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.
13RunGenerates the report.
The green arrow button opens a drop-down from which users can Export, Email, or Print the report.


Back to Top


Report Columns


ColumnDescription
Employee NameName of the employee.
In Time when the employee started the shift.
OutTime when the employee ended the shift.
LocationLocation where the employee worked the job.
JobName of the job that the employee worked.
Pay RateEmployee's hourly rate of pay for the job.
Reg HrsNumber of hours that the employee worked at a regular rate.
Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25.
OT HrsNumber of hours that the employee worked at an overtime rate.
Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25.
Double Time HrsNumber of hours that the employee worked at a double time rate.
Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25.
Tot HrsTotal number of hours the employee worked.
Hours are reported as a decimal. Example: 4 hours and 15 minutes appears as 4.25.
Reg PayAmount owed to the employee for hours worked at a regular rate.
Reg Pay = Reg Hrs x Reg Rate
OT PayAmount owed to the employee for hours worked at an overtime rate.
OT Pay = OT Hrs x OT Rate
DT PayAmount owed to the employee for hours worked at a double time rate.
DT Pay = Double Time Hrs x Double Time Rate
Break PenaltyIndicates whether penalty pay is owed to the employee due to a break violation, such as a short break or missed break. This follows the Break Penalty values set on the Location Record and is explained in greater detail by the Labor by Employee by Job Report.
Break Penalty PayAmount owed to the employee due to the break penalty.
Split ShiftIndicates whether the employee worked a split shift. This follows the Split Shift values set on the Location Record and is explained in greater detail by the Labor by Employee by Job Report.
Split Shift PayAmount owed to the employee due to the split shift.
Other PayAmount owed to the employee for any reason not covered by regular pay, overtime pay, double time pay, and penalty pay, as recorded on the DSS.
Total Labor PayTotal amount owed to the employee for the specified date, including regular pay, overtime pay, double time pay, penalty pay, and all others.
Gross ReceiptsSum of all sales the employee participated in for a given shift.
% of SalesPercentage of sales taken for tips.

% of Sales = Gross Receipts x Percentage of Sales
Charge TipsTips from credit card sales, as reported by the POS.
Declared TipsTips from cash sales, as declared by the employee and reported by the POS.
Tips to Payroll
Displays either % of Sales or (Charge Tips + Declared Tips), determined by which is the greater amount.



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. 



Back to Top


Email, Export, or Print the Report



This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.


Back to Top