Managing Compensation Worksheets

Objective

After completing this lesson, you will be able to create and manage Compensation worksheets.

Worksheet Creation Main Concepts

A Compensation Worksheet is the actual planning sheet that the planner uses to determine and enter compensation recommendations. Worksheets are generated from the Compensation Plan. When worksheets are launched a new compensation cycle begins.

Testing

Throughout the configuration of the Compensation Plan, admins should create and delete worksheets multiple times to verify that the plan is correct.

Managing Worksheets

The Manage Worksheets offer two choices: Create Worksheet and Manage Worksheet.

Create Worksheet (also known as launching) mass generates worksheets based on the compensation planners, by groups, or by route steps. Once forms are launched, the relevant forms display in the My Forms Inbox when a manager chooses the Compensation tab.

Launch Forms Based on Planner

  1. Navigate to Manage Worksheets and select Create Worksheets.
  2. Enter a unique worksheet name.
  3. Select Start/End dates (typically the Plan Period).
  4. Select Due Date.
  5. Select the top-level manager/planner (you must use the Find Employee button OR type the planner’s username). Forms will then be created for that manager and all the planners in that hierarchy.
  6. Select the appropriate check boxes.
    • Include Inactive Users – If users are inactive in the UDF, but need to be on the worksheet, check this box.
    • Create worksheet for Head of Planning only – Creates a single worksheet for the specified planner instead of creating forms for the hierarchy. Used mostly in testing scenarios to reduce form creation time.
    • Send Email Notifications – If selected, planners are notified that forms are ready for review and select Launch Plan.

To include a CEO in compensation planning create a user representing the Board of Directors as the top of the hierarchy.

Manage WorksheetsOnce worksheets are launched, the Manage Worksheets interface provides a way for administrators to delete forms and to export them in either MS Excel format or in a .csv format. A filter option is available to drill down on your search.

The ability to delete forms is useful for testing. Forms can be created and deleted at will. Deleted forms can be automatically purged based on number of days it has been deleted. Administrators can set the purging age in Actions for All PlansCompany Settings. Setting this option can help improve Executive Review loading performance.

Note

There are two other purging tools available for Compensation and Variable Pay: Data Retention Management (DRM) and Data Retention Time Management (DRTM), the latter which allows for different data retention times for different countries. To know more about purging settings for Compensation and Variable Pay, visit the SAP Help Portal for DRM and DRTM guides.

Update WorksheetsUpdating Compensation Forms refreshes the worksheet data. Since individual compensation forms are updated only when opened and saved, this function is recommended after an import of employee data, when there are changes in employee data, budget data, and goal information, before a data export and when performance review ratings are integral to the compensation planning process. You can update all worksheets or a single form.

Caution

Newly eligible employees are also available to be updated into currently open worksheets, not new hires only.

Updating new hires or newly eligible employees to the compensation worksheet.

Employee Form MembershipAll organizations are dynamic: employees come and go. They are hired, retire, get promoted, resign, and change positions. Admins can add members who have joined the organization, move members to new managers and compensation planners, and delete members who have left the organization. SAP SuccessFactors Compensation has three separate tools: Add Members, Move Members, and Delete Members.

Add Members to Forms

To add a member, the employee must be in the SAP SuccessFactors database. Find the person, select the appropriate template and a drop-down list of planners using the template is populated. Select the correct form, decide whether to send email, and select the Add button.

Move Members Between Forms

The Move Members Between Forms option works in the same way. In the tool, select the Compensation Template from the drop-down menu. Then select the compensation form that the member is currently on (Source Form), select the compensation form to which the member is moving (Target Form), choose the member(s) to move, select the email notifications desired, and select Move.

Delete Members

Deleting members is similar. In the Delete Member from Forms tool select the Compensation Template, select the Compensation form, choose the member to delete, choose whether to delete budget and if email notification is to be sent, and select the Delete button.

After forms are created and cascaded, planners will then need to enter their recommendation on the worksheet. The planner’s recommendation is guided by the range parameters (guidelines) set up by the administrators.

The Merit and Extra (Adjustment) and Promotion fields are salary impacting; the amount of recommendation is added to the base salary (Final Salary). Lump sum is one-time cash payout that is non-salary impacting. A recommended amount gets added to the total pay.

Recommendation StageAfter recommendations have been entered, planners/approvers can move the worksheet to the next step of the route map. This step can be found at the top or bottom of the worksheet.

Note

Planners use the worksheet once a year for two weeks and considering there are new features each year and tons of information on the worksheet, it can become challenging. A guided simulation of the worksheets and its elements can be created by using SAP Enable Now. To know more about it, talk to your customer advocate or visit the SAP Help Portal for the SAP Enable Now implementation guide.

Once the worksheet has been submitted and approved by the last user in the route map, it is considered a completed form. These forms can still be reviewed within CompensationFormsCompleted.

Administrators may also take advantage of a deep link to provide a shortcut to these forms. You can add the deep link to email communications or custom home page tiles. An example would be: your-instance.com/sf/completed-comp/forms.

Management of Dynamic Groups

Some organizations may have a need to launch forms to employees within a hierarchy at different points in the year.

Example:

  • UK merit planning takes place in March; Netherlands merit planning takes place in April.
  • Planners with teams in both countries will receive one worksheet with UK employees, and then another for Netherlands employees.

To enable this feature, Role-Based Permission must be turned on. Administrators have permission to manage Dynamic groups.

  1. Navigate to Admin CenterUpdate User InformationManage Employee Groups to create dynamic groups of employees.
  2. Create Employee Groups, based on necessary criteria. These groups work similarly to dynamic Permission Groups in RBP.
    • Select Create Group.
    • Select a category from the People Pool and the associated parameters for that category.
    • Select Update to view the members of the group.
    • Exclude any members from the group as needed.
    • Click Done.
  3. Navigate to the desired Program SettingsAdvanced Settings.
  4. Select Do not duplicate employees on worksheets and Create worksheets by employee.
    • The Do not duplicate option prevents users from being moved around on forms if their membership in a group changes.
    • The Create by employee group option will be grayed out if any forms have already been created. Delete worksheets to enable this option.
  5. Click Update Form Template.
  6. Launch Forms.
  7. Use the same process to launch as previously described.
  8. View the new option, Select a Group of Employees, that displays.
  9. Choose the group of employees to be included on the forms.
    • Planners will receive forms in their inbox with only those employees in the selected group.
    • Head of Planning can also be selected, to narrow down the Planners who should receive forms for the selected group of employees.

Remember, employee groups are dynamic, so in this example, if an employee changes location, they will automatically move to the employee group of that locations. If the Do not duplicate option is selected in Advanced Settings, the employee will not be moved between forms.

Application of Data Updates

When planners open a worksheet, it will reload various data fields from source data. The Apply Data Updates simulates the process of opening a form, where fields are updated dynamically. This functionality is useful when multiple forms need to be updated, but it is unlikely that users will open the forms. Options for Applying Data Updates include:

New Hires:

Updates compensation forms to include new users on a previously launched compensation form.

Manager Hierarchy Changes:

  • Move employee's compensation data from old manager to current manager.– This setting will only work if the new manager already has an existing compensation worksheet.
  • Create Worksheet for new manager(s) – A manager is treated as a new manager if they meet the following condition:
    • This manager is in user hierarchy of specified head of compensation planning and/or is manager of employees in specified dynamic group.
    • This manager doesn't have a worksheet created yet.

This manager will have a worksheet created if any of the following are met:

  • This manager has at least one compensation eligible employee. If all of their employees are compensation ineligible, no worksheet will be created.
  • If the option, Move employee's compensation data from old manager to current manager, is not checked, then only employees under the new manager not in any existing worksheet will be in the created worksheet. Employees already in existing worksheets will still be in those worksheets.

Inactive Employees or Planners:

  • Remove Inactive employee from Compensation Worksheets – Removes inactive (terminated) employees from in-progress compensation forms.
  • Remove Inactive planner’s Compensation Worksheets – Deletes compensation forms when a planner is inactivated (terminated). Be careful: This action will delete the planner’s entire form, even if there are still users on the form. Make sure you first move the employees to a new form before deleting inactive planner forms.

Changes in Eligibility:

  • Update compensation worksheet to reflect employee’s eligibility changes (if any).
  • Rules already set up through the Compensation Template's Eligibility Rules Engine. Apply those to the Compensation Worksheets as well.

Update Budget:

  • Compensation form budgets can be configured to re-calculate the budget amounts when employees are added or moved between compensation worksheets.

Synchronize Bonus Data with PM Form:

Applies to configurations that utilize the Bonus tab (MBO) tab. When Compensation forms are opened or updated, they will synchronize certain Bonus data from the PM form, such as Goal Ratings or Weights. However, by default, Bonus changes such as an addition or removal of a goal will not be synchronized. Use this option to include add/remove of goals to the Update Compensation Forms process.

Caution

Simple bonus planning can be accommodated by using Lump sum in the Salary tab or by using SAP SuccessFactors Variable Pay.

Apply to Completed Forms:

  • If this option is selected, the Apply Data Updates process will also affect Completed forms. This option and Executive Edit are the only two ways by which Completed forms can be modified. Use this option with extreme caution.

Caution

Use this function carefully! Make sure you understand how the update will affect fields in the database. There is no easy way to undo the function.

Manage Worksheets

Business Example

Create a worksheet to test if the configurations in the previous exercises are visible on the form.

Steps

  1. Log in as the admin in SAP SuccessFactors.

  2. Navigate to Compensation Home by using Action Search.

  3. On the left panel, choose the 20xx compensation plan.

  4. Go to Manage WorksheetsCreate Worksheets.

  5. In worksheet name, enter Test 1.

  6. In Start Date, enter today’s date.

  7. In End Date, enter today’s date.

  8. In Due Date, enter today’s date.

  9. In Head of Compensation Planning, enter cgrant.

  10. Check the box, Create for Head of Planning only.

  11. Select Launch Plan.

  12. Select Continue.

  13. Select the Monitor Compensation Jobs link on the notification bar.

  14. Select Download Status to check if worksheet was created successfully.

  15. If a worksheet was created, go to account menu and select Proxy Now.

  16. Enter Carla Grant as target user name

  17. Select Ok.

  18. In the home menu, select Compensation.

  19. Open the new worksheet.

  20. Verify if the changes made to the plan is visible: 

    • Is Program Level field visible?
    • Does Program Level field propagated with Tier 1/Tier 2 values?
    • Does the amount allocated for Merit + Lumpsum reflect 3%?
    • Are the employees with less than 2 Rating (Needs improvement) grayed out for Merit and Lumpsum?
    • Can you see the Lumpsum guidelines?
    • Open Marcus Hoff’s profile. Do you see the compensation history?

Result

This completes the exercise.

Summary

  • A Compensation Worksheet is the planning sheet that planners use to enter and determine compensation recommendations.
  • Some organizations may have a need to launch forms to employees within a hierarchy at different points in the year. To enable this feature, Role-Based Permission must be turned on. Administrators have permission to manage Dynamic groups.
  • When a planner opens a worksheet, the system reloads data fields from their source. The "Apply Data Updates" process simulates opening the form, updating fields dynamically.