Data Transfer Import - Interface, Mapping & Import
- Mara Hartmann
- Alexandra Yussif
- Jonas Demmer
In order to transfer data to the Pillar 2 module, it is necessary to create an interface structure. This structure defines the interface type (e.g. csv file, SAP, REST), the direction of the data transfer (import, export) and the destination of the data transfer (Pillar 2). Mapping translates technical IDs into more readable IDs (e.g. readable IDs such as INC-1, DT-2) or company-specific IDs such as account numbers. Examples of mappings can be found in the "Mappings" section under "Important Documents". Two mappings are required for the data transfer: an import mapping (EXT > IFRS) and a mapping from GTC to Pillar 2 (GTC > P2). Both the interface and the mapping need to be set up once and can then be used for multiple periods or different import files.
The following explanation illustrates the setup of an interface for a csv upload via the data transfer, the configuration of the two mappings and the import into the Pillar 2 module. For information on interface structures for data collection, advanced mappings and other interface types, please contact AMANA.
Creation of an Import Structure
The Interface Structure is part of the Master Data area in the 'Structure' section. A list of all existing interfaces is displayed. A new structure can be created using the 'Create' button.
For a csv Interface the following information is compulsory:
Name | Example Name |
Direction | Import |
Interface Type / Source | Standard (csv,txt,xls) |
Destination | IFRS |
Default interface | Yes |
Delimiter | Semicolon “;” Comma “,” Depending on the language of Excel (English Comma / German Semicolon) |
Data Settings First data row (row) | First row in the csv file that contains relevant data. Usually 2, if the first row is used for a header. |
Unit ID (column) | Column in which the Unit ID is written. Usually 1. |
Position ID (Column) | Column in which the Position ID is written. Usually 2. |
Value (Column) | Column in which the Value is written. Usually 3. |
Mapping Selection | The corresponding Mapping has to be selected in the dropdown menu. If the mapping is not yet established, the information can be added later by clicking on the pencil in the overview of interfaces. |
The data settings may look different depending on the structure of the import file.
Once set up, the interface can be created by clicking on the 'Save' button.
Mapping Setup Import to GTC
The Mapping translates the technical IDs to more legible IDs (e.g. INC-1, DT-2.1) or company specific IDs like account numbers. Examples of a Mapping file can be found in the section “Important Documents”.
Mappings are established in the section “Position mapping”. For a csv Upload to IFRS and then transfer this into Pillar 2 the following information has to be selected:
Applies to period | Please select relevant period |
Balance type | IFRS / Local GAAP |
Mapping type | External => IFRS |
Name of template | Please choose a name for the mapping |
Default mapping? | Check the box if Mapping is relevant for all CEs |
To add the Mapping, simply click the plus sign on the left-hand side after inserting the necessary information.
On the right-hand side, you will find two arrows: one for downloading the Mapping and one for uploading it. You can then edit the Mapping by clicking the pencil icon or delete it by clicking the bin icon. To install the Mapping, download the template by clicking the download arrow. To fill this template with individual mapping, ensure that the version number is included, as shown in the screenshot below. Once the mapping is complete and the version number is added, upload the file using the upwards arrow next to the mapping. If the mapping has not already been selected in the interface structure, follow the instructions above to select it.
GTC-Version | Comments | File |
|---|---|---|
23.05.01 |
|
|
Here is an example of mapping External => IFRS
Mapping Setup GTC to Pillar2
Once you have completed the IFRS mapping, you will need to create a new mapping to transfer the data from GTC to Pillar 2.
Applies to period | Please select relevant period |
Balance type | BEPS |
Mapping type | GTC=> Pillar2 |
Name of template | Please choose a name for the mapping |
Default mapping? | Check the box if Mapping is relevant for all CEs |
Here is an example of mapping GTC=> Pillar2
File |
|---|
|
Import
After the interface and Mapping are set, it is possible to perform an data transfer in the company module. The “Import” button is activated and can be chosen on the section “Import”.
An example can be found in the 'Important Documents' section. To import the file, select the created interface in the import window and choose the CSV file that follows the specified structure (e.g. one row header, column 1 for Unit ID, column 2 for Position ID, column 3 for value).
After importing, the window will display a list of all data from the file along with their respective statuses. To indicate the status of the import, a green arrow will appear if successful and a red mark will appear with an explanation if unsuccessful. To add the imported data to the module, simply click on the 'Save' button located in the upper left corner of the window. If changes are required to the Importfile, correct the file and select the 'Import' button to repeat the process.
Afterwards you can add manual adjustments to the single positions in the Data transfer section.
Finally, the data from the copy of the tax calculation must be loaded into the Pillar 2 module. To do this, go to Pillar 2 => Entity Data Collection => Home and select the option "Copy from Tax Calculation".