Employee Salary Revision & Increment Calculator

Reviewed & updated by Updated Originally published

The Salary Revision & Increment Calculator works out new salaries for a whole team and shows what the increases will cost. Everything runs in your browser, so employee pay details are never sent to a server.

You begin by setting the policy. You choose whether salaries are monthly or annual, set the effective date and currency, and enter the increment percentage for each performance rating from 1 to 5. You can also set a maximum increment, a rounding rule for new salaries, and an approved budget as a percentage of current payroll.

Next, you add employees. Each one has a name, ID, department, rating and current salary. You can type them in, paste a list, or load the sample data. Three optional fields give you control over individual cases: a promotion percentage that is added on top, a manual percentage that replaces the rating-based one, and a fixed amount that replaces both.

The calculator follows the same steps for every employee. It finds the percentage for their rating, applies any promotion or manual change, and uses the fixed amount instead if one is given. It then applies the maximum increment and rounds the new salary. The preview explains the result in plain words, such as “Rating 5: 12% + 3% promotion”, so reviewers can see exactly how each figure was reached.

The A4 landscape preview updates as you type. It shows current and new payroll, the total increase and the average increment. It also shows whether you are inside or over budget, and the extra cost for the months covered and for a full year.

When you are happy, download an Excel workbook with live formulas, or print the sheet with signature lines.

Salary Revision & Increment Calculator

Set your increment policy, add employees, and see new salaries and the total budget impact straight away.

Revision Policy

Increment by Performance Rating (%)

Each employee gets the percentage for their rating. A manual percentage replaces it, a promotion percentage is added on top, and a fixed amount replaces both. The maximum increment always applies.

Employees

One employee per line, separated by commas or tabs.

Review & Approval

Live A4 Landscape Preview