Consolidation Reports

1. Company Ownership - Template: 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. Last updated December 10, 2022.
2. Consolidated Trial Balance - Eliminations by Company: View a trial balance consolidated across companies and see the eliminations by company. The consolidated trial balance displays only the ending balance for each company. A company hierarchy enabled for consolidation is required. If the reporting currency is different from any of the company currencies, translation occurs and an account translation rule set is required. Last updated December 10, 2022.
3. CTA to be posted to Statistic Account: The CTA to be posted to the Statistic Account report calculates the CTA amount that needs to be posted to the statistic account for use in the Equity Pickup and Noncontrolling Interest elimination rules. 
4. Effective Dated Income Statement (Monthly) - Template: You can use this Income Statement Template to set up an effective dated report to take into account any organizational changes based on when the changes are effective within financial statements. Last updated December 10, 2022.
5. Effective Dated Trial Balance (Monthly) - Template: You can use this Trial Balance Template to set up an effective dated report to take into account any organizational changes based on when the changes are effective within financial statements. Last updated December 10, 2022.
6. Elimination Journal Lines: The Elimination Journal Lines report provides details on the journal lines that make up the elimination journal lines. With Eliminations being done in Financial Statements at the time of report run, no journals are generated in this process. This report can help provide details to auditors. We recommend that you only include the ledger accounts used within the elimination rules to best reflect the elimination entries. Last updated December 10, 2022.
7. Equity Analysis Reports: We provide the Consolidated Equity Analysis - Template and Consolidated Other Comprehensive Income Analysis reports to help you verify the presentation of the consolidated equity results and review details of any out of balances.
8. Intercompany Elimination Variances: The Intercompany Elimination Variances report is meant to help determine where there’s an out-of-balance amount from eliminations by breaking down the amounts from a company by the intercompany affiliate. It displays the company and intercompany affiliate elimination amounts based on the prompted company hierarchy, period, time period, and ledger account. Last updated December 10, 2022.
9. Investment Analysis Reports: We provide the Investment Analysis and Investment Analysis with CTA Details reports to help you verify the presentation of your investment in subsidiaries and review details of any out of balances.
10. Ledger Period Status by Company: Facilitates the period close process by providing enhanced reporting on a companies' ledger period status. This enables financial users to quickly see which periods are closed or open and can allow them to review what activities have already been closed.
11. NCI and Investment Details by Movement Code - Matrix: Enables you to analyze both the investment ledger account movement by providing visibility into how or why investment balances change over time and the ledger accounts movement of noncontrolling interest equity. Provides visibility into how or why NCI equity changed over time. Last updated December 10, 2022.
12. Noncontrolling Interest Percent Calculated: The Noncontrolling Interest % 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. Last updated December 10, 2022.
13. Unwanted Intercompany Affiliates Detail: The Unwanted Intercompany Affiliate Detail report is meant to help determine where there are intercompany affiliate tagging on P&L accounts that cause the intercompany affiliate to become present on Retained Earnings. The report requires that the ledger accounts used in the Intercompany Elimination Rules should be filtered out. This report can be used at the end of each year or before the roll-forward to create adjusting journals to remove the unwanted intercompany affiliate tagging. Last updated December 10, 2022.

Deployment of reports requires appropriate access to Object Transporter and your organization's Customer Central tenant. For information, read Implementation Tools.

These are prerequisites for the reports to load successfully:

Alternatively, the Tailored Loading for Object Transporter functionality can be used to help map any of these instances to a target instance using the reference ID. Ensure that the configuration that is being mapped is used in a similar manner. 

This content isn't included in your Workday Customer Support services offering, so they can't answer questions or resolve issues related to these dashboards. Instead:

• Find troubleshooting guidance on the Configuration Catalog Troubleshooting page.
• Document questions, issues, or defects associated with this content through the Ask a related question button at the bottom of this page.
• You can learn more with these resources:
  • Next Level: Getting Started with Customer Central
  • Implementation Tools – Customer Guide
  • WDSetup Release Notes