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.

Step 1: Prepare the import file

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 Lenvica HRMS.

Make sure the commas used in number formats are removed before saving the file.

Let me save the file as CSV.

Step 2: Import the file

Since the file is new to Lenvica HRMS, let me create a new import format.

I’m going to import to both Salary Master and Salary Card.

Now, pick the file.

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.

Step 3: Importing from the same file again

Now, Lenvica HRMS 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.

Let’s proceed to import.