Master Employee Metrics report
The Master Employee Metrics Report is a comprehensive document that tracks key performance indicators (KPIs) related to employee management. This report helps owners understand which factors contribute to their success, so they can make the most of their time and money. The report includes a wide range of metrics, from basic employee information to detailed sales and service data.
On the Reports Dashboard, search for, and select Master Employee Metrics report.
Select the desired filters.
Click Refresh.
Column Name | Short Description | Details and Examples |
|---|---|---|
Base Center | Employee’s primary center assigned in the system. | The primary center where the employee's profile is based. |
Work Center | Center where the employee was actively working during the selected date range. | The specific center where the employee worked during the selected date range. |
Employee Code | System-generated code identifying the employee. | A unique identifier assigned to the employee. |
Employee Name | Name of the employee being reported. | The full name of the employee. |
Employee Start Date | Date when the employee began working. | The date when the employee started working at the center. |
Employee End Date | Date when the employee exited or became inactive. | The date when the employee stopped working at the center. |
Job | Role or designation assigned to the employee. | The job held by the employee. |
Salary | Salary configured for the employee. | Salary of the employee defined in the employee profile. |
Max Work Hours | Maximum number of hours the employee is allowed to work in a period. | The maximum number of work hours defined in the employee profile. |
Vacation Days | Number of vacation days allotted or taken by the employee. | The number of vacation days set in the employee profile. |
Special Leave Days | Number of special leave days taken by the employee. | The number of special leave days in the employee profile. |
Mandatory Break (mins) | Minimum required break time in minutes per shift. | The mandatory break time in minutes that the employee is entitled to during their shift. |
Hourly Rate (Vacation) | Hourly pay rate applied to the employee during vacation time. | The hourly rate paid to the employee during vacation. |
Hourly Rate (Holiday) | Hourly pay rate applied to the employee during holidays. | The hourly rate paid to the employee during public holidays. |
Redo Count | Number of times the employee had to redo a service. | The number of times the employee had to redo a service. |
Services with Provider Requests | Number of services where guests requested the employee. | The number of services that guests specifically requested to be performed by the employee. |
No Show Services Count | Number of scheduled services marked as no-shows. | The number of services booked with the employee where the guest did not show up. |
Cancelled Services Count | Number of appointments canceled by the guest or employee. | The number of services booked with the employee that were later canceled. |
Scheduled Hours | Total hours the employee was scheduled to work. | The total number of hours the employee was scheduled to work. |
Booked Hours | Total duration of all appointments performed by the employee, including recovery time. | The total duration of all appointments performed by the employee, including recovery time. |
Actual Hours | Total hours the employee actually worked. | The actual number of hours the employee worked based on check-in and check-out. |
Service Hours | Total hours the employee spent performing billable services. | The number of hours the employee spent performing services. |
Actual Hours (Primary WT) | Total hours the employee was checked in to their primary work task. | The actual number of hours the employee spent checked in to the primary work task. |
Actual Hours (Production Hours) | Total hours the employee spent on revenue-generating tasks. | The actual number of hours the employee spent checked in to a production work task. |
Non-Production Hours | Total hours the employee spent on non-revenue-generating tasks. | The actual number of hours the employee spent checked in to a non-productive task. |
Mandatory Break Hours (Actual) | Total time taken by the employee for mandatory breaks. | The actual number of hours the employee took as mandatory breaks. |
Vacation Hours | Total hours marked as vacation. | The number of hours the employee took as vacation. |
Holiday Hours | Total hours marked as holiday. | The number of hours the employee took as holiday. |
Total No. of Invoices | Total number of invoices associated with the employee. | Total number of invoices associated with services performed by the employee. If multiple employees contributed to a single invoice, it is counted once for each involved employee. |
Total New Guest Invoices | Number of invoices for first-time guests served by the employee. | Total number of invoices associated with services performed by the employee for new guests. If multiple employees contributed to a single invoice, it is counted once for each involved employee. |
Total Repeat Guest Invoices | Number of invoices for returning guests served by the employee. | Total number of invoices associated with services performed by the employee for repeat guests. If multiple employees contributed to a single invoice, it is counted once for each involved employee. |
Total Service Invoices | Number of invoices that include service transactions. | Total number of invoices generated for services performed by the employee. If multiple employees contributed to a single invoice, it is counted once for each involved employee. |
Invoices with Provider Requests | Number of invoices where the guest specifically requested the employee. | The total number of invoices generated for the services where the employee was specifically requested. |
Employee Sale Value | Total sales value attributed to the employee. | The total value of sales made by the employee, excluding refunds and discounts. |
Employee Service Sale Value | Revenue from services attributed to the employee. | The total value of service sales made by the employee, excluding refunds and discounts. If LP redemptions are configured as non-taxable, their value is excluded from this total and included under service discounts instead. |
Employee Product Sale Value | Revenue from product sales attributed to the employee. | The total value of product sales made by the employee, excluding refunds and discounts. If LP redemptions are configured as non-taxable, their value is excluded from this total and included under product discounts instead. |
Commissionable Service Discount | Discounts marked as free service revenue. | The discount marked as free service revenue. |
Service Tax | Tax collected on services performed by the employee. | The tax collected on the services performed by the employee. |
Product Tax | Tax collected on products sold by the employee. | The tax collected on the products sold by the employee. |
Net Service Sales | Total service revenue after applying discounts and tax adjustments. | The net revenue from the services provided by the employee excluding refunds and discounts. Loyalty point redemptions configured as non-taxable are excluded from this value. |
Net Product Sales | Total product revenue after applying discounts and tax adjustments. | The net revenue from the products sold by the employee excluding redemptions, discounts, and refunds. Loyalty point redemptions configured as non-taxable are excluded from this value. |
Net Service Sales (Exc. Redemption) | Net service revenue excluding liability redemptions. | The net revenue from the services performed by the employee, excluding redemptions, discounts, and refunds. Loyalty point redemptions configured as non-taxable are excluded from this value. |
Net Product Sales (Exc. Redemption) | Net product revenue excluding liability redemptions. | The net revenue from the products sold by the employee, excluding redemptions, discounts, and refunds. Loyalty point redemptions configured as non-taxable are excluded from this value. |
Gross Service Sales | Total service revenue before applying discounts or redemptions. | The total revenue from the services provided by the employee, including discounts, and refunds. |
Gross Product Sales | Total product revenue before applying discounts or redemptions. | The total revenue from the products sold by the employee, including discounts, refunds and excluding redemptions. |
Gross Service Sales (Exc. Redemption) | Total service revenue excluding liability redemptions. | The total revenue from the services provided by the employee including discounts, refunds and excluding redemptions. |
Gross Product Sales (Exc. Redemption) | Total product revenue excluding liability redemptions. | The total revenue from the products sold by the employee, before including discounts, refunds and excluding redemptions. |
Service Discount | Total discounts given on services. | The total discount given on the services provided by the employee. |
Product Discount | Total discounts given on products. | The total discount given on the products sold by the employee. |
Combo Tickets | Total number of invoices with both service and product. | The total number of combo tickets, which are invoices containing both a service and product as items, sold by the employee. |
Product Count | Total number of products sold. | The total number of products sold by the employee. |
Service Sale Collected | Amount collected from service sales. | The total amount collected from the services provided by the employee. |
Product Sale Collected | Amount collected from product sales. | The total amount collected from the products sold by the employee. |
Service Sale Collected (Exc. Redemption) | Amount collected from service sales, excluding redemptions. | The total amount collected from the services provided by the employee excluding redemptions. |
Product Sale Collected (Exc. Redemption) | Amount collected from product sales, excluding redemptions. | The total amount collected from the products sold by the employee excluding redemptions. |
Total Tips | Total tips received. | The total amount of tips received by the employee. |
Service Shop cost | Cost of service as per service-level setup. | The predefined expense for a specific service, configured from the General tab while creating the service. Shop cost is shown at the appointment level and reflects the value recorded during appointment creation. For day packages, the cost is distributed across services based on: (Service Price ÷ Total Service Price of Day Package) × Shop Cost defined at the package level. In payroll, shop costs are captured at the end of each pay period, whereas in this report, they are recorded at the time of appointment creation. Therefore, shop costs in this report may differ from payroll and should be used only for estimation. Payroll gives precedence to employee-level shop costs over service-level costs. Therefore, shop costs in this report may not align with those in payroll. These should be used solely for cost estimations. The shop cost of a service or item on an invoice updates dynamically whenever the quantity changes, until the invoice is closed. For example, in an invoice, if the shop cost of service S1 is $5 per unit and the quantity is updated to 2, the report will display an updated shop cost of $10. |
Service Shop Cost By Employee | Cost of service as per employee-level setup. | The predefined expense configured for a specific employee from the Services tab while creating the employee. For split services, the shop cost is proportionately divided based on the split in commissions across employees. |