Mass Update Salaries

Use the Mass Update Salaries feature to increase the salaries for selected New and Closed jobs.

1. Select Manage Employees from the Human Resources menu, and that window opens.

2. Select Mass Update Salaries from the More menu, and the Specify Salary Update Formula window opens.

3. Enter the parameters to use in updating the salaries. Once percentage and/or amount values are entered and one of the radio buttons is selected, the resulting formula will be displayed in the Salary Update Formula field.

   • Enter Percentage and/or Amount: Enter numeric values in either or both of these fields. You can increase the salary by a percentage of the base OR by a flat dollar amount OR by a combination of both.

   • Select a formula type.

   • • Simple Percentage Increase: Enter a numeric value in the Percentage field and click this radio button. If 2.75 is entered in the Percentage field the Salary Update Formula will be Salary * 1.0275.

     • Simple Amount Increase: Enter a numeric value in the Amount field and click this radio button. If 199 is entered in the Amount field the Salary Update Formula will be Salary + 199.

     • Percentage Plus Amount: Enter numeric values in the Percentage and Amount fields, and click this radio button. If 2.75 is entered in the Percentage field and 199 is entered in the Amount field, the Salary Update Formula will be Salary * 1.0275 + 199.

     • FTE Prorated Amount: Enter a numeric value in the Amount field and click this radio button. If 199 is entered in the Amount field the Salary Update Formula will be (FTE * 199) + Salary.

     • FTE Adjusted Percentage Increase: Enter a numeric value in the Percentage field and click this radio button. If 2.75 is entered in the Percentage field the Salary Update Formula will be (Salary/FTE * .0275) + Salary.

     • FTE Adjusted Percentage Plus Amount: Enter numeric values in the Percentage and Amount fields, and click this radio button. If 2.75 is entered in the Percentage field and 199 is entered in the Amount field, the Salary Update Formula will be (Salary/FTE * .0275 + 199) + Salary

4. If needed, customize the formula to meet special salary increase requirements. Use the variables Salary and FTE with parentheses for grouping and mathematical operators for addition (+), subtraction (-), multiplication (*), and division (/).

5. (Optional) Click Example to display how the current Salary Update Formula will affect an employee with a salary of $30,000 and an FTE of 1.0. For example, if you used the FTE Adjusted Percentage Plus Amount with a percentage of 2.75 and an amount of 199, the Example popup would display a new salary of $31,024.00.

6. Click Select Jobs.

   • If the specified formula would result in a decrease or a greater than 5% increase, a message will popup asking if you want to continue. Click Yes to continue or No to return to edit the formula.

   • If there is no warning, the Mass Update Salaries window opens displaying New and Closed jobs that the user has permission to modify.

7. Check the boxes to select the jobs for which you want to update the salaries.

8. Click Mass Update Salaries. When the process is complete, the total number of successes and failures is displayed at the top of the window. The Status column displays the success or failure for each job, and the Message column displays the reason for any failures.

9. Optional. Export the results list by clicking the in the upper right corner.

Return to Manage Employees Overview