This article explains how to produce the file for the Danish Maternity Fund and what data and format it has.

Description

Reporting to the Maternity Fund in Danske Rederier must be done via upload of a CSV file, reporting periods – quarters.

The specification provided in Danish below. And translated to English further in this article.

Adonis export file is located under Tools > Export > Danmarks Rederiforening > BUR.

Note that the export only creates files with historical payroll data and does not include the current payroll period data.

Dialog window has two format options. Option TXT creates the file of the old format, which has been in use until the year 2021. From the year 2021, a new web portal has been opened, which excepts files only in CSV format.

Adonis version to use

Adonis has added the new CSV format and all the necessary export settings from Adonis Personnel Manager v.2020.60.8.1

Format

CSV file semicolon-separated

Structure

The CSV file must contain 7 columns, each with its header that describes the column contents
Headers should always be the first line of the file
Each employee is represented by 1 separate line in the file
Separators in the file must be “;” (semicolon)
The specific contents of the csv file are specified in the next section

Example

cpr;first_name;last_name;amount;register;atp;quarterly_hours

010280-3762;Sam;Petersen;450,00;DAS;284,00;480,99

010280-3763;Alice;Petersen;450,00;LAND;284,00;480,99

010280-3764;Benny;Petersen;450,00;DIS;284,00;480,99

Specifications

Column 1 - CPR

Employee Social Security number in format 221280-2040 or 2212802040

Adonis: Datagroups > Personal Details > Personal ID

Column 2 – First_Name

Employee First Name

Column 3 – Last_Name

Employee Last Name

Column 4 - Amount

Employee’s total contribution to the Maternity Fund (Barselsfond) in the reported period.

The amount must be rounded to 2 decimals and comma-separated like this:

50,00 or -50,00

If the amount is negative, it will get a “-“ in front of it. If the amount is positive, it does not need any calc sign in front.

Adonis data-fetching: Org.Structure > Reports > Danish reporting > Danmarks Rederiforening > Barselsfond > EC for Barsel amount, Field for Barsel amount.

These settings identify which Entry Code number and amount will be picked up from the payroll history to the export file.

Column 5 - Register

Employee contractual relationship. The column indicates whether the employee has been employed on a “regular” LAND collective agreement (only for employees on land), DAS agreement (gross salary), or whether the employee has been employed on a DIS agreement (net salary).

For each employee, 1 value must be reported (either DIS or DAS or LAND). The value must be stated in capital letters.

Adonis: Org.Structure > Reports > Danish reporting > Danmarks Rederiforening > Barselsfond > Field for Contract Code.

These settings identify which Entry Code number and field will be picked up from the payroll history to the export file.

Column 6 - ATP

The content of this column must be the total employer and employee contribution to ATP for the employee in the quarter in question (collection quarter).

The amount must be rounded to 2 decimals and comma-separated like this:

852,00 or -852,00

If the amount is negative, it will get a “-“ in front of it. If the amount is positive, it does not need any calc sign in front.

Adonis: Org.Structure > Reports > Danish reporting > Danmarks Rederiforening > Barselsfond > EC for ATP, Field for ATP employer amount, employee amount.

These settings identify which Entry Code number and amount will be picked up from the payroll history to the export file.

Column 7 – Quarterly_hours

Employee total work hours in the reported period.

480,99

The number must be rounded to 2 decimal places and must be comma-separated, as in the above example.

Adonis: We received information from a Danish customer, that it does not need to be taken from the crew's Timesheet. It can be calculated as normal work hours per month (160.33 hours according to the contract) prorated per the days that the Maternity Fund deduction is taken.

Org. Structure > Reports > Danish reporting > Danmarks Rederiforening > Barselsfond > Field for normal monthly work hours with free input, Field for Basel days.