----------------------------------------------------------------------------------------------------------------------------
Disclaimer: This article is only for the latest version of Zenoti reports. Do not compare the data in this version with the data in the previous version.
----------------------------------------------------------------------------------------------------------------------------

This article consists of the following sections:

The Employee Hourly Pay/Service Commission v2 report offers flexibility in the way you view reports – the layout is intuitive , you can customize the columns in the report, and much more.

This report helps you to:

  • Compare the hourly pay and service commissions for employees in the selected time period (day or pay period).

  • Track the final amount the employee receives on each day.

Important Notes

  • You can view this report only if the setting, Calculate employee pay based on higher of total hourly pay and service commission (Admin icon > 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 icon > 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

Examples

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. Click the Employee icon.

2. Navigate to Payroll Reports > Payroll Reports.

3. Select Hourly Pay/Service Commission from the filter.

4. Click Try the New Version.

The Hourly Pay/Service Commissions report opens in a new tab.

5. Depending on your requirement, select the desired filters.
Note: You can view the report only for those centers to which you have access.
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.

6. Click Refresh.
The Employee Hourly Pay/Service Commission report appears.

Column Descriptions

Column

Description

Date

The list of the dates in the selected pay period.

Employee Code

The unique identifier for the employee.

Employee Name

The name of the employee (first name, last name).

Total Hours

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

a) 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.

b) 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

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

Did this answer your question?