web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Intercompany consolidation automatic eliminations

(0) ShareShare
ReportReport
Posted on by 1,161

Hi All,

I know you can manually post journal entries in the consolidation company for elimination journal. is there is way to create automatic elimination journals?

Thanks

I have the same question (0)
  • Verified answer
    TWBlaisdell Profile Picture
    on at
    RE: Intercompany consolidation automatic eliminations

    Hello Anita75,

    Thank you for posting on the Microsoft Dynamics 365 Business Central Forum.

    Unfortunately, there is no functionality directly built into Business Central (or predecessor NAV Versions) to automatically process consolidation elimination entries. I would recommend possibly submitting an Idea related to this because I know it has been requested in the past at the following link: experience.dynamics.com/.../

    To manage this in previous support cases discussions, the recommendation from a setup and configuration standpoint is to make sure that the operating subsidiary companies and parent/Consolidation company are setup with the Chart of Accounts where there are Accounts that break out Intercompany transactions through the use of the standard Posting Groups.  For example, it would be recommended to setup Customer and Vendor Posting Groups with a unique A/R and A/P Account, respectively, for related companies. In addition, setup a unique General Business Posting Group for related companies different from regular third party Customers and Vendors. This will allow for General Posting Setup to have different combinations of accounts, such Sales and COGS accounts and Puchase/Direct Cost Applied Accounts, for the combination of General Business Posting Group and General Product Posting Group, so that intercompany transaciton balances can be directly identified as separate accounts in the Chart of Accounts.  When consolidations are completed, the break out of the key intercompany totals are then more clearly presented in the specific related company G/L Accounts.

    I hope this helps give some guidance for moving forward.

    Best Regards,
    Tom

  • Suggested answer
    John Ray Patajo Profile Picture
    837 on at
    RE: Intercompany consolidation automatic eliminations

    Hi,

    If you have the same Consolidation GL Account across all your intercompany accounts, this should offset your Intercompany transactions to zero.

    Regards,

    JR

  • Asanga Profile Picture
    25 on at
    RE: Intercompany consolidation automatic eliminations

    Hi Tom,

    I have a problem with passing elimination entries for our foreign subsidiary company. when we have consolidated the foreign subsidiary which use an other reporting currency, the entices related to the foreign subsidiary will automatically convert to the local currency within the consolidation company after we have run the consolidation process (balance sheet @ closing rate and income statement @ average rate).

    Assume, I have run the consolidation for the January and passed the elimination entry related to the foreign subsidiary

    within the consolidation company (for balance sheet GL). When I run the consolidation process for the next month, the closing balance of foreign subsidiary balance sheet GLs are convert at the closing rate of February month and the elimination entry which I had passed during the January moth will not be revalued (converted)  at the closing rate of February month. This will create an inaccurate balance of relevant GL accounts of consolidation company for February month.

    Any solution for this issue???

    Reporting Currency – USD

    Foreign subsidiary currency - EUR

    GL – Trade Receivable

    January

    IF USD 1 is = 0.5 EUR

    Receivable from ABC company (Parent company) - (EUR 2000 @ 0.5 at Jan 2022) = 4,000.00

    Elimination Entry                                                                                                       =(4,000.00)

    February

    IF USD 1 is = 0.25 EUR

    Receivable from ABC company (Parent company)

                                                             (EUR 2000 from 0.5 to 0.25 at feb 2022) = 8,000.00

    *** Elimination entry is not revalued although entry is passed in Euro or not

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,750

#2
Sumit Singh Profile Picture

Sumit Singh 2,689

#3
YUN ZHU Profile Picture

YUN ZHU 1,987 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans