The procedure for preparing subsidiary accounts for consolidation depends in part on how the closely the structure of the subsidiary chart of accounts reflects the chart of accounts of the consolidated company.

Note Note

Before you start a consolidation at the close of a period, perform the preparatory activities for the period closing, but do not close the subsidiary accounts until the consolidation is completed. For more information about period closings, see Closing the month, period, and fiscal yearand Fiscal year closing checklist.


Map subsidiary ledger accounts to consolidated company accounts

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 > .

  2. Select each subsidiary ledger account that will be transferred to the consolidated company. On the tab, in the field, 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 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 > .

    2. On the tab, in the field, 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 > > > in the consolidated company. To ensure that the transfers take place as planned, select the check box on the tab.

Maintain the same chart of accounts in subsidiary and consolidated company

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 form of the consolidated company, select the check box before consolidation. The transfer of transactions and balances to the correct account occurs automatically during consolidation.

Note Note

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


Use a blank consolidated company (no ledger accounts are created)

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 field 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 check box in the form of the consolidated company before running this type of consolidation.

Note 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.


See Also