Sep 4, 2024

Mastering Eliminations in D365: Clean Consolidations for Real Financial Insights"

Welcome to the AxmedJay Journey

In the world of multi-company accounting, precision matters. When organizations operate across multiple legal entities, internal transactions can blur the true financial picture.

That's where Eliminations come in.

Eliminations ensure that intercompany transactions—like internal sales, expenses, and payments—don't artificially inflate revenues or costs when companies consolidate financial reports.

In this guide, we'll explore how to configure Elimination Journals in D365 Finance, how to run Consolidations, and why mastering these steps is essential for accurate, audit-ready financial reporting.

Whether you’re new to eliminations or fine-tuning your system, you’re in the right place.

Key Takeaways:

  • Eliminations remove internal transactions to ensure clean and accurate consolidated financial statements.
  • Creating a dedicated elimination company (like ZELIM) simplifies the process and improves audit tracking.
  • Elimination journals correctly offset intercompany transactions between legal entities.
  • Consolidations pull multiple legal entities into a single, consolidated company for reporting purposes.
  • Accurate elimination and consolidation setups are critical for compliance with accounting standards like IFRS and GAAP.

Scenario

Imagine a company group with multiple legal entities:

  • ZELIM Trading Ltd buys products from ZCON Manufacturing Ltd (both are part of the same parent company).

When ZELIM purchases inventory from ZCON:

  • ZCON records sales revenue.
  • ZELIM records purchase expense.

If we consolidate without eliminations, these internal transactions:

  • Artificially inflate total sales and total expenses at the group level.
  • Misrepresent profitability and operational performance to investors, auditors, and internal leadership.

By using eliminations:

  • We remove the internal sale and purchase from consolidated reports.
  • Only external transactions remain — giving a true and clean financial picture of the group’s real market activities.

Step by Step

Elimintion Configuration

Create Company ZELM

1.        Go to Org administration> Legal Entities> Create new legal entity

 Graphical user interface, text, application, email

Description automatically generated

Create Elimination Journal

Go to Journal Names GL> Setup>Journal Setup>Journal Names

 Graphical user interface, application

Description automatically generated

 

Post Elimination journal

Open ZELIM company

 Graphical user interface

Description automatically generated

Go to General Journal

1.        Create a new Elimination journal

 Graphical user interface, application

Description automatically generated

2.        Go to Journal Lines.

 

Graphical user interface, text, email

Description automatically generated

Journal Lines

1.        Create new journal lines

2.        Select Main account and offset account lines.

Graphical user interface, text, application, email

Description automatically generated

Select Legal Entity Financial Dimension

1.        Select Legal Entity Dimension

2.        For Both debit account and credit account.

 

Graphical user interface, text, application

Description automatically generated

Consolidation Online

Open ZCON company

 Graphical user interface

Description automatically generated

 

Add ZELIM to the consolidation

vGraphical user interface, text, application, email

Description automatically generated

 

 

Configure Consolidation parameters

A screenshot of a computer

AI-generated content may be incorrect.

Run Consolidation

A screenshot of a computer

AI-generated content may be incorrect.

 

Generate Trail Balance

A screenshot of a computer

AI-generated content may be incorrect.

A screenshot of a computer

AI-generated content may be incorrect.


Generate Consolidated Financial MR

A screenshot of a computer

AI-generated content may be incorrect.

 

A screenshot of a computer

AI-generated content may be incorrect.

 

Table

Description automatically generated

Table

Description automatically generated

🛡️ Thanks for Walking the Path with AxmedJay

Setting up Elimination and Consolidation processes isn’t just a technical task—it’s about building trust in your financial reporting.

By ensuring internal transactions are properly removed, you protect the integrity of your consolidated statements and give stakeholders, auditors, and leadership a clear, honest view of performance.

Stay tuned for more deep dives into D365 Finance essentials. Until next time — stay sharp, stay curious, and always balance the books.