Consolidation across currencies
Companies in Norway and Sweden post in NOK and SEK. The group accounts have to be in one currency.
How we solve it
Consolidation in Business Central with NOK and SEK translated to the group currency.
Industry · Multi-country groups
Subsidiaries in several countries and currencies, each with its own chart of accounts and local VAT. We map them to the group chart of accounts, translate the currency and eliminate the internal trade.
- Consolidation across countries
- NOK and SEK translated
- Eliminations
- Local setup per country
- Monthly import
- Currency translation
- Eliminations
- Group chart of accounts
The problems
What makes group accounts heavy
Every country has its own rules, its own currency and often its own chart of accounts.
Subsidiaries with their own chart of accounts
An acquired company has its own chart of accounts, and it shouldn't have to change for the group to report.
How we solve it
Subsidiaries' charts of accounts are mapped to the group chart, so each company keeps its own.
Internal trade counted twice
Sales between the group's companies have to come out of the group accounts again.
How we solve it
Eliminations of intercompany trade as a fixed part of the consolidation.
Local VAT and setup
A Swedish company must follow Swedish rules for VAT and reporting, not Danish ones.
How we solve it
Local setup of VAT and reporting per country, for example for a Swedish company.
Consolidation as a spreadsheet
When the group accounts are pieced together in Excel every month, it takes days and can't be reproduced.
How we solve it
Monthly consolidation imports in Business Central, so figures can be traced back to the company.
Integrations
What fits together
Consolidation and group reporting in Business Central.
- Consolidation import
Monthly import from the subsidiaries.
- Currency translation
NOK, SEK and other currencies translated to the group currency.
- Chart of accounts mapping
Each company's chart of accounts mapped to the group's.
- Eliminations
Intercompany trade eliminated at consolidation.
- Local setup
VAT and reporting under each country's rules.
- Power BI
Group reports built on the consolidated figures.
Packages
Packages for groups
The group setup is priced after an analysis. The scopes around it are here.
All prices exclude VAT. Business Central and Microsoft 365 licences come on top.
FAQ
What people often ask us
Can subsidiaries keep their own chart of accounts?
Yes. The charts of accounts are mapped to the group chart, so each company posts as before and the group reports as one.
How are Norwegian and Swedish kroner handled?
The figures are translated to the group currency as part of the consolidation.
Can a Swedish company be set up under Swedish rules?
Yes. VAT and reporting are set up locally per country, so the Swedish company follows Swedish rules.
One group, one set of figures
Tell us how many companies and countries you have. We'll show you how the consolidation can run every month.
30 minutes on Teams with Sten or Lauge. You talk to the person who builds it.