Consolidations in Microsoft Dynamics 365 for Finance and Operations: Part 1
Blaine Grzegorek
|
Nov 17 2020
|
6 min read
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.
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.
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.
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.
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
Blaine Grzegorek
Blaine Grzegorek is a Senior Consultant at Sikich LLP specializing in financial implementations. He trains and implements general financial and strategic business practices in relation to integrated computer systems.
He has over 7 years experience in systems and industry consulting. In that time, he has implemented all areas of the Financial and Accounting functionality, including Multi-Company, Multi-currency, Costing, Budgeting, Banking, Fixed assets, Project Accounting, and Customer Engagement.
Sign up for Insights
Join 14,000+ Business executives and decision makers.
Latest Insights
Sikich On Demand
On Demand – Strategic Site Selection – Leveragin...
October 3, 2024
Sikich On Demand
On Demand – Strategic Site Selection – Leveragin...
October 3, 2024
https://youtu.be/J2WRYiAKelQ
Every opportunity to optimize costs and drive growth is crucial in today's business environment. In this webinar, S...
Manufacturers’ Path to the Cloud: Where Do They Stand?...
October 3, 2024
Manufacturing
Manufacturers’ Path to the Cloud: Where Do They Stand?...
October 3, 2024
To cloud or not to cloud? For manufacturers considering integrating new technology, the cloud is an attractive option, particularly for greater secur...
Innovate the Insurance Customer Experience and Competitively...
October 2, 2024
AI
Innovate the Insurance Customer Experience and Competitively...
October 2, 2024
Generative AI capabilities and AI-infused automations in Salesforce allow insurance companies to empower every employee to make a difference for cust...
The Ins-and-Outs of Employment Tax Credits for Manufacturers...
September 26, 2024
Tax
The Ins-and-Outs of Employment Tax Credits for Manufacturers...
September 26, 2024
Through employment tax credits, manufacturers can offset a portion of their income tax liabilities. Credits are available to manufacturing businesses...
How Do Life Sciences Companies Benefit From NetSuite SuiteSu...
September 26, 2024
Life Science
How Do Life Sciences Companies Benefit From NetSuite SuiteSu...
September 26, 2024
Sikich has been a clear leader in the life sciences industry for quite some time now. We even earned the Oracle NetSuite Alliance Partner and Oracle...
Gain Customer Intelligence to Transform Your Most Important ...
September 25, 2024
CRM
Gain Customer Intelligence to Transform Your Most Important ...
September 25, 2024
Customer 360 in Salesforce enables insurance firms to deliver outstanding, personalized customer experiences at every touchpoint, own and expand thei...
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.