Custom Sub-Consolidation Reporting |
Overview of Custom Sub-Consolidation (CSC) Functionality In Manage Configurations, the default for the Custom Sub-Consolidation system parameters for both the Tax Provision tab and Effective Tax Rate tab are set to Yes. The Tax Provision and Effective Tax Rate reports at the sub-consolidated level can be viewed showing Sub Consolidation, rather than Unit detail. There can be multiple CSC groupings. For example, one CSC could be defined to view units by region and another to view units by management lines. Set-up of CSC The Administrator is responsible for managing the following system parameters in Manage Configurations.
To create the Sub-Consolidations: In Manage Units > Unit Sub-Consolidations, create a "parent" sub-consolidation beginning with CSC#_X_. You can have multiple CSC breakout's by multiple parent Sub-Consolidations (e.g., CSC1_X_Regions and CSC2_X_Management). In each of the parent sub-consolidations, include all units for the child Sub-Consolidation.
In Manage Units > Unit Sub-Consolidations, create as many "child" sub-consolidations as you would like beginning with CSC#_ (e.g., CSC1_North America and CSC1_EMEA or CSC2_Corporate, CSC2_Manufacturing).
In the following example, D1000, D2000, F1000, and F2000 can only belong to one child sub-consolidation, either CSC1_Domestic or CSC1_Foreign.
D1000, D2000, F1000, and F2000 can only belong to one child sub-consolidation, either CSC1_Domestic or CSC1_Foreign.
Viewing CSC Reports
|