If the subsidiary chart of accounts does not follow the chart of accounts of the consolidated company, you can map the subsidiary accounts to the consolidated company accounts.

1. In the subsidiary, click General ledger> Chart of accounts .

2. Select each subsidiary ledger account that will be transferred to the consolidated company. On the Generaltab, in the Consolidation accountfield, enter the account in the consolidated company to which the balance or transactions of the selected subsidiary ledger account will be transferred. If the chart of accounts in the consolidated company is simpler than the subsidiary account structure, enter the same consolidated company ledger account on several subsidiary accounts.

   Note
   If the account types of the subsidiary accounts that are being transferred to a consolidated company account differ, the values of transaction accounts override the values of total and header accounts during consolidation.

3. To prepare reports and financial statements that are based on dimensions in the consolidated company, map the dimensions that are used in subsidiary accounts to consolidated company dimensions:

   1. In the subsidiary, click General ledger> Dimensions .

   2. On the Generaltab, in the Group dimensionfield, enter the consolidated company dimension that is assigned during consolidation to subsidiary transactions and balances with the selected subsidiary dimension. The dimensions that are entered here must be used in the consolidation company. You can enter the same consolidated company dimension as the group dimension for several subsidiary dimensions.

4. If you are performing an online consolidation, click General ledger> Periodic> Consolidate> Consolidation, Onlinein the consolidated company. To ensure that the transfers take place as planned, select the Consolidation accountcheck box on the Criteriatab.

If the subsidiary ledger accounts have the same account numbers and chart of account structure as the consolidated company ledger accounts, you do not have to manually map the subsidiary ledger accounts to consolidated company accounts.

• In the Consolidate Onlineform of the consolidated company, select the Consolidation accountcheck box before consolidation. The transfer of transactions and balances to the correct account occurs automatically during consolidation.

Note
If the account numbers do not correspond, the consolidation stops and you receive a message.

You can perform a consolidation without creating a consolidated company chart of accounts in advance.

• If you have planned the structure that you want to use in the consolidated company, you can map the subsidiary accounts to this structure; when you perform the consolidation, the consolidated accounts that you indicated in the Consolidation accountfield are created automatically during consolidation.

• If you make no mappings on subsidiary accounts, the consolidated company accounts are created automatically when subsidiary data is transferred to the consolidated company. Subsequent data, for example, from the second company being consolidated, is accumulated in consolidated company accounts with the same account number as the subsidiary account.

Regardless of whether you have done mapping or not, clear the Consolidation accountcheck box in the Consolidateform of the consolidated company before running this type of consolidation.

Note

You could use this method to create a chart of accounts in the consolidated company from the chart of accounts of one of the subsidiaries. Delete the consolidation transactions as explained in View and delete consolidation transactions. Then assign an appropriate consolidation conversion principle to each ledger account in the consolidated company, and run the consolidation for all the subsidiaries.