Welcome to the Help Center

Compensation (by Pay Cycle) Report

This report shows staff compensation earned based on the pay cycle set up in settings. You can filter the data to include all tickets or just closed tickets, with or without tips. If you haven't set up your staff compensation yet, click here to learn how. Click here for details on Setting up Pay Cycle. Here are a few important things to note:

  • The "Track compensation" checkbox on the staff profile has to be checked in order for the staff member to appear on this report
  • In-House Sale transactions are not displayed on the Compensation report
  • Hourly pay is based on clocked-in and clocked-out hours
  • The Tip columns will only be visible if the "Include tips" box is checked

  • Revenue displayed is based on the post/pre discount settings
  • This report presents data on scheduled appointments, excluding those marked as canceled and no-shows. However, the option to only display data for appointments in the completed status is governed by a hidden setting accessible only to the MyTime team. To activate this setting, please contact our Support Team at support@mytime.com.

  • Commissions for services
    • The commission is calculated on the date when the appointment was performed
    • The commission is assigned to the staff member who performed the service
    • For multi-staff services, such as a couples massage, where multiple staff members are assigned to the service, the service revenue will be divided equally among the staff members. Consequently, the service commission will be calculated based on the revenue assigned to each individual staff member.

      • Example:
        Service Cost: $150
        Number of Staff: 2 (Employee A and Employee B)

      • Commission Rates:
        Employee A: 40%
        Employee B: 30%

      • Calculations:
        Revenue per Staff Member:
        Each staff member receives half of the service revenue: $150 / 2 = $75

      • Commission for Each Employee:
        Employee A: $75 * 0.40 = $30
        Employee B: $75 * 0.30 = $22.50

      • Summary:
        Employee A receives $30 for the service.
        Employee B receives $22.50 for the service.

    • If a staff member was clocked in for a work type that is not eligible for commissions, then no commission will be paid on services performed while clocked in with that work type.
    • Refunds are recorded on the date the service is refunded. For example, if a ticket with an appointment was closed in the previous pay cycle but refunded in the current pay cycle, the report will show the negative revenue in the current cycle instead of the last cycle. The commission for the original ticket will also be deducted in the current cycle.
    • Back bar fees are not deducted when services are refunded. A positive amount will be added on the day of the refund to compensate for the fees already deducted on the date when the appointment was performed.
    • Redo Appointments:
      • If the "Should Original Staff Member Receive Service Commissions On Redos?" setting is disabled, when a redo is done, the commission for the redone service will be deducted from the original staff member's commission. So if John has an appointment with 3 services, of which 1 was redone by Mary, John will get commission only for the 2 services, and Mary will get commission for the redo service.
      • If the "Should Original Staff Member Receive Service Commissions On Redos?" setting is enabled when a redo is done, the revenue and commission for the original service will not be affected. For instance, if John has an appointment with 3 services from which 1 service was redone by Mary, John will get commission for all 3 services for the original appointment, and Mary will get commission for the redone service.
      • Although no revenue will be shown for the redone appointment in reports, the initial service revenue will be shown in the redo adjustment column and will be used to calculate the staff member's commission.
      • The system identifies the service that was redone based on its name. If a ticket includes multiple services with the same name, the system cannot distinguish which specific service was redone, as all services with the same name are considered eligible. Consequently, in the Compensation report, all services sharing the same name will be recorded as redone.
  • Commissions for products, miscellaneous items, packages, gift cards, and memberships
    • The commission is calculated on the date when the POS ticket was closed.
    • If a staff member was clocked in for a work type that is not eligible for commissions, then no commission will be paid on products sold while clocked in for that work type.
    • The commission is assigned to staff members who are selected as commission employees. If no employee is selected on the ticket, then the commission will not be paid to anyone.
    • Refunds are shown on the date when the product, miscellaneous item, package, gift card, or membership purchase was refunded. For example, if a ticket with a product, miscellaneous item, package, gift card, or membership purchase was closed in the previous pay cycle but refunded in the current pay cycle, the report will show the negative revenue in the current cycle instead of the last cycle. The commission for the original ticket will also be deducted in the current cycle.
  • 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

    The commission is listed for each individual appointment and ticket.

    The total commission for the date range is also listed.

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

     

    For tiered commissions by productivity:

    For staff members working at multiple locations, the compensation report will display data based on the selected location.

    • If the report is filtered by the location where the threshold was achieved, it will display both the commission for reaching the productivity level and the base pay for the clocked hours.
    • If the report is filtered by a location where the threshold was not achieved, it will only calculate the base pay for the clocked hours.
    • If the report is filtered by both locations, and collectively the threshold is not met, it will calculate only the base pay for the total clocked hours.

    For straight commissions, we maintain historical data. Once an appointment is completed, the final commission is calculated and stored permanently. The only circumstance under which it might change is if the commission setting is altered, and the merchant opts to update past appointments. The process for POS tickets is quite similar: after the ticket is closed, commissions for products are computed and stored as historical data.

    For tiered commission by revenue, the commission value changes dynamically because staff members can transition from one tier to another by simply purchasing one more product or book another appointment thereby surpassing the revenue threshold. Since the revenue is dynamic, commissions based on tiers are always calculated in real-time without the need for historical data to be stored.
     

To access your Compensation Report: 

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

6922907-d83bf6428558d8f1f356f247ebe3d3bb.png

Report Filters

Filter Description
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 the current cycle, the previous cycle, or a custom cycle range. Pay cycles are determined by the parameters set in settings (staff section).

Note: The custom cycle does not allow you to choose custom days, but rather historical pay cycles. For custom date ranges (outside the 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 a ticket) and product sales will be reported.

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

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 a given day, tip amounts will not appear on the report (even if the filter is applied).

 

Example of report filters:

6923253-b8dd8cd5e168bd35ef7a8ccd777bb0fd.png

Report Columns

Column

Description

Staff Member

The staff member whose compensation you are tracking.

Appointment #

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

Ticket #

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

Client

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

Revenue

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

Note: Service revenue is reported on the day of service completion. Other types (products, memberships, packages, and gift cards) are reported on the day the ticket is closed.

Redo Adjustment

This shows the adjustments for redo appointments. If the "Should Original Staff Member Receive Service Commissions On Redos?" setting is disabled and a redo was done, the revenue for the original staff will be shown in red in the adjustment column on the date of the redo.  

Commissions

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

Base Salary

This column shows the pay for salaried employees. Only applicable if the salary is set in the 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 the number of hours multiplied by the 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.

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 the given staff. Learn more here.

Tips Taken

These are tips that have already been taken out of the register and paid to the staff member.

Tips Not Taken

These are tips that have not been taken out of the register and are still owed to the staff member.

Total Tips

The sum of tips taken and not taken

Taxable Compensation

Total compensation plus tips 

Total Compensation

Commissions + hourly pay + tips not taken - post-commission back bar fees 

 

Example of report columns:

6924361-60f8ff22d5717f38c108da5c96192cbd.png

 

6924369-5adcde58e923b49a636011b53660650f.png

 

6924375-e075e86f90bc9a4e4e49c8ef2cc3b3df.png

 

For custom date ranges (outside the normal pay cycle), try the Daily Compensation report

Powered by Zendesk