Upload Salary Structure for Employees

This help page demonstrates steps to upload salary structure for employees. A salary structure is a template that contains salary heads that may have formulas or dependencies among each other. Empxtrack supports multiple salary structures. A salary break-up, on the other hand, is the assignment of a salary structure to employees with specific values for each head. The assignment is applicable of a specific date and this date is used to calculate arrears automatically (if applicable). In the employee database, employees may or may not be assigned a salary structure.

The upload salary structure functionality allows you to upload the salary breakup and salary structure details of all the employees in one go. This functionality is useful when you need to initialize the Empxtrack system for the first time to run payroll to calculate salaries thereafter. You can even upload new salary structure for employees post appraisal or mass salary increment.

Watch the video to view steps to upload salary structure for multiple employees

Upload Salary Structure for all Employees

To upload salary structures, you need to:

  1. Log into the system as HR Admin/ HR Manager.
  2. On the Dashboards homepage, go to Role and features menu and click Payroll. Process payroll page appears on the screen where you can see the Payroll options. Click on the Setup salaries for employees.

    Figure 1

  3. The Setup Salaries for employees page appears on the screen. Here you can upload salary structure for multiple employees in one go.
  4. Select the checkbox corresponding to the name of the employees whose salary structure is not assigned.

Figure 2

5. Click Upload salary breakup link at the bottom of the page.

Download the Salary Structure File Format

6. A new dialog box appears as shown in Figure 3. Select the preferred salary structure from the Select Structure dropdown for the selected employees.

7. Click Download sheet icon shown in front of Download Sample Sheet in csv format.

Figure 3

8. Once the downloaded file, you have the format in which the data needs to be put. You can now put the salary structure information in the file as shown in Figure 4.

Figure 4

Note: Ensure that dates that you provide, appear in the format mentioned in the file. If dates do not appear in desired format, then right-click the date cell(s) in which you are providing dates and then select the correct date format so that date appears in <MM/DD/YYYY> format.

Upload the CSV File

9. Once you have added the data of all the employees in the csv file, you can upload the file to Empxtrack system. Click Choose file and upload the file that you have filled with salary structure data.

10. Click Save. The salary structure for selected employees is uploaded successfully.

Click on the following links to know more about them: