Compensation Plans in Compensation Worksheets

Compensation Guide

Version
R2025.2.1
ft:lastPublication
2025-11-11T03:27:54.128691
Compensation Plans in Compensation Worksheets

In compensation worksheets, Dayforce shows compensation plan details for bonus pay components that were configured to calculate bonuses based on the compensation plan assigned to the compensation cycle. See Compensation Plans for Compensation Cycles.

Worksheet showing the compensation plan details and the Total Payout values.

Based on the effective date records configured for the assigned compensation plan, the following plan details are shown in the worksheet for employees who are eligible for a bonus in the payout period after the compensation cycle is published:

  • Compensation plan name
  • Bonus eligible salary
  • Target bonus
  • Proration factor
  • Bonus factors
    • Name
    • Weight
    • Guideline
    • Bonus Pay
    • Total Payout
  • Total bonus payout for the compensation plan

Note: These values show only for employees who are eligible for bonuses during the plan payout period.

Dayforce shows an information icon () next to each of the calculated values in the worksheet. Click the icon and Dayforce opens a tooltip with the calculation details.

The values in the Bonus Pay column can’t be edited for bonus factors based on metrics. However, you can update the bonus pay values by importing new values in the Metrics Data tab of Compensation Setup > Compensation Metrics. This import can be done even after the compensation cycle is published. See Update Bonus Factors. For bonus factors based on direct values, you can edit the bonus pay values that are configured to allow editing.

If the compensation plan in the payout period is configured to use Percentage of Total Pay as the target payout, the worksheet shows an information icon in the Bonus Eligible Salaries column, which contains the calculations based on the applicable earning codes.

If the compensation plan in the payout period is configured to use Amount as the target payout, the worksheet won't show the Bonus Eligible Salary column, and a percentage value in the Target Bonus, and Total Payout columns.

If the Apply Target Bonus and Apply Funding checkboxes were selected for a plan-based or target bonus-based pay component in the Budget Calculations section in the Pay Components tab of Compensation Setup > Compensation Cycles, the worksheet shows the Funding column:

Worksheet showing the funding values to calculate the total payout for the compensation plan.

If the compensation plan for the payout period uses the Custom calculation type to determine bonus payouts:

  • When you click the information icon in the Total Payout column for an employee, you can view the custom expression, and the values used to calculate the bonus payout. The calculation includes the formula, input values, and the resulting payout. This information shows in both the manager and single worksheets.
  • The total bonus payout automatically updates as you change the worksheet values. However, the information icon shows the last saved calculation. Save the worksheet to view the latest results.
  • The custom expression uses the worksheet’s currency. If you change the currency, the expression uses the new currency.
  • If the expression results in a valid numeric value (for example, 1000 or 500.75), that value shows as the employee’s bonus payout.
  • If the expression results in a non-numeric or invalid value (for example, null or string), the payout cell remains blank.
  • If an expression error occurs, the payout cell shows in red, the information icon is hidden, and a tooltip shows the error message.