Tax reports0

Various [predefined] reports can be opened from the Tax Reports dialogue. The selected report is opened in an Excel file and can be partially configured by the user [e.g. period to compare or FX code].
Parameters to be set
Every report is based on the selected parameters. Individual settings can be made in the dialogue header; they are described further.

Fig. 156: Parameters for Tax Reports

Parameter		Description
Applies to period		The period must be specified; defines the period under consideration
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="445a2d31-52e6-4576-8eeb-2cca5f8d89c2"><ac:plain-text-body><![CDATA[	Company		The company must be specified. Depending on the 'Display [ !worddav00c5ed59d08ea51d691a3df96541f5d1.png	height=13,width=13! ]' parameter, e.g. a tax group or a subgroup is evaluated. In addition, parameter 'FX Code [ !worddav4772a17b609a38bf55e3b38d14047551.png	height=14,width=12! ]' is also relevant for the selected company.		]]></ac:plain-text-body></ac:structured-macro>
Country		One or several countries can be selected here. The dropdown list content is determined by the period selected above.
Business Unit <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="608bbba5-38c7-4658-b455-b6a0a613d10b"><ac:plain-text-body><![CDATA[ [or Reporting Dimension]		One or several reporting dimensions can be selected here. The dropdown list content is determined by the period selected above or the content of the 'Reporting Dimension' dialogue.		]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d25967be-acf0-4629-a549-d825caf02536"><ac:plain-text-body><![CDATA[	Period to compare [ !worddav727c5167c41337a3ccef39bb3aedc723.png	height=12,width=13! ]		The dropdown list 'Period to compare' contains all periods created in the GTC. Prior period defined for the selected period is automatically proposed as a period to compare [so-called standard selection]. However, any other period can be selected. Period to compare must be selected for reports of the balance development category.		]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="7a075aa4-2137-4d62-92a5-a95334c6b77d"><ac:plain-text-body><![CDATA[	FX Code [ !worddav4772a17b609a38bf55e3b38d14047551.png	height=14,width=12! ]		In own currency ]]></ac:plain-text-body></ac:structured-macro> Report uses the currency of the selected company. <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2d015f7c-f08f-4248-af2d-735fc1cdcd43"><ac:plain-text-body><![CDATA[If the 'group structure' is selected in the 'Display' parameter and the company is a company from the USA [classified as a subgroup], all companies that belong to this group, e.g. also Canadian or South American have USD as their currency. ]]></ac:plain-text-body></ac:structured-macro> In group currency <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b2ac2d4c-b0b4-4aeb-bcf5-f9cf86cfc501"><ac:plain-text-body><![CDATA[Report uses the currency of the company defined as the parent company of the group [EUR] – independently of selected company. ]]></ac:plain-text-body></ac:structured-macro> <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d68873be-d274-448e-b312-5edcf43196ff"><ac:plain-text-body><![CDATA[If the 'group structure' is selected in the 'Display' parameter and the company is a company from the USA [classified as a subgroup], all companies that belong to this group, e.g. also Canadian or South American have EUR as their currency. ]]></ac:plain-text-body></ac:structured-macro> In local currency Report uses local currency defined in the 'Master Data'. Currency is not converted. <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f8a4eb83-27d8-4fa8-aa27-7b38b2d437be"><ac:plain-text-body><![CDATA[If the 'group structure' is selected in the 'Display' parameter and the company is a company from the USA [classified as a subgroup], all companies that belong to this group, e.g. Canadian or South American still have their local currency.		]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="534a2624-32e6-4cc2-85ed-45d401f3c84a"><ac:plain-text-body><![CDATA[	Display [ !worddav00c5ed59d08ea51d691a3df96541f5d1.png	height=13,width=13! ]		This parameter is relevant only for those companies for which the user is authorised. ]]></ac:plain-text-body></ac:structured-macro> Company Only the selected company is displayed in the report. List <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="ec165325-c6bd-477b-9459-54a36866bd9f"><ac:plain-text-body><![CDATA[All companies created in the 'Master Data' are displayed in the report. The content of the dropdown list is determined by the period selected above. If, in addition, a country or a reporting dimension is selected [depending on scope of individual reports], there is a further restriction of the generated report. ]]></ac:plain-text-body></ac:structured-macro> Group structure <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="82371ddb-f292-44ef-82a8-54ac919a97bc"><ac:plain-text-body><![CDATA[All companies belonging to a group are displayed. This selection parameter is available for those companies that are defined as '[sub-]group' in the 'Master Data'. When selecting this display option select a company that is defined as a [sub-]group. ]]></ac:plain-text-body></ac:structured-macro> Tax group structure All tax groups are displayed. . This selection parameter is available for those companies that are defined as 'parent company' in the 'Master Data'. When selecting this display option select a company that is defined as a parent company.
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="3decb519-252c-4d1c-a5f0-da2ab74c8958"><ac:plain-text-body><![CDATA[	Columns / Rows [ !worddav2761751d069d156491f287d69eba9e05.png	height=13,width=12! ]		This parameter determines the order of the generated Excel reports. Companies [values] can be displayed in columns or rows.		]]></ac:plain-text-body></ac:structured-macro>

Table 16: Parameter for Tax Reports
Select list Reports
Column 'Favourites'
Report list can be sorted by columns [e.g. favourites or data origin]. Frequently used reports can be marked as favourites [click on a star symbol]:

Fig. 157: Create and sort favourites in Tax Reports
Columns 'Data Origin' and parameter settings
Report list can be divided into the following areas ['Data Origin' column]:

Balance Development [e.g. Local GAAP – Tax comparison]
ERiC Transfer [e.g. ERiC delivery status]
Deferred Taxes [e.g. Rollforward deferred taxes]
Others [e.g. Comments]
Master Data [e.g. Countries master data]
Current Taxes [e.g. dialogue § 8b KStG]
Technical Details [e.g. Database table of current tax calculation]
TRR [e.g. Translation P&L results local GAAP/IFRS]

Depending on the data origin certain parameters/attributes must be specified. Settings made by the user are marked by green ticks per report. For the Translation P&L results local GAAP/IFRS report it is necessary to specify the period to compare [a green star]. Other parameters are irrelevant, e.g. FX Code does not affect the report.

Fig. 158: Required parameters per report
Column 'Scope'
Every report is based on a scope/viewpoint. The scope provides possible restrictions regarding the relevant companies:

Scope		Description
Company		Report cannot be restricted with respect to the 'Display' parameter. Only the data for the company selected in the 'Company' dropdown menu is displayed.
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8214cd2e-6b10-47d4-a3bb-e1b13cbc50de"><ac:plain-text-body><![CDATA[	[Sub-]Group		Report can be restricted by selecting a classified as a [sub-]group company [with the corresponding 'Display' option 'Group Structure'].	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="984c9055-28e0-4d35-8ffe-98b32cc0cd7a"><ac:plain-text-body><![CDATA[	Tax Group Structure		Report can be restricted by selecting a classified as a parent company [with the corresponding 'Display' option 'Tax Group Structure'].	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9589b6e7-0c28-4bfc-a60a-ef3b03ad84c3"><ac:plain-text-body><![CDATA[	Country		Report can be restricted by selecting one or several countries [with the corresponding 'Display' option 'List'].	]]></ac:plain-text-body></ac:structured-macro>
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="a2c0dc43-767b-418b-b007-3c75551f46b0"><ac:plain-text-body><![CDATA[	Reporting Dimension		Report can be restricted by selecting one or several reporting dimensions [with the corresponding 'Display' option 'List'].	]]></ac:plain-text-body></ac:structured-macro>

Table 17: Scope of Tax Reports
Button 'Show/hide columns'
Using the [ ] button, the technical report IDs can be displayed in a separate column.

Fig. 159: Column 'ID' of Tax Reports
Since report names in the GTC are revised and standardised, you can view additional column Name [alt]. This column helps the user to find the report under its original name.
Generate report
Reports are generated with a click on the Excel symbol. After that the report can be saved locally or opened. The report runtime varies according to the configuration of individual parameters and depends on the hardware used by the GTC server.