All Collections
Imports and Exports
Exports for DATEV LODAS and Lohn- und Gehalt
Exports for DATEV LODAS and Lohn- und Gehalt

Description of DATEV payroll exports for LODAS and Lohn- und Gehalt

Eileen Rohlfs avatar
Written by Eileen Rohlfs
Updated over a week ago

In the payroll export, Circula allows for the export of payroll tax-relevant data which can be further processed in DATEV. For this we offer the following formats:

  1. Payroll Import Data Service

    Learn in this article how you can automatically transfer Circula data to DATEV for payroll accounting.



  2. DATEV Wage and Salary Export ("DATEV Lohn und Gehalt Export")

This export is used for the import into DATEV Lohn und Gehalt. The file itself has a .txt extension and is therefore a text file with a special format.

The content can be represented, in a simplified way, as follows. In the file itself, there is no table, the table here is simply used for a simplified representation.

Consultant Number ("Beraternummer")

Client Number ("Mandantennummer")

Target Month

Employee Number ("Personalnummer")

Wage Type Number ("Lohnartnummer")

Amount

Employee Number

Wage Type Number

Amount

Employee Number

Wage Type Number

Amount

Here is a version with example values:

123456

54321

04/2021

1111111

1108

98,00

222222

1108

100,00

222222

2202

40,00

In the export file, the values look like this:

123456 54321 04/2021

1111111 1108 98.00

222222 1108 100.00

222222 2202 40.00

Please note: When downloading, you will normally receive a zip file that contains one txt file with transaction data (bewegungsdaten.txt). If the capital letter M ("Großbuchstabe M") is added to the master data of a person in the relevant export month, the zip folder will also contain a file with master data (stammdaten.txt).

We recommend that you do not make any manual changes to the export data in the file, as this may result in errors.


3. DATEV LODAS

This export is used for the manuell import to DATEV LODAS.

This is how the export works

  1. Go to Approve & Control and click on the Payroll Export tab.

  2. Select the employees costs you want for payroll by placing a check mark next to their names.

  3. Click on Export, select the appropriate month in which you would like to have the cost rates calculated for payroll disbursement.

  4. Click on the Export button at the bottom left.

  5. The export will start and the LODAS file will be saved to your local download folder.

Manual export of the DATEV payroll file

It is a .txt file with the following content:

[General]

Destination=LODAS

ConsultantNo={Consultant number}

ClientNo={client number}

In German:

Ziel=LODAS

BeraterNr={Beraternummer}

MandantenNr={Mandantennummer}

[Record Description.]

1;u_lod_bwd_buchung_standard;pnr#bwd;abrechnung_zeitraum#bwd;bs_wert_butab#bwd;bs_nr#bwd;la_eigene#bwd;

2;u_lod_bwd_buchung_nachber;pnr#bwd;abrechnung_zeitraum#bwd;nb_datum_mm#bwd;bs_wert_butab#bwd;bs_nr#bwd;la_eigene#bwd;

[transaction data]

1;{employee number};{target month};{amount};{processing key};{wage type number};

Using the same example values as above, the file looks like this:

[General]

Target=LODAS

ConsultantNo=123456

ClientNo=54321

[Record Description.]

1;u_lod_bwd_buchung_standard;pnr#bwd;abrechnung_zeitraum#bwd;bs_wert_butab#bwd;bs_nr#bwd;la_eigene#bwd;

2;u_lod_bwd_buchung_nachber;pnr#bwd;abrechnung_zeitraum#bwd;nb_datum_mm#bwd;bs_wert_butab#bwd;bs_nr#bwd;la_eigene#bwd;

[Transaction data]

1;1111111;01.04.2021;98,00;3;1108;

1;222222;01.04.2021;100,00;3;1108;

1;222222;01.04.2021;40,00;3;2202;


Example of a manually downloaded LODAS txt-file


Do you still have questions?

💬 Chat Support
📞 +49 30 588 491 01
✉️️ support@circula.com

Did this answer your question?