Consolidation Company Mapping Maintenance

---

Open this form by clicking the Set up button on the Consolidation Code Maintenance form. The consolidation code and description come from the Consolidation Code Maintenance form and are read only.

Subsidiary company

Select the subsidiary company for the mapping.

Consolidation company

Select the consolidation company to which the selected subsidiary company is mapped. You cannot set up a company to be a consolidation company in more than one consolidation code.

Main

Percentage ownership

This is set to 100, and is read-only.

Consolidation currency

This is set to the current company's currency code, and is read only.

Inactive

The default value is deselected to indicate the mapping is active.

If this option is selected, the company mapping does not display in the hierarchy diagram on the Consolidation Code Maintenance form, and is not available for selection when processing a consolidation using this consolidation code. You can still prepare the subsidiary company for consolidation.

Period mapping

If the subsidiary and consolidation companies are using different general ledger calendars, you must select a period mapping to indicate how the financial periods are mapped between companies for the purposes of consolidation.

Use translated value

This is enabled if the Translations module is in use for both the subsidiary and the consolidation company. It indicates that the subsidiary's translated values must be used in the consolidation process.

If the subsidiary company has a different base currency to the consolidation company, the option defaults to selected and read-only. If you select this option, the Transaction reserve account and Variance account fields are mandatory.

Transaction reserve account

This field is visible and mandatory if the option to Use translated value is selected.

This field specifies the account that any foreign currency translation reserve amounts should be posted to. It is used by the consolidation process when generating journals for foreign subsidiary companies.

Variance account

This field is visible and mandatory if the option to Use translated value is selected. It specifies the account that any foreign currency translation variances should be posted to. It is used by the Generate Consolidation process when generating journals for foreign subsidiary companies.

Note: Once specified, all variances for foreign subsidiaries is posted to this account whether or not they are because of foreign exchange differences. You should monitor this variance account in the same way that you monitor your normal suspense account.

For other subsidiary companies (which don't use translations), any variances are posted as forced balance values to the normal suspense account.

Account Mapping

To consolidate multiple company ledgers, for each company mapping (subsidiary to consolidation) within a consolidation code, you must map each subsidiary's general ledger chart of accounts to the consolidation company's General Ledger chart of accounts before a successful consolidation process can occur.

A consolidation account mapping is a set of instructions (or rules) for mapping accounts from a subsidiary company to the consolidation company. When you transfer information from a subsidiary to its consolidation company, a general ledger consolidation journal is created in the consolidation company using the subsidiary's mapping information.

Mapping

This form displays a table used to set up the account mapping rules.

Type

Accounts are mapped from the subsidiary company to the consolidation company. Greentree Desktop maps accounts based on:

• One to one: Mapping types Account, Account Pair, Account Range, Tree map accounts on a one to one basis.
• Many to one: Mapping types Range to Account and Tree to Account map accounts on a many to one basis.

Note: The process does not support a one-to-many mapping, as the consolidation process always takes 100% of the value of the subsidiary company into the consolidation company.

The mapping types that you can select are:

Account

Each general ledger account from the subsidiary company is mapped to an account in the consolidation company, on a one-to-one basis, in standard general ledger account sequence. This requires that the account codes of the two companies are identical.

Account Pair

Selected pairs of accounts between the two companies are mapped to each other. Select the subsidiary account in the Source From column and consolidation account in the Destination From column.

Account Range

A range of account pairs between the two companies are mapped to each other. Enter the range for the subsidiary company in the Source From and Source To columns, and the range it is mapped to in the consolidation company in the Destination From and Destination To columns.

Range to Account

A range of accounts of the subsidiary company are mapped to one account in the consolidation company. Enter the range for the subsidiary company in the Source From and Source To columns, and the account it is to mapped to in the consolidation company in the Destination From column.

Tree

You can map accounts in branches of a general ledger account tree of the subsidiary company to accounts in branches of a general ledger account tree of the consolidation company.

Select the:

• Subsidiary company's tree in the Source From column.
• Branch in the Source To column.
• Tree it is to map to in the consolidation company in the Destination From column.
• Branch in the Destination To column.

Press Shift-Enter to expand tree branches in the branch entry columns.

Tree to Account

You can map an account in a branch of a general ledger account tree of the subsidiary company to an account of the consolidation company.

Select the:

• Subsidiary company's tree in the Source From column.
• Branch in the Source To column.
• Account is to mapped to in the consolidation company in the Destination From column.

Press Shift-Enter to expand tree branches in the branch entry columns.

Verify

Once the mappings have been saved, click this button to show the defined mappings, on the Verify Mapping tab., as seen in the examples below:

Example 1:

Account mapping has no errors

Example 2:

A subsidiary account is not mapped. The error *** No match found *** displays in the GL Account (Consolidation Company) column.

WARNING: Any accounts in the consolidation company that do not match any of the subsidiary company's accounts are ignored.

Example 3:

You can map a general ledger account to more than one consolidation account. This generates a Duplicate in rule warning. When consolidating, mapping rules are processed in table sequence so the first mapping found is used.

Example 4:

General ledger accounts must be mapped to an account of the same currency, unless the Translations module is in use.

The Translations module enables a translation to be run before a consolidation, translating subsidiary values into the same currency as the consolidation company.

• Consolidation Code Maintenance
• Generate Consolidation
• Module Control - Period Mapping
• Generate Consolidation
• Global Finanace Translations

---