Welcome to the Help Center

Daily Compensation Report

The Daily Compensation report shows staff compensation earned based on the date range selected in the date filter. Staff members can freely filter by any date range they choose, rather than being constrained to the pay cycle. You can filter the data to include all tickets or just closed tickets, and with tips or without tips. Here are a few things to note about this report:
  • 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
  • Tips are based on appointment completion
  • 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.

    • The calculation for tiered commission is based on the pay cycle. The user must select the dates that correspond to the pay cycle period in order for commission for tiers to be displayed. If multiple pay cycles are selected, the report will calculate everything for the entire period rather than splitting it up by pay cycle. 
    • The clocked hour associated with the appointment is eligible for commissions - 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 shown on the date when the service was refunded. For instance, if a ticket with an appointment was closed on November 13th but refunded on November 23rd, the compensation report will display the negative revenue on the 23rd rather than the 13th. The commission for the original ticket will also be deducted on November 23rd.
    • 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.
      • The clocked hour associated with the purchase is eligible for commissions - 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 with 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 was refunded. For instance, if a ticket with a product was closed on November 13th but refunded on November 23rd, the report will display the negative product revenue on the 23rd rather than the 13th. The commission for the original ticket will also be deducted on November 23rd.

To access your Daily Compensation Report:

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

6925431-48f96cf25bb3ebb83a120ebd05b9de01.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.
Date Range

 View by a specific date or range.

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: Appointments revenue will always be reported by appointment completion date, not by date 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).

Report Columns

Column

Description

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 the selected date range. 

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

Redo Adjustment

This shows the adjustments for redo appointments. If the revenue is being removed from the original staff, it will be shown in red. The staff who performed the redo will show the positive adjustment in the redo column.

Commissions

The totals for different commission types for a selected staff member during the selected date range.

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

Worked Hours

When no hourly work type is defined and a staff member clocks in, the clocked hours will be recorded under this column. 

Worked Hours Pay

Pay calculated for worked hours

This is calculated by taking the number of worked hours multiplied by the hourly amount set in the staff profile.

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

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.

Total Hours

The total number of clocked 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 

 
Powered by Zendesk