Please note that the content of our website (including any legal information) is intended solely for the purpose of providing non-binding information and does not constitute legal advice. The content of this information cannot and should not replace individual and binding legal advice that addresses your specific situation. In this respect, all information is provided without guarantee of being correct, complete, or up to date. 

This article explains how you can use a DATEV DALY export as a year-to-date import (YTD) for the implementation of Personio Payroll to facilitate a successful system change. For general information on year-to-date imports, read our article.

What is the DATEV DALY export?

The DATEV data analysis system (DALY) allows the export of payroll data. This can then be transferred to a compatible system. Benefits of using a DALY export as a YTD import

If you have previously done your payroll via DATEV, the DALY export is a simple and secure solution for providing the carryover values for the YTD import. To use the DALY export successfully, carry out your payroll in DATEV immediately before the system change.

How to export a DALY in DATEV

You can request a DALY export from your DATEV payroll accountant. As the export is not a standard export, you can create it individually. You can find instructions on how to create the export in this article and this article in the DATEV Help Center.

You can find a list of all the fields that the DALY export must contain for the YTD import under Downloads at the top right. 

Important information on the DALY Export

Note the following about the DALY export: 

• Fields
  • Complete the fields: Check that all the fields from the list are complete.
  • Use exact field names: Ensure that the field names are exactly as they appear in DATEV, including spaces.
  • Order of the fields: Does not matter.

• Included employees
  • Personio ID: This is not relevant for the import; use the tax identification number and social security number instead.
  • Exclude outgoing employees: Ensure that any employees who were terminated before the transfer to Personio Payroll are not included in the export.

• File details
  • Create a year-based file: Create the file for each year individually, not for all years. Example: In cases covered by the so-called March clause.
  • Select the payroll month: In the Payroll month field, select the last month before the first real payroll in Personio Payroll .
  • Data source for the export: As data source for the export, select RZ-Lohn for LODAS or Lohn und Gehalt for LUG.
  • Generate values for a specific period: Generate the values from 01.01. to the last day of the month before your first live month with Personio Payroll.
  • Condense evaluation: Condense the evaluation to one line per employee according to the Tax identification number attribute.
  • File format: Make sure that the file format is *.xls or *.xlsx.

Import of the DALY export in Personio Payroll 

Once the file is complete, send it to our Payroll Specialists. They will then take care of the import into Personio.