Bulk update annual salaries – Pento UK

You can upload your pre-populated file or you can manually enter the data in the columns shown in the screenshot above. You can increase the salary by an amount or by a percentage, you just need to add the correct unit (£ or %) in the file, or use the dropdown if you are manually entering the data.

Please note - In order for Pento to match the data to employees, the Employee ID is a mandatory column for both the manual and file upload

Uploading data from a file

If you choose to upload the data from a pre-populated file, you will need to follow the steps below:

Select Upload data from file
Once uploaded, you will see a screen similar to the below:
Select Yes if your file contains headers
Choose Select another row if your file contains headers but it is a different row to the row indicated with the arrow
Select No header row if your file does not contain headers
Once confirmed, Pento will automatically try to match the column headings
If you have any columns that Pento is unable to match automatically, you will see a Lookup matching fields dropdown where you can match the correct columns.
If Pento matched any columns incorrectly, for example, in the screenshot above, %/£ was incorrectly mapped to Hours per week, you can use the dropdown icon to select the correct heading
Once you have confirmed the mapping for each column, select Review
Once you have reviewed the data, select Continue
You will be asked if you are ready to submit, select Yes

Please note - You can leave the Hours per week column blank, Pento will automatically use the default hours on the employee's profile. You should enter the hours per week if the employee's hours are changing from their current settings.

Frequently asked questions

What columns do I need if I am uploading a pre-populated file?

You can find the headings you need in the manual data section. If you choose to use your own headings, Pento will automatically try to match your headings to the data so it is advisable to use similar or easily identifiable headings.

What format should I use for dates/units/currency etc?

For columns that require specific formatting, you can refer to the manual data section; if you hover on the information icon (i) in the column headings, you will see a list of accepted values.

For any columns that have multiple options, you can select the dropdown within the columns in the manual data section to see the accepted values.

What if I enter the wrong unit for the increase?

If you enter % as the unit, Pento will reject any values that exceed 100

Can I enter an effective date in the past?

Yes. If you would like Pento to automatically add the backdated pay to the employee's payslip, you will need to follow the steps below:

Navigate to Employees from the left sidebar
Select the Salary tab
Select the new salary record
You will see an option to Enable automatic addition for backpay, select this

For further guidance on backdated pay and how it is calculated, please refer to our help article Backdated Pay