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:
Payroll Import Data Service
Learn in this article how you can automatically transfer Circula data to DATEV for payroll accounting.
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
Go to Approve & Control and click on the Payroll Export tab.
Select the employees costs you want for payroll by placing a check mark next to their names.
Click on Export, select the appropriate month in which you would like to have the cost rates calculated for payroll disbursement.
Click on the Export button at the bottom left.
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