Note: This file is currently in BETA version and not available for all customers, please contact us if you are interested in learning more.
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.
Data that is exported
The following data is present in the export file in a valid Hogia Lön Plus format (see example below).
Alexis Field | Hogia Field | Example |
Employee number | AnstNr | 12 |
Date for the current compensation startdate | HistorikDatumTid | “2023-01-01” |
lastName + firstName | Namn | “lastName firstName” |
Social security number | Personnummer | “12345678-1234” |
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 | Personligt_lönefält_1 | 20000 |
Full time Compensation | Personligt_lönefält_2 | 40000 We will need to recalculate this if the employee is part time employed. RATE from current employment as calculation. |
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 |
Clearingnumber - Bank account | Bankkontonummer | “1234-5678910” |
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 |
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