Manage Consolidation Acct/Org Mappings

Use this screen to identify the account and organization combination into which costs should be transferred. This is the third step in preparing a consolidation.

Consolidation account/organization mappings are maintained by a subsidiary company. This allows one "host" company to receive data from multiple performing companies.

If you are making a transfer to a company within the same database or to a company in a different database with the same account structure and elements, select the Validate Consolidation Accounts check box to have Costpoint verify that the consolidation account and organization exist and are active.

You must assign all account/organizations to a related consolidation account/organization to be transferred to the host, or consolidation, database. Missing account/organization combinations display on the Consolidation Creation Error Report when you execute the Create Consolidation Entry screen. To arrive at the current amount to transfer, Costpoint converts the account/organization balances and adds them to previous year-to-date amounts transferred for the consolidation account/organizations.

You can link one or many account/organizations to a single consolidation account/organization. You may want to link at the summary account level or summary organization level, or convert detail account/organizations.

A single consolidation account/organization combination should not have both balance sheet accounts and income statement accounts mapped to it. If you use Multicurrency:

  • Balance sheet account amounts use period-end exchange rates.
  • Income statement accounts use period average rates.
  • Stockholders' equity accounts, by default, use historical rates (but can use the override, using weighted average historical exchange rates). 

If your company is using different conversion rates, Costpoint converts the summed amount for the consolidation account/organization using the higher rate.

In Update or Query mode, you can use Subquery to see existing account/organization wildcard strings and consolidation account/organizations. Costpoint explodes the wildcards (provides detail for each existing combination) when you create the consolidation entry, rather than when the mapping table is maintained. This allows you to add, change, or delete from this table using wildcards. Your edits are reflected in the creation process.

Note: Costpoint supports wildcards in both the Account Wildcard String and the Organization Wildcard String columns. However, you should not enter wildcards in the Consolidation Account or Consolidation Organization columns.

The wildcard symbols are:

  • %: The percentage wildcard represents one or more characters.
  • _: The underscore wildcard represents a single character.

You can enter wildcards to indicate that an account or organization entry begins or ends with (%) or contains (_).

Use this screen during the consolidation process before you complete the Manage Transfer Locations screen. To reduce the amount of maintenance, you can enter wildcards that automatically include future accounts and organizations as they are entered.