Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

This page provides a comprehensive overview of all relevant data points, import file examples, position mapping, and CbCR 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.

CbCR Datapoint list - OECD Standard

This list provides an overview of all CbCR 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.

GTC-Version

Comments

File

23.XX

CbCR Example ‘Entity Data Collection’ csv Importfile & Mapping

To import data into the CbCR 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 CbCR 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 CbCR 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 CbCR.

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 CbCR (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 CbCR technical ID. See the two examples of import files with their corresponding position mapping in tab 2-5 Example 2 Import & Mapping using the CbCR Reference IDs and Example 3 Import & Mapping using the CbCR 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:

GTC-Version

Comments

File

23.XX

 

CbCR Master Data Importfile

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

Please note: The CbCR 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 prepare the master data at this time! It is very likely that the information in this dialogue will be updated.

Screenshot

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

GTC-Version

Comments

File

23.XX

 

  • No labels