DATEV export
  1. Home
  2. Manual
  3. All settings

Manual Lots to set, explained everywhere.

Everything has a documented default. Only a few details are required: advisor and client number, a sales channel, the debtor and the revenue accounts of the rates that occur. What a setting does is written on it in the admin.

On the tenant

Per company, in the tabs of the tenant.

your-shop.com/admin

Orders › DATEV export › Tenants

Muster Handels GmbH

CancelSave

Master dataBookingAccountsTax & OSSExportSales channels

Everything here is ready for the export - nothing on this tab can be missing. Whether a run happens at all is decided on the "Accounts" and "Sales channels" tabs: without a revenue and a debtor account and without an assigned sales channel the export is blocked, whatever is set here.

Booking & taxation

When turnover arises for tax purposes and how the bookings are handed over.

Everything here is optional and has a default: accrual taxation (turnover arises with the invoice), one booking row per document, cancellations as a general reversal (DATEV field 118), the lock flag off, no cost centres. Only change something when your tax advisor explicitly asks for it.

Taxation typeAccrual taxation (by invoice)

Performance dateDo not export (default)

Booking modeOne booking per document (default)

Storno bookingGeneral reversal (default)

Lock bookings

Write the order number into the file

Cost centres

Whether the bookings carry the DATEV fields KOST1 and KOST2 - the rules live under Cost centres

Fill cost centres

Posting text

The description that accompanies every booking in the DATEV file (field 14, 60 characters).

Posting text (document)Beleg {belegNummer}Result: Beleg RE-10045

Posting text (payment)Zahlung Bestellung {bestellNummer}Result: Zahlung Bestellung 10045

Document types

Which Shopware document types are exported as invoice, credit note and cancellation. The usual types (invoice, credit_note, storno including their ZUGFeRD variants) are always included - here you only add ADDITIONAL custom document types. Leaving it empty is the norm.

Document types: invoiceDefault: invoice

Document types: credit noteDefault: credit note

Document types: stornoDefault: cancellation invoice

  • Active

    Master data tab, Tenant card, Active switch.

    Default
    on
    Remark
    when inactive, the tenant does not export at all
  • Chart of accounts

    Master data tab, DATEV file card, Chart of accounts field.

    Default
    SKR03
    Remark
    or SKR04
  • Account length

    Master data tab, DATEV file card, Account length field.

    Default
    4
    Remark
    4 to 8 digits
  • Interface version

    Master data tab, DATEV file card, Interface version field.

    Default
    700
    Remark
    the only version; the file always has the 125-field layout
  • Start of the fiscal year

    Master data tab, DATEV file card, Fiscal year start field.

    Default
    1 January
  • Booking time zone

    Master data tab, DATEV file card, Booking timezone field.

    Default
    Europe/Berlin
    Remark
    for document date and month boundaries
  • Seat country (ISO)

    Master data tab, DATEV file card, Seat country (ISO) field.

    Default
    DE
  • Taxation

    Booking tab, Booking & taxation card, Taxation type field.

    Default
    Accrual
    Remark
    or cash basis
  • Booking mode

    Booking tab, Booking & taxation card, Booking mode field.

    Default
    Single booking per document
    Remark
    or collective booking per day and account, then without document number and link
  • Cancellation booking

    Booking tab, Booking & taxation card, Storno booking field.

    Default
    General reversal
    Remark
    or sign flip (side switch)
  • Performance date

    Booking tab, Booking & taxation card, Performance date field.

    Default
    none
    Remark
    or order or shipping date, field 115
  • Lock bookings (DATEV freeze)

    Booking tab, Booking & taxation card, Lock bookings switch.

    Default
    off
    Remark
    flag in the file header with which DATEV freezes after the import
  • Order number in the file

    Booking tab, Booking & taxation card, Write the order number into the file switch.

    Default
    on
    Remark
    field 95
  • Posting text documents

    Booking tab, Posting text card, Posting text (document) field.

    Default
    "Beleg {belegNummer}"
    Remark
    or a pattern of your own
  • Posting text payments

    Booking tab, Posting text card, Posting text (payment) field.

    Default
    "Zahlung Bestellung {bestellNummer}"
    Remark
    or a pattern of your own
  • Document types invoice, credit note, cancellation

    Booking tab, Document types card, Document types: invoice field.

    Default
    Shopware standard, also ZUGFeRD
    Remark
    further types can be assigned
  • Fill cost centres

    Booking tab, Cost centres card, Fill cost centres switch.

    Default
    off
    Remark
    rules under Master data › Cost centres
  • Debtor mode

    Accounts tab, Debtor account card, Debtor mode choice.

    Default
    Collective debtor
    Remark
    or per payment method, with diverse addresses, individual debtors
  • Debtor account rule

    Accounts tab, Debtor account rule card.

    Default
    {{ order.orderCustomer.customerNumber }}
    Remark
    for individual debtors
  • Send email and phone

    Accounts tab, Debtor account card, Include e-mail and phone switch.

    Default
    off
    Remark
    only with individual debtors or diverse addresses
  • Show tax key fields

    Accounts tab, Tax keys (BU) card, Show tax-key fields next to the accounts switch.

    Default
    off
    Remark
    display only
  • Small business

    Tax & OSS tab, Small business scheme card, Small business under §19 UStG switch.

    Default
    off
  • OSS

    Tax & OSS tab, OSS booking method card, OSS procedure active switch.

    Default
    off
  • OSS booking method

    Tax & OSS tab, OSS booking method card, Method choice.

    Default
    Revenue account per destination country
    Remark
    or collective account 8320 (SKR04: 4320) with key 240
  • OSS collective account, electronic services

    Tax & OSS tab, OSS booking method card, OSS revenue account for electronic services field.

    Default
    8331 (SKR04: 4331), key 280
    Remark
    or 250 with an account of its own from the tax firm
  • Already exported documents

    Export tab, Export behaviour card, Already exported documents field.

    Default
    Skip
    Remark
    or again with or without a warning, or block
  • Warnings block the export

    Export tab, Export behaviour card, Warnings block the export switch.

    Default
    off
  • Export payments

    Export tab, Payments card, Export payments switch.

    Default
    off
  • Automatic export

    Export tab, Scheduled export card, Automatic scheduled export switch.

    Default
    off, monthly, 6 a.m.
  • Email after the automatic export

    Export tab, Mail after the scheduled export card, Send the mail switch.

    Default
    on
  • Email addresses: tax advisor, second, own

    Export tab, Mail after the scheduled export card.

    Default
    empty
    Remark
    all three independently optional; each filled address receives a separate email

For all tenants

In the plugin settings under System.

your-shop.com/admin#/sw/extension/config/DvsnDatev

DATEV export › System › Settings

DATEV Export

Save

The per-tenant configuration lives in the module under Orders, DATEV export (master data, sales channels, accounts, tax & OSS). Only the shop-wide settings live here: scheduled export and tax advisor mail, threshold monitoring and protocol level.

Scheduled export & tax advisor mail

Mail even when the export is empty

Mail on a failed/blocked export

Attach the file up to (MB)8

Delivery-threshold monitoring

Monitor the EU distance-sale threshold

EU-wide threshold (EUR)10000

Warning at (% of threshold)90

Decision protocol (traceability)

Which documents the protocol listsDocuments of this period

Beleg packages

Belege per package (max. 4999)4000

Package size in MB (max. 450)100

Look-back for documents dated into the period

Look-back in days30

Step sizes and limits

Belege per step250

Bookings per file99996

Unfinished export jobs

Never frozen: mark as failed after (minutes)1440

Frozen: mark as cancelled after (hours)24

Scheduled tasks and console

Run the scheduled tasks

Allow the console commands

  • Email on an empty export too

    Scheduled export & tax advisor mail card, Mail even when the export is empty switch.

    Default
    off
    Remark
    only for the scheduled export
  • Email on a failed or blocked export

    Scheduled export & tax advisor mail card, Mail on a failed/blocked export switch.

    Default
    on
    Remark
    only for the scheduled export, at most once per period and day
  • Attach the file up to

    Scheduled export & tax advisor mail card, Attach the file up to (MB) field.

    Default
    8 MB
    Remark
    as a link above that
  • Monitor the EU delivery threshold

    Delivery-threshold monitoring card, Monitor the EU distance-sale threshold switch.

    Default
    on
    Remark
    once a day
  • EU-wide threshold

    Delivery-threshold monitoring card, EU-wide threshold (EUR) field.

    Default
    €10,000
    Remark
    fixed by law; a lower value only brings the early warning forward
  • Warning from

    Delivery-threshold monitoring card, Warning at (% of threshold) field.

    Default
    90% of the threshold
    Remark
    early warning before the limit is crossed
  • Which documents the protocol lists

    Decision protocol (traceability) card, Which documents the protocol lists field.

    Default
    Documents of this period
    Remark
    or also those of other periods
  • Documents per package

    Beleg packages card, Belege per package (max. 4999) field.

    Default
    4,000
    Remark
    at most 4,999
  • Package size

    Beleg packages card, Package size in MB (max. 450) field.

    Default
    100 MB
    Remark
    at most 450 MB
  • Look-back in days

    Look-back for documents dated into the period card, Look-back in days field.

    Default
    30
    Remark
    for documents created before the period and dated into it
  • Documents per step

    Step sizes and limits card, Belege per step field.

    Default
    250
    Remark
    smaller for slow servers
  • Bookings per file

    Step sizes and limits card, Bookings per file field.

    Default
    99,996
    Remark
    the DATEV limit; smaller splits into more files
  • Never frozen: mark as failed after

    Unfinished export jobs card, Never frozen: mark as failed after (minutes) field.

    Default
    24 hours
    Remark
    the run never became binding: do not use the file, export the period again
  • Frozen: mark as cancelled after

    Unfinished export jobs card, Frozen: mark as cancelled after (hours) field.

    Default
    24 hours
    Remark
    binding, only document packages are missing and can be resumed; frozen means locked here, not the DATEV flag
  • Run the scheduled tasks

    Scheduled tasks and console card, Run the scheduled tasks switch.

    Default
    on
    Remark
    the admin is not affected
  • Allow the console commands

    Scheduled tasks and console card, Allow the console commands switch.

    Default
    on
    Remark
    the admin is not affected
In the admin

Every setting says what it does.

A note on almost every setting explains its effect, its default and when it pays off.

your-shop.com/admin

Orders › DATEV export › Tenants

Muster Handels GmbH

CancelSave

Master dataBookingAccountsTax & OSSExportSales channels

Export behaviour

How the export behaves in special cases

Already exported documentsWhat happens when a period is exported again. Recommended for live operation: documents already exported once are left out of the next run, so DATEV never books anything twice. Corrections go through a reversal/credit note.Skip (standard - no double export)

Warnings block the export

  • Point at the question mark next to the name of a setting and its note opens.

The other chapters

Accounts and debtors

Revenue, cash, shipping and voucher accounts, the four ways to the debtor and the cost centres.

Export and history

Period, preview, test export and export, the running run and the history.

Glossary

Booking batch, general reversal, freeze and the other words from DATEV and Shopware.