This free UK payslip template gives small employers a clean, printable payslip in Excel. You enter the employee’s details, earnings and deductions from your payroll records, and the sheet totals gross earnings, deductions and net pay, with year-to-date figures underneath. It suits employers with a handful of staff who run payroll software but want a clearer payslip to hand out.
What must a UK payslip show?
Under GOV.UK guidance, a payslip has to show:
- pay before any deductions (gross pay)
- each deduction and what it is for, such as tax, National Insurance or pension
- pay after deductions (net pay)
- the amount paid by each method, if pay is split
- the hours worked, if pay varies with time worked
The template covers all of these. Hours go in the Notes box, because most salaried staff do not need them.
What the template does and does not do
The sheet adds up the five earnings lines and five deduction lines, and works out net pay. It keeps the summary card at the top in step with the figures below it, and shows any negative amounts in brackets. It does not calculate PAYE or NI. Your payroll software works those out and reports them to HMRC through RTI, and the payslip simply records them.
A payslip holds personal data, including the NI number and pay. Store saved copies securely and share each one only with the employee it belongs to.
Pay staff and earn from self-employment too?
If you are a sole trader with employees, your own profits are taxed through Self Assessment rather than PAYE. Read how Making Tax Digital for sole traders affects the records you keep.
