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.

    • Related Articles

    • Mass Update - Employee Demographics

      Use Mass Update to change employee IDs and addresses for multiple active employees at once with a spreadsheet. Employers and Feature Admins can complete this update. You can update: Employee ID Employee Street Address Employee City Employee State ...

    • Adding Employees via Census Upload

      Use the employee census spreadsheet to add multiple employees at once from the Employees list. For a single new hire, see How to Add a New Hire. Who can import employees Employers can import from Employees → List. Feature Admins can import when they ...

    • How to Update Employee Salary

      Use Compensation Adjustment to update an employee's salary for a specific pay period. The change updates the employee's compensation record and can affect income-based benefits and deductions, including payroll integrations when those are in use. Who ...

    • Completing and Formatting the Employee Census

      Use the BerniePortal census template to add employees (and optional spouses or dependents) in bulk. Download the template from the import flow, keep the existing column headers and formatting, then fill each row before you upload. For the upload ...

    • Payroll Tab - Employee Profile

      Use the Payroll tab on an employee's profile to review compensation history and, when BerniePortal Payroll is enabled, download paystubs. Who this is for Employers, and Payroll Feature Admins who can view salaries. To access: Select Employees in the ...