UK Payroll Calculator 2026-2027

Run your monthly payroll in minutes, with the 2026/27 tax year rates built in. Stop wrestling with HMRC rate tables. Enter your employees once, add each month's hours and extra pay, and this spreadsheet works out everything for you, with no macros and no subscription. What it calculates Income tax (PAYE) for England, Wales and Northern Ireland, and Scotland's six-band rates Employee and employer National Insurance, with common NI category letters (A, B, C, H, J, M, V, Z) Student loans (Plans 1, 2, 4 and 5) and postgraduate loans Workplace pension contributions on qualifying earnings or gross pay, with both net pay and relief at source schemes Auto-enrolment checks that flag anyone below the minimum contributions Employment Allowance, applied against your employer NI bill Net pay, total employer cost, and your HMRC payment amount and due date What's included 5 tabs: Guide, Settings, Employees, Payroll and Summary Space for up to 30 employees Dropdown menus to prevent data entry errors Four worked examples, which you overwrite with your own staff A clear colour key: yellow cells are inputs, everything else is formula Perfect for sole traders taking on their first employee, small businesses and start-ups, bookkeepers, and anyone who wants to cross-check payroll figures. Please note: This is a planning and checking tool, not HMRC-recognised payroll software. Live RTI submissions still need approved software. Tax is calculated on a "Month 1" basis, and statutory pay (SSP/SMP) and weekly payroll are not included. Rates are for the 2026/27 tax year, and you should verify them against GOV.UK. This is not financial or tax advice. Requires Microsoft Excel (recommended). Instant digital download.