The Employee Salary Conversion report displays demographic details for employees along with their salary and rate information. When users run the report, they can select a currency to convert the Converted Salary and Converted Rate columns on the report to one common currency. They can also select an as of date to convert the amounts using the rate that was in effect on the selected date.
By default, the report displays employees who currently report to the user running the report. Change the Include my current employees only parameter False to see employees who historically reported to the user.
Note: The Include my current employees only option is only available if you have access to the Historical Employee Data feature in System Admin > Roles. If you don’t see this option when you run the report, the report will only include records for the employees you currently have access to, regardless of the time period.
Fields
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee | A to Z | ||
| Location | |||
| Job Assignment | |||
| Department | |||
| Pay Class | |||
| Pay Group | |||
| ISO Currency Code | |||
| Local Salary | |||
| Converted Salary | Sum | ||
| Local Rate | |||
| Converted Rate |
Custom Fields
Local Salary
The Local Salary custom field displays the employee base salaries in their local currency. It uses the following expression:
EmployeeEmploymentStatus.BaseSalary * EXCHANGERATE(EmployeeEmploymentStatus.ISOCurrencyCodeName, EmployeeEmploymentStatus.ISOCurrencyCodeName, @RateAsOfDate)
Converted Salary
The Converted Salary custom field displays employee salaries converted into the currency corresponding to the ISO code that the user selected when they ran the report.
EmployeeEmploymentStatus.BaseSalary * EXCHANGERATE(EmployeeEmploymentStatus.ISOCurrencyCodeName, @DestinationCurrency, @RateAsOfDate)
Local Rate
The Local Rate custom field displays employee base rates in their local currency.
EmployeeEmploymentStatus.BaseRate * EXCHANGERATE(EmployeeEmploymentStatus.ISOCurrencyCodeName , EmployeeEmploymentStatus.ISOCurrencyCodeName , @RateAsOfDate)
Converted Rate
The Converted Rate custom field displays employee base rates converted into the currency corresponding to the ISO code that the user selected when they ran the report.
EmployeeEmploymentStatus.BaseRate * EXCHANGERATE(EmployeeEmploymentStatus.ISOCurrencyCodeName , EmployeeEmploymentStatus.ISOCurrencyCodeName , @RateAsOfDate)
Filters
The template includes the following filters:
Note: The Destination Currency parameter is configured to allow selection of a single currency. If you edit this report template, it's recommended that you don’t change the Destination Currency parameter to allow multiple selections. If a user selects multiple currencies, Dayforce only converts to the first one selected and ignores the others. Also, the report output doesn't display a currency symbol on the converted amounts. Allowing multiple selections could therefore cause confusion for users running the report.