Welcome to the Help Center

Report: Compensation (Payroll)

This report shows staff compensation earned. The data is based upon your staff compensation settings. If you haven't set up your staff compensation yet, click here to learn how. Click here to for details on Setting up Payment Period.

To access your Compensation Report:

  1. Click Dashboard
  2. Click Reports
  3. Click Compensation under the Staff heading

comp_report.png

Helpful Hints

Service Revenue - appears on the date the appointment was completed.

Product Revenue - appears on the date the ticket was closed. Product revenue from open tickets is not reported.

Hourly Pay -  is calculated from clocked-in hours. In order to include hourly pay on this report, you must use the clock-in/out feature. Learn how to enable this feature.

Track Compensation - Only staff members who have 'track compensation' marked in their staff profile will be reported on.

Please Note: Commission is only calculated if there is Service Time on the services that have been set up. 

 

Report Filters:

Location View by specific location or all locations. Only staff at selected locations will be available options for staff filter.
Staff View specific staff members or all staff.
Pay Cycle

Select either current cycle, previous cycle, or a custom cycle range. Pay cycles are determined by the parameters set in settings (staff section).

Note: Custom cycle does not allow you to choose custom days, but rather historical pay cycles. For custom date ranges (outside normal pay cycle), try the Daily Compensation report. 

Closed Tickets Only

When this box is checked, only appointments and product sales with a closed ticket will be reported. If unchecked, all completed appointments (with or without ticket) and product sales will be reported.

Note: Appointments revenue will always be reported by appointment completion date, not by date ticket was closed.

Post-discount When this box is checked, compensation is calculated on the post-discount prices of product and service tickets, not by the default pricing.
Include Tips

When this box is checked, tips are included in the compensation data for each staff member.

Note: If tips were withdrawn from the register for given day, tip amounts will not appear on the report (even if filter is applied).

 

Example of report filters:

mceclip0.png

 

Report Columns:

Staff Member

The staff member whose compensation you are tracking.

Appointment #

The number associated with the appointment. Click this number to view the appointment.

Ticket #

If there is a ticket associated with this appointment, the ticket number will appear in this column. Click the number to view the ticket.

Client

The client for the appointment/ticket. Click the client name to open the client profile.

Revenue

The totals for different revenue types for selected staff members during selected pay cycle. 

Note: Service revenue reported on day of completed service. Other types (product, package, gift cards) are reported on day ticket is closed.

Commissions

The totals for different commission types for selected staff member during selected pay cycle.

Note: If commission is missing, check staff profile to see that commission has been entered.

Base Salary

This column shows the pay for salaried employees. Only applicable if salary is set in staff profile.

Hours (types and amounts)

The total hours and different hourly types according to clocked hours by staff. For example, if you have an hourly type named “Training” then you will have a Training Hours column. It will have a matching column for Training Hours Pay which shows the total pay for that hourly payment type.

Note: You can learn about creating hourly types here.

Hours Pay (for hourly types)

Pay calculated for each of the hourly types created. Pay has to be set for hourly type in each staff profile. Calculated by taking number of hours multiplied by hourly amount set.

Note: You can learn more about setting hourly pay here.

Overtime Hours

Any hours over the overtime parameters set in each staff profile.

Overtime Hours Pay

Overtime pay calculated by the parameters set in each staff profile multiplied by overtime hours.

Tips

The total tips the staff member earned in the selected time period. This column only exists when the "Include tips" box is checked.

Note: If tips were withdrawn from the register for given day, tip amounts will not appear on the report (even if filter is applied).

Back Bar

Fees that staff incurs for using products during service. These fees are deducted from staff compensation to cover the cost of supplies to perform specific services at your business.

Note: Only reported if back bar fees have been set for given staff. Learn more here.

Total Commissions

Total compensation for selected staff members. Calculated by adding commissions, hourly pay, and tips and deducting back bar fees.

 

Example of report columns:

Capture.PNG

 

Tiered Commission

Tiered Commission is reported slightly differently from Straight Commission and requires attention when generating reports. A summary of the differences follows.

 

Straight Commission Tiered Commission

Commission is listed for each individual appointment and ticket.

Total commission for the date range is also listed.

Commission is not listed for each individual ticket, because commission changes depending on total revenue earned. Instead, the Total Commission for the pay period is listed.

Commission is calculated from the date range set at the top of the report. You may calculate commission for any range of time.

Commission is calculated for the entire week or month of the commission period (as set on your Settings page).

Example

If you set the date range for one day, you will see the total compensation for that one day.

If you set the date range for one day, you will see total compensation for the entire commission period (This will be either one week or one month, as defined in your Compensation Settings).

Compensation for a single day cannot be calculated, because it changes depending on total revenue earned during the commission period.

Example

If you set the date range for 2 months, you will see the total compensation for those 2 months.

If you set the date range for 2 months, and your commission tiers are per week, it will calculate the commission for each week and sum-up to get the total commission for 2 months.

To set up Tiered Commissions for your staff you will need to enable certain settings to make this possible. Business Setup > Staff & Availability > Select Staff Member > Compensation Reporting > Select Commission options for the Staff Member.

Staff___Availability__18_.png

If you are using Tiered Commissions, we recommend generating the report with a date range that includes the entire commission period.

 

Powered by Zendesk