The DATEV export is divided into the DATEV document export and the DATEV payment export. Here we explain how to perform a DATEV payment export. The document export contains all document-related receivables and cancellations of these receivables, while the payment export contains all payment and refund transactions. Both exports can be created separately for the sales channels.

To perform a DATEV export, navigate to Orders → DATEV Export and select the Sales Channel as well as, in the Export type field, the entry Payments and refunds for regular Sales Channels or Cash register transactions at the Pickware POS for POS Sales Channels. Then specify the desired time period – the last completed month is preselected here – and click on Create new export. Please note that exports cannot be created across the boundary of a fiscal year.

Optionally, you can add a comment here. Finally, click on Export.

You can track the progress of the export in this window. Once the process is complete, you can download the export using the Download button.

In the DATEV Payments tab of an order, all payments that are part of the DATEV payment export for that order are listed. All payments from this tab whose amount differs from 0.00 € are exported. Payments with a negative sign refer to refunds to the customer. A transaction is included in the export of the selected time period if the payment date falls within the selected time period. Payments are recorded either automatically or manually. Automatic payments are created according to the configuration. You can adjust these payments afterwards.

In addition, you also have the option of creating manual payments. If you manually enter a transaction reference here, it will be output in the Order number field of the export. For card payments via iZettle or ZVT at the POS, the transaction reference is filled in automatically.

For the automatic clearing of open items for PayPal payments in DATEV, a common matching criterion is needed in both the invoice and the PayPal payment. Use the order ID for this, or alternatively the PayPal transaction number (in the order number or document field 1). If the values differ, for example due to a prefix, the matching will not work. You can find more information in the DATEV documentation.

You can access the export detail page either by clicking the link in the message or by navigating to Settings → Shop → Import/Export (Pickware). There, all created exports can be downloaded at any time.

The Export general ledger account labels and Export debtor master data buttons are only available if you have activated the Individual debtor accounts option in the Debtor accounts section of the DATEV configuration. You can find more information here.

The CSV export can then be handed over to your tax advisor. In this article you will find a list of the exported data types. You can find tips on correctly opening CSV files here.