Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

How to fill the upload template for group structure

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 -    OBS ÆNDRE LINK

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

Descriptions 

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:

  • Subsidiary
  • Associate
  • Do not consolidate

After the template is finalized, you can upload the template by following this article:
How to upload group structure - OPDATER LINK

Need assistance?

Contact support for any questions regarding changing the group structure at support@konsolidator.com