Employee Hourly Pay/Service Commission v2 Report
----------------------------------------------------------------------------------------------------------------------------
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.
----------------------------------------------------------------------------------------------------------------------------
The Employee Hourly Pay/Service Commission v2 report offers flexibility in the way you view reports, enables you to customize the columns in the report, and 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 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 setting 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 Do not consider other center invoices for payroll organizational setting is selected or not. Refer to the table for details.
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. |
Follow these steps to run the report:
Click the Employee tab.
The Employee Dashboard page opens.
Navigate to Payroll Reports > Payroll Reports.
Select Hourly Pay/Service Commission from the filter.
Click Try the New Version.
The Hourly Pay/Service Commissions report opens in a new tab.
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.
Click Refresh.
The Employee Hourly Pay/Service Commission report appears.
Column descriptions
Column Name | Short Description | Details and Examples |
---|---|---|
Date | Date of payroll entry. | The specific workday within the selected pay period. |
Employee Code | Unique ID given to an employee. | The unique identifier for the employee. |
Employee Name | The employee’s full name. | Full name of the employee pulled from their profile (First Name + Last Name). |
Total Hours | Daily work hours calculated from check-in/out times and break rules. | The total hours worked by an employee during a pay period depends on the Calculate Payroll Hours Based On setting. Navigation: Admin > Centers > [Center Name] > Settings >Employee > Calculate Payroll Hours Based On Option 1: Scheduled and Actual Hours Combination Zenoti compares both scheduled and actual times to calculate hours. Check-in time: Uses the later of scheduled or actual check-in. Check-out time: Uses the earlier of scheduled or actual check-out. Total Hours Formula: Total Hours = Clocked-in time – mandatory breaks – breaks between multiple check-ins Example Use Case Schedule: Emily is scheduled to work from 8 AM – 12 PM. Actual Work: She checks in at 9 AM and checks out at 1 PM. Calculation: Zenoti takes the later check-in (9 AM) and earlier check-out (12 PM). Total Hours = 9 AM – 12 PM = 3 hours (breaks deducted if applicable). Option 2: Actual Check-in/Check-out Time. Zenoti uses actual check-ins and check-outs, ignoring the schedule. Total Hours Formula: Total Hours = (First Check-in to Last Check-out) – breaks between check-ins. Example Use Case: Actual Check-ins: Jacob clocks in at 9 AM – 12 PM, then again from 2 PM – 5 PM. Calculation: Total time = 8 hours (9 AM – 5 PM) minus 2-hour gap = 6 hours. Advanced Example with Breaks Scenario: Sarah is scheduled from 8 AM – 5 PM (9 hours). She takes a 30-minute lunch break and has two actual check-ins: 8 AM – 12 PM 1 PM – 5 PM Calculation: Total shift = 9 hours – 1-hour gap between check-ins – 30 min break = 7.5 hours. |
Total Hourly Pay | Total pay for hours worked after break deductions. | 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) setting. The following are the options for the setting: · Scheduled and Actual Hours Combination: For this option, Zenoti checks both the scheduled check-in and check-out times and the actual check-in and check-out times. Zenoti then calculates the clocked-in time as follows: o For check-in time: Zenoti considers the later time between the scheduled and actual check-in time. o For check-out time: Zenoti considers the earlier time between the scheduled and actual check-out time. Example: An employee is scheduled to work from 8 AM and 12 PM, but actually works from 9 AM to 1 PM on a certain day. Zenoti calculates the clocked-in hours for that day as 9 AM to 12 PM. Zenoti then calculates 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. Zenoti calculates this for each day in the selected time period. Total hours = Clocked in hours – mandatory break times – break times between multiple check-ins. · Actual check-in/check-out time: For this option, Zenoti calculates clocked in hours 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. Zenoti calculates this for each day in the selected time period. Total Hours = 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 of 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) minus 2 hours (break between multiple check-ins 12 PM to 2 PM) = 6 hours. |
Service Commission | Commission earned from closed service invoices, add-ons, and bonuses. | 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 | Higher of hourly pay or total commission paid as final daily earnings. | The final amount the employee is paid for that day’s work. This is calculated as the higher of two values: the employee’s total hourly pay or their total eligible service commission for the day. The service commission included here also counts Add-On commissions and any Request Therapist Bonus earned. Example: If an employee earns $100 in hourly pay but qualifies for $125 in service commissions (including add-ons and request bonuses), the system pays the higher amount — so the Final Amount for that day will be $125. |
Hourly/Service commission | Indicates if employee earned via hourly or service commission for the day. | The hourly pay or the service commission earned by employees during the pay period. This column appears only if the Based on higher of total hourly pay (including overtime hours) and service commission option is selected at the Center level. Also, if this option is selected, Zenoti considers both, the hourly pay and the service commission for each day of the selected pay period. The employee earns the amount that is higher. 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 paid to the employee. Service commissions includes Add-On commissions and Request Therapist Bonus. If the Based on higher of total hourly pay (including overtime hours) and service commission option is not selected (at the Center level), then the columns Service Commissions and Add-On Commissions appear in this report. Whether hourly pay is compared against service commission on a daily, weekly, or pay period basis is defined in General > Overtime section of the employee profile. |