Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Create Consolidated Supplemental Data

Create Consolidated Supplemental Data

  • Create a custom report for each Supplemental Data Template to return Supplemental Data Rows from Supplemental Data. See Create Custom Reports for Supplemental Schedules.
  • Security:
    • Process: Consolidated Supplemental Data
       domain in the Advanced Close and Consolidation functional area.
    • Worksheets
       - Provides access to Worksheets to create and manage workbooks and to control which users can export Workday data to a workbook.
You can access and report on supplemental data for a given template in a workbook using Worksheets Live Data capabilities. This enables you to aggregate and consolidate supplemental data in a single reporting view in a common reporting currency.
Once you create a workbook, Workday evaluates the
Process: Consolidated Supplemental Data
 domain and its contextual security to determine if a user can access a file and what permissions the user has. Example: View, Modify, and so on.
  1. Access the
    Create Consolidated Supplemental Data
     task.
  2. As you complete the task, consider:
    Option Description
    Company Hierarchy
    Select a company hierarchy.
    Supplemental Data Template
    Select the template for which you want to create a Consolidated Supplemental Data workbook.
    Companies in the hierarchy should have used this template to create Supplemental Data.
    Period
    Should be the same period for which you create Supplemental Data for a given Supplemental Data Template.
    Time Period
    Should be the same Time Period for which you create Supplemental Data for a given Supplemental Data Template.
    Name
    Enter a unique name for the Consolidated Supplemental Data workbook.
    You can only have 1 Consolidated Supplemental Data workbook in a
    Draft
     status at any given time.
  3. Click
    OK
    .
  4. On the
    Consolidated Supplemental Data Details
     page, click
    Workbook
    .
  5. On the Worksheet, click the cell where you want to add Live Data.
  6. Click
    Add Live Data
    .
    You can add multiple Live Data sets for each reporting currency.
  7. Select the custom report for the Supplemental Data Template you previously created.
  8. Click
    Next
    .
  9. Click
    Select All
     to include all available columns in the Worksheet.
    You can also select and move individual columns into the Worksheet.
  10. (Optional) Once you insert data from a Workday report into the workbook, complete these optional tasks:
    1. Perform Pivot functions to summarize detailed supplemental data and format data according to business reporting requirements.
    2. Add transaction data from Workday to tie out balances using the Worksheets Live Data Capabilities.
    3. Leave comments on cells or the entire workbook. Tag comments so others can receive a notification about your comment.
    4. Add additional sheets for supporting documentation.
    5. Download the workbook to a different format, such as XLSX, PDF, or HTML.
  11. Click
    Actions
     and then click
    Submit
     to initiate the
    Consolidated Supplemental Data Event
     business process to approve or deny the creation of Consolidated Supplemental Data.
    Once you approve the Consolidated Supplemental Data workbook, you can't make any further edits to the workbook.