In this article, you'll learn how to configure the settings of your DATEV extension to suit your needs.

You can find out how to carry out a DATEV export here:

You can find the extension settings under Settings → Extensions → DATEV. Please review the settings together with your tax advisor.

The configuration can be set individually for each Sales Channel. Alternatively, you can use the Base configuration entry to define settings that apply equally to all Sales Channels.

If needed, you can remove the link using this button:

The document reference lets you define which information is output in document field 1 when exporting a posting. A distinction must be made between payment export and document export:

This setting lets you define which value is output in the order number field of the DATEV export. This setting applies both to the document export (receivables) and to the payment export.

You have three options to choose from:

The order number is a custom field on the order that you can use, for example, for transaction references or marketplace order numbers.

In Shopify, this field is automatically populated from the Shopify metafield "External order number (Pickware)". You can populate this metafield manually or via Shopify Flow (e.g. for Amazon or eBay orders) with the marketplace order number.

Here you define revenue accounts for individual tax rates. If no country-specific revenue account is set for a posting, the posting is booked to the default revenue account for the corresponding tax rate. Additional accounts can be added using the Add default account button.

Here you define the accounts used for taxable deliveries abroad. If no account is set for a combination of country and tax rate, a default revenue account is used for the corresponding tax rate. Click Add country-specific account to add accounts.

Here you define a default account as well as country-specific accounts used for intra-community deliveries (deliveries to business customers abroad within the EU). If no account is set for a delivery country, the default account is used. Click Add country-specific account to add accounts.

Here you define a default account as well as accounts for deliveries to third countries (non-EU countries). If no account is set for a delivery country, the default account is used. Click Add country-specific account to add accounts.

In the Posting variant field, you can define whether you want to use collective accounts receivable or individual accounts receivable. Of course, you can configure this option both across all Sales Channels (= base configuration) and for individual Sales Channels only.

Alternatively, you can also enter an individual accounts receivable account for a specific customer in the customer account, which is then used independently of your general DATEV settings.

If this option is selected, you can then use the Add account for payment method button in the Collective accounts section to set an account for each payment method, to which the relevant orders are booked. If no accounts receivable account is set for a payment method, the posting is made to the default accounts receivable account instead.

If this option is enabled, all orders are booked per customer, with the account number corresponding to the customer number. In this case, two additional buttons are available to you in the export detail view, both for the document export and the payment export:

Both files are CSV files. Only customers for whom there is a posting in the associated DATEV export are included.

If you use the Individual account per customer posting variant in the DATEV configuration for accounts receivable, the accounts receivable account is derived from the customer number. For this to work, the customer number must be suitable for export. Otherwise, the export uses the configured default accounts receivable account instead.

Here you can set the clearing account to which payments made with the corresponding payment method are booked. If no collective account is set for a payment method, the payment is booked to the default account.

If your company belongs to a group of companies, postings within the group must be booked in a special way. For this purpose, different company codes can be set for individual customers or entire customer groups. Company codes are appended as the last two digits of revenue account numbers.

You can find the settings for this in the configuration in the Company code section. Here you first need to enable the option, and then you can enter the default company code. Here too, both a cross-Sales-Channel configuration (= base configuration) and an individual configuration per Sales Channel are possible.

Here you can configure a cost center per Sales Channel as well as define the field mapping in the DATEV export. Depending on your selection, the Sales Channel's cost center is exported to the KOST1 or KOST2 field. If available, the product's cost center is exported to the respective other field.

Here you'll find additional settings beyond the extension settings.

In the customer account, under Custom fields → DATEV, you can set a customer-specific accounts receivable account, which is then used for this customer instead of the account set under Settings → Extensions → DATEV → Accounts receivable. This applies regardless of whether you use collective accounts receivable or individual accounts receivable. Please also note that customers with their own accounts receivable account are not included in the export files for general ledger account labels or accounts receivable master data.

You can set a company code specifically for a customer in the respective customer account under Custom fields → DATEV. Similarly, you can set an individual company code per customer group under Settings → Shop → Customer groups, in the Custom fields → DATEV section there.

If you have set a company code both in your DATEV configuration and for the customer account and the customer group, these settings are prioritized as follows: customer account, customer group, DATEV configuration.

This means that when creating a posting, the company code in the customer account is used first. If nothing is set there, the company code for the associated customer group is used, and if nothing is set there either, the default company code from the general DATEV configuration is used.

In addition to the cost centers at the Sales Channel level, you can also specify a cost center for each product. To do this, go to the product properties under Specifications → Custom fields → DATEV → Product's cost center. Below are two examples to illustrate the effects of the product cost center on your DATEV export:

If you ship to EU countries or third countries, the following options should also be enabled under Settings → Shop → Countries, in the Options section respectively. These are used to distinguish between tax-exempt deliveries and deliveries with a 0% tax rate.

*Enabling this option displays the tax-free from field, where you can set amounts above which customers can order tax-free. You don't need to enter anything here.

As soon as you export more than €10,000 into the EU, the invoice must show the destination country's VAT in accordance with the One-Stop-Shop procedure. To do this, first create the corresponding tax rate under Settings → Shop → Taxes. You can then set up an additional account with the foreign tax rate in the extension settings, in the Country-specific revenue accounts per country section.

If you want to fundamentally account for deliveries abroad differently from deliveries within Germany before reaching the delivery threshold, you can set up an account per delivery country using the German tax rates.