Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Example: Create an Income Statement Composite Report

Example: Create an Income Statement Composite Report

You want to create an income statement that compares the actuals and plan data in Workday by referencing data from your matrix subreports. You want to interpret the variance by creating a column that calculates the difference between the data from the subreports.
  • Create actuals and plan subreports.
  • Security: These domains in the System functional area:
    • Custom Report Creation
    • Manage: All Custom Reports
  1. Access the
    Create Custom Report
     task.
  2. Enter
    Income Statement
     in the
    Report Name
     field.
  3. Select
    Composite
     from the
    Report Type
     prompt.
  4. On the
    Business Object Enabled for Filtering and Grouping
     grid, select
    Ledger Account
     from the
    Business Object
     prompt.
  5. Click
    OK
    .
  6. From the menu of column
    C1
    , select
    Define
    Control Field
    .
  7. Enter
    Ledger Account
     in the
    Column Name
     field.
  8. Click
    OK
    .
  9. From the menu of column
    C2
    , select
    Define
    Data
    .
  10. Enter
    Actuals
     in the
    Column Name
     field.
  11. Select
    [Subreport] Actuals
     from the
    Sub Report Name
     prompt.
  12. Click
    OK
    .
  13. From the menu of column
    C3
    , select
    Define
    Data
    .
  14. Enter
    Plan
     in the
    Column Name
     field.
  15. Select
    [Subreport] Plan
     from the
    Sub Report Name
     prompt.
  16. Click
    OK
    .
  17. From the menu of column
    C4
    , select
    Define
    Calculation
    .
  18. Enter
    Variance
     in the
    Column Name
     field.
  19. Select:
    Option Description
    Calculation Type
    Difference
    Column A
    C3 (Plan)
    Column B
    C2 (Actuals)
  20. Click
    OK
    .
  21. Click
    Run
    .
Workday displays an income statement that includes the actuals and plan data, including the variance for ledger accounts.