The compensation worksheet is where a planner (usually the manager) works on their direct reports’ overall compensation payout. This includes, but is not limited to, merit, promotion, and adjustment. The worksheet can be configured to show the budget, guidelines, and also the eligibility information to assist planners in the recommendation.

Note
Select Compensation on the Home dropdown menu. This opens up the My Forms page, from which you select the worksheet to view.
Worksheet Configuration Elements
The worksheet represents all the elements which are configured in the plan.
Planning Sheet tabs: Salary, Stock, Summary
Configured Budget calculation
Approval or Route Map steps
Form instructions
Currency Views enabled
Every configuration should be checked thoroughly against the worksheet to see if the behavior is as expected.
Note
There are some elements in the worksheet that can be displayed according to the user’s preference.
Local number format – Planners can change their number format by going to the Options→Compensation Number Format menu.

- Show/ Hide columns – Planners can choose to show or hide columns or a group of columns while planning. They can also apply filters. This is a sticky feature which will be applied every time the same worksheet is opened.

Advanced filtering capabilities can be created on worksheets for compensation, variable pay, and total compensation plans. You can have up to 30 criteria per filter spread across one or multiple conditions. The advanced filtering capabilities on the executive review are available on the worksheets.

The Salary Sheet
The Salary sheet is used to allocate salary increases for the planner’s group. The sheets are configurable but typical fields you see on a Salary sheet include:
Employee information
Current and final salary information
Merit guidelines
Lump sum
Additional employee information can be viewed from the worksheet, if enabled:
Compensation Profile
Continuous Performance Management (see note below)
Promote link (if Employee Central is integrated)
Compensation Statement (from completed forms)
Custom Views
Data Export: Executive Review and Hierarchy Based Approval (HBA)
Within the Compensation and Total Compensation Templates > Salary Tab, data can be exported from selected fields. This is available for both Executive Review and Hierarchy Based Approval. The exported file only includes the specific data to be viewed.

Note




















