In the payroll export, Circula allows for the export of payroll tax-relevant data. For this we offer the following formats:

  1. 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

2. DATEV LODAS

This export is used for the import to DATEV LODAS.

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;


Do you still have questions?

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

Did this answer your question?