Consolidate different Chart of Accounts, No Problem for D365
Updated: Aug 29
Today we will consolidate Legal Entities (LE) with different Chart Of Accounts.
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.
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.