How to consolidate companies with different currencies in Dynamics 365 Business central

Published on July 21, 2021

To consolidate companies with different currencies, our Business Central consultants have drafted a step-by-step procedure as listed below.

Scenario: We have two subsidiary companies and one consolidation company. The subsidiary companies and consolidation company have different currencies.

STEP 1: The screenshot below shows the COA of the subsidiary company with EURO as its base currency

Consolidate Companies With Different Currencies In Business Central-1

STEP 2: The screenshot below shows the COA of the subsidiary company with INR as its base currency

Consolidate Companies With Different Currencies In Business Central-2

STEP 3: For consolidating the balances from the subsidiary companies, toggle to the consolidation company

Consolidate Companies With Different Currencies In Business Central-3

STEP 4: In the consolidation company, search for the business unit by clicking on Alt+Q. Click new to enter the subsidiary company details. In the card, enter the currency code of the subsidiary company

Note: Make sure that the currency of the subsidiary companies is provided on the currency page of the consolidation company.

Consolidate Companies With Different Currencies In Business Central-4

STEP 5: To specify or change the exchange rate of the subsidiary company opt for the exchange rate in the action ribbon

Consolidate Companies With Different Currencies In Business Central-5

Consolidate Companies With Different Currencies In Business Central-6

STEP 6: On verifying the exchange rate, search for a consolidated trial balance report to view the consolidated report of all business units. The consolidated report shows the balances based on the currency of consolidation company

Consolidate Companies With Different Currencies In Business Central-7