Visma Lön 600 Time off export | AlexisHR

Alexis has the possibility to export time off data in a .tlu file that can be exported into Visma Lön 600.

Description

The export file contains absences for all employees in the selected period and also contains normal working times for those employees based on the work week settings in the employee profile.

The downloaded file will be named :

VismaLon6006537654adbe2a40018d1323b_2023-10-01_2023-10-31_2023-10-24.tlu

VismaLon600[unique export fileid]_[start date of period]_[enddate of period]_[date of generation].tlu

Creation of export file

Export in *.tlu format

You initiate the Visma Lön 600 time off export through Manage time → Export time off.

Select the absences you wish to export with the selection options and checkboxes. You can read more about the Export time off view here

After selecting Export, choose Visma 600 as the file format for download.

The export will be startad and after it´s finished it will download a file in Visma Lön 600 format.

Configuration

In order for the export to work properly there are a few things that needs to be configured.

Company number (swe:organisationsnummer) needs to be filled in under Company profile - company information.
All used leaves needs to have a matching Leave type code, otherwise they cannot be matched when imported into Visma Lön 600.
- Leave types are configured under Settings → Time off settings → selected leave type . You can read more about setting up leave types here
Employment number must match the employees employment number in Visma Lön 600 in order to be able to import it correctly.
First name & Last name needs to be present for the users.

Content

The file will contain time off data for the employees in the selected period and we will send all absences day by day as they have been entered into Alexis.

Example

An absence is added with the following data:

Leave type Vacation with leave type code Code 040
Full day leaves for 2023-10-01--2023-10-06 (Sunday-Friday)
Employee has a defined work week as Monday-Friday (08:00-12:00,13:00-17:00)
Employee has an employee number of 12

This would be represented as below in the export file under as follows

<?xml version='1.0' encoding='ISO-8859-1'?>
<SalaryData ProgramName='AlexisHR' type='SalaryData' Created='2023-10-24'>
    <TimeCodes>
        <TimeCode Code='040' TimeCodeName='Vacation' />
        <TimeCode Code='050' TimeCodeName='parental_leave' />
    </TimeCodes>
    <SalaryDataEmployee FromDate='2023-10-01' ToDate='2023-10-31'>
        <Employee EmploymentNo='12' FirstName='John' Name='Doe' FromDate='2023-10-01'
            ToDate='2023-10-31'>
            <NormalWorkingTimes>
                <NormalWorkingTime DateOfReport='2023-10-01' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-02' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-03' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-04' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-05' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-06' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-07' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-08' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-09' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-10' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-11' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-12' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-13' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-14' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-15' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-16' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-17' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-18' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-19' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-20' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-21' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-22' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-23' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-24' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-25' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-26' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-27' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-28' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-29' NormalWorkingTimeHours='0' />
                <NormalWorkingTime DateOfReport='2023-10-30' NormalWorkingTimeHours='8' />
                <NormalWorkingTime DateOfReport='2023-10-31' NormalWorkingTimeHours='8' />
            </NormalWorkingTimes>
<Times>
<Time DateOfReport='2023-08-01' TimeCode='040' SumOfHours='8.00'/>
<Time DateOfReport='2023-08-02' TimeCode='040' SumOfHours='8.00'/>
<Time DateOfReport='2023-08-03' TimeCode='040' SumOfHours='8.00'/>
<Time DateOfReport='2023-08-04' TimeCode='040' SumOfHours='8.00'/>
<Time DateOfReport='2023-08-05' TimeCode='040' SumOfHours='0.00'/>
<Time DateOfReport='2023-08-06' TimeCode='040' SumOfHours='0.00'/>
</Times>
<TimeAdjustments />
<TimeBalances />
<RegOutlays />
</Employee>
</SalaryDataEmployee>
</SalaryData>