If you feel stressed about performing a salary file import or if your technology doesn't meet the requirements, we can definitely assist you with the entire import process for a fee.
0-2500 employee = 1500 SEK
2500-5000 = 3000 SEK
5000-10 000 = 4500 SEK
10 000-20 000 = 6000 SEK
20 000+ = 7500 SEK
You don't need to worry about anything else except uploading the file in a standard Excel format as described below, and we will take care of the rest. Place your order through the chat or at [email protected]
The idea is that you should be able to upload the file extracted from your payroll system. When you start the import process, you will find our template where you can see the mandatory and recommended fields for importing a salary file into the system.
If you're missing a column in this template, you can certainly add it yourself, such as organization levels.
You can retrieve the salary file template after selecting preferences in the import process.
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 equal pay audit/salary set and discussions.
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
Mandatory for all:
Salary | The salary in full-time equivalent without any additional allowances. Write without decimals, for example, 31000.
Salary Increment | Write without decimals, for example, 500.
Salary Year | The year of the salary review for the employee, for example, 2022.
Position | The job title corresponding to the employment.
Email | [email protected] (only for salary review and discussions)
Company tenure start date | YYYY-MM-DD
Organization Level 1 | The name of the organization/company, for example, Sysarb AB.
Organization Level 2 | Segments within your organization that are the second highest in the organizational structure, such as a department or division.
Currency | For example SEK, EUR, GBP
Country
Below you will find a list of all the optional but recommended detailed data fields:
Advanced/Recommended data fields:
Forename| Name
Surname | Name-son (e.g., "Namnsson" indicates "Son of Namn")
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 | 123456, If you have previously imported with employee number, we recommend that you continue to do so in order to view work history.
Current position start date | 2021-01-01.
Employment end date | 2022-01-01.
Hourly wage | Write without decimals, only if you have any hourly employees.
Salary exchange | Write without decimals, for example, 500.
Salary date | 2022-01-01.
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."
Employment percentage | Write as a percentage, for example, 100.
Statistical code / BESTA Code / AID Code | 105600.
Agreement | Free text.
Cost center | Free text.
Contract type | Free text.
Form of employment | Permanent employment.
Performance / We expect an assessment in either numbers or letters, for example 4. (To use performance as a pay factor, it must be a value in numbers.)