Businesses may prefer to use Zenoti’s payroll data for their entire organization to feed it back into ADP payroll (a third party payroll solution).
You can set the payroll start date, pay period duration, and scheduled delay as per your business needs. For example, if you set the payroll start date as 1 May, the pay period duration as 7 days, and the scheduled delay as 1 day. Then, the payroll will run on 8 May.
After the payroll is successfully generated, Zenoti provides downloadable files that the business can use to input into ADP payroll for further reporting and analytics.
Note:
This report is available only for limited businesses. The Zenoti Product team must enable a db-level setting for this report to be available from the organizational level.
The report works well for Corporate-owned business where the pay periods across centers are an exact match. This model will not work for franchisee-based businesses where the payroll settings may differ.
The payroll runs 2 hours before the center start time (considers the latest in case of a multicenter business with different start times. For example: A business has two centers. One center starts at 9 AM and the other starts at 10 AM. Then, the payroll runs at 8 AM).
This article covers the following topics:
Navigation
To view the employee payroll report at the organizational level
At the organization level, click the Employee icon.
Navigate to Payroll Reports > Payroll Reports.
Select the required filter criteria (see the following section for details).
Click Refresh.
The employee payroll report for the entire organization is generated. Each row shows one pay period.
See the column description table for further details.
Filter Criteria
Criteria | Description |
Statuses | When the report is generated, it may end up as a Queued, Success, or Failed. |
Date range (From and To) | Select the date range for which you wish to see report. Note: By default, you can see the payroll details for pay periods of the last two months. |
Column Descriptions
Column | Description |
Scheduled Date | The date on which payroll was run; usually the day after the pay period ends. The report is generated at midnight (non business hours). |
Payroll Period | The dates/payroll start and end dates for the given pay period. Note: Each row in the report represents one pay period. |
Last Run Date | Shows the date the report was last run for the corresponding pay period. |
Status | Shows the status of the report for the given pay period.
|
Payroll Data File | Download the payroll data file for payroll that is generated successfully (status is Success). |
Payroll Allocation | Download the payroll allocation file to track payroll allocations for employees who work in multiple locations. |
Error Log File | Download the error log file for payroll that ran into issues while generation (status is Failed). |
Rerun | Click the Rerun icon to regenerate the report if you: Important Notes:
|
Payroll Data File (Column Descriptions)
Column | Descriptions |
Center | The Center ID. |
Employee Id | The Employee ID. |
Name | The name of the employee (First name, Last name). |
Job Name | The job name of the employee. |
Job Code | The job code. |
Date | The end date of the payroll period. |
Hours | The hours the employee worked (rounded off). |
Hourly pay rate | The hourly pay rate for the employee. |
Service Revenue | The service revenue (amount) that the employee generated by sale of services during the pay period. |
Product Revenue | The product revenue (amount) that the employee generated by sale of products/retail during the pay period. |
Reg Hours | Depends on payout type – see the following table for how pay may be calculated differently for different employees. For example, overtime and commission-related settings vary for employees and will therefore decide the payout type for a payroll period. |
Reg Pay | Depends on payout type – see the following table for how pay may be calculated differently for different employees. For example, overtime and commission-related settings vary for employees and will therefore decide the payout type for a payroll period. |
Commission Pay | Depends on payout type – see the following table for how pay may be calculated differently for different employees. For example, overtime and commission-related settings vary for employees and will therefore decide the payout type for a payroll period. |
SL Commission Pay | Depends on payout type – see the following table for how pay may be calculated differently for different employees. For example, overtime and commission-related settings vary for employees and will therefore decide the payout type for a payroll period. |
O/T Hours | Depends on payout type – see the following table for how pay may be calculated differently for different employees. For example, overtime and commission-related settings vary for employees and will therefore decide the payout type for a payroll period. |
O/T Pay | Depends on payout type – see the following table for how pay may be calculated differently for different employees. For example, overtime and commission-related settings vary for employees and will therefore decide the payout type for a payroll period. |
Total Pay | Depends on payout type – see the following table for how pay may be calculated differently for different employees. For example, overtime and commission-related settings vary for employees and will therefore decide the payout type for a payroll period. |
Tips | The tips earned by the employee during the pay period and recorded via the POS. |
Declared Tip | The cash tips earned by the employee which are not captured anywhere in Zenoti. With the declare tips option, your business gives employees the means to record cash tips they receive directly from guests to stay compliant with local laws. |
Payout Types (Related calculations)
Note: In the following table, OT refers to Overtime.
If the Payout- Type is … | Reg Pay | Commission pay | SL Commission pay | OT pay | Note |
Hourly pay + Service commission (with Overtime) | (base rate* total hours rounded) | 0 | Commission | (base rate + commission rate) * (overtime multiplier -1)*OT hours | Alternate calculation for OT PAY ((base pay+ commission)/total hours rounded) * (overtime multiplier -1)*OT hours |
Hourly pay + Service commission (No Overtime) | (base rate* total hours rounded) | 0 | Commission | 0 |
|
Hourly pay + Service commission (OT not eligible) | Base rate*Reg hours (rounded) | 0 | Commission | 0 |
|
Hourly pay at base rate (No Overtime) | (base rate* total hours rounded) | 0 | 0 | 0 |
|
Hourly pay at base rate (with overtime) | (base rate* total hours rounded) | 0 | 0 | base rate*(overtime multiplier -1* OT hours |
|
Commission (No Overtime) | 0 | Commission | 0 | 0 |
|
Commission (With Overtime ) | 0 | Commission | 0 | 0 |
|
Hourly pay at commission rate (with overtime) | Commission | 0 | 0 | Commission rate*(overtime multiplier -1)*OT hours |
|