Versions Compared

Key

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

...

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

CbCR Datapoint list - OECD Standard

...

GTC-Version

Comments

File

23. XX- 24.04

View file
nameCbCR Datapoints.xlsx

CbCR Example ‘Entity Data Collection’ csv Importfile & Mapping

...

  • 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

 

23. - 24.04

View file
nameMappingCBCR.xlsx

View file
nameImportWertevorlageCBCR 1CSVImport.csv

View file
nameImportWertevorlageCBCR 1EXCELMitHinweisen.xlsx

24.04

CbCR Master Data Importfile

...

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. - 24.XX04