Consolidation

Below you find a written guide on how you perform consolidations.

Before the first consolidation, we recommend that you look at the related article describing the flow and illustrating how uploaded numbers are included. This will give you an understanding of the data flow on how the balance uploaded in local currencies ends up in the consolidation in the currency for the parent.

Related guide: Reconciliation from upload report -> FX report -> Consolidation report - INDSÆT LINK

Below the consolidation report for December 2020 for our demo customer is attached. As seen in the button, the consolidation report contains individual sheets for each group in the group structure.

As in other guides, we again focus on Denali - then it is possible in the sheet FX for Mountain to see the uploaded number in local currency and the conversion to the number in group/subgroup currency for the nearest parent. Denali is part of the Group Mountain. The translated number is disclosed in column N in the sheet Group Mountain. It is possible to follow the uploaded number for each entity to the consolidated number in the consolidation.

Related report:
Consolidation Report_Demo customer - ???

Checklist Consolidation - Indsæt link

As earlier stated in the area exchange rates, Konsolidator uses the weighted average on exchange rates on Profit/loss.