CLOSE
CLOSE
https://www.sikich.com

Consolidations in Microsoft Dynamics 365 for Finance and Operations: Part 1

There is no shortage of options for ERP systems these days. But when it comes to large enterprises, the list of viable options shrinks substantially. These corporations have high volumes of transactions and complex structures that demand more of an operating system in areas such as consolidations. When choosing an ERP solution, the conversations among these decision makers will almost certainly include Dynamics 365 for Finance and Operations (“D365FO”). In part, that is precisely because D365FO has always had answers to issues surrounding consolidations. Whether this is consolidating large numbers of subsidiaries, multiple level consolidations, or consolidations where subsidiaries are located and operated abroad.

D365FO comes with two different utilities and generally three different methods to effectively accomplish consolidations out of the box. You can use either of these tools on their own to accomplish consolidation, or the third option/method would be to use a combination of the two. One of the functionalities that can be used to consolidate is what is now called Financial Reporter. This is a report building tool that has a focus in creating financial statements and other reports that utilize mainly financial data. This tool handles the issue of combining financial data from multiple entities by consolidating their balances at the time a report is generated to create a “Soft” consolidation. Your second option in D365FO is a process called “Consolidate online.” This option involves consolidating all subsidiaries into a separate consolidation company, creating a “Hard” consolidation. Then the reporting can be done directly out of this consolidated entity in the system.

consolidated entity

This post will focus on the functionalities around online consolidation provided out of the box by Microsoft and what can be done at a high level to address some common challenges of consolidations using this tool.

Financial Reporter VS Online Consolidation Tool

Financial reporter used to be called Management Reporter and FRx before that. It has always been a great simple solution for financial statements that comes out of box with D365FO. For a while it also seemed to be encouraged as the preferred solution for consolidations as well. The advantages really lie in the fact that once you have the report setup correctly, there are no extra processes needed at month end to consolidate. Simply run a report and you have consolidated financial statements. What is often looked over is that the Consolidate online function is also mostly configuration. After initial setup running the actual consolidation takes no time. Then you have a company with all of your needed information to report out of with the tool of your choosing. The truth is that both solutions have their advantages, but more importantly, both of them can navigate all of the challenges that consolidations present. These include things like subsidiaries using different charts of accounts, currency translation, and eliminations.

One goal of many corporations is standardization of subsidiaries. Especially in terms of a chart of accounts, but this can not necessarily be counted on when performing consolidations. Luckily the Consolidate online functionality provided by Microsoft in D365FO allows for a simple solution for this. Of course, the entity where everything is being consolidated into needs to have the master chart of accounts, but you can map all subsidiary accounts easily using a single field on the Main account form called “Default consolidation account”. This function is a simple solution to the problem of multiple charts of accounts. Note that there is a similar option on the financial dimension level as well.

financial dimesion
financial dimension values

An area of consolidations where D365FO offers real flexibility in is currency translation. In the section of the Consolidate online form that covers currency translation, you can choose how legal entities with accounting currencies different from the accounting currency of the consolidation company will be handled. You can actually choose account by account or by account range things like whether to use a rate from individual transaction dates, the rate from date of consolidation (month end for BS) or to specify a rate (an average rate for P&L). You can even choose to use different sets of rates to evaluate the balances. One of the newer features of Online Consolidation is the ability to consolidate reporting currency. This opens a whole other set of possibilities for how you want to run consolidation and track your data. Many companies would be fine with a simple month end and average rate, but the other options available can assist in more complicated consolidation environments.

currency translation
currency exchange rates

Eliminations Functionality

Eliminations is another area where the system gives options on how to handle things. The functionality that aims specifically at Elimination entries lets you define accounts that will have balances eliminated in the final consolidation, and what amounts in these accounts need to be eliminated. From there a journal is created in a company that is designated as an elimination legal entity. You can have a separate entity for this, or you can use the consolidation entity and, in fact, the online consolidation process itself to generate and hold these journal entries. Your other option around eliminations is a little more flexible, and it is simply to create a separate legal entity. Here you can enter and post elimination entries without elimination rules. Then you would just include this legal entity in the consolidation like you would if there were a separate entity where you ran elimination rules.

elimination rules
D365FO consolidation elimination
ledger elimination
D365 consolidations online tool

Summary

The chart of accounts setup to use the Consolidate online function in D365FO is a one-time setup. This is the same for the actual parameters used for currency translation. In fact, most requirements for this process are simply done in configuration. Even the rest of the parameters used in the process will be cached so that you do not need to re-enter them ever unless user data is cleared (Which should happen seldom if ever). Of course, there are the elimination entries. These need to be entered, or rules processed each month as well. As noted earlier, this too can be lumped into the rest of the consolidation process. After these things are set, it is just a matter of running the process using the consolidate online form. Considering this, the argument for using Financial reporter over consolidate online holds much less weight.

The fact is that if you are using only D365FO out of box tools to generate your financial statements, you will be using a combination of D365 data and Financial Reporter. Many companies can find advantages in a middle ground. For example, consolidating in Financial reporter, but creating an elimination company instead of trying to incorporate that piece of the consolidation into the structure of the report. Whatever complications an enterprise has around consolidations and whichever method they chose, the principal thing to realize is that D365FO has solutions and flexibility to handle their consolidation needs.

Have any questions about D365FO consolidation? Please reach out to one of our experts at any time!

This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.

About the Author