With Gutsy’s Mass Job and Salary Change feature, you can easily update multiple employees’ job details and salaries in one go using an Excel template. This article will guide you through the use cases, important notes, and step-by-step instructions to help you apply the changes smoothly.
When should you use Mass Job and Salary Change?
You may use this feature in the following situations:
When you need to mass update job and salary information for multiple employees using an Excel file.
When you want to overwrite existing job and salary information without creating a new career history record.
When certain job or salary fields were previously left blank and you want to populate them for multiple employees at once.
This feature helps save time while ensuring consistent updates across employees.
💡 Scenario
Admin A previously onboarded 10 employees with an incorrect position assigned. The correct position should be Manager instead of Associate.
Instead of updating each employee profile manually, Admin A uses Mass Job and Salary Change to overwrite the incorrect position so that all employee records reflect the correct information instantly.
Important things to note before using this feature
Ensure that all required setup fields (such as Department, Position, Employment Type, etc.) are created in advance so they are available in the Excel dropdown.
Example: If you want to update an employee’s position to Manager, make sure the Manager position already exists in the system before proceeding.
Incorrect or missing setup values may result in upload errors during preview or submission.
What can be updated via the Mass Job and Salary Change Excel template?
You can update the following information in bulk:
Employee Number, Effective Date of Changes, Department, Position, Cost Centre, Employment Type, Probation / Contract / Internship End Date, Pay Type, Currency, Monthly Basic Salary, Hourly Rate (if applicable), Daily Rate (if applicable), Normal OT Hourly Rate, Off-day OT Hourly Rate, Rest Day OT Hourly Rate, Pay Scheme Details, Remark, Timezone, Country of Work, Payment Period
Steps to perform Mass Job and Salary Change
From the side navigation, go to Employees > All Employees.
Click the three-dot icon next to the Onboard Employees button and select Mass Edit.
Choose Job & Salary Change, then click Next.
Select the company you wish to edit and click Download to download the Excel template.
Fill in the Excel sheet accordingly.
Employee Name can be selected directly from the dropdown list.
For other fields, dropdown options will be available where applicable to help you select the correct values.
Decide how the changes should be applied:
To overwrite the current job and salary information, leave the Effective Date of Changes column blank.
To create a new job record and reflect it in the career history, fill in the Effective Date of Changes column.
Save the completed Excel template and upload it back to the Gutsy page.
The system will display a header preview, matching your Excel headers with Gutsy’s required fields.
Click Preview to review the changes.
Once everything looks correct, click Update to proceed.
Great job! You now know how to use Mass Job and Salary Change to efficiently update employee job and salary details in bulk. This feature helps you stay organised, reduce manual work, and ensure employee records remain accurate and up to date.
Still exploring? Head over to our Help Centre for more in-depth guides and FAQs.
If you have any questions, feel free to reach out to us at support@gutsyhq.com. We'll get back to you from there.