Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Example: Composite Income Statement Report in AP&C

Example: Composite Income Statement Report in AP&C

This example illustrates how you can create a custom report in Adaptive Planning and Consolidation (AP&C) that displays a detailed income statement. Composite reporting uses matrix report types as sub reports to enable you to combine data into 1 report. Use financial-specific report data sources (RDS) to define the
primary business object's
 row and column:
  • Types.
  • Groupings.
  • Calculations.
As a company accountant, you need an actuals income statement with configurable rows and columns that:
  • Lists the amounts for Current Period Year-to-date.
  • Lists the Last Year Current Period Year-to-date.
  • Calculates net income or loss.
  • Displays certain expenses in detail.
  • Displays revenue in summary.
Filters and data are specific to your Workday tenant and might be different than the values suggested in this example. Use the information as a guide.
  • Have the appropriate security permissions:
    • For ledger account segments.
    • To all journals, including accounting and operational journals.
  • Create a basic matrix report consisting of the ledger accounts and activity for each cost center. To provide source data into your Composite Report Income Statement, use the report as a sub report. Use:
    • Journal Lines for Financial Reporting
      as the data source.
    • One of these data source filters:
      • Journal Lines for Company and Reporting Time Period
        .
      • Journal Lines for Organization and Reporting Time Period
        .
    Define the report to include:
    • Default prompts for company.
    • Amount type.
    • Ledger.
    • Period and time period.
  1. Access the
    Create Custom Report
     task.
  2. Enter:
    Field
    Value
    Report Name
    A unique name for your composite report income statement
    Report Type
    Composite
  3. Click
    OK
    .
  4. From the available action menu of column
    C1
    , select
    Define
    Control Field
    .
  5. Enter:
    Field
    Value
    Column Name
    Ledger Account
    Business Object
    Ledger Account
  6. Click
    OK
    .
  7. From the available actions menu of column
    C2
    , select
    Define
    Data
    .
  8. Enter:
    Field
    Value
    Column Name
    Current YTD
    Sub report
    Select the basic matrix sub report for journal lines you previously created. Workday populates the
    Map Sub Report Prompts
     grid with prompt values you defined in the sub report.
  9. In the
    Map Sub Report Prompts
    grid, enter:
    Prompt field
    Value Type
    Value
    Company
    Specify Value
    Select your company
    Amount type
    Specify Value
    Activity
    Period
    Specify Value
    Period (Example: 2013 - Mar)
    Time period
    Specify Value
    Current period YTD
  10. Select
    Field to Aggregate
    Amount
    .
  11. In the
    Style
     field, select
    Workday Styles
    Default
    .
  12. Click
    OK
    .
  13. From available actions menu of column
    C3
    , select
    Define
    Data
    .
  14. Enter:
    Field
    Value
    Column Name
    Prior YTD
    Sub report
    Select the basic matrix sub report for journal lines you previously created. Workday populates the
    Map Sub Report Prompts
     grid with prompt values you defined in the sub report.
  15. In the
    Map Sub Report Prompts
    grid, enter:
    Prompt Field
    Value Type
    Value
    Company
    Specify Value
    Name of your company
    Amount type
    Specify Value
    Activity
    Period
    Specify Value
    Period (Example: 2013 - Mar)
    Time period
    Specify Value
    Current period YTD
  16. Select
    Field to Aggregate
    Amount
    .
  17. In the Style field, select
    Workday Styles
    Default
    .
  18. Click
    OK
    .
  19. From the available actions menu of row
    R1
    , select
    Define
    Lookup Data
    .
  20. Enter:
    Field
    Value
    Row Name
    Revenue
    Row Label Override
    Revenue
  21. In the
    Filter Data in Sub Report
    grid, enter:
    Field
    Detailed Instances to Include
    Ledger Account
    • 4000: Revenue
    • 4500: Other Income
    • 4900: Sales Discounts
    • 4999: Management Fee Revenue
  22. In the
    Outline Options
     section, select
    Options
    Reverse the Sign
    .
  23. Click
    OK
    .
  24. From the available actions menu of row
    R2
    , select
    Define
    Lookup Data
    .
  25. Enter:
    Field
    Value
    Row Name
    Cost of Sales
    Row Label Override
    Cost of Sales
  26. In the
    Filter Data in Sub Report
     grid, enter:
    Field
    Detailed Instances to Include
    Ledger Account
    • 5000: Cost of Sales
    • 5100: Billable Travel Expenses
    • 5900: Purchase Discounts
  27. Click
    OK
    .
  28. From the available actions menu of row
    R3
    , select
    Define
    Calculation
    .
  29. Enter:
    Field
    Value
    Row Name
    Gross Profit
    Calculation Type
    Sum
    Rows
    • Revenue
    • Cost of Sales
  30. In the
    Outline Options
     section, select
    Options
    Reverse the Sign
    .
  31. Click
    OK
    .
  32. From the available actions menu of row
    R4
    , select
    Define
    Empty
    .
  33. Enter:
    Field
    Value
    Row Name
    Empty Row 1
  34. Click
    OK
    .
  35. Starting with row
    R5
    , add these values:
    Reference
    Name/Override
    Row Type
    Calculation
    Options
    Ledger Account > Detailed Instances to Include
    R5
    Salaries & Benefits
    Look Up Data
    • 6000: Salaries & Wages
    • 6010: Benefits Expenses
    • 6020: Employer Paid Taxes
    • 6030: Retirement
    • 6040: Bonus - Quarterly
    R6
    Legal Service & Fees
    Look Up Data
    6400: Legal & Service Fees
    R7
    Contingent Labor
    Look Up Data
    6600: Contingent Labor Expense
    R8
    Employee-Related Expense
    Look Up Data
    • 6850: Staff Meeting Food
    • 6860: Employee Expense
    R9
    Travel & Entertainment
    Look Up Data
    6800: Travel & Entertainment
    R10
    Marketing
    Look Up Data
    6200: Marketing
    R11
    Facilities & Rent
    Look Up Data
    • 6100: Facilities
    • 6300: Office & Administrative
    • 7200: Utilities
    R12
    IT Expense
    Look Up Data
    • 6500: Information Technology
    • 6700: Depreciation
    • 7500: Repairs & Maintenance
    R13
    Amortization
    Look Up Data
    6790: Amortization Expense
    R14
    Miscellaneous Expense
    Look Up Data
    • 6900: Insurance
    • 7300: Taxes & Licenses
    • 7310: Postage Expense
    • 7400: Spend
    • 7800: Bad Debt
    • 7900: Other Expenses
    • 7999: Other Direct Costs
    R15
    Total Operating Expense
    Calculation
    Sum Range
    Starting Row
    • R5 (Salaries & Benefits)
    Ending Row
    • R14 (Miscellaneous Expense)
    R16
    Empty Row 2
    Empty
    R17
    Other Income & Expenses
    Look Up Data
    • 8000: Interest Income
    • 8100: Interest Expenses
    • 8200: Impairment Expense
    • 8300: Motor Pool Allocation
    • 8500: Telecommunications Allocation
    • 9000: Gain/Loss on Sale of Assets
    R18
    Income Taxes
    Look Up Data
    8900: Income Taxes
    R19
    Net Income
    Calculation
    Sum
    Rows:
    • R3 (Gross Profit)
    • R15 (Total Operating Expense)
    • R17 (Other Income/Expenses)
    • R18 (Income Taxes)
    Reverse the Sign
  36. Click the
    Run
     or
    Preview
     button to view the report.
The matrix report RDS accesses the journal line as its primary object. The income statement definition:
  • Uses Reporting Time Periods as relative time spans.
  • Includes journal lines that are in
    Posted
     or
    Pro Forma
     status.
  • Excludes journals that are
    Canceled
    , in
    Error
    , or in
    Draft
     status.
Depending on which fields you designated as drillable on the matrix sub report, some of the detailed data for column and row groups you can view include:
  • Company.
  • Cost Center.
  • Ledger Account.
  • Revenue Category.
  • Region.
  • Spend Category.
You can:
  • Share the report definition with organization members that have the appropriate security level.
  • Produce the report output in table format.
  • Use your income statement as the basis for other composite financial reports.