Use this screen to identify the account/organization into which costs should be transferred. This is the next 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 checkbox, and Costpoint will verify that the consolidation account and organization exist and are active. You can use Lookup in the Consolidation Account and Consolidation Organization columns.
You must assign all account/org balances to a consolidation account and org in this table, regardless of whether it has a balance. The account/org balances are converted and added to previous YTD amounts transferred for the consolidation account/organizations to arrive at the current amount to transfer.
You can link one or many account/organizations to a single consolidation account/org. You may want to link at the summary account level or summary org level, or convert detail account/organizations.
Costpoint supports wildcards in both the Account Wildcard String and the Organization Wildcard String columns. You can enter wildcards to indicate that an account or organization entry begins or ends with (%), or contains (_). The percentage wildcard, %, represents one or more characters and the underscore wildcard, _, represents one single character. The Consolidation Account or the Consolidation Organization columns must not contain any wildcards.
You must assign all account/organizations to a related consolidation account/org that will be transferred to the host, or consolidation, database. Missing account/organizations will display on the Consolidation Creation Error Report when you execute the Create Consolidation Entry screen.
A single consolidation account/organization combination should not have both balance sheet accounts and income statement accounts mapped to it. If you are licensed for Costpoint Multicurrency:
Balance sheet account amounts will use period-end exchange rates.
Income statement accounts will use period average rates.
Stockholders’ equity accounts will, by default, use historical rates (but can use the override using weighted average historical exchange rates).
If your company is using different conversion rates, the summed amount for the consolidation account/organization will be converted using the higher rate.
In update or Query mode, you can use Subquery to see existing account/org wildcard strings and consolidation account/orgs. Costpoint will explode the wildcards (detail each existing combination) when the consolidation entry is created, rather than when the mapping table is maintained, so that you can add, change, or delete from this table using wildcards. Your edits are reflected in the creation process.
Use this screen during the consolidation process, before the Maintain Transfer Locations screen. To reduce the amount of maintenance, you can enter wildcards that automatically include future accounts and orgs as they are entered in the Accounting folder.
To create a new mapping combination, enter up to six alphanumeric characters to identify this set of account/org combinations. You can use a given mapping code only once in the same database.
Enter up to 30 alphanumeric characters to describe the mapping code for this combination.
Select this checkbox to validate consolidation accounts and organizations if the transfer is being made to a company within the same database or to a company in a different database with the same account structure and elements. Costpoint will verify that the consolidation accounts and organizations exist, are active, and that the account/org is valid.
When you select this checkbox, you can use Lookup to populate the Consolidation Account and Consolidation Organization columns. You must use this option if you plan to link this mapping code to an internal location in the Link Consolidation Locations screen. The default for this checkbox is unchecked.
Enter, or use Lookup to select, an existing account. Before you save this screen, you can edit the account to include any wildcards. Use the wildcard placeholder (%) to link multiple accounts to a single consolidation account/org combination. For example, use "01%" to map all accounts beginning with "01" to your consolidation account/org. Use the (_) wildcard to link multiple accounts with a specific structure to a single consolidation account/org. For example, "05_30" includes "05030," "05130," "05230," "05330," etc.
Enter, or use Lookup to select, an existing organization. Before you save this screen, you can edit the organization to include any wildcards. Use the wildcard placeholder (%) to link multiple organizations to a single consolidation account/org combination. For example, use "2A%" to map all organizations beginning with "2A" to your consolidation account/org. Use the (_) wildcard to link multiple organizations with a specific structure to a single account/org. For example, "2A_1" includes "2A01," "2A11," "2A21," "2A31," etc.
If you selected the Validate Consolidation Accounts checkbox, you can use Lookup to select an account number to be used to represent the account(s) selected in the Account Wildcard String column. If you did not select the Validate Consolidation Accounts checkbox, you can enter the account number to be used to represent the account(s) selected in the Account Wildcard String field. This account number will appear on your consolidation reports. Do not use project-required accounts as consolidation accounts.
If you selected the Validate Consolidation Accounts checkbox, you can use Lookup to select an organization that will be used to represent the org(s) selected in the Organization Wildcard String column. If you did not select the Validate Consolidation Accounts checkbox, you can enter the organization that will be used to represent the org(s) selected in the Organization Wildcard String column. This org will appear on your consolidation reports.
If you highlight a row and select this pushbutton, the Sample Accounts column at the bottom of the screen will be populated with a list of all the accounts that will consolidate into the one consolidation account.
If you highlight a row and select this pushbutton, the Sample Orgs column at the bottom of the screen will be populated with a list of all the organizations that will consolidate into the one consolidation organization.
If you highlight a row and select this pushbutton, the number of account/organizations that meet both the account criteria and organization criteria will be displayed in the field below this pushbutton.
If you select the Acct Count pushbutton, the applicable account numbers will display in this column. This column is especially helpful when using wildcards. All accounts that fall into the wildcard string are listed here.
If you select the Org Count pushbutton, the applicable organizations will display in this column. This column is especially helpful when using wildcards. All organizations that fall into the wildcard string are listed here.
Select the Multicurrency pushbutton to insert a row in the mapping table that will be used for currency conversion variances, if they exist. This row will have an Account Wildcard String of "Currency" and an Organization Wildcard String of "Conversion." Do not use the account/org combination that you select for the Consolidation Account and Consolidation Organization fields in any other rows. This pushbutton will be enabled only if you are using Costpoint Multicurrency, in which case the "Currency Conversion" row will be required.
If you select this pushbutton, the system will create a row in the table with an Account Wildcard String value of "CURRENT YEAR" and an Organization Wildcard String value of "RETAINED EARNINGS." The Current Year Equity pushbutton will be available only if the Consolidation Calculation Method in the Consolidation Settings screen is set to Inception-To-Date.
You should complete the Consolidation Account and Consolidation Organization fields for this row in the same manner as for other rows. If the Current Year Equity pushbutton is enabled, you can save this screen with only one CURRENT YEAR RETAINED EARNINGS row.
The purpose of the Current Year Retained Earnings account/org is to designate which row the income statement account balances will summarize into during the Update Consolidation Prior Year Balances process.
Data entered in this screen is stored in the CONS_MAPPING and CONS_MAP_WILDCARD tables.