Concept: Alternate Ledger Currency in Consolidated Financial Reporting
To report on an alternate ledger currency (ALC) in consolidated reports, you can configure ledger currency mappings for your companies. See Steps: Set Up Ledger Currency Mappings.
When you select a ledger currency mapping while running a consolidated report, Workday uses it to:
- Display ledgers for each company in either the primary or alternate ledger currency, as configured.
- Perform eliminations using either the primary or alternate ledger currency.
- Translate from either the primary or alternate ledger currency to the translation currency.
Workday doesn’t support ALC in noncontrolling interest (NCI) and equity pickup. NCI and equity pickup journals only generate results and journals for the primary ledger currency.
Before you begin including ALC in consolidated reports, consider:
- If your investment in subsidiary elimination rules are configured on theInvestment in Subsidiary / Subsidiary Equity (To Be Retired)tab on theMaintain Elimination Rulestask, you must move them to theIntercompany / Interworktagand theNoncontrolling Interest Activitytabs. See Workday Community: Guide to Updating the Investment in Subsidiary Elimination Rule.
- If you're using derived noncontrolling interest, you must opt-in to persisting noncontrolling interest on theNoncontrolling Interest Journal Lines Opt-Intask. See Steps: Set Up for Persisting Noncontrolling Interest.
Enabling the Ledger Currency Mapping Prompt
On these consolidated reports, Workday displays the
Ledger Currency Mapping
prompt by default:
- Audit Consolidation
- Intercompany Elimination Out of Balance Report
On these additional delivered reports, and any other custom consolidated reports that you create, you must first enable the
Ledger Currency Mapping
prompt:
- Balance Sheet - Consolidated
- Balance Sheet Retained Earnings Reconciliation
- Consolidated Trial Balance
- Income Statement Retained Earnings Reconciliation