Using the Remuneration Modelling Tool

From Subscribe-HR Wiki Help
Jump to: navigation, search
(→‎Remuneration Modelling Tool Summary)
(→‎Setting Filters on a Remuneration Model)
 
(49 intermediate revisions by the same user not shown)
Line 5: Line 5:
  
 
==Remuneration Modelling Tool Summary==
 
==Remuneration Modelling Tool Summary==
−
The purpose of the Salary Modelling tool is to provide fast access to key remuneration information. You can model increase and decreases in Salary. You can apply Salary and Bonus increases based on Performance Scores. The Tool allows you to view information for Employee's around LSL, Sick Leave and Length of Service, Performance Review Scores. You can use the model to apply information to the Employee for Bonus and Salary or your can just use it as a Visualisation option to have a snapshot the information which has been selected in the Columns. You can Apply Salary reductions to the Model if you are reducing the Compensation for Employees. You can enter into the system, a Salary Date or Bonus Date which will be used to create new Salary and or Bonus records. Salary Bench Mark can also be used to see if the current Salary for people is in line with the Benchmark which has been recorded against the Job. Bonus Payment Dates and Salary Increase Dates can be different to each other. You can also create different dates for different people if required. If you select Bonus from the Columns option, you will be able to see the last Bonus amount. If you use the Authorisation process which is built into the Remuneration Modelling Tool, the person that sets up the Model, can send it for Authorisation to a Manager. All Managers will be available in the selection option, when Submit is clicked. A workflow e-mail will be sent to that person. This person can then Authorise / Decline, or send it to another manager for Authorisation. If Authorisation is performed by clicking the Authorisation button, the model will be Authorised and the Salary and Bonus records created based on the dates that are in the model. If you are using a Payroll integration, and the Payroll integration Supports Salary and Bonus update, this information will be sent from Subscribe-HR to Payroll. You cannot Create and Authorise a Model yourself for the reason of Risk mitigation and compliance.  
+
The purpose of the Remuneration Modelling tool is to provide fast access to key remuneration information. You can model increase and decreases in Salary. You can apply Salary and Bonus increases based on Performance Scores.  
−
<br /><br />
+
 
−
If it is required to give certain employee's an increase in their Salary, rather than manually updating each affected employee's salary, you can use this tool to select those employees and quickly update their salaries or bonuses. This can be done based on their Performance Score - which can be drawn from their Performance Review.
+
The Tool allows you to view information for Employee's around LSL, Sick Leave and Length of Service, Other Costs, Salary Benchmark (available through selecting Salary Increase), Performance Review Scores. You can use the model to apply information to the Employee for Bonus and Salary or your can just use it as a Visualisation option to have a snapshot of the information which has been selected in the Columns.  
−
<br /><br />
+
 
−
The Remuneration Modelling tool can also allow you to filter your employees by department and/or location, so that only employee's working in a selected location(s) or department(s) are affected by the salary update.
+
<b>Modelling Status</b> relates to where the the model is at in terms of processing. The four statuses are: Pending, Submitted, Authorised, Declined.
−
<br /><br />
+
 
−
Columns can be selected and included in the Model. E.g. Current Salary, Last Bonus, Last Review Score, Annual leave Balance, LSL Balance, Other Costs.
+
<b>Model Name</b> is Mandatory. Described the Model.
−
<br /><br />
+
 
−
The Remuneration Modelling tool also allows you to search for an individual Employee by Name and also use filters return Employee results.
+
<b>Apply Salary:</b> reductions to the Model if you are reducing the Compensation for Employees by using the negative Salary feature. You can enter into the system, a Salary Date or Bonus Date which will be used to create new Salary and or Bonus records. Dates can be in the past or in the future. If a date is in the past, it will instantly create new Salary records for those people. Salary Start Date is Mandatory.
 +
 
 +
<b>Remuneration Model Type:</b> can be based on Pay, Redundancy, Growth, Expansion and Performance.
 +
 
 +
<b>Created Date</b> is for the date the Rems Model was created.
 +
 
 +
<b>Salary Benchmark:</b> column can also be used to see if the current Salary for people is in line with the Benchmark which has been recorded against the Job. Bonus Payment Dates and Salary Increase Dates can be different to each other. You can also create different dates for different people if required. If you select Bonus from the Columns option, you will be able to see the last Bonus amount.  
 +
 
 +
<b>Bonus Date/s or Salary Date/s:</b> you are able to either bulk create the Date/s or change them for individual records. This can be done: <b>For Bulk</b> by entering the Date for Salary or Bonus into the field in the Filter area or, <b>Single</b> by entering the date for the new <b>Salary</b> or <b>Bonus</b>, into the individuals record.
 +
 
 +
<b>Salary or Bonus:</b> column can be entered into the model in bulk or also into a single Employee record. This is done by entering in the Salary for the Employees in the Model, in the top Filter area (<b>Bulk</b>, or by entering the one off amount into the Employee Record/s. Please note that if you are entering negative salary information, all Salaries need to be negative in the model. No Salary records will be created if Salaries are negative.
 +
 
 +
<b>Columns:</b> can be inserted into the Model by selecting the relevant <b>Column</b> options from the Top Filter area of the Tool.
 +
 
 +
<b>E-mail Notifications</b> e-mail notifications will send to user who submits and user who authorizes the model when submission and authorisation takes please.
 +
 
 +
<b>Authorisation</b> process which is built into the Remuneration Modelling Tool, the person that sets up the Model, can send it for Authorisation to a Manager. All Managers will be available in the selection option, when Submit is clicked. A workflow e-mail will be sent to that person. This person can then Authorise / Decline, or send it to another manager for Authorisation. If Authorisation is performed by clicking the Authorisation button, the model will be Authorised and the Salary and Bonus records created based on the dates that are in the model. If the model is a Redundancy model, you will be able to create negative Salary values. Upon authorisation no records will be created from Negative values. If you are using a Payroll integration, and the Payroll integration Supports Salary and Bonus update, this information will be sent from Subscribe-HR to Payroll. You cannot Create and Authorise a Model yourself for the reason of Risk mitigation and compliance. Please note that custom workflows can also be set-up based on specific Authorisation processes, which will only allow certain Managers to Authorise a Model. Workflow e-mails will send to the person Submitting to Model to an Authoriser and also send to the Authoriser and the Submitter, upon Authorisation of the Model of if the Model is NOT authorised.  
 
<br />
 
<br />
 +
 +
<b>Budget and Salary Total Information Display</b> will be shown top right of screen. The information in here will vary based on the model. Model Total will show always, based on the SUM off all people in the model and their Salaries. Model Projection Total will show based on increase in Salary if Salary Increase Column is used. If Department Filter is used, Budget information from the Budget Sub Folder will be shown. This information is based on Budget Amount, Current Expenditure and Remainder. This information will be shown along with  Total Salary and the Projection.
  
 
===Creating a Remuneration Model===
 
===Creating a Remuneration Model===
Line 20: Line 38:
 
# Select the <b>[Add New Record]</b> button.
 
# Select the <b>[Add New Record]</b> button.
 
# Enter the <b>Remuneration Model Name</b>. Ensure that the name is descriptive.
 
# Enter the <b>Remuneration Model Name</b>. Ensure that the name is descriptive.
 +
# Select Model Type from the Dropdown option. E.g. Performance, Data Analysis, Growth, Redundancy. You can create your own options in this Dropdown by updating it in Code Library - Model Type.
 
# Select <b>Save</b> at the top of the page.
 
# Select <b>Save</b> at the top of the page.
  
 
===Setting Filters on a Remuneration Model===
 
===Setting Filters on a Remuneration Model===
 
# Open an existing or new Remuneration Model.
 
# Open an existing or new Remuneration Model.
−
# On the right of the page are the filters that can be set on the Remuneration Model.  
+
# Create the Name for the Model.
−
# <b>Model Type</b> allows you to set between Salary and Bonus, as well as the option to include employees that do not have a current salary or bonus.
+
# Select the Model Type. E.g. Performance, Redundancy, Strategy, Expansion.
−
# <b>Employee Name</b> allows you to filter for a specific employee by name.
+
# Select Filter or Individual. Filter will allow you to only see people based on Job, Department, Location, Performance Score, Last Salary or Bonus Increase (>6, <12, <18, Never). Individual will allow you to select individual people and insert them into the model.
−
# <b>Departments</b> allows you filter by department(s).
+
# Select the Columns you wish to include in the Model. Salary, Bonus, Performance Score, LSL, Annual Leave. If you select Salary and OR Bonus, you will be able to see the latest Salary and Bonus and that Date they were received. You will also be able to Apply Bulk Salary and Bonus dates or enter individual dates for all of the people in the model. You can also record bulk or individual "Reasons" for Bonus and Salary Increase.
−
# <b>Locations</b> allows you to filter by location(s).
+
# Complete the information available in the Columns and then either "Save" or "Submit" for Authorisation.
−
# After the desired filter has been entered select the <b>Set Filter</b> button.
+
−
# Current filters can be checked by moving your cursor over the <b>i</b> icon under <b>Current Filters</b>.  
+
−
# If desired, the filter menu can be hidden by selecting the <b>Hide</b> button.
+
−
# If hidden, the filter menu can be shown by select the <b>Show</b> button.
+
  
−
===Setting Increase Rates on Employees===
+
===Budget - Using Budgets with the Remuneration Modelling Tool===
 +
# Budget information can be see in the Remuneration Modelling Tool at the top right of the screen.
 +
# Budgets are set-up based on Departments.
 +
# Budgets need to be used in Conjunction with Department Filter. Budget Information will only show if the Filter options is based on Departments.
 +
# Information shown in this section relates to: Department "Budget Amount", "Current Expenditure", "Remainder".
 +
# These item will be calculates based on the Department, Number of People in the Department, Total Increase in Salary. Bonus Amount.
 +
For more information about Budgets: [[Setting-up-budgets#Adding_Budgets|Setting Up Budgets]]
 +
 
 +
===Remuneration Model Type===
 +
# Model Types include - Redundancy, Performance, Expansion and Growth.
 +
# Please note that if Redundancy is selected you can include negative values for Salary. This will not create new Negative Salary records for the Employees after authorisation.
 +
 
 +
===Inserting Columns into the Remuneration Model===
 +
# Once you have defined your Filters, you can insert columns into the model
 +
# Standard Column include: Salary + - , LSL, Length of Service, Annual Leave, Bonus, Other Cost. Please note that only Redundancy Model type will allow for Negative values for Salary.
 +
# Select the Model Type. E.g. Performance, Redundancy, Strategy, Expansion.
 +
# Select Filter or Individual. Filter will allow you to only see people based on Job, Department, Location. Individual will allow you to select individual people and insert them into the model.
 +
# Select the Columns you wish to include in the Model.
 +
# Complete the information available in the Columns and then either "Save" or "Submit" for Authorisation.
 +
 
 +
===Sorting in the Remuneration Model===
 +
# Once the Model is established and data options have been selected using Filters or Individual Option and Columns and been inserted, the information in the model can be sorted based on Highest and Lowest. Select the Column headings to do this. The data will sort based on Highest and Lowest amounts.
 +
 
 +
===Setting Increase - Decrease Rates on Employees for Salary / Bonus===
 
# Open an existing or new Remuneration Model.
 
# Open an existing or new Remuneration Model.
−
# Enter the new rate into the <b>Remuneration Increase Field</b>. This will be percentage rate if the <b>Model Type</b> filter is set to Salary or Bonus, otherwise it will be set to a currency rate for either Salary or Bonus that include employees with no salary or bonus.  
+
# Select Salary + - (Increase or Decrease) and or Bonus. You will see fields, Current Salary, Salary Benchmark, Projected Salary, Value Increase as well as Bonus. The Projected Salary Amount value will be the same as the Current Salary until increase amount or value is entered. If Bonus is selected you can enter in a one off amount which can then be changed for each person, or you can select a % increase, for everyone which can also be changed per person. The "Projected Amount" Column will show the current Salary until the Projected amount is calculated based on the increase or decrease options have been entered. If you use negative Salary, all records need to be negative in the model.
−
# Select the <b>Calculate</b> button.
+
 
−
# To alter individual rates of employees enter the new rate for an employee in the <b>Individual Increase</b> field for that employee.  
+
===Change History - Audit Full Change History===
 +
# After a Model is created and "Saved", any changes in the model will be audited. Including changes to data, removal or inclusion of Columns, Comments, and the Submission - Authorisation process.
 +
# Audit is performed each time the Model is "Saved" and also through the Submit - Authorisation process.
 +
 
 +
===Applying a Remuneration Model - Submit and Authorise===
 +
# Create or Open an existing Remuneration Model. Including Filters, Columns and Data.
 +
# Submit and select the Manager you wish to get Authorisation from. Note: the Person who receives will be able to Decline (with Comments - see Audit and Change History Section), Submit to another user for Authorisation or Authorise thenselves.
 +
# Prior to Authorisation, the Authoriser will be asked if you want to create the records for the people in the model (Salary and or Bonus) upon authorisation. If the Authoriser says "No" the Model will be authorised without the creation of new records for the people in the Model. If you have a Salary Date (Mandatory) or Bonus Date which is in the past, the update will occur instantly. If the date is in the future, the update will create records with the future date as the start date. Salary Increase Reason will be based on what was selected in the Reason Dropdown in the Model. E.g. Performance, Annual Increase. This also applies to the Bonus. Please note that if the Model Type = Redundancy, no negative Salary records will be created. Any negative Salary records will not be created as new records against the Employee. The model for Redundancy or negative Salary will only be recorded in the model, for record keeping purposes, not for updating New Employees records. There is a step in the Authorisation process that will notify the Authoriser that no records will be created for the Employees in the model, upon authorisation of a redundancy model.
  
−
===Applying a Remuneration Model===
+
Please note that we can add additional Columns to the Modelling Tool on request.  
−
# Open an existing Remuneration Model.
+
−
# Select all employees that the new rate will be applied to.
+
−
# Enter a date into the <b>New Salary/Bonus Date</b>. This is the date that the new Salary or Bonus comes into effect for the selected Employees.
+
−
# Select <b>Apply Model</b> at the top of the page.
+
  
 
[[File:subscribehr_logo.gif]]
 
[[File:subscribehr_logo.gif]]

Latest revision as of 00:13, 6 August 2020

Remuneration Modelling Tool Summary

The purpose of the Remuneration Modelling tool is to provide fast access to key remuneration information. You can model increase and decreases in Salary. You can apply Salary and Bonus increases based on Performance Scores.

The Tool allows you to view information for Employee's around LSL, Sick Leave and Length of Service, Other Costs, Salary Benchmark (available through selecting Salary Increase), Performance Review Scores. You can use the model to apply information to the Employee for Bonus and Salary or your can just use it as a Visualisation option to have a snapshot of the information which has been selected in the Columns.

Modelling Status relates to where the the model is at in terms of processing. The four statuses are: Pending, Submitted, Authorised, Declined.

Model Name is Mandatory. Described the Model.

Apply Salary: reductions to the Model if you are reducing the Compensation for Employees by using the negative Salary feature. You can enter into the system, a Salary Date or Bonus Date which will be used to create new Salary and or Bonus records. Dates can be in the past or in the future. If a date is in the past, it will instantly create new Salary records for those people. Salary Start Date is Mandatory.

Remuneration Model Type: can be based on Pay, Redundancy, Growth, Expansion and Performance.

Created Date is for the date the Rems Model was created.

Salary Benchmark: column can also be used to see if the current Salary for people is in line with the Benchmark which has been recorded against the Job. Bonus Payment Dates and Salary Increase Dates can be different to each other. You can also create different dates for different people if required. If you select Bonus from the Columns option, you will be able to see the last Bonus amount.

Bonus Date/s or Salary Date/s: you are able to either bulk create the Date/s or change them for individual records. This can be done: For Bulk by entering the Date for Salary or Bonus into the field in the Filter area or, Single by entering the date for the new Salary or Bonus, into the individuals record.

Salary or Bonus: column can be entered into the model in bulk or also into a single Employee record. This is done by entering in the Salary for the Employees in the Model, in the top Filter area (Bulk, or by entering the one off amount into the Employee Record/s. Please note that if you are entering negative salary information, all Salaries need to be negative in the model. No Salary records will be created if Salaries are negative.

Columns: can be inserted into the Model by selecting the relevant Column options from the Top Filter area of the Tool.

E-mail Notifications e-mail notifications will send to user who submits and user who authorizes the model when submission and authorisation takes please.

Authorisation process which is built into the Remuneration Modelling Tool, the person that sets up the Model, can send it for Authorisation to a Manager. All Managers will be available in the selection option, when Submit is clicked. A workflow e-mail will be sent to that person. This person can then Authorise / Decline, or send it to another manager for Authorisation. If Authorisation is performed by clicking the Authorisation button, the model will be Authorised and the Salary and Bonus records created based on the dates that are in the model. If the model is a Redundancy model, you will be able to create negative Salary values. Upon authorisation no records will be created from Negative values. If you are using a Payroll integration, and the Payroll integration Supports Salary and Bonus update, this information will be sent from Subscribe-HR to Payroll. You cannot Create and Authorise a Model yourself for the reason of Risk mitigation and compliance. Please note that custom workflows can also be set-up based on specific Authorisation processes, which will only allow certain Managers to Authorise a Model. Workflow e-mails will send to the person Submitting to Model to an Authoriser and also send to the Authoriser and the Submitter, upon Authorisation of the Model of if the Model is NOT authorised.

Budget and Salary Total Information Display will be shown top right of screen. The information in here will vary based on the model. Model Total will show always, based on the SUM off all people in the model and their Salaries. Model Projection Total will show based on increase in Salary if Salary Increase Column is used. If Department Filter is used, Budget information from the Budget Sub Folder will be shown. This information is based on Budget Amount, Current Expenditure and Remainder. This information will be shown along with Total Salary and the Projection.

Creating a Remuneration Model

  1. After logging into the Subscribe-HR HCM Platform, under "TOOLS" select "REMUNERATION MODELLING" from the left navigation.
  2. Select the [Add New Record] button.
  3. Enter the Remuneration Model Name. Ensure that the name is descriptive.
  4. Select Model Type from the Dropdown option. E.g. Performance, Data Analysis, Growth, Redundancy. You can create your own options in this Dropdown by updating it in Code Library - Model Type.
  5. Select Save at the top of the page.

Setting Filters on a Remuneration Model

  1. Open an existing or new Remuneration Model.
  2. Create the Name for the Model.
  3. Select the Model Type. E.g. Performance, Redundancy, Strategy, Expansion.
  4. Select Filter or Individual. Filter will allow you to only see people based on Job, Department, Location, Performance Score, Last Salary or Bonus Increase (>6, <12, <18, Never). Individual will allow you to select individual people and insert them into the model.
  5. Select the Columns you wish to include in the Model. Salary, Bonus, Performance Score, LSL, Annual Leave. If you select Salary and OR Bonus, you will be able to see the latest Salary and Bonus and that Date they were received. You will also be able to Apply Bulk Salary and Bonus dates or enter individual dates for all of the people in the model. You can also record bulk or individual "Reasons" for Bonus and Salary Increase.
  6. Complete the information available in the Columns and then either "Save" or "Submit" for Authorisation.

Budget - Using Budgets with the Remuneration Modelling Tool

  1. Budget information can be see in the Remuneration Modelling Tool at the top right of the screen.
  2. Budgets are set-up based on Departments.
  3. Budgets need to be used in Conjunction with Department Filter. Budget Information will only show if the Filter options is based on Departments.
  4. Information shown in this section relates to: Department "Budget Amount", "Current Expenditure", "Remainder".
  5. These item will be calculates based on the Department, Number of People in the Department, Total Increase in Salary. Bonus Amount.

For more information about Budgets: Setting Up Budgets

Remuneration Model Type

  1. Model Types include - Redundancy, Performance, Expansion and Growth.
  2. Please note that if Redundancy is selected you can include negative values for Salary. This will not create new Negative Salary records for the Employees after authorisation.

Inserting Columns into the Remuneration Model

  1. Once you have defined your Filters, you can insert columns into the model
  2. Standard Column include: Salary + - , LSL, Length of Service, Annual Leave, Bonus, Other Cost. Please note that only Redundancy Model type will allow for Negative values for Salary.
  3. Select the Model Type. E.g. Performance, Redundancy, Strategy, Expansion.
  4. Select Filter or Individual. Filter will allow you to only see people based on Job, Department, Location. Individual will allow you to select individual people and insert them into the model.
  5. Select the Columns you wish to include in the Model.
  6. Complete the information available in the Columns and then either "Save" or "Submit" for Authorisation.

Sorting in the Remuneration Model

  1. Once the Model is established and data options have been selected using Filters or Individual Option and Columns and been inserted, the information in the model can be sorted based on Highest and Lowest. Select the Column headings to do this. The data will sort based on Highest and Lowest amounts.

Setting Increase - Decrease Rates on Employees for Salary / Bonus

  1. Open an existing or new Remuneration Model.
  2. Select Salary + - (Increase or Decrease) and or Bonus. You will see fields, Current Salary, Salary Benchmark, Projected Salary, Value Increase as well as Bonus. The Projected Salary Amount value will be the same as the Current Salary until increase amount or value is entered. If Bonus is selected you can enter in a one off amount which can then be changed for each person, or you can select a % increase, for everyone which can also be changed per person. The "Projected Amount" Column will show the current Salary until the Projected amount is calculated based on the increase or decrease options have been entered. If you use negative Salary, all records need to be negative in the model.

Change History - Audit Full Change History

  1. After a Model is created and "Saved", any changes in the model will be audited. Including changes to data, removal or inclusion of Columns, Comments, and the Submission - Authorisation process.
  2. Audit is performed each time the Model is "Saved" and also through the Submit - Authorisation process.

Applying a Remuneration Model - Submit and Authorise

  1. Create or Open an existing Remuneration Model. Including Filters, Columns and Data.
  2. Submit and select the Manager you wish to get Authorisation from. Note: the Person who receives will be able to Decline (with Comments - see Audit and Change History Section), Submit to another user for Authorisation or Authorise thenselves.
  3. Prior to Authorisation, the Authoriser will be asked if you want to create the records for the people in the model (Salary and or Bonus) upon authorisation. If the Authoriser says "No" the Model will be authorised without the creation of new records for the people in the Model. If you have a Salary Date (Mandatory) or Bonus Date which is in the past, the update will occur instantly. If the date is in the future, the update will create records with the future date as the start date. Salary Increase Reason will be based on what was selected in the Reason Dropdown in the Model. E.g. Performance, Annual Increase. This also applies to the Bonus. Please note that if the Model Type = Redundancy, no negative Salary records will be created. Any negative Salary records will not be created as new records against the Employee. The model for Redundancy or negative Salary will only be recorded in the model, for record keeping purposes, not for updating New Employees records. There is a step in the Authorisation process that will notify the Authoriser that no records will be created for the Employees in the model, upon authorisation of a redundancy model.

Please note that we can add additional Columns to the Modelling Tool on request.

Subscribehr logo.gif

Retrieved from "https://wiki.subscribe-hr.com.au/index.php?title=Salary-modelling-tool&oldid=7511"