Turn on Visma Lønn v.2 as an option for salary export
Go to System Settings → Staffing → Export → select department = All → tick Visma Lønn v.2. Then Visma salary will appear as an alternative when exporting salary basis in RecMan.
Then go to the Paychecks. When you now tick on one or more salary bases, you see that Visma Lønn v.2 appears as a choice for export.
If you click this button, a file named visma_lonn.zip will be downloaded. This ZIP file again contains five CSV files with different information. They can be opened in Excel to see what information RecMan brings with it in the export.
We will go through the five different files below.
Visma Payroll files
File 1 - Employee file
This file contains general information about the employee. The information that is included is:
| Column | Column information |
|---|---|
| A | Employee number |
| B | Address Line 1 |
| C | Address line 2 |
| D | Department no |
| E | Workplace |
| F | Account no |
| G | |
| H | Mobile |
| IN | Name |
| J | First name |
| K | Surname |
| L | Postnr |
| M | City |
| N | Private phone |
File 2 - Employee year
| Column | Column information |
|---|---|
| A | Employee number |
| B | Municipality number |
| C | Wage year |
| D | Tax rate |
| E | Table number |
| F | Table type |
| G | Tax card provided |
File 3 - Employee Information
| Column | Column information | Field in RecMan |
|---|---|---|
| A | Employee number | Employee number in the employee information |
| B | Date of employment | Employment date in the employee information |
| C | End date | End date in the employee information |
| D | Work status | Work status in the employee information |
| E | SSB.code | Occupational code in the employee information |
| F | Job title | Employment conditions in the employee information |
| G | Remuneration period | |
| H | Date of birthday | |
| IN | Job status | Work status in the employee information |
| J | Sex | 0 = Male, 1 = Female |
| K | Hours per week | "Hours a week" in the Employee Information |
| L | Payment method | "Payment method" in the employee information |
File 4 - Employee engagement
| Column | Column information |
|---|---|
| A | Employee number |
| B | Occupational code |
| C | Workplace |
| D | Proportion of position |
| E | Intake date |
| F | End date |
| G | Update department date |
| H | Update occupational code date |
| IN | Message type |
File 5 - Salary lines
This is the actual payroll file to be imported into Visma. In Visma Payroll, this is done from Routines → Registration → Import variable payroll data.
In the table below, there is an explanation of the information that is included from RecMan. In the picture below, you will also find an explanation of the different fields that can be included in an import from Visma.
| Column | Column information (information that can be included in the file) |
|---|---|
| A | Wage year |
| B | Showing «1» (Payroll number) |
| C | Employee number |
| D | Wage type |
| E | Not in use (Salary basis number) |
| F | Number |
| G | Rate |
| H | Amount |
| IN | Showing «0» (Account number) |
| J | Showing «0» (Counter Account) |
| K | Responsibility unit 1 - department number |
| L | Not in use (Responsibility Unit 2) |
| M | Not in use (Responsibility Unit 3) |
| N | Not in use (Responsibility Unit 4) |
| O | Not in use (Responsibility Unit 5) |
| P | Not in use (Responsibility unit 6) |
| Q | Showing «0» (Drawing code (tax)) |
The files we deliver are standard for wage imports in Visma Lønn. We have previously made adjustments for customers when it comes to wage exports. We can also help with this in the future if there is a need for this. This entails a development cost that depends on the size of the adaptation. If this is desirable, please contact our support at support@recman.no.