UK Payroll in Excel (2025/26) – Full Template + Video Guide

Build a complete payroll system in Excel - designed for UK schools, small businesses, and finance teams.

This downloadable template works hand-in-hand with a free 4-part YouTube video series, guiding you through:

✅ Part 1: Staff Setup & Tax Codes

– Set up employees, tax codes, NI categories, and dropdowns

✅ Part 2: Monthly Payroll Calculator

– Calculate PAYE, NIC and Net Pay using 2025/26 HMRC thresholds

✅ Part 3: Payslip Generator

– Create clean, auto-filled payslips using XLOOKUP

✅ Part 4: Dashboard & Reports

– Build a dynamic summary with PivotTables and charts

🧠 No VBA required – just clean formulas and logic

📥 Instant download – fully unlocked Excel file

📺 Watch the full walkthrough series on YouTube (linked inside)

Perfect for:

• UK School Bursars
• Small Business Owners
• Payroll Admins
• Excel Learners