Individuelle Erlöskonten je EU-Mitgliedstaat für OSS-Sachverhalte (Rechnungsdatenservice 1.0)

 

Spätestens ab dem 01.07.2021 wird die Verbuchung je Land, in welches die Waren versandt wurden, unumgänglich werden, da ab diesem Datum tritt die steuerliche Neuregelung One Stop Shop in Kraft tritt. 

Seitens DATEV werden zwei unterschiedliche Vorgehensweisen empfohlen. Welche das sind, lesen Sie in: Umsetzung OSS in DATEV.

Buchung auf Erlöskonten pro Lieferland

Die Datenübertragung via DATEV-Datenservice Schnittstelle kann in easybill bis in das kleinste Detail konfiguriert werde. Je nach den Anforderungen oder den Wünschen der Steuerkanzlei. 

Damit die Umsätze auf unterschiedliche Erlöskonten übertragen werden können, muss das Format zunächst angepasst werden.

  1. Klicken Sie auf Meine Firma
  2. Klicken Sie auf Export
  3. Klicken Sie auf Ausgangsrechnungen
  4. Wählen Sie das Programm DATEV XML-Schnittstelle online (Belegsätze)
  5. Klicken Sie bei Formatkonfiguration auf Bearbeiten
    Sollten Sie noch kein eigenes Format angelegt haben auf Hinzufügen

 

blobid1.png

 

Wenn Sie noch kein eigenes Format angelegt haben, so geben Sie dem Format einen treffenden Namen und klicken Sie, oben rechts, auf Formatkonfiguration speichern. Ansonsten überspringen Sie diesen Punkt. 

 

blobid2.png

 

Sie finden in dieser Konfiguration viele Möglichkeiten die Datenübertragung anzupassen und zu individualisieren. Um die Erlöskonten zu konfigurieren, scrollen Sie bis zu AcountNo runter.

 

Bildschirmfoto_2021-05-17_um_13.30.39.png

 

  1. Aktivieren Sie das Überschreiben des Standards über den Radio-Button. 
  2. Löschen Sie den Inhalt
  3. Tragen Sie die Regel in das Feld ein (die fertige Regel finden Sie unter dem Screenshot) 
  4. Klicken Sie, oben rechts, auf Formatkonfiguration speichern

Bildschirmfoto_2021-05-17_um_13.25.05.png

 

Folgende Abfrage empfehlen wir, wenn pro EU Land, ohne CEE oder PAN EU auf ein eigenes Sachkonto gebucht werden soll. 

Die Erlöskonten hinter jeder Regel können natürlich individuell vergeben werden. 

{% if document.vat_option == nil and document.shipping_country == document.vat_country %}
{% if document.shipping_country == 'AT' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'BE' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '12.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'BG' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'CY' %}
{% if document_item.vat_percent == '19.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'CZ' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '15.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'DK' %}
{% if document_item.vat_percent == '25.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'EE' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '14.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'ES' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% elsif document_item.vat_percent == '4.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'FI' %}
{% if document_item.vat_percent == '24.0'%}4320
{% elsif document_item.vat_percent == '14.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'FR' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% elsif document_item.vat_percent == '5.5'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'GR' %}
{% if document_item.vat_percent == '24.0'%}4320
{% elsif document_item.vat_percent == '16.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'HR' %}
{% if document_item.vat_percent == '25.0'%}4320
{% elsif document_item.vat_percent == '24.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '5.5'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'HU' %}
{% if document_item.vat_percent == '27.0'%}4320
{% elsif document_item.vat_percent == '18.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'IE' %}
{% if document_item.vat_percent == '23.0'%}4320
{% elsif document_item.vat_percent == '13.5'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '4.8'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'IT' %}
{% if document_item.vat_percent == '22.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% elsif document_item.vat_percent == '4.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'LT' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'LU' %}
{% if document_item.vat_percent == '17.0'%}4320
{% elsif document_item.vat_percent == '14.0'%}4320
{% elsif document_item.vat_percent == '8.0'%}4320
{% elsif document_item.vat_percent == '3.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'LV' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '12.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'MT' %}
{% if document_item.vat_percent == '18.0'%}4320
{% elsif document_item.vat_percent == '7.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'NL' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'PL' %}
{% if document_item.vat_percent == '23.0'%}4320
{% elsif document_item.vat_percent == '8.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'PT' %}
{% if document_item.vat_percent == '23.0'%}4320
{% elsif document_item.vat_percent == '22.0'%}4320
{% elsif document_item.vat_percent == '18.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'RO' %}
{% if document_item.vat_percent == '19.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'SE' %}
{% if document_item.vat_percent == '25.0'%}4320
{% elsif document_item.vat_percent == '12.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'SI' %}
{% if document_item.vat_percent == '22.0'%}4320
{% elsif document_item.vat_percent == '9.5'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'SK' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'MC' %}
{% if document_item.vat_percent == '19.6'%}4320
{% elsif document_item.vat_percent == '5.5'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'XI' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'UK' or document.shipping_country == 'GB' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}

 

Folgende Abfrage empfehlen wir, wenn pro EU Land, inklusive CEE oder PAN EU auf ein eigenes Sachkonto gebucht werden soll. 

Die Erlöskonten hinter jeder Regel können natürlich individuell vergeben werden. 

 

{% if document.vat_option == nil and document.shipping_country == document.vat_country %}
{% if document.fulfillment_country == 'PL' and document.shipping_country == 'PL'%}4100
{% elsif document.fulfillment_country == 'CZ' and document.shipping_country == 'CZ' %}4101
{% elsif document.fulfillment_country == 'IT' and document.shipping_country == 'IT' %}4102
{% elsif document.fulfillment_country == 'ES' and document.shipping_country == 'ES' %}4103
{% elsif document.fulfillment_country == 'FR' and document.shipping_country == 'FR' %}4104
{% elsif document.fulfillment_country == 'SE' and document.shipping_country == 'SE' %}4105
{% elsif document.fulfillment_country == 'NL' and document.shipping_country == 'NL' %}4106
{% elsif document.fulfillment_country == 'SK' and document.shipping_country == 'SK' %}4107
{% elsif document.shipping_country == 'AT' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'BE' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '12.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'BG' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'CY' %}
{% if document_item.vat_percent == '19.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'CZ' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '15.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'DE' %}
{% if document_item.vat_percent == '19.0'%}4320
{% elsif document_item.vat_percent == '7.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'DK' %}
{% if document_item.vat_percent == '25.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'EE' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '14.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'ES' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% elsif document_item.vat_percent == '4.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'FI' %}
{% if document_item.vat_percent == '24.0'%}4320
{% elsif document_item.vat_percent == '14.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'FR' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% elsif document_item.vat_percent == '5.5'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'GR' %}
{% if document_item.vat_percent == '24.0'%}4320
{% elsif document_item.vat_percent == '16.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'HR' %}
{% if document_item.vat_percent == '25.0'%}4320
{% elsif document_item.vat_percent == '24.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '5.5'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'HU' %}
{% if document_item.vat_percent == '27.0'%}4320
{% elsif document_item.vat_percent == '18.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'IE' %}
{% if document_item.vat_percent == '23.0'%}4320
{% elsif document_item.vat_percent == '13.5'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '4.8'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'IT' %}
{% if document_item.vat_percent == '22.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% elsif document_item.vat_percent == '4.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'LT' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'LU' %}
{% if document_item.vat_percent == '17.0'%}4320
{% elsif document_item.vat_percent == '14.0'%}4320
{% elsif document_item.vat_percent == '8.0'%}4320
{% elsif document_item.vat_percent == '3.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'LV' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '12.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'MT' %}
{% if document_item.vat_percent == '18.0'%}4320
{% elsif document_item.vat_percent == '7.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'NL' %}
{% if document_item.vat_percent == '21.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'PL' %}
{% if document_item.vat_percent == '23.0'%}4320
{% elsif document_item.vat_percent == '8.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'PT' %}
{% if document_item.vat_percent == '23.0'%}4320
{% elsif document_item.vat_percent == '22.0'%}4320
{% elsif document_item.vat_percent == '18.0'%}4320
{% elsif document_item.vat_percent == '13.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'RO' %}
{% if document_item.vat_percent == '19.0'%}4320
{% elsif document_item.vat_percent == '9.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'SE' %}
{% if document_item.vat_percent == '25.0'%}4320
{% elsif document_item.vat_percent == '12.0'%}4320
{% elsif document_item.vat_percent == '6.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'SI' %}
{% if document_item.vat_percent == '22.0'%}4320
{% elsif document_item.vat_percent == '9.5'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'SK' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '10.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'MC' %}
{% if document_item.vat_percent == '19.6'%}4320
{% elsif document_item.vat_percent == '5.5'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'XI' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% elsif document.shipping_country == 'UK' or document.shipping_country == 'GB' %}
{% if document_item.vat_percent == '20.0'%}4320
{% elsif document_item.vat_percent == '5.0'%}4320
{% elsif document_item.vat_percent == '0.0'%}4320
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}
{% else %}{{ fieldAccountsReceivableLedgerAccountNo }}
{% endif %}

 

Lesen Sie auch: OSS-ab dem 01.07.2021

Haben Sie Fragen? Anfrage einreichen

0 Kommentare

Zu diesem Beitrag können keine Kommentare hinterlassen werden.