8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation
Key Takeaways
- Consolidation requires a dedicated consolidation legal entity whose accounting currency is the group reporting currency.
- Consolidation account groups map each subsidiary main account to the consolidated account when the charts of accounts differ.
- Consolidate online reads subsidiary balances directly from the same Dynamics 365 Finance database and posts them into the consolidation company.
- Currency translation applies the exchange rate type chosen per main account category, following ASC 830 and IAS 21 (current rate for assets and liabilities, historical for equity, average for income statement).
8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation
Quick Summary: Enterprise organizations operating multiple legal entities across diverse geographies, currencies, and charts of accounts require periodic consolidation to produce unified statutory and management financial statements. Microsoft Dynamics 365 Finance provides three robust consolidation paths: Consolidate Online (periodic GL transaction roll-up into a dedicated consolidation legal entity), Consolidate with Import (file-based aggregation for non-D365 or disparate cloud instances), and Financial Reporting (real-time virtual consolidation without GL ledger duplication). This section explores the full consolidation lifecycle, multi-currency translation accounting methods, chart of accounts mapping, and automated Intercompany Eliminations.
1. Comparing Consolidation Methods in Dynamics 365 Finance
Selecting the correct consolidation architecture depends on reporting requirements, currency translation complexity, and whether elimination ledger entries must physically exist in a general ledger database.
+---------------------------------------------------------------------------------------------------+
| Consolidation Method Architectural Comparison |
+---------------------------------------------------------------------------------------------------+
| Architectural Feature | Consolidate Online | Consolidate with Import | Financial Reporting |
| :--------------------- | :-------------------------- | :-------------------------- | :------------------------ |
| **Module / Tool** | General ledger (Periodic) | General ledger (Periodic) | Financial Reporter (MR) |
| **Target Destination** | Consolidation Legal Entity | Consolidation Legal Entity | Report Definition Viewer |
| **Physical GL Vouchers**| Yes (Vouchers created) | Yes (Vouchers created) | No (Virtual aggregate) |
| **Data Source** | Direct D365 Legal Entities | External files / Text / CSV | D365 DataMart Database |
| **Elimination Vouchers**| Posted via Elimination Jrnl | Posted via Elimination Jrnl | Reporting tree / row rules|
| **Execution Frequency**| Periodic (Month-End Batch) | Periodic (Month-End Batch) | Real-Time / On-Demand |
| **Primary Use Case** | Statutory group reporting & | Aggregating non-D365 subs & | Management reporting & |
| | audited group trial balance | acquired legacy systems. | ad-hoc variance analysis. |
+---------------------------------------------------------------------------------------------------+
2. Consolidation Legal Entity Setup & COA Mapping
To perform GL-based consolidations, a dedicated Consolidation Legal Entity is created in Organization administration > Organizations > Legal entities.
Consolidation Entity Parameters
- Use for financial consolidation process: Checkbox must be enabled (
Yes). - Use for financial elimination process: Enabled (
Yes) if this company will also host elimination journals. - Accounting & Reporting Currencies: Configured under
General ledger > Ledger setup > Ledgerto represent the parent enterprise presentation currency (e.g.,USD). - Consolidated Chart of Accounts: The master Chart of Accounts assigned to the consolidation ledger.
+---------------------------------------------------------------------------------------------------------+
| Chart of Accounts Mapping Architecture |
+---------------------------------------------------------------------------------------------------------+
| |
| [ SUBSIDIARY 1: DEMF (Germany) ] [ CONSOLIDATION ENTITY: CONSO (Parent) ] |
| - Local COA (German GAAP / SKR04) - Master Corporate Chart of Accounts (USD) |
| - Main Account: `5400` (Local Travel Expense) - Main Account: `618100` (Global Travel Exp) |
| Mapped via: Consolidation Account = '618100' ----------> Consolidates into Account `618100` |
| |
| [ SUBSIDIARY 2: USMF (United States) ] |
| - Shared Corporate COA |
| - Main Account: `618100` (Travel Expense) ---------------> Consolidates into Account `618100` |
+---------------------------------------------------------------------------------------------------------+
Mapping Disparate Charts of Accounts
When subsidiaries use different local charts of accounts (statutory requirements), D365 Finance provides two mapping mechanisms:
- Direct Main Account Mapping (
Consolidation accountfield):- In the subsidiary company, open
General ledger > Chart of accounts > Accounts > Main accounts. - In the Consolidation account field, enter the target main account number in the consolidation legal entity.
- In the subsidiary company, open
- Consolidation Account Groups (
General ledger > Chart of accounts > Accounts > Consolidation account groups):- Used when a single subsidiary must consolidate into multiple parent entities that each utilize different corporate charts of accounts (e.g., local statutory group vs. international holding group).
3. Consolidate Online Execution & Parameters
Consolidate Online is executed inside the Consolidation Legal Entity under General ledger > Periodic tasks > Consolidate > Consolidate online.
+---------------------------------------------------------------------------------------------------------+
| Consolidate Online Parameter Configuration |
+---------------------------------------------------------------------------------------------------------+
| Criteria Tab: |
| - Consolidation Period: `10/01/2026` to `10/31/2026` |
| - Include Actual Amounts: `Yes` | Include Budget Amounts: `No` |
| ----------------------------------------------------------------------------------------------------- |
| Legal Entities Tab: |
| - Legal Entity: `USMF` | % Consolidation: `100.00%` | COA Mapping: `Consolidation Account` |
| - Legal Entity: `DEMF` | % Consolidation: `100.00%` | COA Mapping: `Consolidation Account` |
| - Legal Entity: `GBSI` | % Consolidation: `50.00%` | (Proportional Consolidation for Joint Venture)|
| ----------------------------------------------------------------------------------------------------- |
| Financial Dimensions Tab: |
| - Transfer Dimensions: `BusinessUnit`, `Department`, `LegalEntity` (Tracks source company of origin) |
| ----------------------------------------------------------------------------------------------------- |
| Currency Translation Tab: |
| - Apply currency translation rules defined in subsidiary ledger / accounts. |
+---------------------------------------------------------------------------------------------------------+
4. Multi-Currency Translation Accounting Methods
When consolidating foreign subsidiaries whose accounting currencies differ from the parent consolidation currency (e.g., consolidating DEMF in EUR into CONSO in USD), Dynamics 365 Finance executes currency translation following international accounting standards (US GAAP ASC 830 / IAS 21):
+---------------------------------------------------------------------------------------------------+
| Currency Translation Rules & Accounting Methods |
+---------------------------------------------------------------------------------------------------+
| Account Category | Translation Rate Method Applied | Exchange Rate Type & Date Used |
| :--------------------- | :-------------------------------- | :----------------------------------- |
| **Assets (Current & | **Closing Rate (Current Rate)** | Spot exchange rate on the balance |
| Non-Current)** | | sheet date (e.g., Oct 31 rate). |
| **Liabilities** | **Closing Rate (Current Rate)** | Spot exchange rate on the balance |
| | | sheet date (e.g., Oct 31 rate). |
| **Equity (Common Stock| **Historical Rate** | Exchange rate in effect when capital |
| & Paid-In Capital)** | | was originally contributed/issued. |
| **Revenue & Expenses** | **Average Rate** (or Transaction) | Weighted average exchange rate over |
| | | the operating period. |
+---------------------------------------------------------------------------------------------------+
Cumulative Translation Adjustment (CTA) Mechanics
Because Balance Sheet assets/liabilities are translated at the current spot rate while Equity is translated at historical rates and Net Income is translated at average rates, an accounting imbalance naturally occurs. Dynamics 365 Finance automatically routes this difference to the Currency translation difference account (CTA) configured in the consolidation ledger (General ledger > Ledger setup > Ledger), recording the balancing entry in Accumulated Other Comprehensive Income (Equity).
A global enterprise is consolidating a German subsidiary (DEMF, operating in EUR) into the US parent consolidation legal entity (CONSO, operating in USD). According to standard accounting translation rules configured in Dynamics 365 Finance, which exchange rate type and date must be used to translate DEMF's Accounts Receivable and Long-Term Debt balances into USD?
A group consolidates a German subsidiary into a US parent consolidation company. The subsidiary and the parent use different charts of accounts. Which setup element maps the subsidiary's main accounts to the consolidated main accounts?