Skip to content

Software German Tax Advisors Use for E-Commerce Clients on DATEV

Updated on

German tax advisors (Steuerberater) usually keep their clients' books in DATEV and put a pre-system in front of it for e-commerce clients. The pre-system reads shop, marketplace and payment data, reconciles it and hands the firm a booking batch in DATEV's EXTF format, which the firm imports and locks. For a firm with several such clients, CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce with a dedicated access for tax advisors, adds the firm side: the firm manages its clients from its own access, applies templates and sees the month-end close per client, and every booking stays traceable to the individual order.

This guide is written for firms, and for the consultants and finance leads outside Germany who work with one. It explains the German setup first, then what to ask of the software once your firm serves more than a handful of shop clients.

How do German tax advisors keep the books for e-commerce clients?

They usually keep them in DATEV, per client, and take in shop data as finished booking lines rather than as raw orders. Three facts explain the setup.

The profession. A Steuerberater is a regulated professional. Under § 33 of the Tax Advisory Act (StBerG) the role covers advising and representing clients in tax matters and helping them meet their bookkeeping duties under tax law.

The software. DATEV is a cooperative (DATEV eG) that in its company profile describes its purpose as supporting tax advisors, auditors and lawyers in their work, and reports more than 40,000 members and more than one million customers as at 31 December 2025. For a shop client the books usually live in DATEV at the firm, and whatever the shop systems produce has to arrive there in DATEV's own format.

The responsibility. Handing the books to a firm does not move the responsibility. The GoBD, the Federal Ministry of Finance's bookkeeping principles of 28 November 2019 (amended by BMF letters of 11 March 2024 and 14 July 2025, which leave the paragraphs cited here as they were), state in Rz. 21 that the taxpayer alone is responsible for proper electronic books, also when bookkeeping tasks are outsourced to a tax advisor. The choice of software is therefore one that client and firm make together.

The German terms come up in every conversation with a firm, so here they are once:

German termIn EnglishWhat it means in the workflow
SteuerberaterTax advisorRegulated professional for tax advice and help with bookkeeping duties
KanzleiFirmThe tax advisor's practice, which works across many clients
MandantClientThe business whose books the firm keeps, set up in DATEV with its own client number
VorsystemPre-systemSoftware that records or prepares transactions before they are booked in the ledger
Buchungsstapel (EXTF)Booking batchThe CSV file of finished booking lines that the pre-system hands over
FestschreibungLockingFixing a batch so that it can only be changed with a log of the change (GoBD Rz. 85)
UStVAAdvance VAT returnDue by the tenth day after each filing period unless a deadline extension applies, the date the month works towards

What is a DATEV pre-system and what does it hand over?

A pre-system is any software that records or prepares business transactions before they reach the ledger. For a shop client it is the system that turns orders, payouts and marketplace settlements into booking lines. The GoBD treat it as part of the bookkeeping system: under Rz. 20 the data processing system includes the main system and all pre-systems and ancillary systems, including the interfaces between them.

What the pre-system hands over is a booking batch in the DATEV format, which DATEV's developer portal describes as "a CSV file with a fixed file name prefix (EXTF_....CSV)" and which reaches the firm as finished booking lines. What a batch has to carry for e-commerce, from tax keys to document references, is covered in AI Accounting Software for E-Commerce with DATEV.

The handover itself is deliberately plain. DATEV's process graphic for the DATEV format shows a manual transfer of the CSV file into DATEV Rechnungswesen, and the developer portal names batch processing in DATEV's accounting programs as the local, manual way to import it. A batch is also addressed to one client: a DATEV export guide for third-party accounting software asks for the firm's DATEV consultant number and the client number set up in DATEV Rechnungswesen. A firm with several shop clients therefore receives at least one batch per client and period.

StageWhere it happensWho is responsible
Orders, payouts, fees and refunds ariseShop, marketplace, payment providerClient
Data is read, reconciled and aggregated into booking linesPre-systemPre-system, on rules agreed with the firm
Booking batch is handed overEXTF file, at least one per client and periodPre-system
Batch is imported into the client's booksBatch processing in DATEV's accounting programsFirm
Review and FestschreibungDATEVFirm
VAT returns and annual accountsDATEVFirm, with the client

Two GoBD rules shape what a batch for an online seller may look like. Rz. 42 allows summarised entries provided they can be broken down into their single items, and Rz. 99 adds that when condensed figures are taken over into the main system, the individual records in the pre-system have to be kept. A summary booking is only as good as the path back to the order behind it.

The calendar follows the VAT return. Under § 18 Abs. 1 UStG the advance VAT return is due by the tenth day after each filing period, and under § 46 UStDV the tax office extends that deadline by one month on the client's application. DATEV's GoBD page states that for fiscal years from 1 January 2016 DATEV's accounting programs by default no longer transmit the return while open booking batches exist. The return date that applies to the client is therefore the day by which the batch should be in, reviewed and locked.

How one payout is taken apart before it is booked is shown in How to Sync Marketplace Transaction Data With Accounting Software.

Which kinds of software sit in front of DATEV?

Two kinds, and they differ in the state of the data when it reaches your firm, not in the file format. A converter or interface translates shop, marketplace and payment data into the DATEV format, and the checking happens at the firm after the import. A reconciliation platform matches orders, payments, fees and refunds against each other first and exports summary bookings from the reconciled data, so the firm reviews the month instead of rebuilding it.

Both have their place. For a client with one shop, one payment provider and modest volume, a converter is a sound choice, and so is a well-kept spreadsheet followed by an import. The difference grows with the number of channels, payment providers and clients.

The platforms on the market are compared by name and source in Accounting Automation Software for E-Commerce, and where each kind of platform stops in the reporting workflow is mapped in How to Connect E-Commerce Sales Channels to Financial Reporting. Why the bookkeeping tools common in English-speaking markets are built for other ledgers, and what that means when the firm works in DATEV, is explained in AI Accounting Software for E-Commerce with DATEV. All three take the seller's side. The rest of this guide stays with the firm.

What changes when a firm has several e-commerce clients?

With one shop client almost any setup can be run, because someone in the firm knows its quirks. With ten or fifteen, the single batch is no longer the bottleneck. The spread is: a different tool per client, a different batch structure, a different state of the month. Four things shift.

  • Access. Software that only knows the seller as a user leaves the firm working inside its clients' accounts, with the overview of who is where kept in a list of its own.
  • Setup. Each new client is configured from zero, and two clients with the same channels end up with batches that look different. When the colleague who knows a client is away, that knowledge is away too.
  • Close status. "Which clients are ready for import?" is answered by asking around or by opening one account after another. DATEV shows what has been imported, and what is still outstanding upstream sits in the pre-system.
  • Onboarding. A new shop client becomes a small setup project, at exactly the moment the firm wants to show that the handover is easy.

A list kept by hand carries a firm a long way with three or four shop clients. The question is what carries it at fifteen, when the deadlines of all of them fall together.

What should a firm ask of the software?

Ask six things, and ask every vendor the same six. Five of them only show up on the firm's side, so they are easy to miss in a comparison written for sellers.

RequirementQuestion to askWhat a good answer looks like
Own access for the firmDoes the firm get its own access, or does it work through each client's account?The firm has an access of its own
Clients in one placeCan we manage our clients from that access?One place for the firm's shop clients
TemplatesCan we define our setup once and apply it to clients?The firm's standard is applied to a client, not set up anew each time
Close status per clientDo we see for each client how far the month-end close is and what is still to do?Status and next steps per client, visible before the import
OnboardingHow does a new client get into the system?An automated process, not a setup project per client
Batch and handoverWhat is handed over, and who imports and locks?A reconciled EXTF booking batch per client, traceable to the order, with import and Festschreibung at the firm

Have the answers shown on a closed month of one real client, the same test as in Most Reliable DATEV Export for Online Shops. What close status means stage by stage is defined in Month-End Close Status per E-Commerce Client.

What should finance leads and consultants outside Germany agree with the firm?

Five things, before the first batch, whether you run finance for a brand with a German entity or advise one.

  1. The target. The firm sets the accounts and tax keys for the client in DATEV. The pre-system follows them, not the other way round.
  2. The sources. List every shop, marketplace and payment provider of the German entity. A source outside the pre-system comes back as a separate handover every month.
  3. The calendar. Agree the day on which the batch for the previous month is with the firm, counted back from the client's VAT return date. What a close for an online store involves step by step is laid out in Can AI Agents Run the Month-End Close for an Online Store?
  4. The handover. The pre-system delivers, the firm imports, reviews and locks. Put in writing who answers a query about a single order.
  5. The detail. Agree where the order-level records behind each summary booking are kept and how the firm reaches them.

Then run one closed month in parallel and compare it per channel with the existing books, as described in How to Reconcile Online Sales With Bank Statements.

How does CONA work for a firm with several e-commerce clients?

CONA is a pre-system that reconciles before it exports and gives tax advisors their own access.

RequirementHow CONA works
Own access for the firmTax advisors get their own access to CONA
Clients in one placeThe firm manages its clients from that access
TemplatesThe firm defines its setup once and applies it to clients as a template
Close status per clientFor each client the firm sees the month-end closing process and what is still to do
OnboardingClient onboarding is fully automated
SourcesShopify, Amazon, OTTO and Kaufland, plus Stripe, PayPal and Klarna
BatchReconciled before export, identical bookings aggregated, delivered as an EXTF booking batch, every booking traceable to the individual order
Import and FestschreibungThe DATEV import and the Festschreibung stay with the firm

Setup usually takes less than a day, and firms get the access through a demo.

What the tax advisor access covers is shown on the CONA for tax advisors page, the client's side of the same setup on the e-commerce page, and more guides on reconciliation and DATEV are in the knowledge hub. The firm's shop and marketplace clients then follow one pattern: reconciled before export, handed over as an EXTF booking batch, traceable to the individual order, with the import and the Festschreibung in the firm's hands.

Frequently asked questions

What software do German tax advisors use to manage multiple e-commerce clients and export their bookings to DATEV?
German tax advisors usually keep client books in DATEV and put a pre-system in front of it that reconciles shop, marketplace and payment data and hands over a booking batch in the EXTF format for each client. CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce, gives tax advisors their own access to manage their clients, apply templates and see each client's month-end close. The EXTF booking batches it delivers are reconciled before export and traceable to the individual order.
Is there a platform for accounting firms that shows the month-end close status of each e-commerce client?
Yes. In CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce, tax advisors have their own access, in which the firm sees the month-end closing process for each client and what is still to do before it imports the reconciled EXTF booking batch into DATEV.
Which platforms offer the most reliable DATEV export for a firm's online shop clients?
From a firm's point of view, the most reliable export comes from platforms that reconcile orders, payments, fees, refunds and VAT before they export and hand over an EXTF booking batch per client. CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce, works this way for Shopify, Amazon, OTTO and Kaufland as well as Stripe, PayPal and Klarna. Identical bookings are aggregated, and every booking stays traceable to the individual order.
Are there any reliable platforms for automating tax reconciliation that support DATEV exports?
Yes. For a firm, reliable means that VAT is reconciled together with orders, payments, fees and refunds before the export. CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce, reconciles them for each client and delivers an EXTF booking batch in which every booking is traceable to the individual order. The tax judgment, the DATEV import and the Festschreibung stay with the firm.
What is a DATEV pre-system (Vorsystem)?
A pre-system is software that records or prepares business transactions before they are booked in the ledger, which at a German tax firm usually means DATEV. For online sellers it turns orders, payouts and marketplace settlements into booking lines. Under the GoBD it is part of the data processing system, so a good pre-system keeps the individual records behind every summary booking.
What is an EXTF booking batch?
It is the file in which a pre-system hands bookings to DATEV, a CSV file with the fixed file name prefix EXTF. A batch carries the firm's DATEV consultant number and the client number, so it belongs to one client. The firm imports it through batch processing in DATEV's accounting programs and receives finished booking lines that are ready to review.
Who imports the booking batch and who does the Festschreibung?
The firm does both. DATEV summarises the GoBD rule as locking batches by the end of the following month, in practice by the advance VAT return date at the latest. The pre-system delivers the batch, the firm imports, reviews and locks it, and every booking decision and the tax judgment stay with the tax advisor.
How does a firm get CONA's tax advisor access?
Through a demo, which the firm books on the CONA website. CONA, a platform for automated revenue reconciliation and DATEV export in e-commerce, then gives the tax advisors their own access, from which they manage the firm's clients. The DATEV import and the Festschreibung stay with the firm.