Employee Hourly Pay/Service Commission Report

Overview

The Hourly Pay/Service Commission report helps you compare the hourly pay and service 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. 

This article covers the following sections:

Important Notes

  • You can view this report only if the Calculate employee pay based on higher of total hourly pay and service commission (Admin > Organizations > Centers > [Edit Center Page] > Settings > Employee) is selected at the Center level.
  • 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 setting Do not consider other center invoices for payroll (Admin > Organization > Organizations > Settings > Employee) is selected or not. Refer to the table for details. Read: Flexibility to Generate Payroll Independently for each Center
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.

  

Navigation

Follow these steps to run the report:

  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.
    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
    The Employee Hourly Pay/Service Commission report appears. 
    Note: To export the report, click the Excel Export_Excel.pngor .CSV Export_CSV.pngicons.  

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 depends on the Calculate Payroll Hours Based on (Admin > Centers > [Center Name] > Settings > Employee > Calculate Payroll Hours Based on) employee setting as follows:

For Scheduled and Actual Hours Combination: Zenoti calculates the clocked in time as follows:
Maximum of the actual check-in and scheduled check-in times and 
Minimum of actual check-out and scheduled check-out times.

Example: If the employee is scheduled 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.

For 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.
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.

   
 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.

   
    

Have more questions? Submit a request

Comments