Salary Identifiers

TABLE OF CONTENTS

• Transfer of Salaries to DATEV
•  Transfer fixed additional payments (using the DATEV fix salary table) to DATEV
• Hourly salaries
• Transactional data (Bewegungsdaten)
• Hourly attendance data

You can transfer the following salary and wage data from Kenjo to DATEV:

Salary and hourly rates (master data):

• Fixed salaries 
• Fixed additional payments 
• Hourly salaries

Variable data (Transactional data):

• Variable additional payments 
• Hourly attendance

Transfer of Salaries to DATEV

To transfer Kenjo monthly and yearly salaries to the DATEV fixed salary table (Festbezüge), go to DATEV settings > Salary Identifiers > Fixed salary mapping. 

Then you need to enter the corresponding Salary Number (Lohnart-Nr.) and Fixed income number (Festbezug-Nr.) for your salaried employees in the below mapping table. These will be applied to all salaried employees activated for this DATEV company.

These codes can be found in the DATEV fixed salary table (Festbezüge)

Important onboarding notes

It is crucial that the Fixed Income ID (Festbezug-Nr.) and Salary Number (Lohnart-Nr.) in Kenjo match those in DATEV for each employee.

Therefore, if in DATEV your employees have different Salary Numbers (Lohnart-Nr.) and/or different Fixed Income IDs (Festbezug-Nr.) for the fixed salary, you must follow the below steps. This is typical for Managing directors, Trainees and Working Students.

1. Export master data from DATEV using these these instructions : DATEV Dataservices for accountants
2. Using the Kenjo DATEV import wizard,  add the correct numbers for each employee to the columns in the downloadable template. This is only for the fixed income. 

• Column Festbezug Lohnart Nummer = Salary Number (Lohnart-Nr)

• ColumnFestbezug ID = Fixed Income ID (Festbezugs ID)

Another option is to manually add the codes to the employee's personal profile > SHOW DATEV FIELDS and enter the codes in the fields Fixed Income ID (Festbezug-Nr.) and Salary Number (Lohnart-Nr.)

Transfer fixed additional payments (using the DATEV fix salary table) to DATEV

To transfer fixed additional payments, such as Internet or childcare, from Kenjo to the DATEV fixed salary table (Festbezüge) go to DATEV settings > Salary Identifiers > Fixed additional payment table. 

Then add a variable pay type, by clicking on ADD variable pay type. If the desired pay type is not listed, you can add it in Settings > Payroll > Compensation > Variable pay types > + Variable pay type. Once selected, enter the corresponding Salary Number (Lohnart-Nr.) and Fixed Income Number (Festbezug-Nr.) for this fixed payment in DATEV.

These numbers can also be found in the Fixed remuneration table in LODAS and Lohn und Gehalt.

Important onboarding notes
For error-free data transfer, it is essential that the Fixed Income IDs (Festbezug-Nr.) and Salary Numbers (Lohnart-Nr.) are consistent for each fixed additional payment across all employees.

An example when the codes don't match:

The fixed additional payment Jobticket ST + S is configured in Kenjo as:

However, if an employee has this payment already set up in DATEV with the fixed income number as 3 instead of 6, it will result in a discrepancy. Consequently, when the file is imported into DATEV, it will interpreted as a new additional payment and add it again to the fixed payment table, resulting in double payment.

For further information on the harmonisation of the DATEV Fixed Income IDs (Festbezug-Nr.), please contact your DATEV support and find out more about the following help document: https://apps.datev.de/help-center/documents/1018836

Hourly salaries

To transfer the employee's hourly rate from Kenjo to the DATEV hourly rate table (Studenlohn), go to DATEV settings > Salary Identifiers > hourly salary mapping and enter the Salary Number (Lohnart-Nr) for the hourly wage (Gehalt) in DATEV.

Note: We only support the transfer of one hourly wage per employee. Hourly wages for salaried employees (for surcharges, overtime etc) should be managed directly in DATEV.

Transactional data (Bewegungsdaten)

Variable payments

You can transfer variable additional payments for an employee from Kenjo to the DATEV 

Variable additional payments are located in the "Bewegungsdaten" (transaction data) file:

• For DATEV LODAS: Bewegungsdaten > Erfassungstabellen > Standard
• For DATEV Lohn und Gehalt: Bewegungsdaten > Stapelerfassung Monat

. 

These may include bonuses, additional awards, and payouts of accumulated overtime.

To add a variable pay type,  go to DATEV settings > Salary Identifiers > Variable additional payment table. Then add a variable pay type by clicking on the ADD variable pay type. If a variable pay type is not available, please add it by going to Settings > Payroll > Compensation > Variable pay types > + Variable pay type. Once you have selected the variable pay type, enter the Salary Number (Lohnart-Nr.) for this payment in DATEV. 

Variable additional payments sent to DATEV LODAS are transmitted with the processing key (BS) 2: Bruttobezug (gross payment). Net salaries/net deductions (processing key 3) are currently not supported.

Hourly attendance data

You can transfer hourly attendance entries from Kenjo to DATEV. 

To do this you first need to make sure that:

1. Attendance settings > Attendance tracking is enabled for the employee 
2. DATEV settings > Employee fields >  Hourly salary and attendance tables have been  
3. DATEV Settings > Salary identifiers > Salary Number for the hourly mapping has been configured

Attendance data sent to DATEV LODAS is transmitted with the processing code (Bearbeitungsschlüssel): 1 -  Hours

Important notes for the transactional data: Double entry risk

Your accountant can only upload the transaction data file once per month to DATEV. If the same file is uploaded more than once, the variable payments and/ or attendance data will be added again, leading to double entry. 

Lohn und Gehalt transaction definition

The existing DATEV template Bewegungsdaten (Standard) is used to import attendance and one-time compensation data into Lohn und Gehalt. If your accountant has adjusted this template, the data from Kenjo may be imported with error messages.