Adaptive Planning and Consolidation Reports

• Beginning Balance Analysis - Ledger vs Translated for Translation Adjustments: This composite report compares ledger and translated beginning balances at the desired granularity for all or selected balance sheet ledger accounts after running roll-forward.

• Beginning Balance vs Prior Year Ending Balances: This Beginning Balance versus Prior Year Ending Balance report is meant to help compare the ledger year beginning balances against the prior year ending balances. This report can help prove that the year-end closing balances match next year's opening balance. If there’s any variance, you can make another copy of the report and have it repeat by company to view where there’s a discrepancy. This report should be run for the 1st period of the fiscal schedule.

• Cash Flow Support - Template: This template is meant to assist you in creating an indirect cash flow statement and support.

• Company Ownership - Template: Report template 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.

• Consolidated Other Comprehensive Income Analysis: We provide the Consolidated Equity Analysis - Template and Consolidated Other Comprehensive Income Analysis reports helping you verify the presentation of the consolidated equity results and review details of any out of balances.

• 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.

• 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.

• 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.

• Find Plan Lines: Accesses all Plan Entry Lines and returns 1 row per Budget Entry Line. Prompts you for worktags to filter the report results.

• FX Impacts on Opening Balances: We provide the FX Impacts on Opening Balance report which displays the comparison of the translated calculated activity for a period (ending balance minus beginning balance) to the translated actual activity to display the impacts of the change in foreign currency translation on beginning balances.

• Investments with Parents by Movement Code: 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.

• Journal Lines by Allocation: This indexed matrix report summarizes the number of journal lines and the translated debit and credit amounts generated by allocation definition and by company. This Journal Lines by Allocation report enables you to verify that each allocation result is within the performance guideline of 50K lines per allocation.

• Ledger Account Summaries and Hierarchies with Ranges: Displays the ledger account ranges and specific ledger accounts that are included with each ledger account summary. By default this process only returns the bottom level of the hierarchy, but at run time the user can select the option to display all hierarchies.

• Ledger Period Status by Company: Eases the period close process by providing enhanced reporting on a companies' ledger period status. This process enables financial users to quickly see which periods are closed or open and can enable them to review what activities have already been closed.

• Parent Company with Investments by Movement Code: 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.

• PLNC Consolidated Balance Sheet: We provide the PLNC Consolidated Balance Sheet to use to view and validate financial results. 

• PLNC Consolidated Equity Analysis: We provide the PLNC Consolidated Equity Analysis and Consolidated Other Comprehensive Income Analysis reports helping you verify the presentation of the consolidated equity results and review details of any out of balances.

• PLNC Consolidated Income Statement: We provide the PLNC Consolidated Income Statement to use to view and validate financial results. 

• PLNC Effective Dated Income Statement (Monthly): You can use this effective dated Income Statement report to take into account any organizational changes based on when the changes are effective within financial statements.

• PLNC Investment Analysis - Template: We provide the Investment Analysis and Investment Analysis with CTA Details reports helping you verify the presentation of your investment in subsidiaries and review details of any out of balances.

• PLNC Investment Analysis with CTA Details - Template: We provide the Investment Analysis and Investment Analysis with CTA Details reports helping you verify the presentation of your investment in subsidiaries and review details of any out of balances.

• PLNC Ledger Accounts by Hierarchy: Reports on each ledger account, displays the summary that includes it, and displays the hierarchies up to the top level.

• PLNC Ledger Account Summaries by Hierarchy: Report based on the Ledger Account Summary object that returns the account ranges associated with each summary and displays the hierarchies the summaries roll up into.

• PLNC Statement of Changes in Equity: We provide the PLNC Statement of Changes in Equity to use to view and validate financial results. 

• PLNC Actual Vs Budget - Template: We provide this report to compare actuals vs budget for the current period, current period quarter to date, and current period year to date. 

• PLNC Actual Vs Budget Eliminations - Template: We provide this report to compare posteliminated actuals vs budget.

• PLNC Actual Vs Budget - 12 Months Trending - Template: We provide this report to compare actuals vs budgets for a period and view the previous 12 months actuals.

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

This package is meant to be deployed as part of a Services Engagement for the Adaptive Planning and Consolidation SKU.

Below are the prerequisites for the reports to load successfully:

Alternatively, you can use the Tailored Loading for Object Transporter functionality to help map any of these instances to a target instance using the reference ID. Ensure that the configuration that's 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 reports. 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