Before You Begin: If the worksheet includes hourly employees, Dayforce calculates and shows values for these employees based on their annualized salary. See How Salary Is Calculated for Hourly Employees.
When you open your worksheet, Dayforce shows a budget summary section in the top-left corner, which provides information about your total and remaining budgets for each pay component in the compensation cycle.
You can allocate a portion of this assigned budget to each employee in the associated pay component columns in the employee list section of the worksheet.
You can allocate your budget manually by entering values in the editable fields for each employee, or you can click the Auto-Allocate button in the toolstrip to distribute the budget automatically. You can auto-allocate the budget to the entire employee list or the filtered list in the worksheet. See Auto-Allocate Budget.
Note: You might be asked to provide a justification if you allocate outside of a pay component’s guideline. See Justify Budget Allocations.
Depending on configuration, your worksheet might include the following columns:
| Column | Description |
|---|---|
|
% Amount Hourly Rate Increase |
Before You Begin: If the pay component uses a flat amount guideline (that is, one based on amounts rather than percentages), the % column doesn’t show. This functionality is because you can't allocate a percentage for pay components that use flat amount guidelines. The % and Amount columns are generally included for both bonuses and salary increases. If the compensation cycle includes one or more employees with the Hourly pay type, the Hourly Rate Increase column also shows for each salary increase pay component:
To allocate in the worksheet, do one of the following:
When you enter a value in the %, Amount, or Hourly Rate Increase fields, Dayforce automatically populates the corresponding value in the other columns. For example, if you enter 4 in the % field, Dayforce calculates what 4% of the employee’s annual salary is and shows that value in the Amount field. Similarly, if you enter a value in the Amount field, Dayforce calculates that amount as a percentage of the annual salary and shows that value in the % field. Depending on configuration, the worksheet might include the Lump Sum column in which some or all of the allocated percentage amount might be populated automatically. See Lump Sum. If you configured rounding rules for equity pay components in the compensation cycle, when you auto-allocate budget, the % and Amount columns of the worksheet show values based on the configured rounding rule. Note: Dayforce shows an information icon ( |
|
Bonus Factors |
If a pay component is configured to use bonus factors, Dayforce shows additional columns for bonus factor information in the worksheet (such as the assigned weight and allocation guidelines). If a bonus factor is configured to allow editing, the Payout Factor and Total Payout columns are editable and you can adjust the associated values:
Note: Whether a bonus factor is editable is determined by the Allow Edit checkbox in the Pay Components tab of Compensation Setup > Compensation Cycles. |
|
Funding |
If a pay component was configured to apply target bonuses and funding for budget calculations, Dayforce shows a Funding column in the worksheet. This column shows the portion of the employee's total target bonus that is used to fund target bonus payouts. The funding is shown as a percentage and as an amount in the Funding columns and when you click the information icon in the Payout Factor column for the pay component, the funding percentage is shown as part of the payout calculation:
|
|
If a salary increase pay component was configured to allow lump sum allocations, Dayforce shows a Lump Sum column in the worksheet. When you allocate using the % field, Dayforce automatically populates any amount above the employee's pay grade in the Lump Sum field. Managers can override the lump sum calculation to allocate above the employee's pay grade by entering the allocation value in the Amount field. This amount is still subject to validation and shows either an error message or warning message depending on the Restrict Out Of Grade setting for the associated pay grade in Org Setup > Jobs and Job Assignments. |
|
|
Proration Factor |
If a pay component was configured to use proration rules for allocations, Dayforce shows a Proration Factor column in the worksheet. This column shows the proration factor for each employee, and an information icon that you can click to view the calculations used to determine that proration factor:
This proration factor is applied to the employee's salary for allocation calculations in the worksheet. For example, an employee with a current salary of $45,000.00, and a proration factor of 16%, would have a prorated salary of $7,200 ($45,000 x 0.16 = $7,200). Based on this prorated salary, an allocation of 28.83% would give them an increase of $2,075.76 ($7,200 x 0.2883 = $2,075.76):
|
) between the two columns to indicate that they’re dependent on one another. When you click the information icon, Allocating for Cycles with Multiple Currencies
By default, the values in the employee list of the worksheet are shown in each employee’s local currency and you allocate to each employee in that currency. When you enter a value in the Amount, Hourly Rate Increase, or any other amount-based field, Dayforce shows the currency code next to the value to indicate that the allocation is in that currency, rather than the cycle currency:
If you enter a value in the % field, the corresponding amount is automatically shown in the employee’s local currency.
Similarly, using the auto-allocate budget option automatically populates the allocated value in the employee's local currency.
If you’d prefer to allocate to employees using a single currency, you can clear the Show Employee Local Currency in Worksheet checkbox in the Currency drop-down list. This converts all monetary values to the currency that you selected for the worksheet, allowing you to view and allocate in that currency, rather than in each employee’s local currency.