Company Ownership Details Reports
We deliver these report templates within the configuration catalog, and we recommend that you use this approach to migrate this into your tenant. Refer to the Configuration Catalog Guide for additional information on how to migrate this report from Customer Central to your tenant.
The Company Ownership - Template is a report template that can be used for creating comparisons against the company ownership details. This report pulls the percentages of ownership based on the net assets and net assets owned amounts. Example use cases for modifying this template are for prior 6-month comparisons or comparing hierarchy ownership percentages. These examples don't fit the WDSetup standards, so they aren't part of the configuration packages, but sample definitions of the hierarchy level and past 6 months reports are attached to this page for reference.
The Noncontrolling Interest Percent Calculated is a report to be used for comparison against the company ownership details. This report pulls the percentages of ownership and minority based on the net asset amount and noncontrolling interest amounts.
Characteristics
| Out of the Box? | You can modify this report template per the details listed below to make the desired output. | |
| Technology | Matrix Report Composite Report | |
| Functional Area | Financial Accounting | |
| WD Version | Tested on 2022R2 | |
| Complexity | Medium | |
| Prerequisites (also called out in the Configuration Package Description) | None | |
Customer Central Package
The Customer Central package listed above ties to the name of the Configuration Catalog package where the corresponding reports are located. Once loaded into your tenant, you can find the reports in the table below using a Report Tag that matches the Customer Central name or simply by searching for the custom report. The Prerequisites listed below are the security domains needed to be able to run the report. For more reports within the package, see RPT Consolidations.
| Custom Report | Data Source and Data Source Filter | Prerequisites |
| Company Ownership - Template | Journal Lines for Financial Reporting Journal Lines for Company and Reporting Time Period | Reports: Financial Accounting |
| Noncontrolling Interest Percent Calculated | Journal Lines for Financial Reporting Journal Lines for Company and Reporting Time Period | Reports: Financial Accounting |
Pattern
These report templates support one key pattern: Foundational.
We deliver these templates to give you a starting point for other reports. Review the templates to determine if this out-of-the-box version works for your company ownership reporting needs. If so, you can use the template to create minor changes to it or copy it for other reporting needs. The level of effort varies depending on the level of modifications needed.
Once you've successfully created or migrated the reports using Customer Central, you can follow the suggested setup steps listed below to update the report based on the desired report output:
Company Ownership - Template:
- Hide Data Columns to be left with only the calculation columns visible.
- Add details within the sub report for row grouping/drill-down per end user's requirements.
- Update the "Balance Sheet Ledger Accounts and Summaries" prompts for the following:
| Column | Value Type | Value |
| C2 Net Assets | Specify Value | Total Assets and Total Liabilities ledger account summaries (i.e Net Assets) |
| C3 Net Assets (Owned) | Specify Value | The Investment and Provision accounts from your Equity Pickup elimination rule |
Noncontrolling Interest Percent Calculated:
- Add details within the sub report for row grouping/drill-down per end user's requirements.
- Update the "Balance Sheet Ledger Accounts and Summaries" prompts for the following
| Column | Value Type | Value |
| C2 Net Assets | Specify Value | Total Assets and Total Liabilities ledger account summaries (i.e Net Assets) |
| C3 Noncontrolling Interest | Specify Value | NCI Offset Ledger Accounts from the Noncontrolling Interest Activity elimination rules |
Ownership at Each Hierarchy Level (SAMPLE)
- Filename
- Ownership_at_Each_Hierarchy_Level (SAMPLE).pdf
- Size
- 103 KB
- Format
- application/pdf
Ownership by Hierarchy (Past_6_months) (SAMPLE)
- Filename
- Ownership_by_Hierarchy_(Past_6_months) (SAMPLE).pdf
- Size
- 131 KB
- Format
- application/pdf
Company Ownership Template
- Filename
- Company_Ownership_-_Template_0.pdf
- Size
- 135 KB
- Format
- application/pdf
Noncontrolling Interest Percent Calculated
- Filename
- Noncontrolling_Interest_Percent_Calculated_0.pdf
- Size
- 136 KB
- Format
- application/pdf