Payroll & HR

Payroll Calculator & Payslips

Small-employer payroll for up to 25 people – PAYE, NI, student loans, pensions, payslips and P32

£20

Secure checkout. Your download link is sent as soon as payment clears.

Overview

This workbook runs the calculations of a complete UK payroll for a small employer. You enter each employee once, then each pay day you enter only what changes – hours, overtime, bonus, sick or maternity pay, deductions. The workbook works out PAYE income tax using HMRC's own tax table method, employee and employer National Insurance for every category letter, student and postgraduate loan deductions, workplace pension contributions, net pay and the total cost to you. It then produces printable payslips, a payroll summary, the P32 record of what you owe HMRC each month (with due dates), year-to-date figures and a P60-style annual summary.

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

Employees

Everyone on the payroll and all the details that drive their tax, NI, loans and pension. What you do: add starters, record leavers and new tax codes.

Step 2

Pay Run

The variable inputs for every employee in every period, with gross, tax, NI and net pay shown alongside. What you do: enter hours and changes for the period you're paying.

Step 3

Payslip

A one-page A4 payslip for any employee and period. What you do: pick the employee and period, then print or save as PDF.

Step 4

Payroll Summary

Everyone's pay for one period, and every period of the year. What you do: pick a period to view.

Who it is for

Made for people like you

Example – text

WATCH OUT – This workbook is NOT RTI payroll software. HMRC requires every employer to report each payment on or before pay day using a Full Payment Submission (FPS), and to claim Employment Allowance or recover statutory pay using an Employer Payment Summary (EPS). You must do that with HMRC-recognised software – HMRC's free Basic PAYE Tools works for up to 9 employees, and many low-cost products cover more. Use this workbook to calculate, check, budget and produce payslips, and copy the figures into your RTI submission.
Small employers running their own payroll – Accurate tax, NI, loans and pension for up to 25 people, with payslips you can print or PDF.
Directors of small companies – Director NI on the annual earnings period, Employment Allowance tracking and the true cost of salaries.
Bookkeepers and practice staff – A transparent calculation you can audit line by line – useful for checking payroll software or answering staff queries.
Anyone planning pay changes – See the effect of a bonus, a pay rise or a new starter on tax, NI and the HMRC bill before it happens.

Quick start

Up and running in minutes

Example – text

Settings – Enter your business name, address and PAYE references, choose the tax year and pay frequency, and type your first pay date. Check the pay calendar on the right – it lists every pay date in the year.
Employees – Add one row per employee: personal details, salary or hourly rate, tax code, NI letter, student loan, pension and – for new starters – the P45 figures. Keep each person on the same row all year.
Pay Run – Find the block of rows for the period you're paying (the period number is in column B). Salaried staff are paid automatically; enter hours for hourly staff and anything else that changes.
Move the current period on – On Settings, set 'Current pay period' to the period you've just entered. Later periods aren't calculated until you do this, so the HMRC figures and year-to-date totals stay correct.
Check and print – Look at the Payroll Summary and the Dashboard checks, then print or save a payslip for each employee from the Payslip sheet.
Report and pay HMRC – Copy the figures into your RTI software (FPS on or before pay day). Each month, pay HMRC the amount on the P32 sheet by the due date and record the payment.

Key features

Payroll for up to 25 employees paid weekly, 2-weekly, 4-weekly or monthly, for 2025/26, 2026/27 or 2027/28.
Cumulative PAYE using HMRC's tax table method (Week 1/Month 1, K, BR, D and NT codes; Scottish S and Welsh C codes) – tested against HMRC's own worked examples.
Employee and employer NI for every category letter including directors, student and postgraduate loans, auto-enrolment pensions (relief at source, net pay, salary sacrifice), SSP, SMP and Employment Allowance.
Printable A4 payslips, a payroll summary, P32 employer payment record with due dates, year-to-date figures and a P60-style annual summary.
Not RTI software: report each payment to HMRC on an FPS (and claims on an EPS) using HMRC-recognised payroll software.

What’s included

Dashboard – Pay, costs and HMRC payments at a glance
Settings – Employer, tax year, frequency, pay calendar
Employees – Tax codes, NI, loans, pensions
Pay Run – What changes each pay day
Payslip – One A4 payslip per person per period
Payroll Summary – Everyone, every period
P32 – What you owe HMRC and when
Year to Date – Running totals for everyone
P60 – End of year summary
Payroll Workings – Every calculation, line by line
Tax Rates – Rates, thresholds and payroll tables
HMRC Checks – Formulas tested against HMRC examples
Guide – How to use this workbook

How buying works

Your file is only released 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 download link arrives as soon as payment clears.

Explore the range

Trial Balance to Accounts Mapper

Turning a trial balance into statutory accounts means mapping every account to the right heading, posting year-end adjustments, and then building a profit and loss account, balance sheet and notes in the format the Companies Act requires – for this year and last year.

£20

View details →

Staff Appraisal & Performance Tracker

Good appraisals are fair, consistent and joined up: objectives agreed at the start of the year, regular 1-to-1s, honest ratings against a clear competency framework, a calibration meeting so one manager's…

£20

View details →

Practice Timesheet & WIP

An accountancy practice sells time, but most of its fees are fixed.

£20

View details →

Need it tailored to your business?

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

Custom spreadsheets Talk to us

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

Accounts Tax compliance and planning Bookkeeping and VAT Payroll and CIS Cloud accounting software Business growth and planning

Get In Touch

We're open Monday to Friday, 9am – 5pm. Call our Plymouth office on 01752 42 72 82 or send us a message below, whether it's about consultancy, spreadsheets or our document templates.

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Payroll Calculator & Payslips

Overview

A walk through the main sheets

Employees

Pay Run

Payslip

Payroll Summary

Made for people like you

Up and running in minutes

Key features

What’s included

How buying works

Click Buy now

Pay securely

Download your file

Explore the range

Trial Balance to Accounts Mapper

Staff Appraisal & Performance Tracker

Practice Timesheet & WIP

Need it tailored to your business?

Need an accountant too?

Get In Touch

Quick Links

Company information

Legal