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.

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.

Salary Import Wizard

Step 1: Prepare the import file

I want to update Basic Pay and Medical Allowance for all my employees with effect from Jan 1st.

Salary Import - Basic Pay and Medical Allowance Salary Card

I’ve got the data in an excel sheet. Let me show you how to import this in to AttendHRM.

Salary Import Excel

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

Salary Import File

Let me save the file as CSV.

Salary Import CSV File

Step 2: Import the file

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

Salary Import New Format

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

Salary import to master and card

Now, pick the file.

Pick the Salary Import File

Since the file has a header row, check this option.

Pick the Salary Import File

As you see, the system has read the data properly.

Salary Import File Read

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.

Salary Import - Matching the fields

The field matching is done.

Fields Matched for Salary Importing

The import is done. Click ‘Finish’ to save the values. Or cancel to discard.

Salary Import Finish

Let’s go to the Salary Card to check if the values are updated. As you see, the values are updated.

Salary Card Values Imported

Step 3: Importing from the same file again

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.

Salary Import File Updating

Now, pick the ‘Existing Import Format’ and pick the saved format.

 Existing Salary Import Format

Let’s proceed to import.

 Proceed to salary import
 Proceed to salary import
Keep the import files in the same location and in the same data format with the same name for you to reuse them later.

You can use the Salary Import to update salary data for all employees in one shot.

Frequently Asked Questions

No. ‘With effect from’ is mandatory only when you import to Salary Master. This field has no effect in case of Salary Card.
Yes. Just pick an existing format, and make necessary changes and the changes will be saved.
When you import, the existing data is over written.