Skip to main content

Employee Hourly Pay/Service Commission report

Overview

The Hourly Pay/Service Commission report helps you compare the hourly pay and service commissions or service plus product commissions for the employees in the selected time period (day or pay period) and shows you the final amount the employee receives on each day.

Important notes

  • You can view this report only if the Calculate employee pay based on higher of total hourly pay and service commission or if the Calculate employee pay based on higher of total hourly pay (including overtime hours) and (service commission + product commission) setting is enabled is selected at the Center level. Refer to the Configure Payroll Controls to learn more.

  • This report:

    • Considers only closed invoices

    • Shows the payroll summary of an employee either in the reports of the primary center or in the reports of the deputed center (where an employee is on loan) based on whether the organizational Do not consider other center invoices for payroll setting is selected or not. Refer to the table for details.

If...

Then...

Useful for..

Example

The checkbox is selected

Employee's payroll appears in each of the centers where the employee worked during the selected time period.

The franchisee model of running a business, where each center pays employees for work done at their center.

Assume that an employee's primary center is Center A. This employee is deputed or is on loan to another center (Center B) for a few days in a selected time period. In this case, Center A pays for employee's work done in Center A and Center B pays for the employee's work done in Center B. This means, that the employee's earnings or payroll appear in the payroll summary reports of both centers.

The checkbox is not selected

The employee's payroll appears only in the base center.

The enterprise or corporate model of running a business, where the central corporate office pays employees for their work, irrespective of the center in which they worked.

Assume that an employee's primary center is Center A. This employee is deputed or is on loan to another center (Center B) for a few days in a selected time period. In this case, the base center (Center A) pays the employee for work done in both centers.

  1. Ensure that you are at the Center for which you want to run the report.

  2. Navigate to Employee > Payroll Reports > Payroll Reports.

  3. Select the time period for which you want to generate the report.

  4. From the list of reports, select Hourly Pay/Service Commission or Hourly Pay or (Service + Product Commission). Note: By default, this report shows details of all employees in the center. If you want to generate the report for any one employee, select the name of the employee as part of filter criteria.

  5. Click Refresh to view the report.

    Note

    To export the report, click the Excel or .CSV icons.

Column descriptions

Column

Description

Code

The unique identifier for the employee.

Name

Name of the employee.

Date

Lists all the dates in the selected pay period.

Total Hours

The Total Hours of work for the employee in the pay period depend on the Calculate Payroll Hours /Employee Utilization Based on (Admin > Centers > [Center Name] > Settings > Employee > Calculate Payroll Hours/Employee Utilization Based on) employee setting as follows:

Scheduled and Actual Hours Combination: Zenoti calculates the clocked in time as follows: Later time of the actual check-in and scheduled check-in times (that is, Expected Check-in time) and the earlier time of actual check-out and scheduled check-out times (that is, Expected check-out time).

Example: If the employee is scheduled (or Expected Check-In and Expected Check Out time) to work from 8 AM to 12 PM, but works from 9 AM to 1 PM on a certain day, the clocked in hours for the day are taken as 9 AM to 12 PM.

Zenoti then calculates the Total Hours as the clocked in hours minus the following two break times: mandatory break time and the break time between multiple check-ins per day, if any. Total hours = Clocked in hours - mandatory break times - break times between multiple check-ins.

Actual check-in/check-out time: Zenoti calculates the clocked in hours solely based on the actual check-in and check-out times irrespective of the employee schedule. The Total Time is calculated as the duration between first check-in and last check-out time minus the break time between multiple check-ins, if any, for each day in the selected time period.

Total Time = Duration between first check-in and last check-out for the day - Break between multiple check-ins.

Example: If an employee has multiple check-ins per day as follows: 9 AM to 12 PM and 2 PM to 5 PM. Then the total hours per day for the employee as per actual check-in and check-out time is 8 hours (Duration between first check-in, 9 AM, and last check-out, 5 PM) - 2 hours (break between multiple check-ins 12 PM to 2 PM) = 6 hours.

Total Hourly Pay

Zenoti calculates employee pay based on an hourly rate as follows:

Total regular hourly pay (for regular hours) + Overtime pay (for overtime hours).

Regular hours, hourly rate, overtime multiplier are all set up in the employee profile page (Employee > Employees > [Employee Profile] > General)

Note that overtime calculation can be set up based on overtime hours per day or overtime hours per pay period. Overtime pay applies only when Calculate Payroll Hours Based on is set to Actual Check-in/Check-Out time.

Service Commission

The commission that the employee is eligible for based on all the service invoices of the employee that were closed on the day. Service commissions include Add-On commissions and Request Therapist Bonus.

Product Commission

The total commission earned by the employee on product sales in the selected pay period. This column is displayed if the Calculate employee pay based on higher of total hourly pay (including overtime hours) and (service commission + product commission) setting is enabled.

Final Amount

The final payable amount for the employee on the day. It is the maximum of their hourly pay or the service commission for the day. For example, if an employee is eligible for $100 in hourly pay and $125 in service commissions for a day, the service commission of $125 is considered as the employee earning for the day.

Note

Service commissions in this column include Add-On commissions and Request Therapist Bonus.

Hourly/Service

Shows whether hourly earnings or service commissions was paid to the employee on the day. If the Hourly earnings were higher, the column shows Hourly as the text, and if the service commissions were higher, Service is displayed in the column.

Hourly Pay or (Service + Product Commission)

Displays the higher amount between hourly pay and service plus product commission. Visible only if the center-level setting Calculate employee pay based on higher of total hourly pay (including overtime hours) and (service commission + product commission) is enabled.

Cross check your data

Report

Relevance

Attendance Details Report

If the Calculate Payroll Hours Based On configuration for your center is set to Actual Check-in/Check-out, the Total Hours column in this report should be equal to the Working Hours column in the Attendance Details report for the day.

In this section: