Tax reports


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

Company

 The company must be specified. Depending on the 'Displa<' parameter, e.g. a tax group or a subgroup is evaluated. In addition, parameter 'FX Code' is also relevant for the selected company.

Country

One or several countries can be selected here. The dropdown list content is determined by the period selected above.

Business Unit
(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.

Period to compare

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.

FX Code

In own currency
Report uses the currency of the selected company.

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.

In group currency
Report uses the currency of the company defined as the parent company of the group (EUR) – independently of selected company.

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.

In local currency
Report uses local currency defined in the 'Master Data'. Currency is not converted.

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.
Display

This parameter is relevant only for those companies for which the user is authorised.

Company
Only the selected company is displayed in the report.

List
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.

Group structure
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.

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.

Columns / Row

This parameter determines the order of the generated Excel reports. Companies (values) can be displayed in columns or rows.


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):


_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. ERiC Transfer (e.g. ERiC delivery status)

  3. Deferred Taxes e.g. Rollforward deferred taxes)

  4. Others (e.g. Comments)

  5. Master Data (e.g. Countries master data)

  6. Current Taxes (e.g. dialogue § 8b KStG)

  7. Technical Details (e.g. Database table of current tax calculation)

  8. 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.

(Sub-)Group

Report can be restricted by selecting a classified as a (sub-)group company (with the corresponding 'Display' option 'Group Structure').

Tax Group Structure

Report can be restricted by selecting a classified as a parent company (with the corresponding 'Display' option 'Tax Group Structure').

Country

Report can be restricted by selecting one or several countries (with the corresponding 'Display' option 'List').

Reporting Dimension

Report can be restricted by selecting one or several reporting dimensions (with the corresponding 'Display' option 'List').


Button 'Show/hide columns'
Using 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.