UK Tax (PAYE) Spreadsheet

What is here

Here you can download a macroless spreadsheet for doing UK income tax and national insurance calculations.

Please leave a comment below if you find this useful or have any feedback! Please also consider making a small donation.

Downloads

Tax year 2012/2013 (From 6th April 2012 to 5th April 2013)

• Excel Version 17 kb
• OpenDocument Version 18 kb
• Change log 0 kb

Tax year 2011/2012 (From 6th April 2011 to 5th April 2012)
Now with pensions, age related allowances, student loans and blind persons allowance!

• Excel Version 16 kb
• OpenDocument Version 18 kb
• Change log 0 kb

Tax year 2010/2011 (From 6th April 2010 to 5th April 2011)
(Including new 50% rate and personal allowance taper)

• Excel Version 13 kb
• OpenDocument Version 15 kb

Tax year 2009/2010 (From 6th April 2009 to 5th April 2010)

• Excel Version 12 kb
• OpenDocument Version 15 kb

User comments / feedback

1. Paul Banks says:

   2012-01-10 11:49

   Andrew, this is now in the 2011 and 2012 versions. You just need to change the age field. Let me know if that works for you!
2. Andrew Platt says:

   2012-01-09 21:04

   Will you be able to add a field for over 65s and over 75s to take account of their increased allowances?
3. NickR says:

   2011-12-05 14:37

   Many thanks for this and for making it available for free. Suggestions for future enhancements - Interest income Dividend income Other income e.g. Rental income.
4. Ian says:

   2011-10-09 22:26

   Is there any way this could be updated to specify an age, pension contributions, blindness and student loans? I've tried to do it myself but it is a bit confusing!!
5. Alan says:

   2011-08-30 14:46

   Remember to add pension contributions (and other allowable expenses) to the allowances (RHS of the sheet). Though please correct me if I'm wrong.
6. Chris Turner says:

   2011-08-28 10:05

   thanks for the old years. I tried HMRC software and it does not allow old years.
7. Neil says:

   2011-08-24 09:53

   Thank you so much for this. I was getting really frustrated attempting just half of what you've given us!
8. Mark says:

   2011-08-21 18:52

   Really useful calculator. It would be good to see the basis of the calculations as cell comments. Thanks for posting FOC
9. Kumar says:

   2011-07-28 11:31

   Really helpful, thank you.
10. Wilkes says:

    2011-05-07 13:18

    Thanks, that's awesome! My only suggestion is to amend the sheet so you can put in multiple gross salaries so you can do a quick comparisons. I've cheated and used a macro to provide the net annual/monthly/weekly salaries for all salaries from 50k to 150k in increments of 5k. Wilkes
11. Andy F says:

    2011-05-03 11:28

    Thanks. Really helpful. Appreciate the time you have put into this and for making it available.
12. Jim says:

    2011-04-30 12:16

    Many thanks for sharing your spreadsheet.
13. Rajan says:

    2011-04-03 09:20

    Just wanted to say "thanks" - very useful to crosscheck my tax deduction...i had a feeling i was paying more....
14. Clive says:

    2011-04-01 16:03

    Googled and came here - thank you. And I have added a couple of lines which enable me to enter gross salary then the pension which it take out as a salary sacrifice before tax. I had not quite realised how much tax that was saving me!
15. Aidan says:

    2011-03-30 09:59

    Ideal - Just what I wanted. I was just about to make one, but you've done it much better ! Have you considered combining historical years onto seperate sheets in the same book ? Could even have a year by year summary sheet ! I don't suppose you have any previous years ? Thanks.
16. Chris Hart says:

    2011-03-30 08:36

    Getting my annual updated version! Thanks yet again for such a helpful tool
17. Glenn Atterton says:

    2011-03-20 23:31

    Is it possible for you to make a monthly tax calc so I can add in bonus's and overtime pay etc?
18. Dave says:

    2011-03-15 20:34

    Just wanted to say "thanks" for the 2011/2012 Tax Calculation - shows me how much worse off I'll be in 2011/12 though!
19. James Forsyth says:

    2011-03-13 12:23

    Excel version 2011/2012 Thanks great but will you be updating it with maybe a Overtime column or row most grateful
20. Rich F says:

    2011-02-26 22:38

    Started to prepare a spreadsheet myself but then realised that it isn't as straightforward as you first think. Then thought, someone must have done this already and a quick Google search reveals that you have!!! :-) Thanks very much for sharing your hard work and great to see the OpenOffice version.
21. Mike says:

    2011-02-12 22:04

    Back again for 2011-2012 version. Thank you very much!
22. Omar says:

    2011-02-06 15:01

    Thanks!! :) Very good sheet...
23. Dan says:

    2011-02-04 15:26

    Thanks so much for sharing your tax spreadsheets! You are an absolute star and saved me a ton of time!!
24. Peter says:

    2011-02-02 14:23

    Great work! Useful for future budgeting... :o)
25. Jim says:

    2011-01-24 16:10

    Many thanks! Excellent work. Digging the openoffice version. Hate excel. Thanks again!
26. Andrew says:

    2011-01-20 08:21

    The PAYE calculator is great. I do hope you are planning to update for 2011-2012!
27. Terry says:

    2011-01-19 16:48

    excellent stuff keep up the good work!
28. Mike says:

    2010-09-27 15:38

    Thank you very much for sharing this, goes well with my home made spreadsheet for calculating income and expenses. Great the see an OpenOffice Version too.
29. Rosy says:

    2010-09-05 20:14

    Thanks for putting this together and allowing others to use it for no charge. It could be very poplular with the PAYE tax underpayments/overpayments suggested by HMRC.
30. Mark says:

    2010-08-09 15:14

    Thanks for this! It's really helpful!