← All prebuilt solutions
Payroll & HR

Pay Review & Salary Band Planner

Plan a pay review – minimum wage uplifts, pay bands, and the full cost including employer National Insurance and pension

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Pay Review & Salary Band Planner

Overview

Each April the minimum wage rises, and for many employers that sets the size of the pay review. Raising the lowest paid can squeeze the differential with supervisors and more experienced staff. This workbook shows the knock-on effect and the true cost, including employer National Insurance at 15% above £5,000 a year and pension contributions.

Price
£20
Who it’s for
Payroll & HR
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Staff

Each person's current pay, increase and full cost. What you do: one row per person.

Staff
Pay Bands

Step 2

Pay Bands

Your pay bands as hourly rates. What you do: enter your bands.

Step 3

Settings

The increase, minimum wage and employer cost rates. What you do: check once a year.

Settings

Step 4

Who it is for

Made for people like you

  • Example – text
  • Employers with hourly-paid staff – See the knock-on effect of minimum wage rises.
  • Hospitality, retail and care businesses – Protect pay differentials as rates rise.
  • HR and finance managers – Cost the review accurately before agreeing it.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Set the general increase and check the minimum wage rates that will apply on the review date.
  2. Pay Bands – Enter your bands as hourly rates (optional).
  3. Staff – Enter each person's age group, hours, current rate and band. Override the increase or set a new rate where needed.
  4. Dashboard – See the cost of the review and who it affects.

Key features

  • Applies a general increase, individual increases or new rates to each person, and automatically lifts anyone who would fall below the minimum wage for their age group.
  • Checks every new rate against your pay bands and shows where pay has been squeezed together by minimum wage rises.
  • Works out the full annual cost before and after the review – pay, employer National Insurance (less the Employment Allowance) and employer pension contributions.

What’s included

  • Dashboard – Cost and who is affected
  • Settings – Increase, minimum wage and employer cost rates
  • Pay Bands – Your pay bands
  • Staff – Current and new pay for each person
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions