Introduction and scope
The following is a guide to setting up Visma Payroll.
In the first part, you are guided through the setup of the integration itself, which includes what is supported in Emply, an overview of the setup, a setup guide and what you need to have prepared for the setup. In addition, there is also an overview of employment conditions, benefits, absence types and examples, as well as setting up employment information.
The second part is a guide to setting up a payroll group in Emply with the integration. In the payroll group in Emply, you can set up a number of records that cover different records in a single file or in several separate files. In addition, the setup of the FTP server is also covered if you have purchased access to this service from Visma. Finally, you will be guided through setting up automation of payroll files for Visma.
The guide has the following steps:
- Setting up Emply
- Import of employees
- Setting up payroll groups
- Testing the payroll file
- FTP Setup
- Setting up automation
Guide to setting up the Visma Løn integration
General schedule for setup
Setting up Visma Løn files requires in-depth knowledge of Visma Løn. It is recommended that you consult a Visma Løn consultant who can provide information and verify the content of the files. You also need to decide how and when the files are loaded into Visma Løn.
| Task | Content |
| 1. Setting up Emply |
Setup form Benefits Leave types Create payroll groups |
| 2. Importing employees |
Master data Employement data Benefits / base salary Compensation balances - possible future absences |
| 3. Setting up payroll groups |
Export setup Visma codes Absence codes Resignation codes |
| 4. Testing the payroll file |
Possibly FTP setup > Visma test Check with Visma consultant Corrections Approval |
| 5. Testing the FTP setup*An additional assurance that the files are correct for automatic loading. |
Secure submission of codes, URL, username, password Fingerprint |
| 6. Setting up FTP** Automatic loading |
Secure submission of codes, URL, username, password Fingerprint |
| 7. Setting up the automation |
Clarification of needs and possibilities Clarification of frequency Setup activated |
*Test FTP and FTP require an additional service purchase from Visma
**FTP service is not required as you can also upload Visma Løn files manually.
Requirements for setup
This setup guide requires:
- that the customer has provided various codes for setting up Visma Løn.
- Customer relationship, pay type codes and FTP information if applicable
- the customer ensures to have assistance from Visma for testing and acceptance of payroll files from Emply*
- Emply is/will be set up with the help of Emply consultant
*It is recommended that you contact your Visma consultant and arrange for the payroll files to be reviewed and verified for a test period before exporting and loading on a regular basis.
1. Setting up Emply
1.1 Master data form
Employee master data must contain as a minimum (highlighted):
| Field no. | Excel column | Name | Emply |
| 1 | A | Customer relation | Specified on the payroll group |
| 2 | B | Employer | Specified on the payroll group |
| 3 | C | Identification | Hardcoded - MLE-25-MEDA |
| 4 | D | Employee | Employee number Master data form |
| 5 | E | CPR number | Master data form |
| 7 | G | Last name | Master data form |
| 8 | H | First name | Master data form |
| 9 | I | Address 1 | Master data form |
| 11 | K | Postal code | Master data form |
| 13 | M | First hired | Specified on paryoll widget |
| 14 | N | Master data form | |
| 15 | O | Country code | Master data form |
| 20 | T | Initials | Master data form |
1.2 Benefits
Go to Settings > Templates > Benefits
Benefits in Emply are set up under templates and can contain employee benefits, allowances and deductions as well as pension schemes. Once set up, they can be found on the payroll group where the respective payroll types are set.
Below is an example of different employee benefits:
Examples on supplements and deductions:
Example of setting up a pension scheme:
Below are the benefit types that have been created under templates/benefits in Emply. You can control which ones apply to each payroll group.
These are activated under Settings > Templates > Payroll > where you either create a new group or select an existing Visma Løn group to edit. Under Export you will find the different benefits that can be activated.
Example of an aggregated payroll file:
1.3 Absence types
Go to Settings > Templates > Absence > select Absence
The absence types used in Visma must at least be created in Emply and can be mapped with your Visma absence codes (MLE-55). Absence types that are not used in Visma are omitted in the setup of the payroll group. Below are examples of absence types:
Export of absence registrations supports:
- Registration of absences
- Deleting absence > Note! The entire registration in Emply must be deleted
Example of an absence file:
Explanation of fields:
Note that opening the file in Excel removes the preceding '0'.
1.4 Employment information for Statistics Denmark
Employment information of the company's employees must be provided by employers to Statistics Denmark. Emply must set up the codes they use on the master data form.
Please note that the export of employment information is limited to one type, it is recommended that this is set to IP350.
2. Import of employees
Employees are imported under Employees > Organization, with the Visma Løn form for importing employees, which is selected in the overview of forms:
The payroll info is then imported. Under Employees > Payroll > click on 'Import payroll info' you can download an example of importing a payroll file and which payroll fields the following contains:
- Payroll
- Benefits
- Supplements & deduction
- Pension scheme
For more information on managing the import of employees, see the following article: Import employee information to master data.
For more information on how to handle the import of payroll info, see the following article: Import Benefit information.
Below, employment conditions and fixed salary will be discussed.
2.1 Employment conditions
Note that most employment relationship fields are hardcoded to values on the employee's payroll widget.
Department code can be mapped with Emply's department information.
Dimension codes 1-6 correspond to 'Optional 1-6' in 'MLE-30-ANSF'.
Employment relationship data is set up in different places in Emply, as indicated in the column below:
| Field nr | Excel column | Name | Emply |
| 1 | A | Customer relation | Specified on the payroll group |
| 2 | B | Employer | Specified on the payroll group |
| 3 | C | Identification | MLE-30 |
| 4 | D | Employee | Employee number |
| 5 | E | From date | Payroll-primary.effective date |
| 7 | G | Resignation code | Specified on the payroll group |
| 8 | H | Resignation date | Job title (Payroll widget) |
| 9 | I | Job category | Calculation based on weekly working time of employee |
| 10 | J | Job title | Specified on the payroll group |
| 11 | K | Standard employee time | Payroll widget department - folder specified on the payroll group |
| 13 | M | Payroll group | Form element 'Options' |
| 14 | N | Department | Form element 'Options' |
| 19 | S | Optional 1 | Form element 'Options' |
| 20 | T | Optional 2 | Form element 'Options' |
| 21 | U | Optional 3 | Form element 'Options' |
| 22 | V | Optional 4 | Form element 'Options' |
| 23 | W | Optional 5 | Form element 'Options' |
| 24 | X | Optional 6 | Form element 'Options' |
| 25 | Y | Pay scale | Form element 'Options' |
| 26 | Z | Salary step | Form element 'Options' |
| 27 | AA | Step code 1 | Form element 'Options' |
| 28 | AB | Step code 2 | Form element 'Options' |
| 29 | AC | Step code 3 | Form element 'Options' |
| 30 | AD | Next step date 1 | Form element text DDMMYYYY |
| 31 | AE | Next step date 2 | Form element text DDMMYYYY |
| 32 | AF | Next step date 3 | Form element text DDMMYYYY |
Example of setting up employment relationships
Dimensions are used in Visma Løn for e.g. bookkeeping.
The form element of type 'Options' is set up:
2.2 Fixed salary
Please note that this part must be included in the file.
Please note that only the salary type for salary needs to be filled in.
Activate FTE salary > will send the FTE salary to Visma Løn.
FTE Salary is calculated in Emply based on the salary specified in the agreement. See the example below:
3. Setting up payroll groups
When setting up payroll groups in Emply, you as a customer must provide the following codes in order to set up 'Export':
- Visma codes
- Absence codes
- Severance codes
3.1 Create payroll group(s)
A payroll group must be created in Emply per payroll group in Visma Løn, for example blue and white collar employees.
Go to Settings > Templates > Payroll > create or click on the payroll group and select Export.
You need to enter the following for each payroll group with Visma Løn:
- Company code (same for all payroll groups)
- Employer ID (same for all payroll groups)
- Job category (defines employees on the payroll group)
- Payroll group (defines employees on the payroll group)
Below is an overview of how to set up a Visma Løn payroll group in Emply:
3.2 Payroll file settings
File name
The file name format has 3 options. In addition, the file name can only be used once during loading and can consist of a maximum of 20 characters. This is important to remember if you want to load the files manually during the test phase.
If you are using or considering using Visma's FTP service, the above setting is not important as the files are renamed on the FTP server.
3.3 Records and payroll files
It is possible to send all records in the same file or in separate files:
- Include in file - record will be included with the master data file
- Include in a separate file
- a file is created instead, which can be useful if you manually upload files to Visma Løn
- Do not include - record will not be exported
4. Testing the payroll file
Once the payroll file is set up, it needs to be tested so you can approve the payroll file and delivery.
The test works like generating a regular payroll run and is created by going to Employees > Payroll > click '+New payroll' > enter title, period and payroll group/employees and click 'Generate':
Once the payroll has been generated, it will then be found in the list of payrolls. Here you select the desired payroll run, click on 'Generated files' and click on the generated payroll file(s).
Please note that it is recommended that the payroll file is checked by a Visma Løn consultant.
It is possible to manually handle the payroll files by exporting the payroll file in Visma Løn.
If you want the payroll files to be delivered directly to Visma Løn, you can set up FTP in Emply.
5. FTP setup
With FTP setup, payroll files can be delivered directly to Visma Løn, and with automation setup in Emply.
On the payroll template at the bottom under 'Export', the files can be set up to be sent to Visma's FTP server* or an external payroll partner.
You get the FTP information from Visma, which is filled in. Enter the information and finish by clicking 'Check connection'.
*Note that Visma offers this paid service. They can also offer to set up a test payroll database where the payroll files are tested.
6. Setting up automation
By setting up an automation in Emply, it is possible to create payroll files for your payroll groups automatically.
The payroll files are then automatically sent to your FTP server.
Go to Settings > Automation > click '+ New workflow' > enter title > select 'Payroll group'.
Tap 'Scheduled' and select when to trigger the automation. As shown in the example below, it is recommended that the automation is triggered as late in the week as possible. Therefore, this is selected to be triggered on Sundays at 23:00 every week.
Next, you need to select which criteria must match in order for the automation to be triggered. Here you select 'Payroll group' and then select the desired payroll group. If you want multiple payroll groups to trigger the automation, select the 'or' criteria as shown below. Finish by clicking 'Save'.
Then add the action by pressing '+ Add action' and select 'Payroll integrations'.
Here you can select delay, criterion and period. In this example, 'Current week' is selected for the period. Finish by clicking 'Save'.
Ultimately, automation will look like this: