DATEV & Lexware Accounting Export Pro

DATEV & Lexware Accounting Export Pro

Commercial accounting export extension by [KeRn Web Services](https://kern-ws.com), version 1.2.0. Supports Bagisto 2.3 / Laravel 11 / PHP 8.2+ and Bagisto 2.4 / Laravel 12 / PHP 8.3+.

Included workflows

- DATEV EXTF 700 booking batches, format version 13, with a 31-field metadata header and 125 booking fields. Windows-1252 encoding and CRLF line endings.

- UTF-8 preparation CSVs for Lexware and sevDesk workflows. These require column mapping, review and a compatible receiving process. **Lexware Office and sevDesk do not directly import these booking CSVs.** This extension includes no connection to their APIs.

- Invoices and refunds selected by creation date and channel. Refunds reverse the recorded amounts; refund adjustments are separate untaxed components. Re-exporting an overlapping period produces duplicate documents: reconcile batch history before importing again.

- Recorded accounting **base amounts and currency**, including shipping, discounts and mixed 0%, 7% and 19% VAT. Other rates and currencies with other than two decimal places are rejected. Different base currencies cannot share a batch; transaction currency is retained as reference in preparation CSVs.

- Configurable SKR03/SKR04 revenue and collective debtor accounts, including zero-tax and adjustment accounts. All accounts must match the configured length of 4–8 digits. Defaults are starting points and require accountant review.

- Native Bagisto admin components, role permissions, private file downloads, batch identifiers, SHA-256 file integrity checks and retained batch metadata when a file is removed. ShopAgent integration provides authorized administrators with batch status only.

- 23 language catalogs, covering the 22 native Bagisto admin locales plus Finnish. No external service is contacted during export.

Configure before exporting

Enable **Configuration → Sales → Accounting Export**. Set the chart and every account mapping. For DATEV, enter the actual consultant number (1001–9999999), client number (1–99999) and account length. Grant **Sales → Accounting Export** only to intended administrator roles. The permission allows viewing, generating, downloading and removing export files.

Open **Sales → Accounting Export**, choose a channel, format and dates, then create the batch. A batch contains at most 5000 documents, 1000 items per document, 25000 postings and 25 MB; select shorter periods for larger shops. The maximum period is 366 days. DATEV supports a single calendar year with a January 1 fiscal start; non-calendar fiscal years require preparation CSVs and accountant processing.

Zero-tax treatment defaults to the standard zero-tax account. Selecting EU or third-country exemption is an explicit classification by the operator and is only accepted for documents with no recorded tax. An address or VAT ID never causes an automatic exemption. The EU option additionally requires a syntactically valid EU VAT ID in DATEV; it does not validate VAT IDs online or prove eligibility.

The export reconciles native four-decimal source amounts and allocates rounding at document level. DATEV uses automatic revenue accounts. Where Bagisto recorded tax before a discount, an additional correction posting uses BU 0040 to preserve the recorded tax. A DATEV batch is rejected if automatic-account tax still differs from the recorded tax; use a preparation CSV for accountant review. Custom mappings must retain the corresponding account functions in the target chart.

Unsupported rates, inconsistent recorded totals, invalid DATEV document identifiers or missing configuration stop the complete batch. No partial file is offered. Preparation CSVs preserve document/payment state; they do not mark invoices paid or record payment settlements. They are not a complete general ledger, purchase ledger, bank reconciliation or electronic invoice archive.

Files and history

Files are stored privately under `storage/app/private/accounting-exports` and downloaded through authenticated, permission-checked admin routes. Back up this directory together with the database. Removing a file retains the batch totals, source document IDs, hash and removal event. This history is operational metadata, **not an immutable or certified GoBD archive**. Your retention and privacy processes remain necessary. Files using an unsupported export schema must be regenerated before downloading.

Untrusted text is quoted correctly and spreadsheet formula prefixes are neutralized with an apostrophe. Review this visible prefix when mapping text into other software. DATEV reference identifiers with unsupported characters are rejected instead of silently changed. Windows-1252 transliteration may replace characters outside that encoding.

See [INSTALLATION.md](INSTALLATION.md) and [LICENSE.txt](LICENSE.txt). The commercial license permits one production shop and its private staging/development copies, including source modifications for that shop. Support: [support@kern-ws.com](mailto:support@kern-ws.com).

This extension is not certified by DATEV, Lexware, sevDesk or Bagisto. Acceptance in a particular accounting application must be tested with that application's import configuration.