top of page
365 Finance Architec

Consolidate different Chart of Accounts, No Problem for D365

Updated: Aug 29, 2023



Today we will consolidate Legal Entities (LE) with different Chart Of Accounts.


Scenario

LE Chart Of Accounts Name Country

US01 COA_USA USA

FR01 COA_FRA FRA

CON COA_USA USA


The France LE is using a French Statutory Chart of Accounts.

The USA Consolidation LE (CON) is using a different Chart of Accounts.


Assumption

You have already created all the Main Accounts in the corresponding Chart of Accounts.



The following setup for account number translation will be two steps.

Then will cover the related Consolidate, Online process.



1. Consolidation Account Group


Select your consolidation Legal Entity (CON).

Create a Consolidation Group



If I wanted to translate into different CON companies (i.e. CON1, CON2, CON3) that have different Chart of Accounts, you can create additional Consolidation Account Groups for use with those additional Consolidation Legal Entities.


If I only need one consolidation account group, I like to name it 'Default'.


General ledger > Chart of Accounts > Accounts > Consolidation account groups


2. Additional Consolidation Accounts


Create a listing of Additional Consolidation Accounts


This list will itemize the foreign Main Accounts (ie. COA_FRA), the Consolidation Group, and the Consolidation Main Accounts (i,e, COA_USA).


After you choose the Chart of accounts that you want to translate (COA_FRA), you will add new lines for each Main Account as exhibited.


For our demonstration, we are only translating the French Chart of Accounts for use in a United States Consolidation Company.


If I wanted to translate multiple Chart of Accounts into a single Consolidation company, I would choose those additional charts and repeat the process.


General ledger > Chart of Accounts > Accounts > Additional consolidation accounts

Note: The Consolidation account name will need to be manually input.


If you prefer to create the AdditionalConsolidationAccounts quickly, I recommend using the Data Management Workspace.

The template can be filled out using your normal copy/paste MS Office functions.

After assigning the Consolidation Account to each line, you may use Excel VLOOKUP function to quickly populate the Consolidation Account Name.


Here is a sample of the related Data Management template.


3. Consolidate, Online


Now we are going to use our setup in the USA consolidation company.


Select the consolidation company (CON).

Perform the consolidation with your normal settings plus as exhibited.


Consolidations > Consolidate, Online


We have successfully performed a consolidation using different Chart of Accounts.

The Consolidation companies Trial Balance will now display the activity consolidated from the French Legal Entity using the USA Chart of accounts that were specified in step 2) above.



Recent Posts

See All

Comments


bottom of page