Templates
Payroll Template for Excel and Google Sheets free & workplace-ready
Free · Version 2026.10
Estimate a payslip with 2026/27 rates – for guidance, not a replacement for payroll software. The free payroll template works in Excel and Google Sheets and covers the United Kingdom.
- 100% free
- Workplace-ready
- Excel & Google Sheets
Automate payroll with Ordio
Cut payroll errors and save hours every week
Automatic calculations
Minimum wage, overtime, and premiums calculated automatically
Direct accounting export
No manual re-entry, your accountant gets digital exports
Save 10 hours per week
Automation keeps manual work to a minimum
95% fewer errors
Automatic checks help prevent costly payroll mistakes
With Ordio:
See how Ordio simplifies payroll
See automated calculations save hours · No obligation · 15 minutes
More free templates
Discover more Excel templates for planning, time tracking and HR.
Frequently asked questions about Payroll template Excel
What must a UK payslip show?
Gross pay, the amount of each deduction, net pay and, where pay varies with time worked, the number of hours paid (Employment Rights Act 1996, s. 8). Employees and workers must receive it on or before payday. (Source: [gov.uk](https://www.gov.uk/payslips))
How long should payroll records be kept in the UK?
PAYE records for at least three years after the end of the tax year they relate to, and minimum wage records for six years. (Source: [gov.uk](https://www.gov.uk/paye-for-employers/keeping-records))
Does the template support biweekly and monthly pay?
Yes. Set the pay period dates in the header for weekly, biweekly, semi-monthly, or monthly runs, including monthly payroll templates with formula rows that recalc each period. The earnings layout stays the same; only the period label and hours from your timesheet change.
What do YTD and FICA mean on a pay stub?
YTD means year-to-date totals for pay or tax withheld. FICA is US Social Security and Medicare withholding. UK payslips use PAYE and NI instead. See the abbreviations table on this page for a full US and UK legend.
Is the payroll template free, and does it work in Excel and Google Sheets?
Yes. You download it free of charge after a short form and get an Excel file (.xlsx, Excel 2016 or Microsoft 365) and a Google Sheets copy. Excel and Sheets contain the same 6 sheets: Instructions, Payslip, Pay breakdown, Checks, Legal basis, Ordio.
Does the template work for the United Kingdom?
Yes. It is set up for the United Kingdom and is based on, among others, Employment Rights Act 1996 s.8; GOV.UK, HMRC rates and thresholds for employers 2026 to 2027 and GOV.UK income tax rates. Enter different rules from collective agreements or contracts yourself.
What does the template check automatically?
The “Checks” sheet shows ✔ or ⚠ for: Required details complete; Pay period plausible; National Minimum Wage met; Deductions plausible (below gross); Tax code entered.