FAQ Financial accounting export

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.

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.

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 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: