Role feature access: Report Library > Time & Attendance > Entitlements & Balances > Definable Rate Entitlement Liability Report
The Definable Rate Entitlement Liability Report is designed to be used in conjunction with the Definable Pay Rates feature in Pay Setup > Definable Pay Rates. The report calculates the dollar value of any employee balances, including any associated percentage factors, such as a loading. See Definable Pay Rates in the Dayforce Implementation Guide.
Although the report is intended for use with the Definable Pay Rates feature, you can still use this report to calculate the rates if they are not present. When configuring definable pay rates, each balance is mapped to a definable pay rate code. The linked code serves as the lookup value for the appropriate effective-dated record from the Employee Definable Pay Rates table. To use the report without the definable pay rates feature, see Use Report Without Definable Pay Rates.
| Field Name | Group by | Sort Order | Totals |
|---|---|---|---|
| Employee No | |||
| Employee Name | |||
| Location | |||
| Hire Date | |||
| Balance Name | |||
| Unit | |||
| Total Balance | |||
| Rate Source | |||
| Rate | |||
| Liability Value | |||
| Additional % | |||
| Total Liability |
Use Report Without Definable Pay Rates
When definable pay rates are not configured, you can manually enter an expression formula in the Employee Rate Conversion Formula field in the Pay Rates section in Pay Setup > Balances.
Otherwise, the report uses one of the following formulas depending on how the balance is stored in Dayforce:
| Balance unit | Formula |
|---|---|
| Balance stored in hours | Balance * Hourly Rate
|
| Balance stored in days |
If average daily earnings rate is not available, the application uses the following formula: |
| Balance stored in weeks |
If average weekly rate is not available, the application uses the following formula: |
You can also configure an additional loading to apply to the calculated balance liability, such as a leave loading rate or an oncost value. This value appears in the Additional % field in the report. You can enter a percentage in the Default Employee Pay Rates Percentage field in the Pay Rates section in Pay Setup > Balances. Note that this is not a formula field, but it requires a decimal value. When neither of these fields are configured, the report defaults to zero.