Tax ID for ELSTER VAT reporting Germany

(0) Share

Report

Posted on by CapsLock

1,419

Hi,

In Germany two different tax numbers are used:

* TAX ID format: 12 345 678 901. This is the one used to report on ELSTER.

* VAT number format: DE123456789

Does anyone know where the ELSTER file picks the TAX ID from?

I would expect from "Organization administration > Legal entities > Tax registration number":

But the file produced does not include that number (I assume the name of the field where it should be included is the one in yellow):

I then assume that the "Tax registration number" field is to inform the VAT number and does not get inserted into the ELSTER file.

So, my question is: where do we inform the Tax ID so it is picked up by the file? The report designer says that the name of the field is "Tax number":

Also, does anyone know what does these "mapped, no-mapped" refer to?

Thanks!

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

TaxNumber use the following mapping:

(TaxElectronicDeclaration.TaxAuthorityId&"0")&RIGHT(REPLACE(CurrentCompanyInfo.CoRegNum, "\D", "", true), 8)

It use combination of TaxAuthorityId field on TaxElectronicDeclaration table and CoRegNum (Routing number) on CompanyInfo table.

Was this reply helpful? Yes No
CapsLock 1,419 on at

Like (0)

Report

Hi Alireza,

That sounds like a very useful information and I thank you very much for it. Unfortunately I can't decipher it. Could you translate it to user interface language, please? Which field do we need to fill in so the VAT ID comes up in the Steuernummer on the file?

Thanks again!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi CapsLock,

At the moment there is no Elster integration available.

You have to do the reporting manually.

Best regards,

Ludwig

Was this reply helpful? Yes No
Christian Rothner 159 on at

Like (0)

Report

Hi CapsLock,

Our Elster integration is avaliable on AppSource:

appsource.microsoft.com/.../terna.be-terna_elster

Feel free to contact us if you need more information.

Was this reply helpful? Yes No