Export timesheets to DATEV
Export calculated hours as a DATEV import file for LODAS or Lohn und Gehalt, ready for you or your tax adviser to import. Timeclock.Kiwi totals each person’s hours per Lohnart for the month, so payroll in DATEV starts from complete, accurate time records.
Available for DATEV in Germany.
How the DATEV export works
- Track hours automatically. Staff clock in and out on the tablet kiosk or mobile app, and Timeclock.Kiwi totals their time for you.
- Pick your pay period and format. Open Export Times, choose who and when, then select DATEV as your format.
- Send it to payroll. Export payroll-ready hours and bring them into DATEV, with no retyping timesheets.
What the DATEV file looks like
One row per person, per Lohnart, with the month’s total hours and a decimal comma. Each person is matched by their Personalnummer, and the file also carries your Beraternummer, Mandantennummer and payroll month.
| Personalnummer | Lohnart | Stunden |
|---|---|---|
| 123 | 1000 | 160,50 |
| 123 | 1300 | 12,00 |
| 124 | 1000 | 86,25 |
DATEV export questions
Does Timeclock.Kiwi connect directly to DATEV?
No. You download an import file from Timeclock.Kiwi, and you or your tax adviser import it in LODAS (Mandant > Daten übernehmen > ASCII-Import) or in Lohn und Gehalt (Erfassen > Bewegungsdaten > Importieren). Nothing is sent to DATEV until the file is imported.
How are staff matched to their DATEV records?
By Personalnummer, the employee number in DATEV. You enter it once per person in Timeclock.Kiwi, along with your Beraternummer and Mandantennummer for the export. Anyone left blank is excluded from the export.
Can night, Sunday and holiday hours go to different Lohnarten?
Yes. Pay rules split hours by time of day, day of the week, public holidays (including each German state’s own holidays) or hours over a weekly limit, and each rule books its hours to the Lohnart number you choose.
Which payroll month do the hours go into?
The month of the last day you export, or the following month if you pay variable hours a month in arrears. You choose this once in the export settings.
Learn more about DATEV.
Free for 3 months, no credit card required.