Payroll Earnings Summary and Drilldown
The Payroll Earnings Summary and Drilldown views let payroll administrators review employee compensation for a pay period β including hours, pay, commission, overtime, tips, deductions, and paid time off β and then drill into per-employee earnings detail to understand exactly how each figure was calculated.
Audience: Payroll administrators and center managers who generate, review, and reconcile employee payroll.
On this page
Before you begin
- Pay periods must be configured for the center before summary data is available. Navigate to Configuration > Employee > Pay period to verify that at least one pay period exists.
- Payroll must have been generated for the pay period you want to review. If payroll has not been generated, the summary returns no data.
- The payroll lock setting controls how far back you can recalculate or edit payroll. Navigate to Configuration > Employee > Payroll and commissions > Payroll controls to check the lock window for your organization.
Permission: Payroll (under View Employee Reports) β Required to view payroll summary and drilldown data. Grant it on the View Employee Reports row in the Employee Manager section of the security role (Configuration > Security > Security roles > the role > Permissions). Admin path: Configuration > Security > Security roles > [your role] > Permissions > Employee Manager > View Employee Reports > Payroll
Permission: Grooming Points (under View Employee Reports) β Required to view grooming points columns in the earnings summary. Grant it on the View Employee Reports row in the Employee Manager section of the security role (Configuration > Security > Security roles > the role > Permissions). Admin path: Configuration > Security > Security roles > [your role] > Permissions > Employee Manager > View Employee Reports > Grooming Points
Important: The permissions listed above are the minimum required. Your organization's security roles may require additional permissions depending on the view scope (Organization, Zone, or Center) you need to access.
Steps
View the Payroll Earnings Summary
The Payroll Earnings Summary shows the most recent payroll batch for the selected pay period. Each row represents one employee and includes columns for hours, pay, commission, overtime, tips, deductions, and paid time off (PTO).
Navigate to Employee > Payroll.
Select the center you want to review from the center selector.
Set the Start Date and End Date to match the pay period you want to review.
Optionally, select a specific employee from the employee filter to narrow results to a single person.
Set the Page and Page Size values if you want to page through a large employee list. Results are returned with server-side pagination.
Review the summary grid. The columns include:
Column Description Employee Employee name and code. Total Hours Total hours worked in the pay period, calculated based on the center's payroll hours setting (scheduled or actual check-in/check-out). Pay Base pay for the period (salary, hourly, or fixed, depending on the employee's pay plan). Commission Total commission earned across all commissionable items. Overtime Overtime pay calculated according to the center's overtime rules. Tips Tips collected and attributed to the employee during the period. Deductions Commission deductions applied at the invoice level or total commission level. PTO Paid time off hours and pay included in the period.
Note: The summary always reflects the most recent payroll batch for the pay period. If payroll has been recalculated, earlier batches are not shown here.
Drill down into per-employee earnings detail
The earnings drilldown shows a detailed breakdown of how each employee's pay was calculated, including straight-time pay, overtime hours and multipliers, and the result of the higher-of comparison between hourly pay and commission.
From the Payroll Earnings Summary, select an employee row to open the drilldown panel, or navigate directly to the drilldown view and enter the following:
- Center β the center for which you want to view earnings.
- Pay Period Start Date β the start of the pay period.
- Pay Period End Date β the end of the pay period.
- Employee (optional) β leave blank to return all employees, or select a specific employee.
Review the drilldown columns:
Column Description Employee Employee name and code. Total Hours Total hours worked in the pay period. Hourly Rate The employee's effective hourly rate for the period. OT Hours Overtime hours worked beyond the standard threshold. OT Multiplier The multiplier applied to overtime hours (for example, 1.5 for time-and-a-half). OT Premium The additional pay earned for overtime hours (OT Hours Γ (OT Multiplier β 1) Γ Hourly Rate). Straight-Time Pay Pay for all hours at the base hourly rate, before overtime premium is added. Rate Type Indicates whether the hourly rate is derived from the employee's work task assignment or from the employee's profile. See Understand the rate type indicator. Granularity The overtime rule level applied: pay period, weekly, or daily. See Understand the overtime granularity and winner columns. Considered Pay The pay amount used in the higher-of comparison for the applicable granularity level. Winner Indicates whether hourly pay or commission was higher for this employee in the period.
Understand the rate type indicator
The Rate Type column tells you which source Zenoti used to determine the employee's hourly rate:
| Rate Type value | When it appears |
|---|---|
ahr |
The employee's center uses work tasks with separate hourly rates per task, or the center's payroll comparison setting is configured to compare hourly pay against service and product commission combined. |
profile |
The employee's hourly rate comes directly from their employee profile, and the center is not using work-task-based hourly rates. |
Tip: To review or update an employee's hourly rate, navigate to Employee > Employees, open the employee profile, and select the Employee Roles tab. To configure work-task pay rates, navigate to Configuration > Employee > Payroll and commissions > Payroll controls.
Understand the overtime granularity and winner columns
Zenoti resolves overtime rules by evaluating the applicable overtime configuration for each employee. The drilldown presents the result of this evaluation in two columns:
Granularity β the level at which overtime was calculated:
| Granularity value | Meaning |
|---|---|
pay_period |
Overtime was evaluated across the entire pay period as a single block. |
weekly |
Overtime was evaluated on a week-by-week basis within the pay period. |
daily |
Overtime was evaluated on a day-by-day basis within the pay period. |
Winner β the result of the higher-of comparison between straight-time hourly pay and total commission for the granularity period:
| Winner value | Meaning |
|---|---|
hourly |
Straight-time hourly pay was greater than or equal to total commission for the period. The employee is paid based on hourly pay. |
commissions |
Total commission was greater than straight-time hourly pay for the period. The employee is paid based on commission. |
Note: The higher-of comparison is only performed when the center's payroll controls are configured to compare hourly pay against commission. If your center uses a standard payroll model without this comparison, the Winner column may not be applicable. Navigate to Configuration > Employee > Payroll and commissions > Payroll controls to review the Compare Employee Pay Calculation setting.
Worked example:
An employee named Alex works at a center that uses weekly overtime evaluation. During a two-week pay period:
- Week 1: Alex works 45 hours. Straight-time pay = 45 Γ $20 = $900. OT hours = 5, OT multiplier = 1.5, OT premium = 5 Γ $10 = $50. Total hourly pay = $950. Commission = $820. Winner: hourly (because $950 > $820).
- Week 2: Alex works 38 hours. Straight-time pay = 38 Γ $20 = $760. No overtime. Commission = $900. Winner: commissions (because $900 > $760).
The drilldown shows two rows for Alex β one per week β each with its own Granularity (weekly), Considered Pay, and Winner value.
Tips
- Filter by employee to speed up review. When reviewing a specific employee's pay, use the optional employee filter in the drilldown view. This avoids loading all employees and makes the comparison columns easier to read.
- Check the payroll lock before recalculating. If you need to recalculate commissions for a past period, verify that the period is not under payroll lock. Navigate to Configuration > Employee > Payroll and commissions > Payroll controls and check the Lock employee details setting. Once a period is locked, attendance details, tip reassignments, and commission recalculations are blocked for that period.
- Use the look-back period setting for new employees. For employees without prior payroll history in Zenoti, the system uses the look-back period setting to determine whether commission pay is likely to exceed non-commission pay. Navigate to Configuration > Employee > Payroll and commissions > Payroll controls and review the Look-back period setting (1, 2, or 3 pay periods).
- Cross-reference with the Employee Payroll Summary report. The drilldown view provides line-level detail, but the Employee Payroll Summary report gives a consolidated view across all employees and centers. Navigate to Employee > Payroll to access the summary report.
Troubleshooting
The summary shows no data for the selected pay period.
The most common cause is that payroll has not been generated for the period. Verify that a payroll batch exists by navigating to Employee > Payroll and checking whether a generated date appears for the period. If no batch exists, generate payroll first. Also confirm that the pay period dates you entered match a configured pay period exactly β partial date ranges that do not align with a defined pay period return no results.
The drilldown shows a rate type of ahr but the employee does not use work tasks.
The ahr rate type also appears when the center's payroll comparison setting is configured to compare hourly pay against service and product commission combined (not service commission alone). Navigate to Configuration > Employee > Payroll and commissions > Payroll controls and review the Compare Employee Pay Calculation setting. If the setting is configured for the service-plus-product comparison mode, ahr is expected even without work tasks.
The Winner column shows commissions but the employee's payroll shows a lower amount than expected.
The Winner column reflects the higher-of comparison for the granularity period shown. If the granularity is weekly, the comparison is made week by week β an employee may win on commission in one week and on hourly pay in another. Review each row individually. Also confirm that all commissions have been calculated for the period; if commissions were recalculated after payroll was generated, regenerate payroll to reflect the updated figures.
The OT Multiplier column shows 1.0 even though the employee worked overtime hours.
A multiplier of 1.0 means the overtime premium is zero β the employee is being paid straight time for those hours. This can occur if the center's overtime rules have not been configured, or if the employee's profile has an overtime exemption. Navigate to Configuration > Employee > Payroll and commissions > Payroll controls to review the overtime configuration, and check the employee's profile under Employee > Employees for any overtime exemption settings.