Skip to main content

MDP - Employee - Import Salaries

Learn how to quickly import multiple employee salaries into the system

Written by Sharabin Mathi

This article will guide you through importing salaries in bulk using the Import Salary feature.

Quick Navigation

Accessing the Salary Import Screen

To access the salary import screen, follow these steps:

  1. Navigate to the dashboard by clicking on the logo. This will take you to the Company List page.

  2. Find the company and click the People icon in the corresponding row. This will open a list of employees.

  3. Click on Import and select Import Salaries to open the import screen.

Importing Salaries

On the import screen, you will find three main options:

  • Download Import Template

  • Upload Completed File

  • View Import History

Downloading the Salary Import Template

To ensure accurate formatting, begin by downloading the official import template:

  1. Click Download Import Template.

  2. An Excel file (named SalaryImportTemplate) will be downloaded with the following column headers:

The import template includes built-in descriptions and available options to guide you in entering accurate information. Fields highlighted in light blue are mandatory, while fields highlighted in orange are conditionally mandatory. Conditional mandatory fields are only required when the corresponding dependent field is set to Yes.

Complete mandatory fields to ensure the import processes successfully.

Uploading the Completed Salary Import Template

Once you've filled out and saved the template:

  1. Return to the Import Salaries screen.

  2. Upload the file by either:

    • Dragging and dropping it into the upload area, or

    • Clicking Browse to select the file from your device.

Notes:

  • You can upload up to five files at a time.

  • Files can be removed by clicking the delete icon next to them.

  • Click Upload to start the import process. After the upload, the files will appear in the Import History section, where you can track successful and failed records.

Note: The system will update the employee’s salary and create a recurring pay item for the relevant pay period.

If you need to amend the salary details, you can perform another import to override the previously imported information. When the new import is processed, the system will delete the existing pay items or add end dates for the payroll processed and create new ones based on the updated salary details.

Viewing Salary Import History

To review past imports, click Import History on the Import Salaries screen.

It provides a comprehensive view of all salary imports within your company. The following columns are displayed to access information easily.

  • Import ID – System-generated unique number for the import

  • Date – Date of the file upload

  • Successful Records – Number of successfully imported entries.

  • Failed Records – Number of entries that failed to import.

  • Status – Status of the Import (e.g., Uploaded, Uploading, Processing, Processed, Error, Header Mismatch)

  • Actions – Options such as downloading success or error files.

Import History Filters

In the import screen, please click on the Filter icon⁣⁣ to expand the view below. Click the filter icon again to collapse the filter section.

You will have the following filter options:

  • Import ID

  • Upload Date

  • Import Status

After filling in the fields, click Search to filter the list of import histories. To remove all entered filters and start fresh, click Reset.

Managing Salary Import Errors

If an import fails:

  • Look at the Status column in the Import History.

  • If the status is Processed but the import has errors:

    • A red Error File icon will be available in the Actions column.

    • Download the file and check the Errors column (last column) for details.

    • Please correct the errors and re-upload the file, or update the error file and upload it.

If you see a Header Mismatch error:

  • This typically indicates that the column headers in your file do not match the required template.

  • Download a fresh copy of the import template.

  • Copy your data into the new file to ensure the format is correct.

  • Re-upload the updated file.

To return to the import screen, click the orange back icon next to the Import History title.

Related Articles

Need Further Assistance?

Need help or have questions? Our team is just a message away—let us know how we can make things easier for you!

Did this answer your question?