User Docs

User Docs

6.2 Datev Export

In Germany, many financial accounting programs or Datev Online directly offer the import of transaction data in Datev CSV format. This significantly facilitates accounting and the work for the tax consultant.

RETAIL7 offers the export of transaction data in this defined format.

In order to be able to use this, various settings must be made in advance - preferably together with the tax consultant.

The Datev export as well as the associated settings can be found in the Management Console -> Exports -> DATEV Export.

The necessary settings are made in the menu "Header", which is located directly under the selection field, where you define the period of the transaction data to be exported.

In some cases, data is already given as a suggestion, but it is mandatory to verify it by the tax advisor. It is important to note that this does not constitute tax advice, but only shows the technical possibilities. Any consulting activity in this case is the responsibility of the tax consultant.



Header data

Header data are the defined default values or global values for the export file.


Default value: 1001

This is used to store the consultant ID in the export file.


Default value: 1

This is the client ID

G/L account number length

Default value: 4

The G/L account number length is specified by the tax advisor


Default value: Invoice

How should the transactions be named

Dictation abbreviation

Default value:

Freely definable value that identifies the origin of the data.

Currency code

Default value: EUR

Denotes the currency in which the transactions were created

G/L account framework

Default value: 04

Each farm is managed according to a G/L account framework defined by the tax advisor. As a rule, it is 04 or 03


Default value: RE



Default value: 1

Stack of bookings

defines the default accounts

Cash account

Default value: 1000

Defines which posting account should be used for the cash register.

Change account

Default value: 1360

Defines which posting account is to be used for the change

Deposit account

Default value: 1360

Defines which posting account should be used for deposits

Disbursement account

Default value: 1360

Defines which posting account should be used for disbursements

Skimming account

Default value: 1360

Defines which ledger account should be used for skimmings. Skimmings are intraday cash withdrawals from the cash register to reduce the cash balance.

Different means of payment in one transaction

Defines which posting account should be used if there is a use of several different means of payment in one transaction and therefore no clear assignment is possible.

Tip account

Defines which booking account should be used for tips

Tax account assignment

For each valid tax group a tax account must be specified. In Germany, these are at least the standard tax rate (currently 19%), the reduced tax rate (currently 7%) and tax-free. In special cases, other tax rates are also valid; please consult your tax consultant. These can also be added for your RETAIL7 environment.

Means of payment

Default values: BAR 1000, EFT 12000

Each means of payment must be assigned to a G/L account, otherwise it will not appear in the export. Additional means of payment can be flexibly assigned to the system. Our support will be happy to help you with this.

Tax free account

Default value: 8100

A complete transaction can be defined as tax free by function. This is intended for a wide variety of use cases.

Save as default

Default value: active

Your entered values will be stored permanently, if this option is active, so that the values do not have to be stored again and again.

Once again, it should be mentioned that the RETAIL7 system does not / may not provide tax advice. This is the exclusive responsibility of tax consultants. We are happy to assist with the technical configuration.