Communications Pangea/September 07, 2020 /Dynamics 365/Finance/ 3 min read

The Online Company Consolidation Benefits with Dynamics 365

Keep this entry for future references

A frequent challenge in my work as a Dynamics 365 Finance consultant is the company consolidation process. Most companies I have recently worked with have many subsidiary companies in various countries; therefore, we need to create not only separate entities but also different charts of accounts (COA) that can meet regulatory requirements. For example, there’s a mandatory COA structure in Colombia that has to be managed to comply with statutory regulations.

There are many ways to accomplish proper company consolidation within Microsoft Dynamics 365 Finance, such as using tools like Management Reporter (MR) or Dynamics 365 Finance Online Company Consolidation. Today, in this blog, I would like to focus on the latter.

The Online Company Consolidation Benefits with Dynamics 365 Finance

Online Company Consolidation in Dynamics 365 Finance offers several benefits, which I will share in this blog, but first, let us talk about what online consolidation entails.

1.    Online Company Consolidation in Microsoft Dynamics 365 Finance

In order to run an online company consolidation in Dynamics 365 Finance, the first thing we need is a consolidation COA to ensure everything works seamlessly. It usually will be the leading company’s COA, which will also be helpful when setting up consolidation accounts.

We also must create a consolidation entity to consolidate transactions into the statutory or the global COA (this will depend on what accounts we want to visualize in the reports). This entity will be alongside the other legal entities within the system. Statutory accounts can be mapped to the global COA in the consolidation account field.

When performing the online consolidation, we can select an option to use consolidation accounts, and Dynamics 365 Finance will move the transactions to the account’s setup in the COA for the consolidation company. It is quite common to have more than one source account merge into a consolidation account.

2.    Benefits

There are many benefits of running Online Company Consolidations in Dynamics 365 Finance, some of them are:

  • By posting the original transactions into a global template, consistency across multiple countries can be maintained.
  • The legal entity can be consolidated into two different consolidation companies. One consolidation company supports the statutory COA. Since the transacting legal entity has the same global template, it can be set up for easier and faster reporting along with other legal entities in the enterprise.
  • By doing the consolidation via online consolidation instead of MR, the transactions will exist in the consolidated legal entity in Dynamics 365 Finance, which can then feed Power BI and other reporting mechanisms to gain visibility and accurate real-time reporting.
  • Currency rates can be set up to translate from the accounting currency of the source company to the accounting currency of the consolidation company according to the end-users needs.

In conclusion, Online Company Consolidation in Microsoft Dynamics 365 Finance will facilitate the consolidation process and help you maintain consistency, gain visibility, and, most importantly, obtain enough flexibility to add new entities for consolidations efficiently and effectively.

Learn more about the benefits Dynamics 365 Finance has to offer by downloading the eBook here.

Thank you.

I hope it was helpful to understand how Microsoft Dynamics 365 Finance can benefit your business.

Communications Pangea

Read more post from Communications Pangea

Read more: Dynamics 365 | Finance

Ask for specialized advice for Dynamics 365 Finance and online company consolidation and make your business thrive.