Developing Budgets for the Compensation Plan

Objective

After completing this lesson, you will be able to design a Budget.

Budgets

Budget can be defined as the money set aside to be used for different compensation components, such as merit, lump sum, adjustments or stocks. Budgets can be calculated per user, planner, group or template.

Budget and how it is calculated should be included in all Compensation component discussions.

Leading Practices

Note

The budget for the Stock sheet is displayed in units and not currency.

Only use a split budget if there is a driving business need (such as no sharing across countries) versus just a display issue. Splitting budgets can also impact aggregate reporting, making it appear "busy".

Budget proration should be consistent with type. For example, if merit is prorated, then prorate merit budget. If adjustment is not prorated, don’t prorate adjustment budget.

There are many different ways budgets can be configured depending on customer requirements. Commonly used is the Bottom Up budget in which a percentage of salary is summed up by employees across the organization.

Total budget amounts are displayed from the budget panel.

  • What is displayed depends on which sheet is active, as well as the configuration.

  • The boxes show assigned budget, total currently allocated, and amount remaining to be allocated.

Budget Settings Overview

Budget settings are divided into three parts:

  • Budget Calculation: refers to how budget amount is calculated per employee, template, group or planner.

  • Budget Rule: determines how the system behaves when recommendation exceeds budget.

  • Budget GroupBy: refers to separating budget panel by currency code or custom field. This is different from budgets based on group.

Additional information about budgets is found in the relevant sections of the SAP SuccessFactors Compensation Implementation Guide.

Considerations for Budget Configuration - remove

Budget and how it is calculated should be included in all Compensation component discussions.

Leading Practices

Only use a split budget if there is a driving business need (such as no sharing across countries) versus just a display issue. Splitting budgets can also impact aggregate reporting, making it appear "busy".

Budget proration should be consistent with type. For example, if merit is prorated, then prorate merit budget. If adjustment is not prorated, don’t prorate adjustment budget.

Budget Settings - remove

Additional information about budgets is found in the relevant sections of the SAP SuccessFactors Compensation Implementation Guide.

Budget Settings Overview

Budget settings are divided into three parts:

  • Budget Calculation: refers to how budget amount is calculated per employee, template, group or planner.

  • Budget Rule: determines how the system behaves when recommendation exceeds budget.

  • Budget GroupBy: refers to separating budget panel by currency code or custom field. This is different from budgets based on group.

Budget Calculations

Let’s look at how to configure different budget calculation options.

Selecting Add or Edit Budget Calculation opens a pop-up window that allows the setting of the different budget calculation options.

From this pop-up, you can select:

  • Mode

  • Use For

  • Components

  • Budget Value

  • Based On

  • Advanced options

  • Language

  • Budget Label

Edit Budget Calculation page displaying budget settings, components like merit or promotion, budget value, labels, and advanced options link.

Budget Calculation Options: Mode

The Mode determines the amount that will be used as budget base.

PercentofCurSal:

  • The system uses employee salary as the base amount.
  • This method is easiest to configure.

Percent of Target (Merit/Lumpsum/lumpsum2):

  • The budget base is an amount uploaded in the user data file.
  • Not used frequently; used by customers who would like the base amount to be different from salary.

PercentOfCustomField

  • The budget base is calculated from a custom field, typically using a lookup table.
  • Most flexible and yet hardest to configure.
  • Can only be used in the Salary tab.
  • Cannot be used for cascading budgets.

Direct Amount

  • Used for cascading budgets.
  • Used for Stock budgeting.
  • Budget amount can be updated using Update worksheet..
  • When used for cascading budgets, the budget amount is specified on the Budget Assignment page. Assign budgets to the top level of the cascading budget.
Manage Worksheets section under Plan Setup, highlighting the Budget Assignment option for managing budgets within employee worksheets.
Table displaying Head of Hierarchy, Total Eligible Base, and Cascading Budget with budget allocation in dollars and percentages.

Guideline:

  • The system uses the total of the calculated default guideline as base amount.
  • When this mode is used, basedOn field is ignored.
  • Typically used for Stock budgeting. May also work in a scenario where the client wants the worksheet to calculate the ideal recommendation and pre-populate that for all planners. Planners could then make alterations to the system recommendations.
Table presenting Formula Name, Rating, and ranges with columns for Min, Low, Default, High, and Max values.
Employee performance table showing names, budgets, stock options, and corresponding stock guidelines with recommendation columns for allocation tracking.

DeltaofCurSal

  • Budget base will be calculated from current salary plus or minus the amount indicated in Budget Value.
  • For example, budget value –5000, the merit budget will be total salary minus 5000 for each user.
  • Not commonly used.
Edit Budget Calculation screen showing mode selection, salary components, budget value, and the basis for budget allocation adjustments.
Employee budget data showing names, job titles, lump sums, merit percentages, current salaries, and total group allocation values.

Budget Calculation Options: Use For, Components

Use For is the worksheet tab where the budget will be displayed.

Components are the fields which get to spend the allocated budget.

You can include multiple standard fields or custom fields. However, you cannot combine standard and custom fields in one budget calculation. If customers have this requirement, create a new custom field that adds the required standard and custom fields, and use that new custom field as the budget component.

Edit Budget Calculation window showing PercentOfCurSal mode, components selection for salary budgeting, including Merit, Total Pay, and adjustments.

Budget Calculation Options: Budget Value, Based On

Budget Value – Depending on the mode selected, this can be a percentage or an amount. This is the value which the base amount will be multiplied with.

The Based On menu specifies how budget percentage will be determined:

  • User: The budget percentage is taken from the user data file. The value referenced in the importKey supersedes the number entered in the Budget Value box. Budget changes can be reflected automatically if the field is set to reloadable.
  • Group: The budget percentage is taken from group percentages created by the administrator. Number entered in Budget Value is ignored. Budget changes can be reflected on forms by using Update Worksheet.
  • Template: Budget Value entered will be used as budget percentage for entire plan. All worksheets generated from the template will have the same budget percentage. Changes on budget require launching of new forms.
  • Planner: The budget amount is granted to each compensation planner, using the Budget Assignment tool in Manage Worksheets.

Budget Calculation Options: Advanced Options

Supplementary budget configuration is available in Advanced Options.

  • Include Ineligible: Determine if ineligible employees should be included in the budget allocation.
  • Family Name: Used only for budgets where Group was selected from the Based On dropdown menu.
  • Prorating: Allows the budget to be prorated based on either date or percentages. Only applicable if basedOn is "user" or "template".
  • Hide Percentage: Hide the display of the budget percentage, showing only the budget amount.
  • Import Key: Imported field name containing the budget percentage to be used for basedOn=User.
  • Base Custom Field: Column id of the custom field containing budget value to be used for the PercentofCustomField mode.
  • Allocation Columns and the Use Final Payout for VP Budget fields: refer to SAP SuccessFactors Variable Pay.

Note

For more details, refer to the Set Up Proration section of the SAP SuccessFactors Compensation Implementation Guide.
Edit Budget Calculation menu with options like Include Ineligible, Prorating, Hide Percentage, Import Key, Base Custom Field, and Allocation Columns.

Budget Calculation Options: Language and Budget Labels

Column and row headers and language in the budget panel can be configured and relabeled in different sections of Compensation Home.

  • Column budget headers and language can be relabeled within Budget Calculation.Edit Budget Calculation with Budget Label field set to merit and language dropdown showing Default for customization options.
  • Row budget headers are relabeled within Design Worksheet.Design Worksheet interface configuring Budget Fields, showing Total and More to Allocate labels, with language-specific customization options available.

Configure Budget Calculations

Business Example

You need to modify the budget calculation.

Delete any test worksheets that are active at this point. The system won't allow any changes to the budget when there is an in-progress worksheet.

Steps

  1. Create a budget base for Adjustment.

    1. In the Design worksheet, create a custom formula with the following details:

      Form tab

      Salary

      Column Name

      Adjustment Budget

      Read-OnlyYes

      Column Type

      Money

      Formula

      if ((curRangePenetration<=10&&pmRating>=4),0.015, if((curRangePenetration<=10&&pmRating>2&&pmRating<4),0.005,0.00))*curSalary

      Other Options

      Reportable, Calculate Total

    2. Save.

    3. Take note of the column Id.

  2. Create a budget calculation for Adjustment.

    1. Navigate to Plan DetailsBudget.

    2. Select Take ActionEdit for the Adjustment budget.

    3. Select See advanced options

    4. In the Base Custom Field, enter the column Id used earlier.

    5. Click Save.

Budget Rules Configuration

A budget rule tells the system how to handle a budget that falls outside of the preconfigured amounts.

Budget Rules Configuration

Can be set to Allow, Warn or Disallow. Leading practice recommends setting a soft limit (warn) at planner level and use aggregate reporting to view at higher levels.

Budget rule configuration screen with options to add rules, allow exceed warnings, save on exceed, and customize warning messages.

groupBy

The budget panel typically displays total amounts in functional currency. However, a planner may have multiple employees paid in different currencies and displaying budgets on different currencies may be required. The groupBy function addresses this need.

This should not be confused with calculating budgets based on groups. groupBy is used for display purposes only and amounts can be displayed and grouped using the following:

  • Local currency code – the only standard salary field supported Budget configuration screen with options to add budget grouping, group by field, label, show total budget, and actions menu.
  • Read only, Reportable and String type Custom Salary field

  • In the example in the figure below, Lump Sum and Merit budgets amounts are segregated per currency.Budget allocation table displaying amounts across currency types (EUR, JPY, USD) with categorized totals for Lump Sum, Merit, and remaining allocations.

Budget Groups

Employee populations are sometimes segregated into groups for budget or guideline purposes. These groups are called budget groups or compensation groups.

Budgeting by Groups - Example

Consider the following use case: A company has a presence in multiple locations, and it follows a different budget strategy for each country.

  • The budget for the U.S. is 5%, for Canada is 6%, and for the UK it is 4%, and they have a manager who has employees across all locations. In such a scenario, the budget will need to be calculated by location and then added up to create the budget pool for that manager.
  • To simplify calculation, you can use compensation groups. Create one compensation group for each country:
    • All US-based employees will be grouped under the US compensation group

    • All Canadian employees will be grouped under the Canada compensation group

    • All UK-based employees will be grouped under the UK compensation group

  • These groups can also be used for guidelines.

Note

Creating families and groups for budget purposes is not the recommended approach. Consider using a custom field and lookup table to assign different percentages to different employee populations.

Adding a Group

Screenshot displays a Manage Families And Groups interface with options to create and manage compensation families, listing two groups.

Adding a group (overview):

  1. Navigate to Actions for all PlansGroup AssignmentsManage Families and Groups.

  2. Create a Family List or if a family is already available, create a group within the family. The family name will be referenced within the budget calculation page.

Add Employees to Group: Using Filters

Interface for assigning employees to groups, with filters for divisions, departments, locations, and dropdown to select target group.

One method of adding employees to groups is by using filters:

  1. Navigate to Group AssignmentsAssign Employees to Group.

  2. Select the desired employees using the Select and filter options. You can also assign employees one at a time by clicking Assign individual users to a group and searching for the individual employee.

  3. Indicate the name of the group you want the employees assigned to using Target Group.

  4. Click Assign to target group.

Add Employees to Group: Using CSV Files

Spreadsheet showing two columns: USERID and GROUP. USERIDs are categorized into two groups, US Comp and Canada Comp.

A second way to add employees to groups is by creating a simple CSV import file. The file should have two columns, as follows:

  • The first column is USERID which is the unique identifier for each user and must match exactly the USERID in your core user data file.

  • The second column is GROUP – that is the group name that you want to assign to the employees (this can be anything you like).

Note

All "like" values should be the same.

If you are using groups for guidelines, match the group names exactly to the group names expected in your guideline matrix.

Screenshot of Import Group Assignment tool for uploading group memberships into the system via file import with multiple options.

After the file is created, import it into the system.

  1. Navigate to Group AssignmentsImport Group Assignments.

  2. Browse to the file.

  3. Select the import options desired.

    Note

    You can update the existing groups by adding employees to the existing group assignments or you can replace all previous group assignments for all active users.

  4. Select Import Groups.

Interface for budget management showing assigned users, budget type, values, holdbacks, prorate options, and create budget functionality.

After group members are assigned, you can now:

  1. Create budget for the group.

  2. Enter the budget value and any holdback amount or percent.

  3. You can also apply proration as appropriate.

  4. Add budget calculation and use the group as appropriate.

    Budget settings configuration screen with options for mode, salary, components, budget value based on group, and family name selection.

Note

Budget Value on this page is ignored. The budget value created for the group will be used in the calculation.

Summary

  • Budget Definitions and Calculations: Budgets in compensation planning are designated funds for components like merit, lump sum, adjustments, or stocks. They can be calculated per user, planner, group, or template and should be a key consideration in all compensation discussions. Note that the Stock sheet displays budgets in units, not currency.

  • Best Practices for Budget Management: Use split budgets only if there is a substantial business rationale to avoid unnecessary complexity in reporting. Consistency in budget proration is crucial—if merit is prorated, the merit budget should be prorated likewise; if adjustments are not prorated, neither should their budgets be.

  • Budget Calculation Setup: Configure budget calculations through options like Mode (e.g., PercentofCurSal, Direct Amount), Use For, Components, and Budget Value, to tailor the budget base to specific compensation needs.

  • Budget Rules Configuration: Budget rules determine how the system handles budgets that exceed predefined amounts. They can be set to "Allow," "Warn," or "Disallow" exceeding budgets. It's recommended to use a soft limit ("Warn") at the planner level and utilize aggregate reporting for oversight at higher levels.

  • While compensation groups can simplify calculations by grouping employees by location or category, it's advisable to use custom fields and lookup tables for assigning different budget percentages to streamline and enhance flexibility in budget management.