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 Ratesreport.
- Currency Translation Adjustment Reconciliation by Companyreport, 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.
- Access theView Account Translation Rule Setreport.Review and note the account translation methods assigned to your ledger accounts.Security:Set Up: Currency Translationdomain in the Financial Accounting functional area.
- Access theCurrency Translation Adjustment Reconciliation by Companyreport.Review and note the results of translation by checking the:
- Ledger amounts.
- Translated amounts.
- Workday-calculated translation rates.
For rates that translate using theHistorictranslation 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 byAccounting Dateto assess the underlying journal lines.Security:Report Executiondomain in the Tenant Non-Configurable functional area. - Access theHistoric Currency Ratesreport.To verify that Workday calculated translation rates correctly, compare the calculated translation rates from theCurrency Translation Adjustment Reconciliation by Companyreport to the historic rates on this report.Security:Reports: Currency Ratesdomain in the Common Financial Management functional area.
- (Optional) When the calculated rates don’t match the historic currency rates, access theFind Journalsreport.To find translation adjustments that might have changed the calculated rates, search for journals without journal numbers.Security:Process: Journals - Reportingdomain in the Financial Accounting functional area.