Data Points and technical IDs

This page provides a comprehensive overview of all relevant data points, import file examples, position mapping, and P2 master data. It is important to note that finding the individual structure for your group when importing is crucial. Therefore, this explanation cannot replace a personal meeting before preparing an import file or anything else.

To read the files, they should be downloaded and opened in Excel format.

Pillar 2 Datapoint list - OECD Standard

This list provides an overview of all Pillar 2 data points in the Entity Data Collection - OECD Standard section. It can be used in the data collection process or to discuss data points with tax advisors.

Pillar 2 Example ‘Entity Data Collection’ csv Importfile & Mapping

To import data into the Pillar 2 module, use an Excel csv file. This file type is especially useful for importing entity choices and text, such as accounting standards, which are not usually available in the company's other IT tools and are collected solely for the purpose of the GTC P2 calculation. Before uploading the import file via csv, ensure that the structure has been implemented by AMANA. The import file must match the interface and mapping of the individual, and a specific structure will be most beneficial for your data input and IT environment. This file provides a simple example to give an idea of the structure. The file will generally include the following information:

1. Company ID - Column 1 of the example (Tab Bsp.1)
   The data is imported to the company with the corresponding GTC company ID.

2. Technical ID - Column 2 of the example (Tab Bsp.1)
   The technical ID of the data entry field.

3. Value - Column 3 of the example (Tab Bsp.1)
   Entry value of the company for the corresponding entry field in the GTC

Usually the technical ID is translated into a more readable format by integrating a position mapping. For example, it can be translated to the reference IDs of the GTC (INC-1, DT-2, ...) or to the individual account IDs of the company. In the case of an interface to other IT tools, the position mapping links the ID of the other IT tool to the relevant GTC technical ID. See the two examples of import files with their corresponding position mapping in tab 2-5 Example 2 Import & Mapping using the GTC Reference IDs and Example 3 Import & Mapping using the GTC Reference IDs. 3 Import and Mapping using Individual Account IDs.

General information on csv Importfiles:

• You can import any value, text or election from the Entity Data Collection section. Choices with the csv file are imported using 0 (no choice) and 1 (choice).

• Tax rates are generally imported in full numbers. (e.g. 30 for 30%)

• It is possible to import multiple values to a single technical ID or to map multiple accounts to a single technical ID. Conversely, it is possible to map a single value to multiple technical IDs, or to map an account to multiple technical IDs.

• It is possible to perform a mass import of data for multiple companies. The data is imported into the company with the company ID of the import file.

• In the position mapping, you can add calculation logic (e.g. a multiplier) to the imported values. This allows you, for example, to import only a percentage of each import value (e.g. in the case of a joint operation or a pro rata import of joining or leaving CEs), or to convert positive values to negative values or vice versa.

Example Importfiles and position mappings:

Pillar 2 Master Data Importfile

The import file is used to import or update the data in the Company Master Data section of the Pillar 2 tab.

Please note: The Pillar 2 master data is currently being revised due to the ongoing development of the module. At the moment the information in this dialogue has no impact on the calculation (except for Excluded CEs and AMAE00). Therefore, we are not suggesting our customers to prepare the master data at this time! It is very likely that the information in this dialogue will be updated.

Open

Pillar 2 company Master Data

The import must be uploaded to the system by AMANA, but you can prepare your company information in the P2 Master Data Import file: