Shopify DATEV integration

DATEV is not an inventory system.For merchants who want their Shopify revenue posted cleanly into financial accounting, without expecting DATEV to hold products or inventory.

What DATEV actually does in this chain

DATEV is financial accounting and tax advisory software, not an inventory management system. It holds no product master data, no stock levels and no prices. Anyone looking for a "DATEV integration" almost always means something else: that Shopify revenue, refunds and fees arrive at the tax advisor as journal entries, posted to the right accounts and with the right tax keys.

That is why the task looks different from an ERP project. It is not about synchronisation in both directions, but about a clean handover in one direction: out of Shopify, or out of the ERP upstream of it, into a format DATEV can read. Everything to do with stock or products belongs in another system, and if there is none, that is the real gap.

Which objects run in which direction

The many empty rows are the result, not an oversight: DATEV cares about documents and accounts, not about catalogue data.

Object	Direction	Leading system	Note
Products	no sync	-	DATEV holds no product master data. That needs an ERP or a PIM.
Inventory	no sync	-	Stock management is not a DATEV topic.
Prices	no sync	-	Prices are set in the store or the ERP, not in accounting.
Orders	Shopify →	Shopify	Orders become revenue postings with an account and a tax key.
Credit notes	Shopify →	Shopify	Refunds and cancellations as separate journal entries, not as a correction to the original.
Customers	Shopify →	Split by field	Only where customer accounts are kept. A collective customer account is often enough.
Journal entries	Shopify →	DATEV	Journal-entry batches in the DATEV format, usually once per month.

Which route holds up

Handover from the ERP
The cleanest route when an ERP is involved. Invoices and credit notes are created there anyway, so the accounting handover hangs off that system. Shopify stays a sales channel and does not need to know anything about accounting.
A specialised accounting app
Without an ERP, apps take on the job: they read orders, refunds and payouts out of Shopify and produce a journal-entry batch DATEV can read. The work sits in the one-off account mapping, not in the technology.
Your own export
Worth it with unusual account logic or several legal entities in one store. A custom export reproduces exactly your rules, but it needs your accounting firm at the table before the first line is written.

Common pitfalls

Payment providers not reconciled
Shopify Payments, PayPal and Klarna pay out in batches and net of fees. If you only post orders, the payout will never reconcile cleanly. You need a clearing account per provider and the payout data to go with it.
Tax keys and cross-border sales
Sales into other EU countries, small-business exemptions and reporting through the One Stop Shop scheme all need different keys. The mapping should be agreed with your tax advisor, not worked out by trial and error in the journal-entry batch.
Credit notes treated as corrections
Refunds must not overwrite the original document. They are their own postings with their own date. Reducing the original revenue instead destroys the audit trail between the store, the payment provider and accounting.

Frequently asked questions

Can DATEV take over products and stock levels from Shopify?

No, and that is not a limitation but a division of labour. DATEV is financial accounting. Product master data, inventory and prices belong in an inventory management system or an ERP. If that system is missing, that is the real gap in your setup.

What is handed over to DATEV?

Journal entries: revenue from orders, refunds, payment provider fees and the payouts themselves, each with an account, a tax key and a date. Depending on the setup, customer accounts as well, though a collective customer account per payment method is often enough.

How are Shopify Payments and PayPal posted correctly?

Through clearing accounts, one per provider. The order posts the revenue, the payout clears the clearing account, and the fee is recorded separately. Without that separation, a permanent difference stays between your revenue figures and your bank statement. Reconciliation then fails.

Do I need an ERP for this?

Not necessarily. Without an ERP, specialised apps prepare the data directly from Shopify. But as soon as inventory, purchasing or B2B conditions matter, you will need an inventory management system anyway, and the handover to accounting is then attached to that system.

Who decides on the account mapping?

Your tax advisor. The chart of accounts, revenue accounts and tax keys are a tax decision, not a technical one. The integration only reproduces what was agreed. If that step is skipped, you end up with a journal-entry batch that the firm has to rework by hand.

Shopify Xentral integrationFor D2C brands outgrowing spreadsheets that want to run order processing, warehousing and shipping in one place at last.View integration Shopify weclapp integrationFor brands with mixed B2C and B2B business that use weclapp for inventory management and do not want to maintain the store separately.View integration Shopify JTL-Wawi integrationFor retailers who run their operations in JTL-Wawi and want Shopify as the sales channel in front, instead of changing systems again.View integration

System integration: patterns and data ownershipThe overarching view of ERP, PIM, WMS and middleware.