The DATEV export is split into the DATEV document export and the DATEV payment export. Here we explain how to run a DATEV document 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.

To run a DATEV export, navigate to Orders → DATEV Export and select the Sales Channel as well as the entry Forderungen und Rückforderungen (Receivables and reclaims) in the Art des Exports (Export type) field. Then specify the desired time period – the last completed month is preselected here – and click on Neuen Export erstellen (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 via the window. Once the process is complete, you can download the export using the Download button.

The DATEV export includes all receivables resulting from the document types invoice, invoice correction, and cancellation invoice. If it is a POS Sales Channel, then the order amount is exported. A transaction is included in the export of the selected time period if the document date falls within the selected time period.

If Shopify customers have ordered in a currency other than the Pickware default currency, the associated postings in the export are automatically supplemented with the DATEV foreign currency fields: the amount in the customer's currency (Umsatz (Revenue)), the amount in the Pickware default currency (Basisumsatz (Base revenue)), and the exchange rate calculated from these (Kurs (Rate)).

Orders where neither the customer's currency nor the Shopify shop currency matches the Pickware default currency are not exported. A corresponding message appears in the export log for each excluded document.

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

Using the Belegbilder exportieren (Export document images) button, you can additionally export the associated documents (invoices, etc.) for all transactions included in the export as a ZIP file.

The Sachkontenbeschriftungen exportieren (Export general ledger account labels) and Debitoren-Stammdaten exportieren (Export debtor master data) buttons are only available if you have activated the Einzeldebitorenkonten (Individual debtor accounts) option in the DATEV configuration under the debtor accounts section. You can find more information here.

The CSV export as well as the ZIP file 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.