Skip to main content

How do I export customer master data to DATEV?

Shopify — Export your customers' master data (account number, name, address, email) as a CSV for DATEV. Requires the single debtor accounts booking type.

With the export of debtor base data, you output your customers' master data – in addition to the account number, for example name, address, and email address – as a CSV file. This is useful for passing the data on to your tax advisor or for creating the matching debtor accounts in DATEV.

Prerequisite: The export of debtor base data is only available to you if you have activated the booking type Einzelkonto je Kunde (Individual account per customer) under Debtor Accounts in the DATEV configuration.

Export debtor base data

Open a DATEV document export or a DATEV payment export and switch to the export detail view. There, two additional buttons are available to you:

  • Export account labels – contains only the account number and the label of the respective customer account. Useful for creating the corresponding accounts in DATEV.

  • Export debtor base data – contains, in addition to the account number, the further customer master data (e.g. name, address, and email address).

Both files are CSV files.

What you should keep in mind

  • Only customers for whom there is a posting record in the associated DATEV export are included.

  • Customers with their own (customer-specific) debtor account are not included in the file.

Did this answer your question?