...
It is possible to import the full report from Excel. A basic import template can be opened at the Excel menu ("Save template as…"). The Excel import works with Excel named ranges, so all named ranges need to exists in a Workbook. For the multi-line and column ranges like the list of entities and summery per tax jurisdictions, the number of columns in the named range needs to match the template, otherwise the import is not possible. But the named ranges can be moved to any region in the Workbook or being integrated into existing Workbooks.
It is important to know, that all data in the report will be removed and overwritten, if an Excel import is performed. So, the recommended approach is to import data from Excel first, and then adjust the report in the tool.
Creating Reports for the German Tax Authorities (BZSt)
When submitting the CbC Report to the German tax authorities (BZSt), a custom XML Schema have to be used with additional fields. This section is only available in the template starting with version 1.1.9, and all fields are mandatory. It is very important to carefully read the instructions about the content of the fields provided in the comment/note of the cell header.
However, for the field "Steuernummer der Konzerngesellschaft" requires a special treatment, due to an error from the BZSt (see more information on page 8 of the Kommunikationshandbuch).
- When submitting before the 1st of December 2019, the BZSt Number has to be added instead of the Steuernummer.
- When submitting on or after the 1st of December 2019, the Steuernummer has to be provided, but in a special format:
- No special characters like "/" are allowed.
- The Steuernummer has to be provided as a 12-diget, so called "Bundesschema" (see more information and sample Steuernummern on Wikipedia).
- If the Steuernummer is only 9 or 10 digest, the Finanzamtsnummer has to be added as a postfix.
- If the Finanzamtsnummer is not know, it can be found out by searching the city of the Finanzamt in the Gemfa 2.0 tool on the BZSt Webpage:
https://www.bzst.de/DE/Service/Behoerdenwegweiser/Finanzamtsuche/GemFa/finanzamtsuche_node.html
Submitting Reports to BZSt using the ELMA SFTP Upload
...