Versions Compared

Old Version 1

changes.mady.by.user ANI

Saved on

compared with

New Version 2

changes.mady.by.user Lars Schuermans

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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

 

The

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

 

Company

 The company must be specified. Depending on the 'Display [ !worddav00c5ed59d08ea51d691a3df96541f5d1.

pngheight

png height=13,width=13! ]' parameter, e.g. a tax group or a subgroup is evaluated. In addition, parameter 'FX Code [ !worddav4772a17b609a38bf55e3b38d14047551.

pngheight

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! ]

 

<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[

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>

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>


Wiki Markup
_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\]:
!worddavb861d71a29801d26dccf60c5b2d6063e.png|height=207,width=549!
_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\]:

...


  1. Balance 
     
     Development 
     
     \[e.g. 
     
     _Local 
     
     GAAP 
     
     – 
     
     Tax 
     
     comparison{_}\]
  2.  Wiki Markup
    ERiC 
     
     Transfer 
     
     \[e.g. 
     
     _ERiC 
     
     delivery 
     
     status{_}\]
    unmigrated-wiki-markup
  3. Deferred 
     
     Taxes 
     
     \[e.g. 
     
     _Rollforward 
     
     deferred 
     
     taxes{_}\]
  4.  Wiki Markup
    Others 
     
     \[e.g. 
     
     _Comments{_}\]
    unmigrated-wiki-markup
  5. Master 
     
     Data 
     
     \[e.g. 
     
     _Countries 
     
     master 
     
     data{_}\]
  6.  Wiki Markup
    Current 
     
     Taxes 
     
     \[e.g. 
     
     _dialogue 
     
     § 
     
     8b 
     
     KStG{_}\]
  7.  Wiki Markup
    Technical 
     
     Details 
     
     \[e.g. 
     
     _Database 
     
     table 
     
     of 
     
     current 
     
     tax 
     
     calculation{_}\]
    unmigrated-wiki-markup
  8. 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
 
Report 
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:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9589b6e7-0c28-4bfc-a60a-ef3b03ad84c3"><ac:plain-text-body><![CDATA[
]]></ac:plain-text-body></ac:structured-macro>
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>

 Wiki Markup
_Table 17: Scope of Tax Reports_
_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 server.