Prorated Salary information on intelliHR is a new field as of March 2023 that forms part of the remuneration schedule. This auto-populated field will multiply the FTE by the Annual Package (Base Annual Salary + additions) entered for the employee providing the prorated salary as a value that is reflective of their true salary. This article will explain the changes that have been made, how these may affect you, and how you can begin effectively using the prorated salary field.
This article covers:
- What are Prorated Salaries (on intelliHR)
- How will Prorated Salaries benefit me?
- How will Prorated Salaries affect my Remuneration Data?
- What do I need to do to ensure my remuneration data is accurate?
What are Prorated Salaries (on intelliHR)
Prorated Salary on intelliHR will display within the remuneration section as seen below and will be calculated using the formula:
Annual Package (Base Annual Salary+ Additions) x FTE = Prorated Salary
How will Prorated Salaries benefit me?
By displaying prorated salaries on intelliHR you will be able to gain an accurate reflection of the remuneration spend. The base annual salary entered for employees can thus reflect the salary for a specific role with an FTE of 1 (click here for more information regarding FTE), while at the same time, the prorated salary will display the actual remuneration of the employee.
How will Prorated Salaries affect my Remuneration Data?
There are two scenarios that explain how the addition of prorated salary information will affect the remuneration data stored on intelliHR.
Scenario 1:
In the base annual salary field you have always recorded what the salary would be if the person had an FTE of 1; for example, the Customer Success Manager has an FTE salary of $80,000 and this is what has been entered in the base annual salary field.
In this case, simply navigate to Settings >> System Settings >> Remuneration Display>> Check the box marked 'Show Prorated Salary'.
In the remuneration section for each employee, you will see the base annual salary figure and a slightly different figure in the prorated salary field, if the FTE is less than 1; for example, if the Customer Success Manager has an FTE of 0.8 their prorated salary will display as $64,000.
Scenario 2:
In the base annual salary field you have always recorded the employee's actual salary (i.e. you had manually input the prorated salary in this field); for example, following the example above for our customer success manager with an FTE of 0.8 you have entered the base annual salary of $64,000.
In this case, if you wish to display the field Prorated Salary within remuneration you will want to follow the steps in the following section to ensure remuneration data is accurately recorded for those employees with an FTE less than 1.
What do I need to do to ensure my remuneration data is accurate?
To ensure your remuneration data is accurate before turning the Prorated Salary field on and making this visible to those with access to remuneration data you will want to do three things.
- Identify those employees with an FTE less than 1, and confirm these FTE's are correct.
- Amend the base annual salary of the employees identified above to display the base annual salary that is accurate for an employee in that role with an FTE of 1.
- In Settings >> System Settings >> Remuneration Data check the 'Show Prorated Salary' option >> Save.
Step 1
Identify those employees with an FTE less than 1, and confirm these FTE's are correct.
1. Go to Settings >> All Settings >> Data Import/Export >> Export >> Job Data >> Lookup by Display Name >> Include the FTE and Position Title column
2. Review the FTE of these employees and confirm that these are correct
3. For any incorrect FTEs navigate to the employee's profile and use the Update Job function to amend the FTE.
Step 2
Amend the base annual salary of the employees identified above.
1. Go to Settings >> All Settings >> Data Import/Export >> Export >> Job Remuneration Data
2. Remove the rows of anybody not identified in step 1
3. On the remaining rows edit the column base_annual_salary (normally column F)
4. This column should display the base annual salary of the employee if their FTE was 1
5. Save the file as a CSV
6. Go to Settings >> Bulk Data Tool >> Start an Import
7. Name the Import (e.g. Base Annual Salary amendment for Part-Time employees 2023)
8. Upload >> Update Job Remuneration Data
9. Select your saved CSV (step 5) into the file area
10. Next >>
11. Review the data >> Save
12. Start Processing
Step 3
In Settings >> System Settings >> Remuneration Data check the 'Show Prorated Salary' option >> Save.
Comments
0 comments
Please sign in to leave a comment.