DeelđŸ€solution for managing payroll, HR and compliance for international teams

How the connector works and how to set it up with Deel

How integration works

      • Solutions concerned: Core HR and Payroll
      • Integration type: Flat file
      • Sense of integration: Lucca to Deel

Foreword

Setting up an FTP

To set up the integration, the administrator of the Lucca database must set up an FTP . This will automatically synchronize data on users, establishments and salaries.

Setting up the integration

1. Export of employee data

When sending employee data to Deel, an export must becreated that includes the following data:
    • Payroll number
    • Address
    • Zip code
    • First name
    • Last name
    • Country of residence
    • City
    • Job title
    • Date of effect
    • Business email
    • Contract start date
    • Full-time equivalent (value to be created in exports) 
    • Full-time (drop-down list to be created in export)
    • Contract start date

To help you, you can consult these two help sheets:

The settings for this export must be as follows:

  • File templates:
    • File name: data_{{config.name}}_{{export.date}}_{{export.hour}}_{{export.period}}
    • Format : CSV
    • Encoding: UTF-8 without BOM
    • Culture: English
    • Date format: MM/dd/yyyy
    • Field separator: Semicolon
    • Decimal separator: Dot
    • Include in export file: check ‘Only modified employees’ and ‘Employees created and updated’
  • File structure
Lucca Data / Body Header Comment
Payroll number employeeNumber  
Address addressLine1  
Zip code zip  
First name firstName  
Last name lastName  
Country of residence country  
City city  
Job title jobTitle  
Date of effect jobEffectiveDate  
Business email workEmail  
Contract start date startDate  
Full-time equivalent fte the data must be between 0.1 and 1
Job type employmentType the data must be Full Time or Part Time
Contract start date employmentEffectiveDate  
Establishment’s city localization  

Update data via import into Lucca

If you need to update employee data en masse, please refer to the dedicated sheet: Importing employee data

2. Export of establishments

Another export must be configured to import establishments from Lucca to Deel.

The settings for this export must be as follows:

  • File templates:
    • File name: establishment_{{config.name}}_{{export.date}}_{{export.hour}}_{{export.period}}
    • Format : CSV
    • Encoding: UTF-8 without BOM
    • Culture: English
    • Date format: MM/dd/yyyy
    • Field separator: Semicolon
    • Decimal separator: Dot
    • Include in export file: check ‘All employees’.
  • File structure
Lucca Data / Body Header
Establishment code companyId
Establishment name companyName

3. Export of payroll

To send payroll data, you will need to create a generic payroll export.
In terms of settings, here are our recommendations:
  • In the Export scope, select the establishments and population concerned, as well as the fixed and variable payroll elements to be exported to Deel. The configuration name must be Compensation export
  • In Export data and format, you can select the "Institution (code)", "Employee (payroll number)" and "Employee (login)" fields to be included in the export. 
    Check the box
    ‘Show only active natures linked to the establishments in this export’
      • File name: compensation_$[configName]_$[exportDate]_$[exportPeriod]
      • Format : CSV
      • Encoding: ANSI
      • Date format: MM/dd/yyyy
      • Field separator: Semicolon
      • Check the Use inverted commas (‘’) box to force text format in the generated file
  • In Automated exports, configure FTP export with only the export file(s)

Page content

Was this article helpful?
0 out of 0 found this helpful