Payroll Forecaster

Finance

Payroll Forecaster 2026/27

Forecast the cost of up to five staff on hourly pay before and after a pay rise, including employer National Insurance and employer pension. Everything is calculated on the server.

Rates and assumptions (2026/27)

  • National Living Wage£12.71an hour, age 21 and over, from 1 April 2026
  • Employer NI15%above £5,000 a year
  • Employer pension14.38%NHS Pension Scheme default, editable
  • Pay year52 weeksmonthly = annual ÷ 12
Assumptions and official references
  • Pay is annualised as 52 weeks a year (a calendar year has about 52.18). Monthly figures are the annual figure divided by 12.
  • Employer National Insurance is 15% of annual pay above £5,000 for every member of staff, whether or not they are in the pension scheme. It assumes the standard employer rate: reliefs for under-21s and apprentices, and the Employment Allowance, are not applied.
  • Employer pension is an editable assumption (default 14.38%, the NHS Pension Scheme employer rate for 2026/27), applied to all pay for staff ticked as in the scheme. An additional administration charge is optional, zero by default and shown as a separate line; it is not assumed to be payable, and it is not established whether the 14.38% already covers one. Enter one only if your provider confirms it.
  • The National Living Wage used is £12.71, the rate for ages 21 and over from 1 April 2026. Age-banded and apprentice rates are not applied, so a "below the National Living Wage" flag may not apply to staff under 21 or apprentices.
  • No rate for April 2027 has been announced. Methods that depend on a future National Living Wage use the figure you enter and nothing else.
  • Employee pension contribution tiers are not shown: they do not change the employer cost, and no official 2026/27 table is held.

Sources:

Assumptions

£12.71 is the 2026/27 rate (age 21 and over). No rate for April 2027 has been announced, so enter your own forecast (at least £12.71, no more than £30). It is used by the “match a rise” and “bring up” methods only.

The NHS Pension Scheme employer contribution rate for 2026/27 is 14.38%. This is the default; you can edit it.

Optional and zero by default. Enter a rate only if your payroll or pension provider confirms a charge payable on top of the employer contribution; it is not established whether the 14.38% already covers one, so none is assumed. Shown as a separate line.

Staff (up to five; leave unused rows empty)

Staff member 1

Pay

Pay rise

Pension

Staff member 2

Pay

Pay rise

Pension

Staff member 3

Pay

Pay rise

Pension

Staff member 4

Pay

Pay rise

Pension

Staff member 5

Pay

Pay rise

Pension