How to Calculate Your Trainer's Wages

Follow

This article will take you through; 

  1. How to Calculate your Trainer payroll
  2. Next steps and additional support

How to calculate your Trainer's payroll

We've now made it easier for you to calculate your Trainer's payroll. To begin, follow these steps; 

  1. Make a copy of this Google Sheet 'Payroll Template' here, or download the Excel version here. (We recommended using the Google Sheet version if possible) 
  2. When making a copy, we recommend changing the name to match your Trainer's name and the time period you're calculating, for example: ' TrainerName_Feb2020'. (You will need to do a separate report for each Trainer so this will make it easier to keep track)trainer_name.gif
  3. You will then need to download the trainer performance reports from the Glofox Dashboard by going to the 'Reports' tab, 'Trainer Performance' report, and then selecting the trainer and timeframe and download it as a CSV file trainer_cv.gif
  4. Open the CSV file in spreadsheet software and copy and paste the Trainer Performance date into Sheet 2 of the payroll spreadsheet 'Trainer Performance Report' (Copy and paste the entire CSV file into this tab) 
  5. Once you have that done, sheet 1 'Wages' will populate with the relevant information. Next, you will need to update the wage rate fields within on Sheet 1 'Wages' (the white boxes only). This will then calculate your Trainer's wages for you. 

Please note;

If you're using the excel version you will notice some sample data is already populated in the sheet. You can replace this data with your own.

  Base rate per Class

 

  The amount you want to pay your Trainer per class

 

 Bonus applied for every booking over

If you want to give your Trainer a bonus per client once they hit a certain amount of clients. For example, if your Trainer needs to have 15 or more clients in a class before a bonus is given, you would set this number to 14. 

 

  Bonus rate per head

 

This is the amount of bonus per head that you want to        give your Trainer

 

 trainer_wage.gif

Please note;

  • The Trainer Performance Report will only download the classes with more than 1 booking. 
  • The Trainer Performance Report pulls in numbers based on bookings and not who actually turned up to class

Next steps and additional support

Once you understand this, you might want to take a look at the 'Trainer Performance Report' in more detail, to do that, read the article below; 

For additional support reach out to support@glofox.com and we will be happy to assist you.

Please note;

This sheet works best in Google Sheets - there have been some issues reported by those using excel. If the download below does not work, download via this link: Google Sheets

Click the link below to download your payroll template.

arrow.png

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.