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. 

Things to know:

• The ability to access this report is governed by the "Accessing Reports" access control settings
  
• 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 from no-show or canceled appointments is not displayed in the report.
• Revenue displayed is based on the post/pre-discount settings or if a refund occured

• 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 

• If a value is set for "Pay the service commissions only if staff productivity is above $" in the staff profile, and the staff member does not meet the productivity threshold, the following will occur:
  • The Service Commission column in the web view will be greyed out.
  • The detailed export will be empty for the respective date.
• Commissions for services

  • By default, commission is calculated based on the date the appointment is performed. However, there is an option to calculate commission based on the date the ticket associated with the appointment is closed. This functionality is controlled by a hidden setting, which can only be enabled by the MyTime team. To activate this setting, please contact our Support Team at support@mytime.com. Please note that this change will apply only to appointments created or edited after the setting is activated. Examples:

    • Appointment scheduled and completed on December 11th, but the ticket closed on December 20th

      • If the hidden setting is disabled, the revenue and commission will appear in the report on December 11th.

      • If the hidden setting is enabled, the revenue and commission will appear in the report on December 20th.

    • Multi-day appointment scheduled for December 4th-7th, but the ticket closed on December 6th

      • If the hidden setting is disabled, the revenue and commission will appear in the report on the first day of the appointment, December 4th.

      • If the hidden setting is enabled, the revenue and commission will appear on the last day of the appointment, December 7th, if the ticket was closed on that day. If the ticket was closed on December 6th, the revenue and commission will be reflected on December 6th.

  • 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 is 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.
  • For partial refunds, the report will display the reduced revenue and adjusted commission.
  • 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.
  • Additionally, if a facility fee is configured for a service, the revenue displayed will reflect the amount after deducting the facility fee. For example, if a $2 facility fee is applied to a haircut service valued at $10, the revenue for that service will be $8 ($10 - $2).
  • 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 is 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.
• When a staff member exceeds overtime hours in a pay cycle, any additional hours are automatically classified as overtime, regardless of the work type selected. For example, if the pay cycle runs Sunday to Saturday and the staff member has already reached 40 hours by Friday, any hours clocked on Saturday will appear in the Overtime column in reports, rather than under the specific work type.
  
• 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 booking 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

Report Filters

Example of report filters:

Report Columns

Example of report columns

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

Related Articles:

• Daily Compensation Report
• Tips Report
• Why Are Commissions Missing for Some Items in Compensation Report?
• Set up Compensation for Staff Members
• Compensation for Services
• Compensation on Product Sales
• Compensation for Classes/Events
• Compensation on Package Sales
• Compensation on Membership Sales
• Compensation on Gift Card Sales
• Managing Hourly Work Types
• Compensation for Redo Appointments
• Compensation Snapshot
  
• Daily Revenue Report
• Time Tracking Report
• Calendar Utilization Report
• Staff Scheduling Report
• Vacation Days Report
• Sick Days Report