Before adding pay bands, you will first need to set up the following:
Congratulations! You’re now ready to set up your Pay Bands in Barley!
Click the main Navigation Menu, and then click Pay Bands.
Bulk Pay Band Imports & Edits
Whether you're just getting started and want to import your pay bands or edit your existing pay bands, Barley supports doing so in bulk.
Step 1:
Click the Actions drop-down menu in the top right, and then click the Export Bands button to generate an Excel template pre-populated with your Barley data. This will ensure that the template you will use to import your pay bands is already pre-populated with the correct required fields (Pay Zone, Job Title, etc.).
Step 2:
In a spreadsheet editor of your choosing, populate your pay band data into the template you downloaded. Once you have made all necessary edits, save your spreadsheet as a CSV or Excel file.
Step 3:
Click Actions again, and then click Import Bands to open the Barley file upload tool. Drag & drop your file into the pop-up, or click on the highlighted area to upload your data and begin your import.
⚠️ Important: If a required column is not automatically mapped during your import, you will be prompted to assign a column from your data to it.
Step 4:
Using the built-in data editor, review your imported data to confirm its accuracy.
Resolving Errors (Cells in Red):
Each column with errors requiring attention will automatically be highlighted in red. Clicking any cell with an error will display additional details and steps to resolve it.
TIP: To quickly view all rows with errors, select the Rows with issues tab. Click any heading’s error icon to filter by error.
Troubleshooting Common Errors:
Error Code | Definition | Solution |
Multi-column uniqueness error | Duplicate pay bands | Ensure that you only have one pay band or data row per [Pay Zone + Job Function + Job Level + Job Track] |
External validation error | Data does not match your account configuration. | Ensure that inputted values match your configuration. |
This cell must be filled | Required columns must have a value | Ensure all cells in required columns are completed |
TIP: Click Find and replace to bulk edit values directly within the editor tool.
⚠️ Reminder: To see all rows that are ready to import, click the Clean rows tab. To import all clean rows, proceed to Step 5.
Step 5:
After reviewing your data for accuracy, click the blue Import button at the bottom of your window to begin finalizing your import.
Optional: To save all rows with errors highlighted as an Excel file, click Export at the bottom of the pop-up window.
Click the blue Import button to complete your import.
Congratulations! You’ve successfully completed uploading your pay bands in Barley!
Manual Pay Band Configuration & Edits
Step 1:
Click the Actions drop-down menu in the top right, and then click the Edit Bands button.
TIP: If the Edit Bands button is grayed-out, be sure you’re not trying to edit your bands within a zone that is linked to your Primary Zone; these bands will automatically populate using your inputted multiplier:
Step 2:
Now that the Pay Band fields are editable, enter new values for Low, Midpoint (can be renamed to Target), and High.
You can also configure the Type of band by clicking the cell and selecting Base or Total (Base Pay + Variable Pay).
⚠️ Important: Once you have input all of your values for a Pay Zone, remember to click Save Changes in the bottom-left of the page to ensure you do not lose any of your work.
After setting up Pay Bands within your Primary Pay Zone, any Pay Bands within linked Pay Zones will automatically populate using your selected Pay Zone Multiplier.
Simply repeat the process for any Pay Zones that are not linked to any Primary Pay Zone and you’re all set!
Need Help?
If you encounter any difficulties while editing your Pay Bands, please email our Customer Support team at support@barley.io for further assistance.
You can also contact Customer Support directly within the Barley app by simply clicking on the widget in the bottom-right corner: