First year, we need to import the file and start the salary setting process, but you need to prepare the file with columns that must be included. Normally, a file is imported with personal identification numbers (personnummer) for each individual. However, if you as a customer want to make an exception, a unique identification number can be used instead of a Swedish personal identification number.

Second year you can import the file buy your self "import data", we can help you for a fee. If you would like an Excel template, you can request it from our [email protected].

First year, when the file is ready, you save the file to Customer Success.

Below you will find a list of all the mandatory data fields that must be included in the salary file if you intend to use it for salary set according to our Job Architecture when using Swedish personal identification numbers for your employees:

Mandatory data fields include:

If you are an existing customer, please make sure to enter the same information as in previous years to avoid creating new employees, positions, or organization nodes.

Mandatory for all:

For those who retrieve gender and age from their unique ID:

Swedish personal identification number | For example: YYYYMMDD-XXXX, YYMMDDXXXX

For those who do not retrieve gender and age from their unique ID:

Unique ID | Must be a unique number, for example, 931121.
Date of Birth | 1993-10-21
Gender | Female or Male

First name | John
Last name | Doe
Salary | The salary amount in full-time equivalent without additional allowances. Write without decimals, for example, 31000.
Salary increment | Write without decimals, for example, 500.
Salary year | The year of the salary revision for the employee, for example, 2022.
Position | The job title of the employment (existing customer - it should match the one in the system, otherwise it will be considered new and may require re-grouping).
Company tenure start date | YYYY-MM-DD.
Organization level 1 | The name of the organization/company, for example, Sysarb AB (existing customer - make sure the organization name matches the one in the system).
Organization level 2 | Part of your organization that is second highest in the organizational structure, such as a department or division.
Organization level 3 | Can be a unit, for example, Sysarb Unit.
Organization level 4 | Can be a team.
Organization level 5 | Free text.
Organization level 6 | Free text.
Employment number | 12345.
Hourly wage | Write without decimals, only if you have any hourly employees.
Salary increment 2 | Write without decimals, for example, 500.
Salary increment 3 | Write without decimals, for example, 500.
Short-term incentive I A bonus or reward granted based on performance over a brief period.
Long-term incentive I A bonus or reward granted based on performance over a longer period.
One time bonus I A single, non-recurring payment.
Benefits in kind I A financial reward given to employees in addition to their regular salary.
Overtime I Overtime covers additional hours worked beyond the standard workweek, often compensated at a higher rate.
Pension I The sum dedicated to the employee's retirement fund. It's typically calculated as a percentage from the base salary.
Paid holidays I Paid time off for employees used for vacation or similar. Calculated from base salary x no. of paid holidays.
Car allowance I When you use part of the employee's salary to pay for a car lease.
Manager code | Can be a letter, for example, A, B, C, L, F (Note! If you want to use the manager codes as a salary factor under the salary philosophy, it needs to be a numerical value, for example, 1-5. It can also be imported later).
Employment percentage | Write as a percentage, for example, 100.
Statistics code/ BESTA code/ AID code | 152012.
Agreement | Free text.
Cost center | Free text.
Contract type | Free text.
Employment type | Permanent.
Statistical code | 15607.
Employment rate | 100.
Country
Currency | For example: SEK, EUR