Disclaimer: The factors used to calculate service revenue in the employee payroll summary report vary from the ones used in other reports. We recommend you do not compare this report with other reports.
The employee payroll summary report provides a quick snapshot of details such as total salary, attendance, leave balance, tips, and commissions earned by all employees of a given center.
Note: You can click the name of any employee in this report to view the corresponding employee's detailed report (Employee Payroll Details Report).
Important: You can click the Total Hours column of this report to view the break-up of hours the employee worked in a given pay period in the Attendance Details report. This way, you can verify the total hours that employee worked by matching the numbers in both reports.
Watch this video to learn how to generate the employee payroll summary report.
When to Use this Report?
You can run the employee payroll summary report to check the:
Leave balances and attendance details of all employees in your center.
Commissions and tips earned by employees.
Number of service and other invoices (such as selling products, memberships, packages) employees have closed.
Salary details and the number of times a guest requested for an employee and the bonus earned as a result.
You must first run the employee payroll summary report to ensure the accuracy of data in the employee payroll details report and in the employee commissions report.
You should have already configured pay periods from Employee > Settings > Pay Period.
This report considers only closed invoices.
If the organization level setting, Show commission amount in payroll post invoice-level deduction, is ON, the commission amounts that appear in this report reflect values after Zenoti has made invoice level deductions.
This report shows the payroll summary of employees either in their primary center or in the deputed center (center to which the employee is loaned) based on whether the setting Do not consider other center invoices for payroll is selected at the Organization level or not. Read: Configuring Organization Level Settings for Employee Commissions.
This setting is selected
An employee is a regular employee of center A, but is on deputation for a few days in the pay period to center B
An employee from center C is on deputation to center A
Administrator of center A runs the payroll summary report for center A
This report shows the payroll summary of employees from center A including payroll details for the employee who was on loan to another center, so long as the employee performed services and sold some sale items in center A.
Payroll details of the employee who is on deputation to center A do not appear in the payroll summary report of center A.
Note: The payroll details for the period for which the employee from center A worked in center B appear in the payroll summary report of center B. Similarly, payroll details of an employee from center C who is on loan to center A appear in the payroll summary of center C.
This setting is not selected
An employee from another center is on deputation (on loan) to center A
Administrator of center A runs the payroll summary report for center A
This report shows the payroll summary of employees from center A and includes details of any employees who are on deputation (or on loan) to center A.
To run the employee payroll summary report:
Ensure you are at the Center for which you want to run the report.
On the main menu, click Employee.
On the Employee Dashboard, click Payroll Reports > Payroll Reports.
Select Summary along with other appropriate filter criteria.
Click Calculate Commissions Now.
Note: If you have already run the payroll summary report for the given pay period earlier, you can click Refresh. In cases where there are changes to data in the given pay period and you have run the payroll summary report earlier for the given pay period, you will see the option Recalculate Commissions Now.
Important: To view all columns of the report, export the report – the UI shows fewer columns. Use the Excel
icons on the top right-hand corner to export the report.
Select the cycle based on your need:
Select a Report
Select Summary from the drop-down list.
Split commission by item type
Select this option if you want to view the commission details split by item type such as service commission, product commission, membership commission, package commission, gift card commission, tenure commission, and center commission.
Refer to the following table to view column and column descriptions.
Displays the unique identifier for the employee.
Employee First Name
Displays the first name of the employee.
Employee Last Name
Displays the last name of the employee.
Displays the job of the employee.
Invoice Wise Details
Click the Commission Details link to drill down to view a break-up of commission details based on each invoice.
Displays the salary earned by the employee.
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 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:
For Actual check-in/check-out time: 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.
Tip: Click the total hours (number) for an employee to view the break-up of hours the employee worked in a given pay period – Zenoti shows you these details in the Attendance Details report.
Total Hourly Pay
Zenoti calculates employee pay based on the hourly rate as follows:
Total Hourly Pay = Total regular hourly pay (for regular hours) + Overtime pay (for overtime hours).
Displays the number of hours the employee utilized to perform services. That is the total duration of all the closed appointments of the employee in the selected pay period.
Displays the hourly pay or the service commission earned by employees during the pay period.
Displays the total commission amount employees earn.
Note: If you select the Split commissions by item type checkbox in the filter criteria, you can view commission details for each of the following:
Note: To consider the instructor's commission for classes where guest status is canceled or set to no-show, enable the organization setting Enable package or membership credits to be redeemed for class cancellation or no-show fees. This setting calculates instructor pay only for classes booked using membership/package credits.
If a guest is unhappy with a service asks for the service to be redone, the commission is deducted as Redo Penalty for the first provider and commission is awarded to the second provider. Learn more: Configure Center Level Settings to Award Commissions for Redo Appointments
Total tips the employee earns in the selected pay period.
SSG (Support Staff Gratuity)*
Displays the total SSG amount the employee earns as SSG (gratuity or service charge) on closed invoices in the selected pay period.
Note: This column appears only if you have the center level setting Allow collection of SSG selected.
* Note also that Zenoti updates the name of this setting depending on the label you have configured for SSG at the Organization level such as Gratuity or Service Charge.
Leave Balance (Days)
Displays the leave balance for the employee in terms of days (as configured in the Employee profile).
Special Leave Balance
Displays the special leave balance for the employee (as configured in the Employee profile).
Displays the gratuity earned by the employee if any.
Displays the total number of closed invoices in which the employee has sold at least one item.
# Service Invoices
Displays the number of invoices the employee has closed for performing services.
Displays the number of times guests requested for a particular employee to perform a service and where the invoice was closed.
Request Therapist Bonus
Displays the total amount an employee earns as a bonus in the selected pay period because a guest requested a particular employee to perform a service and where the invoice was closed. Read: Employee Overtime and Therapist Request Bonus
Displays the Instructor’s pay. Applicable only if you have configured Classes.
Displays the Instructor’s hourly rate or charges. Applicable only if you have configured Classes.
Displays the timings for a class. Applicable only if you have configured Classes.
Displays the total strength or number of students in a class. Applicable only if you have configured Classes.
Deduction On Total Commission
Displays the amount that is deducted on the total commission the employee earned in the pay period.
Service and Invoice Level Deductions
Displays the amount that is deducted as service and invoice level deduction from the commission the employee earned.
Note: If the organization level setting, Show commission amount in payroll post invoice-level deduction, is ON then the commission amount that appears takes into account invoice-level deductions. For example, assume an employee earns $100 as a commission. Invoice level deduction is $5.
Cross-Check Your Data for Total Hours
You can cross-check your data for Total Hours of this report against the Working Hours column in the Attendance Details report.
If the Calculate Payroll Hours Based On setting 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 a given day. You can view the Attendance Details Report from Employee > Other Reports > Time > Attendance Details.