In this article, we discuss how we can upload the salary data of multiple employees at once to save time in a step-by-step process while explaining the necessary information.
Instructions to add multiple employee salary data
you can add multiple employee salary data in the following manner:
Step 1: Choosing the data type
Step 2: Importing Data
Step 3: Uploading the data and finish the process
Step 1: Choosing the data type
Go to the People tab.
Use the Import Data option.
Select the Import data type.
In this case, select Salary Breakdown from the drop-down.
Step 2: Importing Data
If you do not have the template, you can download the template and upload the Employee Information basis on the template file.
Drag and drop the file or select the file from your device.
Step 3: Uploading the data and finish the process
After uploading the file, click on Upload and Continue.
IF Any, the error in the file will be shown.
If no errors are found, the employee details have been added to the directory.
You can either add more files or go back to the People tab.
Here is a directory of salary breakdown template
Column | Details |
EMPLOYEE_ID | Employee ID as per joining records |
FIRST_NAME | First Name (only for validation) |
MIDDLE_NAME | Middle Name (only for validation) |
LAST_NAME | Last Name (only for validation) |
CTC | Latest annual CTC |
BASIC | Latest annual Basic, as per salary structure (typically 40-50% of CTC) |
HRA | Latest annual House Rent Allowance as per salary structure (typically 50% of Basic) |
BONUS | Latest annual Bonus as per salary structure |
COMMISSION | Latest annual Commission as per salary structure |
EMPLOYER_CONTRI_PF | Latest annual Provident Fund (employer contribution) as per salary structure: Note that this includes both EPF and EPS. (Typically 12% of Basic) |
LTA | Latest annual Leave Travel Allowance as per salary structure |
TELEPHONE_REIMBURSEMENTS | Latest annual Telephone Reimbursements as per salary structure |
SPECIAL_ALLOWANCE | Latest annual Special Allowance as per salary structure (Typically CTC - all other components) |
Custom component 1 | Enter any custom component name (which are already created in the Salary Components section) as a column name and the respective values |
Custom component 2 | Enter any custom component name (which are already created in the Salary Components section) as a column name and the respective values |