GermanyAccounting/Localizations/Reporting

DE UStVA Worksheet +

Name: DE UStVA Worksheet +
Price: 49 USD

Umsatzsteuer-Voranmeldung worksheet: compute Kennziffern (Kz 81/86/89/93/46/47/43/41/66/61/67/62/83) and emit the ISO-8859-15 ELSTER import XML you upload in Mein-ELSTER

Odoo 20.0Odoo 19.0Odoo 18.0

$49Buy on Odoo Store

Want DE UStVA Worksheet + installed and configured for you? Onboarding Pack: $350 one-off

Support plans from $425 a month

Odoo 19.0

Also available for Odoo 18.0 and 20.0 · OPL-1 · English, Deutsch

UStVA Kennziffern from your posted taxes, and the ELSTER XML

Umsatzsteuer-Voranmeldung worksheet for a month or quarter: Kennziffern from the tax lines, plausibility checks and the XML file you upload in Mein ELSTER

Every month or quarter the Voranmeldung needs the same Kennziffern: 81 and 86 for the domestic sales, 41 for intra-EU supplies, 89 for acquisitions, 84/85 for §13b, 66, 61 and 67 for the Vorsteuer and 83 for the Zahllast. This app builds them from the posted taxes of the period, signed, so credit notes reduce them, checks the result and writes the XML file for the upload of form data in Mein ELSTER. The module transmits nothing itself.

Month or quarter Kz 81 · 86 · 41 · 89 · 84 Vorsteuer 66 · 61 · 67 Kz 83 Plausibility ELSTER XML

What you get

Kennziffern from the taxes

Tax lines and the bases of 0 % taxes are summed into the Kennziffern; credit notes reduce them.

Treatment on the tax

Intra-EU supply, export, acquisition and §13b all have 0 % or a special rate; you classify the tax once and the right Kennziffer pair is used.

Self-assessed tax

§13b and intra-EU acquisitions: the owed VAT and the deductible Vorsteuer go to their own Kennziffern.

Nothing dropped silently

Taxes with bookings but no mapping are listed with their amount.

Plausibility check

Steuernummer, rate consistency, bases without tax, negative values and the Zahllast arithmetic; blocking errors stop the XML.

ELSTER XML

ISO-8859-15 file with the namespace and version of the form year, for the upload in Mein ELSTER.

Corrections and worksheet

Berichtigte Anmeldung as a copy, CSV worksheet per Kennziffer, Dauerfristverlängerung worksheet with the Sondervorauszahlung (1/11).

Screenshots

Odoo 19.0 with German user interface and example data of a German company.

1. Start a Voranmeldung

Company, year and period.

DE UStVA Worksheet + in Odoo: Start a Voranmeldung

2. Kennziffern September 2026

Domestic sales, intra-EU supplies, acquisition, §13b and Vorsteuer, with the Zahllast.

DE UStVA Worksheet + in Odoo: Kennziffern September 2026

3. Plausibility check

A tax with bookings but no Kennziffer (0 % EU service) is a blocking error: no XML until it is mapped.

DE UStVA Worksheet + in Odoo: Plausibility check

4. ELSTER file

August 2026 passed the checks: the XML for the upload in Mein ELSTER.

DE UStVA Worksheet + in Odoo: ELSTER file

5. Tax mapping

Which tax goes into which Kennziffer.

DE UStVA Worksheet + in Odoo: Tax mapping

6. Kennziffern

The UStVA Kennziffern with nature and direction.

DE UStVA Worksheet + in Odoo: Kennziffern

Why this app

✓ The Kennziffern come from the posted taxes, not from a spreadsheet.

✓ Credit notes and self-assessed taxes are counted the right way.

✓ Unmapped taxes are shown, so no turnover goes missing.

✓ The file is ready for the upload in Mein ELSTER.

Auf Deutsch

DE UStVA Worksheet ermittelt die Kennziffern der Umsatzsteuer-Voranmeldung eines Monats oder Quartals aus den gebuchten Steuern, prüft sie und erzeugt die XML-Datei zum Hochladen in Mein ELSTER.

Kennziffern 81, 86, 41, 43, 89, 93, 46/47, 84/85, 60, 66, 61, 67, 62 und 83
UStVA-Behandlung je Steuer für innergemeinschaftliche Umsätze, Ausfuhr und §13b
Nicht zugeordnete Steuern werden mit Betrag angezeigt
Plausibilitätsprüfung mit blockierenden Fehlern
ELSTER-XML (ISO-8859-15), Berichtigung, CSV-Arbeitsblatt, Dauerfristverlängerung