Skip to main content
Administrator Guide
Last Updated: 2025-04-04
Steps: Audit Cumulative Translation Adjustments

Steps: Audit Cumulative Translation Adjustments

For audit purposes, you must verify that Workday has correctly calculated and reported cumulative translation adjustments (CTAs). To verify CTA calculations, you can use the:
  • Account translation rule set and associated account translation methods.
  • Historic Currency Rates
    report.
  • Currency Translation Adjustment Reconciliation by Company
    report, or another custom report that includes the ledger amount, translated amount, and calculated translation rate.
When the Workday-calculated translation rates don’t match the historic currency rates, you can check whether the calculated rates were changed by translation adjustments.
  1. Access the
    View Account Translation Rule Set
    report.
    Review and note the account translation methods assigned to your ledger accounts.
    Security:
    Set Up: Currency Translation
    domain in the Financial Accounting functional area.
  2. Access the
    Currency Translation Adjustment Reconciliation by Company
    report.
    Review and note the results of translation by checking the:
    • Ledger amounts.
    • Translated amounts.
    • Workday-calculated translation rates.
    For rates that translate using the
    Historic
    translation method, the calculated rates represent a blended rate based on the accounting date of each transaction and the posted rate for that day.
    To audit the rates, drill into the amounts and view by
    Accounting Date
    to assess the underlying journal lines.
    Security:
    Report Execution
    domain in the Tenant Non-Configurable functional area.
  3. Access the
    Historic Currency Rates
    report.
    To verify that Workday calculated translation rates correctly, compare the calculated translation rates from the
    Currency Translation Adjustment Reconciliation by Company
    report to the historic rates on this report.
    Security:
    Reports: Currency Rates
    domain in the Common Financial Management functional area.
  4. (Optional) When the calculated rates don’t match the historic currency rates, access the
    Find Journals
    report.
    To find translation adjustments that might have changed the calculated rates, search for journals without journal numbers.
    Security:
    Process: Journals - Reporting
    domain in the Financial Accounting functional area.