Overview: What are we talking about?
The Appointment Wage to Sales Report provides a breakdown of your business's financial performance as it relates to appointment revenue taken in and staff wages 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.
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. 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.
This article includes:
- 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.
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|
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|
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|
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|
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 Setting up 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|
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|
Exporting & Printing the Report
If you'd like to export to a CSV file, check the tick box "Export to csv?" in the report parameters at the top of the page before selecting the blue "Generate Report!" button.
After the report parameters have been set and you generate the report, you can select "Print PDF" with the green button at the bottom of the report parameters.