This guide shows step by step how to download the salary file template in the system. The salary file template is used when importing data via a file import. It contains information about Sysarb’s different columns as well as which values and formats are expected.
Tip: To ensure the template is up to date, make sure to download and use the latest version of the salary file template whenever you begin an import.
Where do I download the salary file template?
Step 1: Start the import
Go to the Import Data tab in the left menu of the system.
Click File Import to start the import of the salary file.
Step 2: Select Preferences
Which columns become mandatory or recommended in the salary file template depends on the choices you make in the first step of the import, Preferences.
If you use Swedish personal numbers as the unique ID:
Check the option Fetch gender and date of birth from unique ID
If you instead use an employment number or another unique ID:
Do not check this option.
Important: Use the same structure for Unique ID and employment number as you have previously used to maintain the employee history.
2. Select the date format used in your salary file.
3. Choose how the organizational structure is built in the file.
The most common option is Organizational Levels.
Tip: If you have previously imported data into the system, you can check how it is structured via the Employee Management tab under Organization.
4. Select which module the data should be imported into:
If you are importing data into the Job architecture or Pay equity audit, choose Pay equity audit.
5. Click Continue at the bottom right.
Step 3: Download the salary file template
In the Choose Salary File step, you can either download the salary file template or upload your completed salary file.
Click Download template at the top right. The template will be saved to your downloads folder.
Done!
What does the salary file template contain?
The salary file template consists of three different sheets:
1. Mandatory fields
The columns on this sheet are mandatory and must be included in the file during import.
2. Recommended fields
These columns are recommended to enable a more nuanced analysis and better data quality.
If you do not have data for these fields, it is fine not to include them.
3. All fields
Here you can find all columns that can be imported into the system:
Column name - What the column is called in Sysarb.
Example value - An example of what value the column can contain.
Description - Explanatory text, for example if the column has specific format requirements.
Used for - Describes how the column is used in the system.
Assistance with Salary File Import
If you do not want to import the file yourselves, Sysarb can assist for a fee. We ensure that the import is completed within 5 business days from the moment the file is uploaded and we have received your confirmation.
Cost for import assistance:
0-2,500 employees: 1,500 SEK
2,500-5,000 employees: 3,000 SEK
5,000-10,000 employees: 4,500 SEK
10,000-20,000 employees: 6,000 SEK
20,000+ employees: 7,500 SEK
What you need to do:
1. Upload the completed salary file in Excel format according to the instructions in the guide below.
2. Send a confirmation in the chat or via [email protected] that the file has been uploaded, and provide a reference for the invoice.