google sheet for take home tax calcs

InspectahDave

I've put together a spreadsheet for PAYE take-home calculations - I needed it to for cross-checking my numbers elsewhere. I'm using it plug in numbers and check if the two agree, if not then it helps me flush out issues.

What's in it
- 2025/26 and 2026/27 (covers the Plan 2 student loan threshold change)
- Difference pension plans: Salary sacrifice, relief at source, and net pay
- PA taper, Plan 1/2/4/5, Postgrad (additive)
- Calculations and rates are separated onto different tabs with sources listed
- Workings tab shows the calculation breakdown live from inputs
- Notes, About tabs tells you my assumptions and who I am if you're interested

Limitations
- England/Wales/NI only
- annual basis (so won't exactly match HMRC's tool which rounds per pay period)
- no BIK or niche allowances!

Usage
File → Make a copy if you want to plug your own numbers in. Hope it helps. And if you use it and spot something wrong, please tell me.