Import salaries

What this does

Admin/Payroll: imports approved historical salary revisions and establishes current salaries from a reviewed XLSX file.

Before you start

Employees must already exist with Employee IDs. Import requires compensation create and update permissions and supports up to 2,000 revisions. Use only authorized salary data; do not share completed files publicly.

Steps

1. Open Import Salary History, select Download Template, complete it, choose Upload XLSX, then Continue. Only XLSX is supported.
2. In Validate Salary History, inspect Errors and Warnings using All, Errors, Warnings, and Valid. Required fields are Employee ID, Revision No (a non-negative whole number), Revision Type, Effective From (YYYY-MM-DD), Gross Monthly, Basic, and Is Current (Yes or No). Errors include unknown Employee IDs or Approved By (Employee ID), invalid dates or non-numeric/negative salary amounts, unsupported revision types, duplicate revision numbers/dates, and overlapping date ranges. Revision 0 must be Joining; numbers must increase with effective dates.
3. Mark only the latest revision Is Current = Yes, with no Effective To. It cannot start in the future or precede a later existing revision. Use Download correction XLSX, fix the workbook, then Choose another file to validate again.
4. Warnings do not prevent review: a name mismatch uses Employee ID; Gross Monthly or Net Monthly mismatches use the component total; identical already-imported rows are skipped. Choose Review full import when there are no errors, or explicitly choose Import ... valid employees only. Any employee with an invalid row has their entire timeline skipped.
5. In Review Import, check each Salary timeline and Current salary. Select Import Salary History > Confirm Import. Check Salary History Imported totals and Download skipped rows if offered. Submission revalidates the file; if salary history changed, correct and validate again.

Result

Approved history and current salary records are saved. Full import is all-or-nothing; the valid-employees-only option imports each employee's complete valid history together, never a partial employee timeline.

Related/Next guide: Check payroll readiness.