Appointment Wage to Sales Report (Reference)

Article Details

Introduction

Businesses that offer appointment-based services can have a hard time measuring their performance as related to the overhead involved in paying staff to perform their services. Industry experts like Joe encourage businesses to track money coming in from specific services and money being paid out for those services.

As part of Gingr's partnership with Joe Zuccarello, owner of Paragon Dog Grooming and an expert in business management for pet care businesses, we help connect businesses with this expert to best utilize this report and others like it. Joe can assist in setting performance goals as well as provide guidance on reaching those goals. To find out more and to get connected with Joe please click the "Talk to an Expert" button at the top of the report or visit our webpage about this partnership

In partnership with these industry experts, Gingr provides a report that allows you to generate a wage-to-sales ratio that can be used to help improve your business performance. Our goal is for you to be able to spend more time discussing strategy and less time tracking down numbers. 

 

Getting Started

  • Viewing this report requires the permission "Can View Financial Reports". Please see our article on User Groups for more information. 

  • This report is designed for past reporting. The dates selected in the report should be in the past and it solely displays checked-out services. It cannot be used to forecast performance. You can select one or multiple additional services at once. This report is run for a selected date range, one location at a time. 

 

Report Parameters

To access the Appointment Wage to Sale Report, navigate to Book Icon » Reports » Appointment Wage to Sales Report. From this page, you can adjust the following reporting parameters to tailor the report to your needs:

Location Location you are running the report for. This report is run one location at a time
From Date Starting date for the report. This must be a past or current date
To Date End date for the report. This must be a past or current date
Appointment Services Optionally, choose all relevant appointment/additional service types and/or service add-ons that you would like to see reports for. If nothing is selected the report will run for all of your services

Screen_Shot_2022-06-06_at_12.06.30_PM.png

Report Output

Additional Service Revenue

This section contains a list of the selected additional service types. Each additional service type has information about the number of services performed, total revenue, and average revenue. 

Services Each of the selected additional services will display on their own line
Quantity Number of additional services completed within the selected parameters
Revenue Total revenue generated by each additional service
Average Revenue Average revenue for the additional service. Value = total revenue divided by total quantity performed

Screen_Shot_2022-06-06_at_12.07.42_PM.png

 

Service Add-ons Revenue

This section contains a list of the selected service add-on types. Each service add-on type has information about the number of services performed, total revenue, and average revenue. 

Add-ons Each of the selected service add-ons will display on their own line
Quantity Number of service add-ons completed within the selected parameters
Revenue Total revenue generated by each service add-on
Average Revenue Average revenue for the service add-on. Value = total revenue divided by total quantity performed

Screen_Shot_2022-06-06_at_12.08.32_PM.png

 

Staffing

This section contains information about each specialist's performance over the selected timeframe. This includes time clock data, the quantity of and revenue for appointments, average time per appointment, and average revenue. Additionally, you can enter a compensation value to then display the ratio of wage to sales. 

Name Name of each specialist. Only Specialists who completed Appointment Types included in the report will display in this section
Hours Worked

If you utilize Gingr's integrated time clock, this section displays the total amount of time the specialist was clocked in for over the selected date range. If you do not use Gingr's time clock this value will be 0.

For more information, please see Employee Timeclock

Number of Appointments The number of times the specialist performed the appointment types selected in the report parameters
Revenue from Appointments Total revenue generated by the selected services assigned to this specialist
Average Time per Appointment Hours worked divided by the total number of appointments
Average Revenue per Appointment Total revenue from appointments divided by the number of appointments assigned to this specialist
Compensation

Optionally enter the wage per hour provided to the specialist. 

If the specialist is paid hourly, multiply the Hours Worked by the specialist’s hourly wage to determine what number to input in this field (Hours Worked X Hourly Wage = Compensation)

If the specialist is paid commission, we recommend using the total commission numbers provided in the Commissions Report. For more information see our article on the Commissions Report

If an employee who is paid hourly shares responsibilities for the specialist’s appointments, we recommend inputting the total compensation of the Specialist plus the estimated or actual compensation for the hourly employee

Wage to Sales Ratio (Compensation / Revenue from Appointments) x 100 = Wage to Sales Ratio

Screen_Shot_2022-06-06_at_12.09.13_PM.png

 

Related Resources

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.