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. |
Ensure that you are at the Center for which you want to run the report.
Navigate to Employee > Payroll Reports > Payroll Reports.
Select the time period for which you want to generate the report.
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.
Click Refresh to view the report.
Note
To export the report, click the Excel or .CSV icons.
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 of work for the employee in the pay period depend on the Calculate Payroll Hours /Employee Utilization Based on setting (At the center level, click the Configurations icon; search for and select Calculate Payroll Hours/Employee Utilization Based on) employee configurations setting) as follows: Scheduled and Actual Hours Combination or Actual check-in/check-out time |
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. Comparing Hourly Pay and Service commission is either per day/per week/per pay period is defined at employee > general tab > Overtime section.onus. |
Hourly/(Service + Product) commission | Indicates if payout was based on hourly or combined (service + product) commission. | 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 + product commission) option is selected (at the Center level). Also, if this option is selected, Zenoti considers both, the hourly pay and the service + product 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, $25 in product commissions for a day, the (service + Product) commission of $150 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 + product commission) option is not selected (at the Center level), then the columns Service Commissions and Add-On Commissions, Product commissions appear in this report. Comparing Hourly Pay and (service + Product) commission is either per day/per week/per pay period is defined at employee > general tab > Overtime section. |
Product commission | Commission earned from products sold, based on configured payout rules. | Product Commission is the payout awarded to an employee based on the revenue they generate through the products they sold. It is calculated according to the payroll configurations, which define how, when, and on what basis the commission is paid — such as a flat amount, a percentage of sales, or revenue slabs. |
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. |