DATEV Export

About the Extension

DEMO SHOP AVAILABLE

Try every feature in our demo shop first: storefront with a prepared customer account and full administration, reset every night. Access via "View demo" below the screenshots.

WEBSITE

More about DATEV Export on shop-buchhaltung.de.

DESCRIPTION

Your monthly handover to the tax firm in one click: orders, invoices, credit notes and cancellations become a finished DATEV booking batch, with debtor master data, document images and a protocol that explains every single booking.

You pick the period, see in the preview what will be booked, and export. Out comes the file your tax firm can import directly, together with a ZIP holding the matching document images. If you like, a scheduled task does that every month by itself and mails the file to the firm - or hands the batch straight to the DATEV booking data service. The document packages wait in the history for download.

The problem you know

The same job every month: the figures have to leave the shop and enter the bookkeeping. The usual ways there cost time and produce errors.

• The CSV export from Shopware knows no tax keys, no debtor accounts and no document field. Whatever is missing gets rebuilt in a spreadsheet.
• The tax firm types from the PDF invoices. That is slow and billed by the hour.
• An export that only covers the ordinary case. As soon as OSS, cash-basis taxation, the small-business rule or credit notes come into play, the manual work is back.
• Afterwards nobody knows why a figure is in the file. Every question from the firm turns into a search through the orders.

How DATEV Export solves it

• What was actually invoiced is what gets booked. The basis is the document in Shopware, not the order: the invoice, the credit note, the correction. An order without an invoice does not appear in the batch, and a cancelled invoice is booked as a cancellation. That is the view your tax firm takes anyway.
• Every tax case is provided for. Accrual and cash-basis taxation, OSS per EU destination country, the small-business rule under section 19, reverse charge, intra-community supply, third country and foreign currency. Not as a workaround, but as an ordinary setting.
• The setup guides you. A wizard asks for everything DATEV needs when you create your first tenant. The DATEV standard accounts are offered as suggestions, and a readiness check tells you what is still missing before the first export.
• The documents come along. Every run carries a ZIP with the document images, linked through the document field so your tax firm can attach them on import.
• Every booking is justified. The protocol records per document which tax case applied, which date and account were used, and why a document was not booked if it was skipped.
• The export runs by itself. As a scheduled task at the cadence you choose, with a mail to the tax firm. An empty month can be reported too, so nobody waits for a file that does not exist.

The benefit at a glance

• Hours of manual work each month turn into one click.
• Your tax firm receives bookings and documents from the same run and types nothing.
• Every figure in the file can be traced back to the order.
• You see your revenue figures in the shop before the bookkeeping does.
• The size of the shop does not matter: the run works step by step and splits booking batches and document packages by itself.

Typical use cases

The monthly run: at the start of the month the scheduled task exports the previous month and mails the file to your tax firm. You see in the history that it worked, and the document packages are waiting there too.

Switching over: before you switch, you run a test export. It produces a real, complete file, does not lock documents in Shopware and can be repeated as often as you like. The DATEV finalisation flag follows the tenant setting. Your tax firm imports it for a trial and reconciles it. A handout on the Export page explains every convention of the file to them.

Several companies in one shop: you create one tenant per company, with its own accounts, its own consultant number and its own sales channels. Each tenant exports only what belongs to it.

Selling into the EU: you store one revenue account per destination country. The rates come from your Shopware tax rules, and the threshold monitoring warns you before the distance-selling limit is reached.

Catching up on a year: a period covering twelve months with hundreds of thousands of bookings runs through in the administration, without a time limit and without a console.

What you set per tenant

Everything below belongs to the tenant, not to the shop. Every setting carries a help text that says what it does.

• Tax firm: consultant number, tenant number, the firm's mail address and a copy, your own address as the operator.
• Bookkeeping: chart of accounts SKR03 or SKR04, account length from four to eight digits, start of the fiscal year, interface version, country of establishment, booking timezone.
• Taxation: accrual or cash basis, the small-business rule under section 19, the freeze flag.
• How it books: one booking per document or a condensed collective booking, cancellations as a general reversal or as a counter booking, the behaviour for documents already exported, and whether warnings alone block the export.
• Document types: which Shopware document types count as an invoice, as a credit note and as a cancellation.
• Debtors: a collective account, a collective account per payment method, a collective account with diverse addresses, or individual accounts; plus the rule for the number and whether contact data travels along.
• OSS: on or off, the path (a revenue account per EU destination country, or a collective account with a tax key), and for both paths separate accounts and keys for goods and for electronic services.
• Fields in the file: the performance date from the order or the shipping date, the Shopware order number as the order reference, the posting text separately for documents and payments, tax keys shown or hidden.
• Payments: whether the money side from the Shopware payment state is booked along.
• Schedule: on or off, daily, weekly or monthly, and the hour in the tenant's own timezone.
• Sales channels: which channels this tenant exports.

Rules you write yourself

• The debtor account rule. An expression that turns the customer into an account number, from the customer number or a custom field for example. With a preview over the first customers before you save.
• Cost centre rules. As many as you like, each with its own priority. They match by sales channel, payment method, delivery country and tax rate, and set KOST1 and KOST2 individually.

Before you export

• Setup wizard. Guides you through every mandatory field of your first tenant.
• Readiness check. Tells you what is still missing before the first export and links straight to it.
• Preview. Computes the period without writing anything: the number of documents, bookings and the volume.
• Test export. A real, complete file that does not lock documents in Shopware and can be repeated as often as you like. The DATEV finalisation flag follows the tenant setting. The way to reconcile with your tax firm.
• Handout for the tax accountant. Explains every convention of the file to the firm.

After the run

• Report. Every finding sorted by severity, each one acknowledgeable.
• Protocol. One line per document: tax case, date, account, booked or skipped and why.
• Reconciliation. The run checks itself for completeness and balances the sums.
• Reporting. Revenue per account and tax rate, payments per cash account, invoices, credit notes and cancellations, VAT and net revenue, with a CSV.
• History. Every run with its state, file and document package, downloadable again at any time.

Automatic

• Scheduled task. Exports the period that is due and mails the file to your tax firm; the document packages wait in the history. An empty month can be reported too, and so can a failed run.
• Console command. The same export for your own automation.
• Threshold monitoring. Totals the EU-wide distance-selling revenue daily and warns on the tenant, on the dashboard and in the report before the threshold is reached.

The file and the documents

• EXTF booking batch in format 13, the way DATEV expects it for the import.
• Debtor master data and diverse addresses as files of their own, matching the debtor mode you chose.
• If a batch grows too large for one file, several are written, along the limits DATEV sets.
• Document images as a ZIP with a DATEV XML for the document management, split by count and size.
• Large periods run step by step in small portions and are assembled at the end; an interrupted run continues where it stood.

GoBD: frozen and unbroken

A binding export run with a file locks its documents in Shopware and joins an unbroken hash chain. On top of that comes a duplicate check across runs. A second export of the same period books nothing twice unless you say so explicitly.

Direct handover to DATEV

The booking batch goes straight to the DATEV booking data service if you want it to - no download, no mail. That gives you three outlets and you pick the one that suits your tax firm: download the file yourself, have it mailed to the firm automatically, or hand it to DATEV directly.

Who this pays off for

For shops whose bookkeeping is done by a DATEV tax firm and where the monthly handover no longer fits into a spare hour: from a few hundred orders a month upwards, with EU sales, several sales channels or several companies in one shop. You set it up once together with your tax accountant, and from then on your shop's bookkeeping is finished every month at the same hour, complete and traceable.

General information

• Snippets
  The extension uses snippets so that all texts and labels can easily be translated into other languages in the administration.
• Multi-shop ready
  Relevant configuration options can be adjusted individually for each sales channel.
• Compatibility
  The extension is always compatible with the latest Shopware version and the Shopware default theme.
• Incompatibility
  If you use a custom theme and/or third-party extensions, please test the extension thoroughly before buying. Compatibility cannot be guaranteed.
• Responsive
  Desktop PC, tablet or smartphone: the extension is fully responsive.
• Test version
  The extension can be tested free of charge and without obligation for 30 days (see the free trial month of the rental license).
• Features
  The features described in the description, the screenshots and the demo shop always refer to the latest version of the extension.
• Individual change requests
  Every company is unique and requires individual solutions that are precisely tailored to its own workflows. Feel free to contact me without obligation: I will gladly adapt my extensions to your requirements and integrate them seamlessly into your in-house processes.
• Liability disclaimer
  The manufacturer of this extension is not liable for damages, in particular not for direct or indirect consequential damages, data loss, lost profits, system or production failures resulting from the use of the extension, except in cases of intent or gross negligence.

Contact information

• Phone
  +49 (0) 234 97354482
• Internet
  info@digitvision.de
  https://www.digitvision.de
• Address
  Hevener Straße 65
  44797 Bochum

About me

• 20+ years of experience
  More than 20 years in e-commerce, more than 10 of them exclusively with Shopware. Your specialist with extensive industry and technical knowledge.
• Reliable
  Shopware is my passion and my hobby. I take care of your project reliably and with commitment, as if it were my own.
• Quality
  High service quality is my focus. I use state-of-the-art design patterns, current technologies and innovative tools.

Your competent partner

For more than 20 years I have been working as a passionate web developer in e-commerce. In this time I have advised and supported many companies in interesting projects. I stand for uncomplicated communication, future-proof solutions, modern technologies and a high level of commitment.

Every company is unique and requires individual solutions that are precisely tailored to its own workflows. Feel free to contact me without obligation: I will gladly adapt my extensions to your requirements and integrate them seamlessly into your in-house processes. I would be happy to provide you with offers for adaptations or individually developed extensions according to your wishes.