DATEV

Connect Exopen to DATEV to automatically import accounting data: chart of accounts, fiscal years, vouchers, balances and opening balances.

One data source in Exopen corresponds to one DATEV company (Mandant). To connect several companies, one data source is created per company. The currency is always EUR.

DATEV Datenservice Export Rechnungswesen is required

The DATEV Datenservice Export Rechnungswesen service must be activated for every Mandant to be connected. See DATEV's instructions.

Prerequisites

• The DATEV Datenservice Export Rechnungswesen service activated for every Mandant to be connected.
• A DATEV login with access to those Mandanten.
• Chart of accounts SKR04. See Limitations.

Create Data Source for DATEV

1. Log in to Exopen's portal.

2. Go to Data Sources and click on New Data Source.

3. Choose DATEV from the list of available integrations.

4. Choose how the authorization should be completed:

   1. If you have a DATEV login with access to the companies, select I want to do it myself and click Continue.
   2. Otherwise, choose I want to share a link with a non-Exopen user and click Copy Link. See Connecting with a shared link.

5. Sign in to DATEV and approve the access.

6. In the Select companies list, select the companies to connect. You can search by company name or by consultant number/client number. Click Connect.

7. DATEV shows a consent dialog once per selected company. Approve all of them and do not close the window until you are back in Exopen. Five selected companies means five approvals.

Each selected company becomes its own data source with its own legal entity. An initial data run starts automatically. After that, new data is imported every 20 minutes.

Connecting with a shared link

Use this when the person holding the DATEV login is not an Exopen user.

1. Send the link from step 4.2 above to the person with DATEV access.
2. The person opens the link, reads the Connect DATEV to Exopen information page and clicks Proceed.
3. The person signs in to DATEV.
4. If DATEV does not provide the email address, a page is shown where it is entered.
5. The person selects companies and approves one company at a time, as in steps 6 and 7 above.
6. The Access granted page is shown once everything is done.

The person never needs to log in to Exopen. The data sources appear in Exopen once the connection is complete.

Add more companies

Repeat the steps under Create Data Source for DATEV. Already connected companies are hidden from the list, so you only see the remaining ones.

Manage the connection

The data source page shows who approved the connection, when the access expires (about two years) and whether the connection needs to be renewed.

Recreate

Recreate a data source if it needs to be reconnected, for example if the access has expired.

1. Log in to Exopen's portal.
2. Go to Data Sources and click on the data source you want to recreate.
3. Click on the three dots on the right and choose Recreate.
4. Choose I want to do it myself, or share a link with someone who has DATEV access.

The previous access is revoked automatically once the new one is in use.

Revoke access

The access can be revoked either in Exopen or in DATEV.

In Exopen

1. Log in to Exopen's portal.
2. Go to Data Sources and click on the data source.
3. Click Revoke DATEV access under Access given by.

In DATEV

1. Open DATEV verbundene Anwendungen. The link is also available under Access given by on the data source page.
2. Find Exopen in the list of connected applications.
3. Revoke the access for the company to be disconnected.

The data source remains but imports no new data until it is recreated. This cannot be undone.

Access is per company

Every company has its own access. Revoking one company does not affect the others, even if they were connected with the same DATEV login.

Limitations

Area	What applies
Currency	Always EUR.
Organisation number	Not imported. The legal entity gets its name and Mandant number.
Chart of accounts	SKR04 is supported. SKR03 and other charts leave accounts untyped, which means opening balances are missing. The sync log warns when the chart is unsupported.
Older fiscal years	DATEV does not export postings further back than its own retention limit. Such years are skipped with a warning, while balances remain available.
Vouchers	Individual vouchers may not net to zero. This is caused by DATEV's follow-on postings and is expected.
Opening balances	DATEV delivers opening balance entries both as postings and as opening balances. Exopen uses the opening balances and filters out the postings, to avoid counting them twice.
Not yet available	Customers, suppliers, invoices, products, projects and orders are not delivered by DATEV.

Troubleshooting

The company is greyed out in the list, marked no accounting data access Datenservice Export Rechnungswesen is not activated for that company. Activate the service in DATEV and redo the connection.

The company is missing from the list entirely The login does not have access to that company in DATEV. Sign in as a user who does, or share the connection link with someone who has access.

The message Integration Failed with an error code Click Try again. If the error persists, contact support@exopen.se and provide the error code.

The sync succeeds but data is missing Check that Datenservice Export Rechnungswesen is still active for the company. If the service is removed afterwards, data stops being delivered without the connection breaking.