Using the State Controller
Selecting a State Controller button will open the General Ledger window related to the consolidation step you need to complete. The section below provides a functional overview of the consolidation steps, an outline of the related State Controller actions you need to perform to complete the consolidation step, and references to the detailed task descriptions for each action.
Define Your Consolidation Chart of Accounts
- Carefully plan your parent and subsidiary charts of accounts. This will help simplify the consolidation process. We recommend that you review the suggestions presented earlier in this chapter for creating multiple sets of books for multiple companies. See: Accounting for Multiple Companies with Multiple Sets of Books
Note: The State Controller does not provide access to the General Ledger windows needed to complete this consolidation step.
Map Consolidation Data (Mapping; Mapping Set)
1. Choose the State Controller's Mapping button to define (or modify, as needed) a consolidation mapping for each subsidiary set of books you want to consolidate to your parent. When you define the mapping, choose a consolidation method. You can consolidate actual, average, translated, budget, or statistical balances. You can also consolidate actual journal entry transaction details from a subsidiary set of books. See: Mapping Subsidiaries to Your Parent.
Note: If you have average balance processing enabled, your choice of consolidation method determines whether you should consolidate into a consolidation or non-consolidation set of books.
2. Select rules to specify how to map accounts from each subsidiary into your parent. See: Selecting Mapping Rules.
3. (Optional) Choose the State Controller Mapping Set button to create a set of consolidation mappings that you can use to transfer multiple subsidiaries' data to your parent at the same time.
Prepare Consolidation Data (Translation Status)
1. If any of your sets of books have balance sheet accounts that are denominated in a foreign currency, revalue the balances to reflect the impact of any changes in exchange rates. Post the resulting revaluation journal. See: Preparing Subsidiary Data.
2. Choose the State Controller's Translation Status button to check the current status of your subsidiary translations. Translate the account balances for any subsidiary set of books whose functional currency differs from the parent. Translate to the functional currency of the parent set of books. See: Preparing Subsidiary Data.
3. Run a trial balance report for each subsidiary set of books, using the parent set of book's functional currency. These reports will help you reconcile your subsidiaries to the parent.
Transfer Consolidation Data (Transfer; Transfer Set)
2. Choose the State Controller's Transfer button to transfer your consolidation data. General Ledger creates an unposted consolidation journal batch in your parent set of books. See: Transferring Subsidiary Data to Your Parent.
Optionally, choose the State Controller's Transfer Set button to transfer consolidation data from multiple subsidiaries, as defined by a mapping set. See: Transferring Consolidation Sets.
3. If you use the audit mode when transferring your consolidation data, review the consolidation audit reports.
4. If you use audit mode, purge the consolidation audit data to delete the audit details associated with your consolidation. See: Purging Consolidation Audit Data.
Post Parent and Subsidiary Amounts
1. Choose the State Controller's Review Journal button to review or modify the unposted consolidation journal batch. See: Posting Subsidiary Data.
2. Choose the State Controller's Post button to post your consolidation batch to your parent set of books. See: Posting Subsidiary Data.
3. Review the results of your consolidation.
Create Eliminating Entries
1. Choose the State Controller's Eliminate button to create, as needed, journal entries in your parent set of books for your consolidation eliminations. See: Creating Eliminating Entries.
2. Post the eliminating entries.
Report on Consolidated Balances
- Choose the State Controller's Report button to run your consolidated and consolidating reports. You can run standard reports, or use the Financial Statement Generator or GL Desktop Integrator Report Wizard to define custom consolidated reports for your parent set of books. See: Overview of the Financial Statement Generator.
Note: You can report on multiple sets of books in the same report as long as each set of books shares the same account structure and calendar.
Analyze Consolidated Results
Note: The State Controller does not provide access to the General Ledger windows needed to complete this consolidation step.
State Controller Button Colors
To help guide you in completing your consolidation steps, the State Controller buttons will be displayed in one of three colors. The colors and their meanings are as follows:
Blue: represents a recommended step.
Gray: represents a step that is not recommended. Optionally, the button might be disabled instead of colored gray.
Red: represents a warning. For example, a red Translation Status button indicates that the subsidiary's translated balances are out of date.
When you select a subsidiary from the Consolidation Workbench, the State Controller's buttons will change color based on which steps you've performed or need to perform for that subsidiary. After you successfully complete a consolidation step, the State Controller buttons may change color to reflect the current status. For example, the Review Journal button is gray until you have successfully transferred your subsidiary data to your parent and imported the consolidation journal. After these steps complete successfully, the Review Journal button's color changes to blue, to indicate that reviewing the consolidation journal is now a recommended step.
See Also
Global Consolidation System
Consolidation Workbench
Mapping Subsidiaries to Your Parent
Preparing Subsidiary Data
Transferring Subsidiary Data to Your Parent
Transferring Consolidation Sets
Posting Subsidiary Data
Creating Eliminating Entries
Purging Consolidation Audit Data