DE OSS / One-Stop-Shop
EU OSS (One-Stop-Shop, §18j UStG) worksheet: aggregate intra-EU B2C distance sales by destination rate, watch the EUR 10,000 threshold, build the OSS return worksheet for the BZSt portal.
Want DE OSS / One-Stop-Shop installed and configured for you? Onboarding Pack: $350 one-off
Support plans from $425 a month
The quarterly OSS return worksheet from your invoices
EU B2C distance sales per member state and VAT rate, the 10.000 EUR threshold with the crossing invoice, and a CSV for the BZSt portal
A German shop selling to private customers in other EU states pays the VAT of the destination country once the 10.000 EUR threshold is passed, and declares it quarterly through the One-Stop-Shop of the BZSt (§18j UStG). This app collects those sales from the posted invoices, groups them by country and rate, watches the threshold per year and prepares the figures you enter in the portal.
What you get
Collect a quarter
Posted customer invoices and credit notes to partners without VAT ID in another EU state, grouped by member state and rate, in company currency.
Rate check
The rate on the invoice is kept only when it is a rate of the destination state; an invoice still carrying German VAT gets the destination's standard rate from the table and the line is flagged.
Foreign currency
Invoices in another currency use the rate of the last day of the quarter.
Threshold monitor
Year-to-date and prior-year distance sales against 10.000 EUR, the crossing invoice and date, and voluntary opt-in.
Prior-period corrections
Corrections of earlier quarters with original and corrected VAT, deadline and net payable.
EU rate table
Standard and reduced rates of the 27 member states, with the previous standard rate where it changed.
Export
CSV of the return lines, totals and corrections for the BZSt entry; consistency check and annual summary.
Confirmed stays confirmed
A confirmed return is not collected again, from the form or the dialog, until you reset it to draft.
Screenshots
Odoo 19.0 with German user interface and example data of a German company.
1. OSS returns 2026
Q1 and Q2 confirmed, Q3 collected.
2. Return Q3 2026
Lines per member state and rate; the French order with German VAT flagged and taxed at 20 %.
3. Threshold 2025
Distance sales passed 10.000 EUR; the crossing invoice and its date.
4. EU VAT rates
Standard and reduced rates of the member states.
5. Collect a quarter
Year and quarter (the current one proposed) and confirm after collecting.
Why this app
✓ The return comes from the posted invoices of the quarter.
✓ Wrong German VAT on an EU sale is caught and flagged.
✓ The threshold is watched with the invoice that crossed it.
✓ File based: you enter the figures in the BZSt portal yourself.
Auf Deutsch
DE OSS / One-Stop-Shop erstellt das Arbeitsblatt für die vierteljährliche OSS-Meldung nach §18j UStG aus den gebuchten Rechnungen.
- Fernverkäufe an Privatkunden je Mitgliedstaat und Steuersatz
- Prüfung des Steuersatzes gegen die Sätze des Bestimmungslands
- Schwelle von 10.000 EUR mit der Rechnung der Überschreitung
- Berichtigungen früherer Quartale
- CSV für die Eingabe im BZSt-Portal, keine Übermittlung
Specifications
- This page: Odoo 19.0 (also available for Odoo 18.0 and 20.0)
- License: OPL-1
- Languages: English, German
- Depends on: Accounting (account)
- Output: CSV worksheet; no transmission to the BZSt
- Author: Pokutsoft, pokutsoft.com
- Support: support@pokutsoft.com
Update date: 2026-10-28 · Version: 19.0.1.0.17
User guides (PDF)
Related modules
DE Gelangensbestätigung
Audit-proof EU arrival confirmation (Gelangensbestätigung, §17b UStDV) and zero-rating evidence for innergemeinschaftliche Lieferungen.
DE Innergemeinschaftliche
Flag EU acquisitions (i.g. Erwerb) and imported services for reverse-charge VAT (§1a / §13b UStG) and map them to the correct UStVA boxes.
DE Ist-/Soll-Versteuerung
German cash-basis VAT (Ist-Versteuerung, §20 UStG): threshold watch, eligibility check and a clean Soll<->Ist changeover with transition register.