Export in Hogia Lön Plus format
The employee export is made from People → Export/Import → Hogia Lön Plus .
When exporting you are given the choice to export all active employees or to customize the report to only filter out a subset of employees (currently only organization available).
The file will then download and you can from then refer to the documentation for your specific payroll system on how to import the file.
Note: If Hogia is not available as an option, make sure you have configured the integration as described in this article
Data that is exported
The following data is present in the export file in a valid Hogia Lön Plus format (see example below).
Note : If a field is EMPTY in Alexis HR the default behaviour will be that it is NOT sent in the file. You can change this from Settings -> Integrations, and thus send empty values that then will override/blank out that data in Hogia Lön Plus.
Alexis Field | Hogia Field | Example |
Employee number* (see below for exception) | AnstNr | 12 |
Date for the current compensation startdate | HistorikDatumTid | 2023-01-01 |
firstName + lastName | Namn | John Doe |
Social security number | Personnummer | 12345678-1234 |
firstName | Förnamn | John |
lastName | Efternamn | Doe |
Home address - Street name | Utdelningsadress | Vävarstigen 124 |
Home address - Zip code | Postnummer | 11157 |
Home address - City | Postadress | Nyköping |
Work phone | Telefonnummer | 073-6823609 |
Home address - Country | Land | Sweden |
Private phone | Telefonnummer_2 | “” |
Work email | E_mail | |
Current Actual Compensation (Monthly employed) | Personligt_lönefält_1 (Will only be included If the employee payperiod is monthly ) | 20000 |
Current Full time Compensation | Personligt_lönefält_2 (Will only be included If the employee payperiod is monthly ) | 40000 We will need to recalculate this if the employee is part time employed. RATE from current employment as calculation. |
Current Actual Compensation (Hourly employed) | Personligt_lönefält_3 (Will only be included If the employee payperiod is hourly ) | 150 |
| Personligt_lönefält_7 | Custom logic. See below for details |
Actual hours per week | Personligt_lönefält_8 | We use the RATE of employment and then multiply with 40. |
Full time week hours | Personligt_lönefält_9 | 40 |
| Personligt_lönefält_12 | Custom logic. See below for details |
Clearingnumber - Bank account | Bankkontonummer | 1234-5678910 |
Clearingnumber | Clearingnummer_ISO | 1234 |
Bank account | Bankkontonummer_ISO | 567890 |
CFAR number (from Office) | CFARnummer | 12345678 |
Workplace number SCB (from Office) | Arbetsställenummer | 123 |
Workplace number SNI (from Office) | Arbetsplatsnummer | 1 |
costcentercode | Resultatenhet_1 | 124 |
Hire date | Anställningsdatum | 2023-01-01 |
Tax Table | Skattetabell | 30 |
Tax column | SkatteKolumn | 1 |
Offboarded date/End date | Avgångsdatum | 2024-02-29, "0" if no end date is registered |
Century (19 for 19XX, 20 for 20XX | SekelPersnr | 19 |
Emergency contact name | AnhörigNamn | First record of the Emergency contact in Alexis |
Emergency contact phone | AnhörigTel1 | First record of the Emergency contact in Alexis |
Custom logic
*Employee number : If an existing custom field exists named "Hogianumber" and is populated on the employee then that number will be exported as Hogia AnstNr in the file. If this field does not exist the Alexis Employee number will be used.
*Personligt_lönefält_7 : Individual compensation
This field is populated in the Hogia employee file if there is an active additional compensation is created on an employee with Salary Code = P7
If that is the case then the amount from that additional compensation will be added to the file as Personligt_lönefält_ = Amount
Example : Employee has an additional compensation with Salary Code = P7 and amount 15000. Then the file would contain Personligt_lönefält_7 = 15000
*Personligt_lönefält_12 : Provision % compensation
This field is populated in the Hogia employee file if there is an active additional compensation is created on an employee with Salary Code = P12
If that is the case then the amount from that additional compensation will be divided by 100 and added to the file as Personligt_lönefält_12 = Amount / 100
Example : Employee has an additional compensation with Salary Code = P12 and amount 37.5. Then the file would contain Personligt_lönefält_12 = 0.375
Example output in valid format
Click here to expand
Click here to expand
Filhuvud
Typ="Anställda"
SkapadAv="AlexisHR to HogiaLön Plus"
DatumTid="2024-03-05 09:52:29"
Pstart
Typ="Anställda"
AnstNr=107
HistorikDatumTid="2024-03-01"
Namn="Rob Banks Create 107"
Personnummer="19940506-9296"
Utdelningsadress="Hargebadsvägen"
Postnummer="871 31"
Postadress="Härnösand"
Telefonnummer="+46709123455"
Land="SE"
Telefonnummer_2="+4670123111"
E_mail="[email protected]"
Personligt_lönefält_1=15000
Personligt_lönefält_2=15000
Personligt_lönefält_8=40
Personligt_lönefält_9=40
Bankkontonummer="1234-56789012345"
Resultatenhet_1="2"
Anställningsdatum="2022-09-28"
Skattetabell=30
SkatteKolumn=1
Avgångsdatum="0"
SekelPersnr="19"
AnhörigNamn="Lisen"
AnhörigTel1="+4670123456789"
Pslut