Dataløn File Export

The Dataløn file export is not an integration, but a guide to setting up the export of absence for Dataløn. You can extract the relevant data from Emply to be manually edited and manually uploaded to Dataløn.

Setup absence templates

In this example, we would like to export absence records on payroll types 47 (vacation days) and 77 (Additional holidays). Here it is important to check that the absence templates are set up correctly, depending on whether it is recorded as days or hours.

From the main menu, go to Options+Templates+Absences.
Click Allowances and select the appropriate allowance from the list.
Check that the title and registration form are correct.
1. Holiday days are here selected to be recorded as days.
2. During holidays, hours are selected here so that these are recorded as hours.

Setup salary template

From the main menu, go to Preferences+Templates+Salary, and click + New Group.
Give the group a title and select the created export file as the payroll system. In this case Absence DATALØN.
From the main menu, go to Employees and select the employee.
Open the salary widget and select the desired salary group. In this case Absence DATALØN.

Setup payroll template

You now need to create an export file.

From the main menu, go to Settings+Integrations+Export.
Click + New export, select Excel/CSV and click Continue.
Give the export file a title and assets Use as export to payroll system.

Example 1. Example of how the export file is set up

Company number is entered as New value where you fill in the column title yourself as well as the column value, in this case 10931533. Company number can also be added on master data, thereby adding as existing element. Also in the event that the employees have different company numbers.

Salary term is also entered as New value where you need to fill the column title but not the column value, as this is added manually after the export file is generated.

Salary number is added with Add existing element and is filled in automatically. In this case, salary number is the same as employee [employee.number].

Type of salary and number are added as New value where only the column title is filled in. The column value should be left blank, as you need to manually move the salary species and the number in the generated Excel file

Salary type 47 shall be added by Add existing element and is filled in automatically. In this case, the vacation days must be filled in as days spent [absence.vacation.used.days].

Salary item 77 shall be added by Add existing element and is filled in automatically. In this case, the vacation days must be filled in as hours spent [absence.additional_holidays.used.hours].

Create payroll

From the main menu, go to Employees, Payroll and click + New Payroll.
Fill in the title of the payroll, select the period, as well as which group or employees to pick up absence registration from. Finish by clicking Generate.

Once the payroll is generated, it can be found on the payroll list.
Click on the desired payroll.
Click Files generated to find the generated export file.
Click on the Excel file to retrieve it.
Open the generated Excel file. Here you need to manually fill in Salary term, as well as moving the values to Salary types and Amount.
Data salary only accepts one pay record per line per employee and therefore each absence record must have one row in the file. Like the example below, where employee 1029's two registrations are split up on two lines. In addition, the number of days and hours has multiplied by 100