Consolidating Financial Data in Microsoft Dynamics NAV or Business Central
With roots that go back to Denmark in the 1980s, Microsoft Dynamics NAV and Dynamics 365 Business Central offers strong multinational and complex accounting capabilities—including the ability to handle consolidations—that other ERP solutions do not.
Some organizations need to consolidate financial data for multiple business units or legal entities, while others have subsidiaries that report into parent organization. In either case, Business Central and Dynamics NAV come with tools out of the box to make those processes faster and easier. Following are tips for handling consolidations in either product:
What Dynamics NAV and Business Central Do When It Comes to Consolidations
When companies need to begin consolidating subsidiaries for financial reporting, there are often misconceptions of how the consolidations process works in NAV and Business Central. Here is list of what both products allow you to do:
- Map different Chart of Account and Dimension structures from the subsidiary companies to the master Consolidation company
- Identify the ownership percentage for a subsidiary and automatically applies this percentage to the consolidated financial data
- Consolidate financial data from subsidiary companies within the same Dynamics NAV database
- Consolidate financial data using a file created from another Dynamics NAV database (or any other financial software capable of producing the required file format)
- Establish a G/L Entry in the Consolidation company for the net change in the mapped G/L Account(s) balance for the consolidation period for each subsidiary
- If desired, bring forward the related Dimension detail for the net change G/L Entry that is established
- Consolidate foreign currency subsidiaries in accordance with standards set in FAS 52-Foreign Currency Translation
- Re-consolidate past periods if G/L balances in a subsidiary company have changed
- Do financial reporting at both the consolidated and subsidiary level from the Consolidation company
Multiple Consolidation Translation Methods And When They’re Used
- Average Rate (Manual). Typically used for Income Statement accounts; the rate is specified during consolidation process
- Closing Rate. Typically used for Balance Sheet Accounts, with the exception of Equity accounts; the rate is specified during consolidation process; the beginning balance is restated.
- Historical Rate. Typically used for Retained Earnings, Intercompany Payables and Receivables, foreign currency loans from third parties; use the exchange rate in effect on the transaction’s posting date.
- Composite Rate. Used for Equity accounts. The beginning balance is not restated; the average rate specified during consolidation is used for the current period; indicate accounts for posting on the Business Unit page.
- Equity Rate. Similar to Composite; indicate accounts for posting on the Business Unit page.
NOTE: Methods should agree with those being used currently (manually) and confirmed through testing and with outside auditors.
Tips for Consolidations Using Dynamics NAV or Business Central
What do I need to do when adding a new G/L account? Complete the Consol. Debit Account, Consol. Credit Account, and Consolidation Translation Method fields.
How do I select Dimensions for consolidation? From the Business Unit, select Functions > Import Database. On the Options tab, click the ellipsis in the Dimensions field. Place a check in front of the dimensions to import.
How do I record eliminating entries? Enter the eliminating entries in a journal batch. To view all entries prior to posting, run the Eliminations report from the Business Unit page. On the Options tab, select the Journal and Batch for the elimination entries.
Do I need to close the year in the consolidated company? The year must be closed to properly reflect retained earnings and the income statement balances.
What are the steps involved in processing a consolidation for multicurrency? From the Business Unit:
- Click the Exchange Rates button > Average Rate and enter the average exchange rate for the period.
- Click the Exchange Rates button > Closing Rate and enter the closing exchange rate for the period.
- Process as normal for other consolidations
What exchange rate is used for processing a consolidation? In the Currency Exchange Rate Table, you can select the option to use the Local (Parent) or Business Unit (Subsidiary) as the source; alternatively, you can enter the exchange rates from the business unit card.
Are there special considerations when reconsolidating with multiple currencies? Yes. Enter the Average Rate and Closing Rate on the Business Unit card.
Can I use an Additional Reporting Currency for consolidations? Yes. In the Data Source field on the Business Unit card, select the Additional Reporting Currency option.
Do I need to run the Adjust Exchange Rate batch in the consolidated company? If you use the Additional Reporting Currency (ACY) as the consolidation currency, you need to run the Adjust Exchange Rate batch job in the consolidated company for the ACY. If you use multiple currencies in any of the subsidiary companies, you need to run the Adjust Exchange Rate Batch job for your customers, vendors, and bank accounts prior to consolidating.
What Dynamics NAV and Business Central Do Not Do
Although NAV and Business Central are very well equipped for consolidations, there are some things they were not designed to do:
- Establish detailed G/L Entries from the subsidiary’s daily transactions in the Consolidation company
- Bring forward posted sub-ledger detail from the subsidiary company (e.g., Customer Ledger, Vendor Ledger, Bank Account Ledger, etc.)
- Establish Posted Documents from the subsidiary in the Consolidation company
- Establish G/L Budgets in the Consolidation company
- Automatically identify or process Elimination entries
However, what NAV and Business Central do versus what they don’t do is very much in their favor.
Need Help With Consolidations? Ask The Experts
At ArcherPoint, our accounting and finance experts have years of experience helping companies make it easier to manage multiple legal entities, subsidiaries, or business units, both within the U.S. and multi-nationally. Contact us for help with setting up your consolidations process.
To learn more about consolidations in NAV or Business Central, read this blog, How To Set Up Consolidations In Microsoft Dynamics Business Central Or NAV.
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard