...
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:
Company ID - Column 1 of the example (Tab Bsp.1)
The data is imported to the company with the corresponding CbCR company ID.Technical ID - Column 2 of the example (Tab Bsp.1)
The technical ID of the data entry field.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.
...