Consolidated Ledger > Consolidation Processes > Map Chart of Accounts

To map the subsidiary’s chart of accounts to the consolidation company GL Account IDs, perform the following steps in the Selection Criteria page:

1.Click the List box button beside the Subsidiary Company field, and select the subsidiary company which GL Account IDs you want to map to the consolidation company GL Account IDs.

2.Select one of the following options in mapping your subsidiary GL Account IDs:

oMap Identical Accounts

Choose this option to automatically locate and select a matching GL Account ID in the consolidation company for each GL Account ID in the subsidiary company. This is useful when the consolidation and subsidiary companies have identical GL Account IDs and GL account structures. If you chose this option, proceed to step 5.

oMap Using Major Segment Values

Select this option to map the consolidation company’s major segment value (e.g., Account #) to the subsidiary company’s major segment value. If you chose this option, proceed to step 3.

oMap 1 Consolidation Company Account to Range of Subsidiary Company Accounts

Select this option to choose a range of subsidiary company GL Account IDs to be mapped to a single GL Account ID in the consolidation company. This option is useful when you need to map a group of subsidiary company GL Account IDs (e.g., all petty cash accounts) to one GL Account ID in the consolidation company. If you chose this option, proceed to step 4.

3.If you chose the Map Using Major Segment Values option, specify in the grid columns the consolidation company’s major segment value that you want to map to the subsidiary company’s major segment value.

Note: If you chose the option to Map Using Major Segment Values, the account segment values in the subsidiary and consolidation companies need not be identical.

4.If you chose the option, Map 1 Consolidation Company Account to Range of Subsidiary Company Accounts, specify in the Subsidiary Company column a single or a range of subsidiary company GL Account ID(s) that you want to be mapped to the single consolidation company GL Account ID highlighted in the grid.

Note: If you chose the option to Map 1 Consolidation Company Account to Range of Subsidiary Company Accounts, the account segment values in the consolidation company GL Account ID and the subsidiary company GL Account ID(s) need not be identical, but these must have the same account type (e.g., asset, liability, or equity); otherwise, the subsidiary GL Account ID that has an account type that is different from the consolidation company GL Account ID will not be mapped (e.g., an Asset account cannot carry balances from a Liability account, or vice-versa).

5.Click the Generate button to proceed with mapping the subsidiary company GL Account IDs to the consolidation company GL Account ID(s).

Note: The subsidiary company’s GL Account IDs cannot be mapped to the consolidation company’s allocation accounts, inactive accounts, and “Translation Adjustment” GL Account ID.

Selection Criteria Page

Selection Criteria Page