Employee Payroll v2 Report at the Organizational Level

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).

Businesses can schedule this report to run a day after a payroll period ends – this way, the payroll details are generated for the entire organization in one go. 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.

This article covers the following topics:

Navigation
Filter criteria
Column Descriptions
Payroll Data File (Field Descriptions)
Payout Types (Related calculations)
See Also

Navigation

To view the employee payroll report at the organizational level

Ensure you are at the organizational level.
Click the Employee tab.
The Employee Dashboard page opens.
Go 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. For the status Success, business owners can view the Download link for the Payroll Data file. For the status is Failed, business owners can view the Error Log file. For the status Queued, wait for a few minutes before checking the status again.
Payroll Data File	Download the payroll data file for payroll that is generated successfully (status is Success). See the following table for details on the Payroll Data File.
Payroll Allocation	Download the payroll allocation file to track payroll allocations for employees who work in multiple locations. Note: You can see this field only if your organization uses the FLSA model to calculate overtime (OT). Business owners interested in using this feature must reach out to Zenoti Support to enable this feature for their business.
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: a) ran into issues b) made changes to employee data directly from the employee level – for example, you updated check-in and checkout hours for an employee. Important Notes: If you made any changes at the center level for employee payroll related details, these changes do not automatically get reflected at the organization level. You must rerun the report at the organizational level separately. When you click Rerun, the report is scheduled to rerun at midnight of the same day (during non-business hours). Conditions apply The report will rerun at midnight provided: a) it is not a scheduled time to run the payroll for the latest payroll period. b) no other run is scheduled at the same time.

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. Service revenue = Total service revenue earned – (minus) cost of redo service
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

Employee Payroll v2 Report at the Organizational Level

Navigation

Filter Criteria

Column Descriptions

Payroll Data File (Column Descriptions)

Payout Types (Related calculations)

See Also