Previous  Next          Contents  Index  Navigation  Glossary  Library

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

   To define a consolidation mapping:

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.

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:

Suggestion: Use account rules only for specific exceptions where a subsidiary account cannot be mapped correctly with a segment rule.

   To enter segment rules:

Note: This action produces the same result as the Copy Value segment rule in earlier versions of General Ledger.

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.

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:

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


         Previous  Next          Contents  Index  Navigation  Glossary  Library