Mapping Subsidiaries to Your Parent
To consolidate multiple sets of books that have different functional currencies, accounting calendars, or charts of accounts, you must first map your subsidiaries' charts of accounts to your parent's chart of accounts.
A consolidation mapping is a set of instructions for mapping accounts or entire account segments from a subsidiary set of books to the parent set of books. When you subsequently transfer amounts from a subsidiary to your parent, General Ledger creates an unposted consolidation journal batch in your parent set of books based on the subsidiary's mapping information.
Additional Information: You define one consolidation mapping for each subsidiary. If you want to change how a subsidiary consolidates to your parent, change the subsidiary's consolidation mapping before you transfer the data.
You can group multiple consolidation mappings into a consolidation mapping set. You can then transfer the mapping set to your parent rather than transferring each subsidiary's data separately. See: Creating Mapping Sets.
Prerequisites
Define your parent and subsidiary sets of books. If you have average balance processing enabled, determine if the parent set of books needs to be a consolidation or non-consolidation set of books.
To define a consolidation mapping:
1. Navigate to the Consolidation Mappings window.
3. Choose a consolidation Method.
4. (Optional) Enter a Description for the mapping.
5. Enter the name of the Subsidiary set of books you will be consolidating.
6. Enter the Parent set of books name.
If you plan to consolidate budgets, your subsidiary and parent sets of books must share the same calendar and functional currency.
7. Enter the Currency to use for the consolidation:
- If you are consolidating balances, enter the parent set of book's functional currency. Optionally, enter STAT to consolidate statistical balances.
- If you are consolidating transactions, enter the parent set of book's functional currency. This must be the same as the subsidiary set of book's functional currency.
8. Enter a range of Effective Dates for which the consolidation mapping can be used. If you use the mapping to transfer consolidation data for periods that fall outside the effective date range, the transfer will fail.
9. If you have average balance processing enabled, select a default Usage type from the poplist.
Standard: Only standard balances will be transferred to the parent set of books.
Average: Only average balances will be transferred to the parent set of books.
Standard & Average: Both standard and average balances will be transferred to the parent set of books.
Additional Information: You can create separate consolidation mappings for standard and average balances. This is helpful if you want to use different mapping rules to get different levels of detail. For example, you might map standard balances so you can view consolidated totals for each cost center within each company. However, you might map your average balances so you can view consolidated totals for each company.
Note: If you choose Transactions as your consolidation method, General Ledger will enter Standard as the Usage type. You cannot override this when you transfer your subsidiary data.
10. Select your consolidation run options. See: Consolidation Run Options. You can change these when you transfer your subsidiary data.
11. Choose the Account Rules button to define rules to map subsidiary accounts into parent accounts. Choose the Segment Rules button to define rules to map subsidiary account segments into parent account segments.
Selecting Mapping Rules
Use segment rules, account rules, or a combination of both to specify how to consolidate balances or transactions from your subsidiary to your parent.
Segment rules: map subsidiary account segments to parent account segments. For example, you can map your subsidiary's Department segment to your parent's Cost Center segment.
Account rules: map a specific subsidiary account or a range of accounts to a specific account in your parent set of books. For example, you can map subsidiary account 02.300.5400.100 to account 01.100.3000.000.000 in your parent set of books. Or, you might map the entire range of subsidiary accounts 02.300.5400.100 through 02.300.6999.100 to account 01.100.3000.000.000 in your parent set of books.
Notes:
- You must define a segment rule action for each segment in your parent's chart of accounts. You cannot define more than one action per parent segment.
- Segment rules are preferable to account rules because:
- It's fast and easy to create a consolidation by using segment rules. For example, if your parent account has only three segments, you can map a subsidiary's entire chart of accounts with just three segment rules.
- Consolidations based on segment rules process faster.
Suggestion: Use account rules only for specific exceptions where a subsidiary account cannot be mapped correctly with a segment rule.
- Account rules override segment rules if there is any conflict.
- If you define segment rules for dependent segments in your chart of accounts, the list of values for the dependent segment value may appear to contain duplicate entries (if you have defined the same dependent value and description for different independent segment values). Choose any entry with the appropriate value; the Global Consolidation System does not use the description.
To enter segment rules:
1. Navigate to the Consolidation Mappings window.
2. Enter or query a consolidation mapping.
3. Choose the Segment Rules button.
4. For each subsidiary segment being mapped, enter the Parent segment name to which it will map, an Action, and the Subsidiary segment name. You can use only one action for each parent segment. Possible Actions include:
Copy Value From: Copy all values in your subsidiary segment to the same values in your parent segment. The segments do not have to use the same value set, but must use the same segment values.
Note: This action produces the same result as the Copy Value segment rule in earlier versions of General Ledger.
Assign Single Value: Assign one specific value that will be used for the parent segment. You must enter the value that the parent chart of accounts will use.
Suggestion: Use this action when your parent account has more segments than your subsidiary account.
Note: This action produces the same result as the Single Value segment rule in earlier versions of General Ledger.
Use Rollup Rules From: Map values from your subsidiary segments to your parent segments using the rule specified in the Rollup Rules region.
5. If you chose the Use Rollup Rules From action in the previous step, enter the mapping rules in the Rollup Rules region.
Additional Information: Once you save your work, you cannot modify your rollup rules, except to change the parent and subsidiary segment detail values. To change a rollup rule, delete it then create a new one.
To enter account rules:
1. Navigate to the Consolidation Mappings window.
2. Enter or query a consolidation mapping.
3. Choose the Account Rules button.
4. Enter the Subsidiary Accounts that you want to consolidate. If you enter multiple ranges, they must not overlap.
5. Enter the Parent Account to which you want to map each subsidiary account range.
See Also
Rollup Rules
Using Summary Accounts
Consolidation Run Options
Global Consolidation System
Consolidation Workbench
Transferring Subsidiary Data to Your Parent
Transferring Consolidation Sets
Posting Subsidiary Data
Creating Eliminating Entries
Defining Sets of Books
Notes on Consolidating Average Balances