Salary import allows you to import data from an excel or text file. Importing a lot of data is easier than keying in. You can import data to Salary Master and Salary Card at the same time.
I want to update Basic Pay and Medical Allowance for all my employees with effect from Jan 1st.
I’ve got the data in an excel sheet. Let me show you how to import this in to AttendHRM.
Make sure the commas used in number formats are removed before saving the file.
Let me save the file as CSV.
Since the file is new to AttendHRM, let me create a new import format.
I’m going to import to both Salary Master and Salary Card.
Since the file has a header row, check this option.
As you see, the system has read the data properly.
Now, let’s match the fields. Field ‘With Effect From’ is mandatory if you are importing to the Salary Master. If you are importing only to the Salary Card, you can skip this field.
The field matching is done.
The import is done. Click ‘Finish’ to save the values. Or cancel to discard.
Let’s go to the Salary Card to check if the values are updated. As you see, the values are updated.
Now, AttendHRM understand this file and it’s format, so, when you want to update same kind of data, just fill the file again and import. Let me prepare the data again and save it.
Now, pick the ‘Existing Import Format’ and pick the saved format.
You can use the Salary Import to update salary data for all employees in one shot.