1. How do I perform the export in DATEV format (CSV)?

  2. What can I do with the DATEV format (CSV)?

  3. Field-specific features in CSV

  4. Which accounting tools can we connect with the CSV?

With CANDIS, your invoices can be exported in the DATEV format (CSV), among other formats. All information that you add to your invoices in the approval process is exported to you in a CSV with a document link URL to the corresponding invoice in CANDIS.


How do I perform the export using DATEV format (CSV)?

If invoices have been approved, you can select the export method in the Export menu. On the right, you will find all export methods supported by CANDIS and here you will also find the DATEV format.

After selecting the export method DATEV format (CSV), your invoices will be separated by month according to the invoice date. By default, we specify the oldest available month. In our example, we have one invoice from January and one from February. Here, January has been set as the default. Clicking on the available month opens a drop-down list with all the months included in the export view.

By clicking Export, the document will be saved to the location specified in the browser. Then you can download the second document from February. You decide the order of the download.


What can I do with the DATEV format (CSV)?

You can open this file with any conventional table calculation program. Some programs perform formatting on their own, so in some cases, there may be display problems.

Do you want to import the file to a subsequent accounting or ERP system that supports the DATEV format? Then we recommend

not to open and save the file before importing it.

Otherwise, problems may occur during the import.


Field-specific features in the CSV

We would like to explain a few special features of the CSV here.

Debit/Credit Indicator (Column B)

In this file, you will not find negative amounts. The file is designed for accounting systems, and they work with debits (Soll) and credits (Haben). An incoming invoice contains the marking H for credit in the B column.

Belegfeld 2 Payment status (column L)

In Belegfeld 2, either a 9 or due date is specified. You decide this with the help of the function "Create transfer" directly in the processing view.

  • Create transfer activated = due date

  • Create transfer disabled = 9

Booking text (column N)

The booking text contains the name of the contact.

Document link (column T)

Here you can find the ID of the invoice. This is exclusively reserved for DATEV systems. For an invoice assignment in other systems, we recommend the document URL below.

Note (Column V)

The note can be filled in during the approval process and is displayed here. Not to be confused with the comments that can be sent between employees in CANDIS.

Document URL (column X)

With the URL, other systems can display an invoice via CANDIS. You can also copy and paste the URL into your browser to get to the invoice. The user needs access to CANDIS and access to the corresponding invoice to use it.

IBAN (column Z)

In addition, we have added the IBAN of the contact to enable payment in other systems.


Which accounting tools can we connect with the CSV?

  • Agenda (Click here for instructions)

  • Lexware (Click here for instructions)

  • Sesam (Click here for instructions)

  • Sage (Click here for instructions)

  • BMD (Click here for instructions)

Did this answer your question?