How to fill the upload template for group structure
- Last updated on October 28, 2024 at 2:39 PM
In Konsolidator, you can either create your group structure directly in the application or via an Excel file, as demonstrated here. This guide will show you how to fill out the Excel template correctly.
Before you start
Download the template: CompanyExcelUploadTemplate.xlsx
The template includes three sheets:
- "Company List"
- "Currency Codes"
- "Documentation" - Read this before filling in data
Table Definitions
All columns (A - H) in the sheet "Company list" must be filled in.
Recommendation:
We always recommend placing the ultimate parent on the first row of the template.
| Columns name | Description |
| Company short name | This name is the call name or reference name. A good idea is to use the same short name as used in the ERP system. |
| Company full name | This name is the legal name and the name you want to appear in your reports. |
| Parent short name | This is the short name of the nearest parent entity. Info: You should see the template as a tree-hierarchy template, and consider how your future reporting should be reflected in Konsolidator. Maybe it is possible for you to have a flat reporting structure if you do not need sub-group consolidations. If in doubt about how to build your group structure correctly reach out to Konsolidator support for recommendations. |
| Currency code | This is the currency code for each entity. When uploading numbers to Konsolidator you always upload numbers in local currencies. |
| Ownership percentage | For each entity, you must input the ownership percentage that your group owns. |
| Accounting principles (Equity/Cost) | Here you select the accounting principle for how the group measures the investment in subsidiaries. If you use the cost principle, you do not adjust your investment frequently but only yearly perform an impairment test. If you use the equity method, you adjust the investment with the profit/loss from the subsidiaries. Therefore, the investment in the parent entity should always reconcile to the equity from the subsidiaries. |
| Company type | In Konsolidator we have two company types. Either you have companies or you have branches. Be aware that if using branches the currency code must be the same as in the parent entity. Therefore it is not possible to have EUR as currency in a branch if the currency in the parent is DKK. |
| Consolidate as | In Konsolidator you can consolidate with the following options:
|
After the template is finalized, you can upload the template by following this article:
How to upload group structure
Need assistance?
Contact support for any questions regarding changing the group structure at support@konsolidator.com