The DATEV export is split into the DATEV document export and the DATEV payment export. The document export includes all document-related receivables and cancellations of these receivables, while the payment export includes all payment and refund transactions. Both exports can be created individually for the Sales Channels. The payment export includes all payments that you can also see in the DATEV Payments tab in the order details.
To run 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 movements at Pickware POS for POS Sales Channels. Then specify the desired 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.
Via the window, you can track the progress of the export. As soon as the process is complete, you can download the export.
What is included in the DATEV payment export?
In the DATEV Payments tab of an order, all payments that are part of the DATEV payment export for this 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 period if the payment date falls within the selected period. Payments are recorded either automatically or manually. Automatic payments are created according to the configuration. You can adjust these payments afterwards.
Additionally, you also have the option to create 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 automatically filled in.
For the automatic reconciliation of open items for PayPal payments in DATEV, a common matching criterion is required in 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 reconciliation will not work. You can find more information in the DATEV documentation.
Download and view the export
You can access the export detail page either by clicking on the link in the notification or by navigating to Settings → Shop → Import/Export (Pickware). There, all created exports can be downloaded at any time.
The buttons Export general ledger account labels and Export debtor master data are only available if you have activated the Individual debtor accounts option in the Debtor accounts area 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 in connection with Shopware here.
Can I view DATEV payments in the order details?
In the DATEV Payments tab of an order, all payments that are part of the DATEV payment export for this order are listed. Payments are recorded either automatically or manually. Automatic payments are created according to the configuration. You can adjust these payments afterwards. Additionally, you also have the option to create 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 automatically filled in.
