Import DATEV Employee data

Modified on Thu, 02 May 2024 at 09:45 AM

Once the DATEV integration is active on your account and you have added the employees in the settings (by default all employees are added), you are now ready to add the DATEV employee information.


DATEV requires more detailed employee information beyond what the basic Kenjo employee profile offers. Specific details like Residence permit validity, Social security group and Training start date are integral to German payroll but are not included in the basic Kenjo profile. To ensure seamless synchronization of employee data between Kenjo and DATEV, we've expanded the Kenjo employee profile for those with DATEV activation. This extension incorporates all necessary fields required by DATEV for accurate payroll calculations. To access these fields, navigate to an Employee profile and scroll down to DATEV Specific Wage Data.

For a comprehensive list of DATEV fields that can be sync to DATEV from Kenjo, refer to the bottom of this article.

How do I add the employee fields to Kenjo? 

You have 2 options to add the DATEV employee fields to Kenjo.


Manually add the DATEV data 

Admins and employees can manually add the DATEV data to their employee profiles. 

  1. Go to  People > Directory
  2. Select employee > Personal  > scroll to DATEV Specific Wage Data.

3. Insert the DATEV employee information into the editable fields. 

4.Fill out the Excel, tab DATEV

Important Reminders:

Dropdown Selections: Certain fields are dropdown menus. Please exclusively choose options from the dropdown menu. Copy-pasting values into these fields may lead to errors during the import process.

Prepopulated Template: If employee DATEV fields were previously added, the template will auto-fill with this information. You can edit any DATEV-specific fields as needed.

Name and Email Restrictions: The first name, last name, and email address cannot be modified here. Any changes made in this section won't reflect in Kenjo

 Top tip! You can extract all the DATEV master data for your employees from DATEV. Follow the steps in Extract Master Data from DATEV for accountant.

5.Once the template is ready to upload. Drag and drop the file to Kenjo or upload it from your computer and click on UPLOAD.

6.You will then be asked to map the columns from the excel sheet to fields in Kenjo. Each column should be mapped. We have already mapped as many as possible based on their names. Anything that isn't automatically mapped can be manually mapped with the dropdown menu. You can always choose Don't import column. When you are done, click on CONFIRM.

7.Lastly, choose the import name and click on FINALISE IMPORT. 


Note: When you download the template, do not reorder, delete or add any columns. For the import to properly work, the structure sheet needs to stay as it is.

Important: Before you can extract the first DATEV payroll file, all the Employee information in Kenjo must  match your employee information in DATEV. This way, you can easily do your monthly payroll without any mistakes.  Do consider that from this point on, the source of truth will be Kenjo. This means that the information you would like to change about your employees, need to first be changed in Kenjo. This change will then be automatically synced with DATEV during the monthly payroll period.  

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article