Mass Salary Update - Knowledge Base | BerniePortal

Mass Update - Salary

Employers and Feature Admins can update salaries for multiple employees at once with a spreadsheet from Employees > Mass Update.

To update salaries via spreadsheet:
  1. Go to Employees in the top navigation.
  2. Select Mass Update in the secondary navigation.
  3. Select Mass Update.
  4. In the Mass Update window, select Download to get the employee template. You must use this template or the import will not work.
  5. Fill in salary columns for each employee you are updating: First Name, Last Name, Employee SSN, New Salary, Salary Type, and Salary effective date (mm/dd/yyyy).
  6. Under Upload your data, select the completed spreadsheet file (.xlsx or .xls).
  7. Leave Email employees new election sheets if the update impacts benefits. checked to email new election sheets when benefits are affected, or clear the checkbox to skip those emails.
  8. Select Import.
After a successful import, BerniePortal shows how many employees were updated.

Notes:
  • Salary Type must be Per Year or Per Hour.
  • Salary effective date (mm/dd/yyyy) must use date format mm/dd/yyyy in a Date-formatted column.
  • Employee SSN is used to match each employee. Enter digits only, or with dashes; dashes are removed on import.
  • If a salary change affects salary-based benefits (for example Long Term Disability), BerniePortal generates new election sheets. Emails are sent only when the checkbox above is selected.
  • The same template can also update demographic fields. For those columns, see Mass Update - Employee Demographics.

To view salary update history for an employee:
  1. Go to Employees in the top navigation.
  2. Select the employee's name.
  3. Select Payroll in the employee menu.
  4. If Paystubs and Compensation tabs appear, select Compensation.
The table lists salary changes. The Action Taken column shows Mass Update or Individual Update.