| Wiki Markup |
|---|
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.
!worddav9859d67c7f0a15e18be165f8bc183bfd.png|height=202,width=646!
_Fig. 156: Parameters for Tax Reports_ |
...
Parameter
...
...
Description
...
...
Applies to period
...
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.
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 | The company must be specified. Depending on the 'Display [ !worddav00c5ed59d08ea51d691a3df96541f5d1.pngheight=13,width=13! ]Displa<' parameter, e.g. a tax group or a subgroup is evaluated. In addition, parameter 'FX Code [ !worddav4772a17b609a38bf55e3b38d14047551.pngheight=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 | 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: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! ] |
| |
Columns / Row | 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> |
...
...
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
...
Wiki Markup Balance Development \[e.g. _Local GAAP – Tax comparison{_}\]Wiki Markup ERiC Transfer \[e.g. _ERiC delivery status{_}\]Wiki Markup Deferred Taxes \[e.g. _Rollforward deferred taxes{_}\]Wiki Markup Others \[e.g. _Comments{_}\]Wiki Markup Master Data \[e.g. _Countries master data{_}\]Wiki Markup Current Taxes \[e.g. _dialogue § 8b KStG{_}\]Wiki Markup Technical Details \[e.g. _Database table of current tax calculation{_}\]Wiki Markup TRR \[e.g. _Translation P&L results local GAAP/IFRS{_}\]
| Wiki Markup |
|---|
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.
!worddav31de002f88ced9bb985ab3c60b1fcaac.png|height=209,width=557!
_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
...
...
favourites (click on a star symbol):
_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. 
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 | (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 | ). |
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> |
...
). |
Button 'Show/hide columns'_
Using the \[ !worddavaf842bd065f05a26d1528262d4babc1b.png|height=30,width=138! \] button, the technical report IDs can be displayed in a separate column.
!worddav05c61ec1b7e2b806905b91b6ade62dbd.png|height=184,width=643!
_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 the Show / hide columns-button, the technical report IDs can be displayed in a separate column. 
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.