Study guide

8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation

Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: MB-310 Exam Overview & Financial Architecture

1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework

2 Chapter 2: Chart of Accounts & Main Accounts

2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions

3 Chapter 3: Financial Dimensions & Account Structures

3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates

4 Chapter 4: Ledgers, Calendars & Currencies

4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

5 Chapter 5: General Ledger Journals & Allocations

5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals

6 Chapter 6: Intercompany Accounting & Settlements

6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing

7 Chapter 7: Cash and Bank Management

7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting

8 Chapter 8: Periodic Closing & Financial Consolidations

8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules

9 Chapter 9: Sales Tax & Withholding Tax

9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting

10 Chapter 10: Accounts Receivable Setup & Invoicing

10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts

11 Chapter 11: Credit Management & Collections

11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

12 Chapter 12: Subscription Billing & Revenue Deferrals

12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)

13 Chapter 13: Accounts Payable & Invoice Processing

13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation

14 Chapter 14: Vendor Payments & Expense Management

14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses

15 Chapter 15: Budgeting & Budget Control

15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries

16 Chapter 16: Fixed Assets Configuration & Transactions

16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)

8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation

Key Takeaways Explain This Topic AI

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).

Last updated: August 2026

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 > Ledger to 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 account field):

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.

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) .