Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Example: Map Aliases to Ledger Account Summaries in AP&C

Example: Map Aliases to Ledger Account Summaries in AP&C

This example illustrates how you can run a standard income statement and balance sheet in Adaptive Planning and Consolidation (AP&C).
As an accounting manager, you need to produce an income statement and balance sheet for an urgent board meeting. You decide to use and configure the Workday-delivered income statement and balance sheet by mapping Workday aliases to your ledger account summaries.
Ledger account summaries are specific to your Workday tenant and might be different from the values suggested here.
Security:
  • Access to the
    Aliases
     domain.
  • Appropriate ledger account segment security permissions to all journals, including the accounting and operational journals.
  • Reports: Financial Accounting
     domain in the Financial Accounting functional area.
  1. Access the
    Map Standard Aliases
     task.
  2. From the
    Business Object
     prompt, select
    Ledger Account Summary
    .
  3. Map these Workday-delivered aliases to your ledger account summaries:
    Field
    Value
    _BS_Current_Assets_Row1
    _BS_Current_Assets_Row2
    _BS_Current_Assets_Row3
    Map the ledger account summary you want to display in the first, second, and third rows of the Current Assets section for the Balance Sheet.
    Example:
    1: Corporate: Cash and Cash Equivalents
    2: Corporate: Receivables
    3: Corporate: Investments
    _BS_Current_Liabilities_Row1
    _BS_Current_Liabilities_Row2
    _BS_Current_Liabilities_Row3
    _BS_Current_Liabilities_Row4
    _BS_Current_Liabilities_Row5
    Map the ledger account summary you want to display in the first to fifth rows of the Current Liabilities section for the Balance Sheet.
    Example:
    1: Corporate: Accounts Payable
    2: Corporate: Notes Payables
    3: Corporate: Interest Payable
    4: Corporate: Customer Deposits
    5: Corporate: Short Term Loans
    _BS_Equity_Row1
    _BS_Equity_Row2
    _BS_Equity_Row3
    _BS_Equity_Row4
    _BS_Equity_Row5
    Map the ledger account summary you want to display in the first to fifth rows of the Equity section for the Balance Sheet.
    Example:
    1: Corporate: Capital Stock
    2: Corporate: Retained Earnings
    3: Corporate: Currency Translation Adjustments
    4: Corporate: Accumulated Other Comprehensive Income
    5: Corporate: Treasury Stock
    _BS_Noncurrent_Assets_Row1
    _BS_Noncurrent_Assets_Row2
    _BS_Noncurrent_Assets_Row3
    Map the ledger account summary you want to display in the first to third rows of the Noncurrent Assets section for the Balance Sheet.
    Example:
    1: Corporate: Property, Plant, and Equipment
    2: Corporate: Goodwill
    3: Corporate: Other Noncurrent Assets
    _BS_NonCurrent_Liabilities_Row1
    _BS_NonCurrent_Liabilities_Row2
    _BS_NonCurrent_Liabilities_Row3
    Map the ledger account summary you want to display in the first to third rows of the Noncurrent Liabilities section for the Balance Sheet.
    Example:
    1: Corporate: Long Term Debt
    2: Corporate: Deferred Revenue
    3: Corporate: Other Noncurrent Liabilities
    _IS_Expense_Row1
    _IS_Expense_Row2
    _IS_Expense_Row3
    _IS_Expense_Row4
    _IS_Expense_Row5
    _IS_Expense_Row6
    Map the ledger account summary you want to display in the first to sixth rows of the Expense section for the Income Statement.
    Example:
    1: Corporate: Salary and Benefits
    2: Corporate: Other Employee Related Expenses
    3: Corporate: Contingent Labor
    4: Corporate: Operating Expenses
    5: Corporate: Facilities Related Expenses
    6: Corporate: Misc. Expenses
    _IS_Other_Revenue_Expense_Row1
    _IS_Other_Revenue_Expense_Row2
    _IS_Other_Revenue_Expense_Row3
    Map the ledger account summary you want to display in the first to third rows of the Other Revenue or Expense section for the Income Statement.
    Example:
    1: Corporate: Interest Expense
    2: Corporate: Income Taxes
    3: Corporate: Other Income
    _IS_Revenue_Row1
    _IS_Revenue_Row2
    Map the ledger account summary you want to display in the first and second rows of the Revenue section for the Income Statement.
    Example:
    1: Corporate: Total Income
    2: Corporate: Operating Income
  4. Click
    OK
     and
    Done
    .
You can run the standard income statement and balance sheet.
When you select
Copy
 from the related actions menu of the income statement and balance sheet, Workday automatically creates custom financial reports. You can then edit the custom reports according to your company needs.