X-ledger : Employee export

Modified on Wed, 4 Jun at 2:23 PM

Note: This file is currently in BETA version and not available for all customers, please contact us if you are interested in learning more.

X-ledger employee file format

It is possible to export employee data from Simployer One to X-ledger in a *.csv file format. See end of article for example output

Export employees to X-ledger

The employee export is made from People → Export/Import → X-ledger.

When exporting you are giving 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 X-ledger on how to import a xml file containing employee data.

Data that is exported

The following data is present in the export file with the defined logic as described. Other fields are present in the file but are not populated. See example export for full list of "columns" exported.

Simployer One Field	X-ledger field	Example
Employee Number	Code	20001
First name + Last name	Description	Kristin Sunde
Employment types*	Employee Group imp*	see mapping list below
Same as column 2 : navn	Supplier Imp	Kristin Sunde
First name	First Name	Kristin
Last name	Last Name	Sunde
First letter of first name+First letter of last name	Initials	KS
Birth date	Date of Birth	19631216
Social security number	Social Sec	16126345788
Male or Female, if not set or “other” then send blank.	Gender	F
Hire date	Employment From Imp	19990518
Offboarded date. If it does not exist then send blank	Employment To Imp	20101231
End date of probationary employment	Trial Date	Date
”Frivillig” or “Ufrivillig”	Exit Reason Imp
Cost center	Posting 1	2760
Private phone	Phone
Work Phone	Cell Phone
Work email	Email
Private email	Email 2

*Employment types

Simployer One employment types are mapped as follows for the X-ledger import.

Simployer One Employment types	Employee Group imp
Permanent	Fast ansatt
Fixed-term Employment	Tidsbegrenset ansettelse
Probationary Employment	Prøveansatt
Hourly Employent	Timelønnet
Consultant	Oppdrag
Temporary Employment	Midlertidig ansatt
Special Fixed-term employment	Spesiell tidsbegrenset ansettelse
Internship	Praksis

Example output

Code;Description;Employee Group Imp;Supplier Imp;First Name;Middle Name;Last Name;Initials;Alias Name;Prefix;Suffix;Date of Birth;Social Sec;Gender;Marital Status;Employment From Imp;Employment To Imp;Date From Imp;Date To Imp;Seniority Imp;Trial Date;Exit Reason Imp;Position Imp;Position Category Imp;Superior Imp;Timesheet;Overtime;FlexTime;TimeBased;Dummy Imp;Posting 1;Posting 2;XGL;Info;Internal Info;Phone;Phone 2;Cell Phone;Cell Phone 2;Email;Email 2;Text 1;Text 2;Text 3;Text 4;Text 5;Text 6;Value 1;Value 2;Number 1;Number 2;Amount 1;Amount 2;Bool 1;Bool 2;Date 1;Date 2;Date 3;Date 4;Code 1 Imp;Code 2 Imp;Code 3 Imp;Code 4 Imp;End of Line