The Payroll Report is a labor report that line-itemizes labor totals by employee, location, or location group for any specified time frame. This report also displays hourly wage, paid breaks, unpaid breaks, overtime pay, double time pay (if applicable), credit card, auto gratuity, and declared tips per employee per shift.
Note: If your company is utilizing the Payroll Validation module and the company preference ‘Suppress Payroll Report Validation Messages’ is set to “No”, a message will display at the top of the report detailing whether or not the selected location(s) have been certified. For more information see the “**Important Notice**” section below.
This report tracks labor totals, so it is a good report to use to see what your current labor cost is for a work center, store, or group of stores. This report can also be used to see which employees are consistently hitting overtime, which employees are hitting double time, and which employees do not take their breaks. Note: The Payroll Report explicitly excludes "null" shifts where In Time = Out Time.
- Filter by location(s) or location group(s). This report can be run for any specified length of time.
- Select whether or not to hide zero dollar penalties.
- Select the type of tips displayed on the report. Options include: Original, CC tips only, Autograts only, and CCTips + Autograts.
- Filter by metric. The metrics available for selection are: Employee Details, Employee Punch Audit Details, Employee + Job Totals, Employee Totals, Job-Employee Details, Job-Employee Totals, Job Totals, and Work Center Totals.
- Select which Employee ID you would like to display on the report.
- Select from the following: Payroll ID, POS Number, SSN, or "Payroll ID if available, else POS Number".
- Enter additional custom Filter Text.
- Select whether to include or exclude zero rate employees.
- Select whether to filter by: SSN, last name, or payroll ID. You may also select "No Filter".
- Select whether or not to group by locations.
- Select whether or not to include externally worked shifts.
- Select whether or not to filter by job.
- This report can be viewed/exported in various formats. It can also be directly emailed.
Frequently Asked Questions
Q: Why does the Payroll Report have the wrong rate of pay for an employee?
A: The reason for this is most likely that the employee has the same incorrect rate of pay programmed for them into the POS. To fix this problem, fix the rate of pay for the employee in the POS.
Q: Why does the Payroll Report’s total display a different OT Pay than when I sum up the individual OT Pay per employee?
A: The reason the values differ has to do with how the values are being rounded. Overtime rates and wages get calculated and stored to the 4th decimal place. This value is then displayed on the Payroll Report as a rounded value (to the 2nd decimal place). The grand total sums the unrounded “OT Pay” for each employee then rounds to the 2nd decimal place. Since the 3rd and 4th decimal place value is not displayed on the payroll report, summing each employee’s displayed “OT Pay” value (to calculate the total overtime pay) can often times differ from the report’s “OT Pay” grand total by a few pennies.
Q: Why are my employees’ breaks split out differently across different locations?
A: The reason why your employees’ breaks are displayed differently on the Payroll report (as well as the Punch Details w/o Rates or Wage export) is because different POS systems report data differently. Digital Dining, for example, will report the clock in / clock out times as exclusive to break minutes (thus there will be 2 distinct shifts and 1 break entry). Aloha, however, is the opposite – it will report the clock in / clock out times as inclusive to break minutes (thus there will be 1 distinct shift and 1 break entry). I edited an employee shift four days after the shift.
Q: Will this change be reflected on the Payroll Report?
A: Yes. During each nightly poll, labor data is polled for the past 21 days. This process will pick up any new or edited shifts and reflect them on the following business day.
Q: What does * next to the Employee’s Name denote?
A: This symbol indicates an edited shift as denoted by the POS. Since labor is polled for 21 days prior to the current date, any edits made inside those 21 days will be reflected.
Q: What does ** next to the Employee’s Name denote?
A: This symbol indicates that an employee has a waiver on file.
Q: Why doesn't the "Group By Locations" option appear to be working?
A: This report always groups by employee first and then groups by location under each employee.
If your payroll is showing to be “Not Validated”, etc.:
You have NOT validated and certified that the information, wages and payroll rules contained in this report are correct. One or more locations have NOT been validated and certified through the Payroll Validation module. You are solely responsible for information that you submit to your payroll provider. The terms and conditions of the current Ctuit Subscription Agreement apply to the data and use of this payroll report.
If Payroll Validation has not been turned on:
You have NOT validated and certified that the information, wages and payroll rules contained in this report are correct. You are solely responsible for information that you submit to your payroll provider. The terms and conditions of the current Ctuit Subscription Agreement apply to the data and use of this payroll report. Please contact your Site Administrator to activate the Payroll Validation Module.