Welcome to our FAQ page! Here you’ll find answers to the most common questions about our products and services. This page is designed to provide you with quick and helpful information to support you in using our platform. Whether for setup, troubleshooting, or tips for optimal use, our FAQs offer comprehensive support.
Warning
The new Datev Export is valid from Xentral version 23.17.3 and later versions. The service is only available on our cloud.
Note
We are continuously working to enhance the new financial accounting export and to incorporate your feedback directly into development.
If any issues arise, please update to the latest Xentral version to benefit from the newest improvements.
You can find all changes and updates in the Release notes (all versions in 2023).
If you are working on a very old Datev Export version (before 2018) or if you are preparing Datev Export for other accounting systems, it may be that due to new features of the export and the related API, old functions are no longer available or have been replaced by new fields on the part of Xentral and Datev. If you encounter problems with your version, you can quickly find the most important questions and answers in this FAQ list.
If you can’t find a question here, please create a support ticket.
The validation checks the export for valid characters according to Datev requirements, which otherwise might be truncated, ignored or imported incorrectly when imported into DATEV. This does not necessarily mean that this check is relevant in your case. Therefore, please deactivate the CSV validation in the Financial Accounting Export module first (option: Deactivate CSV validation) and check if your export is ok. Feel free to create a support ticket if you have problems despite deactivating the validation.
Please deactivate the CSV validation in the Financial Accounting Export module (option: Deactivate CSV validation) or store a pseudo advisor/client number in the Settings tab.
For the Datev export, a client and advisor number is mandatory, so that your tax office receives an automatic assignment of your data to your company. If you import the Datev accounting export into other systems and you don’t have a consultant and client number, you can assign a five-digit number yourself. The number is transferred in the export format, e.g. in the header.
If you have used the Datev export only for single projects and have not assigned a consultant number as default, add an entry without project as fallback. This consultant number is used for exports without project assignment and prevents you from getting an error message here.
Steps:
Add an entry without a project by entering consultant number, client number, G/L account length and business year in a New Entry. In this case, just leave the Project field empty.
Our export is designed for DATEV and therefore always supports the latest DATEV format. Please write us a ticket if and why you can’t use the new format and we will be happy to check your case.
In the new version of the Financial Accounting Export we have adjusted the file names so that they correspond to the recommendations and requirements of DATEV. The old file name was previously chosen individually by Xentral.
The new financial accounting export includes a validation of your data. Among other things, the bank details (IBAN, BIC) stored in your contacts are checked for validity and conformity.
Please deactivate the CSV validation so that the export still works. In the exported file you can identify the wrong IBANs/BICs (usually too short or too long) and correct the affected address (under Contacts > Bank details) in Xentral.
Xentral checks whether there is a currency conversion when exporting documents in foreign currency, which must be stored or can be retrieved in the Currency Conversion module. If not, it must be added. More info can be found here: Currency management and currency conversion
The easiest way is to load the rates from the ECB and activate the process starter to keep them up to date, as shown in the screenshot below:
This is a current programming error that occurs in some instances, which causes the error message to be displayed by mistake and the export to not be executed. We are already working on a fix for this issue. Please deactivate the CSV validation as a workaround so that the export still works.
Previously, the export in Datev Connect happened asynchronously in the background. The reason for this was the slower export speed of the old export. For this reason, a progress bar was necessary. This is no longer the case, as the new export is triggered and executed directly after clicking on Export. The validation of the data already takes place during the export, the progress is therefore no longer necessary.
We have already received feedback that this was useful and will adjust the interface accordingly in a timely manner. If the last exported time period is no longer known, then this can be changed in the module Database View
can be viewed in the datevconnect_online_export table. Please sort by id.
Ja, technisch schon – Felder für Konten, Debitoren und Kreditoren sind alphanumerisch. Führende Nullen werden aber im Standard nicht genutzt und können bei Export/Import oder Abstimmungen für Verwirrung sorgen.
Wie werden Sachkonten in DATEV erfasst? (Nullen)
Standard ist eine 4-stellige Kontonummer (z. B. 1000 Kasse). Eine Eingabe wie 01000 wird auf 1000 reduziert. Empfehlung: immer 4-stellig, ohne führende Nullen.
Welche Nummernkreise gelten für Debitoren und Kreditoren? (Nullen)
Debitoren: ab 10000, Kreditoren: ab 70000. Eine Kundennummer 00123 kann zwar importiert werden, entspricht aber nicht dem Standard.
Gibt es einen Unterschied zwischen führenden Nullen und Füllnullen?
Führende Nullen sind rein optisch und entfallen im Standard. Füllnullen sind nötig, wenn ein Feld eine feste Länge haben muss (z. B. bei bestimmten Schnittstellen).
Was ist die empfohlene Praxis? (Nullen)
Sachkonten: immer 4-stellig, keine führenden Nullen. Debitoren: ab 10000, keine führenden Nullen. Kreditoren: ab 70000, keine führenden Nullen.