Pay Rise and Pay Change Calculator

Who this is for

What a pay change is really worth. Enter your current and new rate for up to four scenarios and the sheet turns each into a yearly figure, the change as an amount and a percentage, and a monthly difference before and after the deduction percentage you enter.

Anyone offered a pay rise, weighing more or fewer hours, comparing a new job's rate with their current one, or checking whether an annual increase matched what was promised.

What this helps you track

• Your current and new pay on the same yearly basis
• The change as an amount a year and as a percentage
• The monthly difference before deductions
• The monthly difference after the deduction percentage you enter
• Up to four offers or scenarios side by side

How to use it

1. Write the hours you work a week now, the paid weeks in your year and the date the change takes effect.
2. Enter your own total deductions as a percentage, taken from a recent payslip; the sheet supplies none.
3. On each row, choose whether the rate is per hour, week, month or year, then enter the current rate, the new rate and the new weekly hours.
4. Use extra rows for alternatives: a different offer, more hours at the same rate, or a new job.
5. The yearly and monthly figures and the percentage are worked out in the browser and the workbook; on paper, work them through with a calculator.
6. Check the result against your first payslip after the change.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Why do I enter my own paid weeks?

Because paid weeks depend on your contract, holiday pay and any unpaid time. The sheet multiplies hourly and weekly rates by the figure you enter, so the yearly totals reflect your working year rather than an assumption.

Where does the deduction percentage come from?

From your own payslip: divide total deductions by gross pay for a typical period and multiply by 100. It is an approximation, because some deductions do not rise in step with pay; the payslip after the change is the real answer.

How do I compare a change in hours only?

Choose the hourly basis, put the same rate in both the current and new columns, and enter the new weekly hours on that row. The current figure uses the hours in the header, so the difference is the effect of the hours alone.

Can I compare a salaried offer with an hourly job?

Yes, if both are on the same row basis. Convert one to match the other first, or use the salary and hourly rate converter, then enter both rates on a single row so the comparison is like for like.