Study guide
8.4 Import Consolidations & Intercompany Elimination Rules
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.4 Import Consolidations & Intercompany Elimination Rules
Key Takeaways Explain This Topic AI
Consolidate with import brings in balances from subsidiaries that are not in the same Dynamics 365 Finance database, including third-party ERP systems.
Elimination rules remove reciprocal intercompany balances so the consolidated statements do not double-count internal trading.
An elimination rule is defined in the consolidation legal entity and executed as a proposal that generates an elimination journal.
Elimination journals post to the consolidation company only — they never touch the source subsidiaries' ledgers.
Last updated: August 2026
8.4 Import Consolidations & Intercompany Elimination Rules
Quick Summary: Subsidiaries outside the Dynamics 365 Finance environment are brought in with Consolidate with import, and reciprocal intercompany balances are removed with elimination rules. This section covers both, including where elimination journals actually post.
1. Consolidate with Import (External / Non-D365 Subsidiaries)
For enterprise divisions running third-party ERP systems (e.g., SAP, Oracle, NetSuite) or external acquisitions: +---------------------------------------------------------------------------------------------------------+
- | Consolidate with Import Processing Flow |
- +---------------------------------------------------------------------------------------------------------+
- | |
- | [ External Subsidiary / Legacy ERP ] |
- | - Exports trial balance / period transactions to CSV/Text file format. |
- | | |
- | v |
- | [ File Structure Validation ] |
- | - Columns: Source Account, Source Dim, Amount, Currency, Target Account, Target Dim |
- | | |
- | v |
- | [ Consolidation Legal Entity (CONSO) ] |
- | - Navigate to: General ledger > Periodic tasks > Consolidate > Consolidate with import |
- | - Select import file, specify currency conversion rate, and submit batch import. |
- | | |
- | v |
- | [ Consolidated General Ledger Updated ] |
- +---------------------------------------------------------------------------------------------------------+
- 2. Intercompany Eliminations Configuration & Execution
When affiliated legal entities transact with one another, consolidated financial statements must remove all reciprocal balances to prevent double-counting internal revenue, expenses, receivables, and payables.
Common Elimination Scenarios
Intercompany AP / AR: Eliminates Due-To (Liability) against Due-From (Asset).
Intercompany Revenue / COGS: Eliminates internal sales revenue against the purchaser's inventory/cost of goods sold.
Unrealized Inventory Profit: Eliminates internal markup on goods held in inventory at period-end that have not yet been sold to third-party external customers.
Step-by-Step Elimination Rule Setup
Navigate to General ledger > Setup > Postings > Intercompany elimination .
Click New and configure the Elimination Rule :
- Rule ID: ELIM_AP_AR
- Description: Eliminate Intercompany Due-To and Due-From
Elimination Method: Select Net change (reverses monthly activity) or Fixed amount .
On the Lines tab:
- Source Legal Entity: USMF and DEMF
- Source Main Accounts: 130500 (Due From) and 210500 (Due To)
Destination Account: Elimination balance sheet clearing account (e.g., 210599 ). +---------------------------------------------------------------------------------------------------------+
- | Worked Intercompany Elimination Example |
- +---------------------------------------------------------------------------------------------------------+
- | PRE-ELIMINATION CONSOLIDATED BALANCES: |
- | - USMF Books: Due From DEMF (Asset Account 130500) .................................... $50,000 (Dr) |
- | - DEMF Books: Due To USMF (Liability Account 210500) .................................. $50,000 (Cr) |
- | ----------------------------------------------------------------------------------------------------- |
- | ELIMINATION PROPOSAL & JOURNAL POSTING (in Elimination Entity / CONSO): |
- | - Line 1: Debit Intercompany Due To Elimination Account (210500) .................... $50,000 |
- | - Line 2: Credit Intercompany Due From Elimination Account (130500) .................. $50,000 |
- | ----------------------------------------------------------------------------------------------------- |
- | POST-ELIMINATION CONSOLIDATED GROUP BALANCE: |
- | - Net Intercompany Balance = $0.00 (Perfectly Eliminated from Group Financials). |
- +---------------------------------------------------------------------------------------------------------+
- Processing Elimination Proposals
Eliminations are generated via General ledger > Periodic tasks > Elimination proposal :
Select the Elimination rule , specify the Proposal date , and select the target Elimination company .
Click OK to generate the proposal lines.
Open the created elimination journal under General ledger > Journal entries > Elimination journals .
Review the calculated debit/credit lines and click Post to finalize consolidated group eliminations.
3. Choosing Between Import and Online Consolidation
- Requirement Correct method
- Subsidiary is a legal entity in the same Dynamics 365 Finance environment Consolidate online
- Subsidiary runs a third-party or legacy ERP Consolidate with import
- Subsidiary balances arrive as a file from an external accounting team Consolidate with import
- Group needs a live, re-runnable consolidation with drill-back to source vouchers Consolidate online
Consolidate with import reads balances from the Consolidation account and dimension staging entities rather than from a sibling legal entity's ledger. Because the source system is outside Dynamics 365 Finance, there is no drill-back to a source voucher, and the imported balances have to be re-imported whenever the subsidiary restates a period.
Import Sequence
Prepare the consolidation legal entity exactly as for an online consolidation — group accounting currency, consolidation account groups, and a matching fiscal calendar.
Load the external trial balance through the data management framework into the consolidation staging entity, mapping each external account to a consolidation main account and each external dimension value to a financial dimension value.
Run Consolidate with import , selecting the date range, the consolidation account group, and the exchange rate types.
Reconcile the imported total to the source trial balance before running eliminations — an out-of-balance import will silently distort every downstream elimination.
4. Elimination Rules in Depth
An elimination rule is a journal-generating rule stored in the consolidation legal entity that removes reciprocal internal balances so the group statements do not double-count intra-group trading.
- Rule component What it controls
- Elimination journal name The general journal the proposal writes into
- Source legal entity / destination Which company's balances are read and which company is credited
- Rule lines The main account or account range being eliminated and the offset account
- Effective dates The period over which the rule applies
Run the rule from Consolidations > Eliminations > Elimination journal proposal , choose Proposal only to review, then post.
The Three Facts Candidates Miss
Elimination journals post only in the consolidation legal entity. The source subsidiaries' ledgers are never touched, so USMF still reports its full Due From DEMF balance in its own statutory accounts.
Eliminations are re-run per period. They are not a permanent adjustment; if you re-consolidate a period, you re-run the eliminations for that period.
Reciprocal balances must actually agree. If USMF shows Due From DEMF of $100,000 and DEMF shows Due To USMF of $98,000, the rule eliminates what it is told to and leaves a $2,000 residual. Reconciling intercompany balances is a prerequisite for elimination, not a by-product of it — which is exactly why ledger settlement of intercompany clearing accounts is scheduled before consolidation in the period close template.