Before you can add pay bands in Workleap Compensation, make sure you’ve completed the following setup steps:
Configure your job structure
Map your job titles
Configure your currencies
Create your pay zones
Once setup is complete, go to the main Navigation Menu and click Pay Bands.
You only need to set pay bands for Primary Pay Zones. Pay Bands in linked zones will auto-populate using your configured Pay Zone Multiplier.
Bulk import or edit pay bands
You can import or update pay bands in bulk using the built-in import tool.
Step 1: Export the pay band template
Click the Actions dropdown in the top right.
Select Export Bands to generate a pre-populated Excel template that includes fields like Pay Zone, Job Title, Job Level, and Job Track.
Step 2: Populate the template
Open the file in your preferred spreadsheet editor.
Fill in or update your pay band data.
Save the file as a CSV or Excel file.
Step 3: Import your completed file
Click Actions, then select Import Bands.
Upload your file by dragging it into the import window or selecting it manually.
Caution: If a required column isn't auto-mapped during the import, you'll be prompted to assign it manually.
Step 4: Review imported data
Use the built-in data editor to validate your import.
Columns with issues will be highlighted in red.
Click any cell with an error to view more details.
Tip: Use the Rows with issues tab to quickly find errors. Use Find and replace to make bulk updates in the editor.
Troubleshoot common import errors
Error Code | Definition | Solution |
Multi-column uniqueness error | Duplicate pay bands. | Ensure only one row exists per unique combination of Pay Zone + Job Function + Job Level + Job Track. |
External validation error | Value doesn't match your configuration. | Update your data to match existing configuration values. |
This cell must be filled | Required field is empty. | Complete all required fields before importing. |
Caution: To view all valid entries, click the Clean rows tab. Only clean and non-error rows will be imported.
Step 5: Finalize your import
Optional: Click Export to download a file showing all errors.
When ready, click the blue Import button at the bottom of the window to complete the upload.
Bulk remove or delete pay band components
To remove a value from a pay band:
Leave the applicable fields blank in your import file.
You can remove:
Base or Total Pay (Low, Target, High)
Bonus Target
Equity (Low, Target, High)
Manually create or edit pay bands
If preferred, you can manage pay bands manually in the platform.
Step 1: Enter edit mode
Click the Actions dropdown.
Select Edit Bands.
Note: If Edit Bands is grayed out, you may be viewing a linked zone, which inherits values from its Primary Pay Zone.
Step 2: Enter pay band values
Edit values for Low, Midpoint (Target), and High.
Set the Band Type as either Base or Total Pay (Base Pay + Variable Pay).
Note: Click Save Changes in the bottom left corner to apply your updates.
Manually remove or delete pay band components
To remove a value from a manually configured pay band, leave the following fields blank:
Base or Total Pay (Low, Target, High)
Bonus Target
Equity (Low, Target, High)