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

To view the employee payroll report at the organizational level

  1. Ensure you are at the organizational level.

  2. Click the Employee tab.
    The Employee Dashboard page opens.

  3. Go to Payroll Reports > Payroll Reports.

  4. Select the required filter criteria (see the following section for details).

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

See Also

Did this answer your question?