Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Intercompany reconciliation

Posted on by 135

We are looking for a simpler solution to reconciling intercompany accounts.   We have 5 companies and multiple due to/due from accounts.  We use AIT on GP8.  We also have multi-currency transactions so the reconciliations need to be performed by originating currency. 

*This post is locked for comments

  • Richard Schultz Profile Picture
    Richard Schultz 1,085 on at
    Re: Intercompany reconciliation

     Gloria,

    At one company I worked for, we had 9 operating companies (12 total).  We were able to create eliminations fairly easily by lining up the intercompany accounts to match in any pair of companies.

    For example, the account in the US company for the US - Canada relationship would be, say, 14500, and the same account would be used in the Canadian account for that relationship.  Accordingly, there should be a corresponding entry on either side of the relationship whenever intercompany is invoked; any difference must be due to either a GL entry to the intercompany account, or a real FX difference.

    To check against the GL entry issue, just print a detailed gl listing for the intercompany account for both companies, ensuring that no entries were sourced from the GL.  If there are none, then you have an FX issue, which is solved by a simple FX entry.  The accounts will eliminate on consolidation.

    One other important note:  when we got to around 7 companies, we finally stopped supporting sub-to-sub transactions; that is, a transaction where a subsidiary sold something to another subsidiary was required to go through the parent companies; this ensured a much simpler setup for the intercompany, and also was inline with the legal relationships of the companies.  I imagine, if you have 5 companies that can all sell to each other, you're going to have a plate of spaghetti pretty soon...

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans