What the taxman claims
April 13, 2007Note: an updated version of this post for 2008/09 can be found here.
When I first read through my job offer I couldn’t have been happier with my stated salary and benefits package and I starting daydreaming immediately. However, once I realised how much money would actually end up in my account and how much of that nice sum would go into Her Majesty’s pockets, life suddenly seemed a lot crueller. It took me a while to understand how the UK tax system works and I thought I would share my newly-gained knowledge with you!
First things first: income tax. Any UK resident in employment has a personal allowance of at least £5,225 for the tax year 2007/08 - you can get more if you’re older than 65 or blind, but I’m assuming the majority of my readers won’t be… This personal allowance means that you won’t pay tax on the first £5,225 you earn per tax year (starting April 6th, 2007).
The next £2,230 you earn during 2007/08 will be taxed at a starting rate of 10%. The basic rate of 22% covers all money earned that exceeds £7,455 (= £5,225 + £2,230) up to a total amount of £39,825. That means, for the next £32,370 earned after you covered your personal allowance and starting tax rate in full, you will pay 22 pence of every pound earned to the government. Anything that exceeds the £39,825 will be taxed with the higher rate of 40%.
You can find an overview of the 2007/08 tax rates here. But beware that HM Revenue & Customs quotes the values without taking account of the personal allowance. The values in their table should look familiar if I’ve done a good enough job of explaining how I got to the abovementioned values.
Once you’ve paid all your tax duties, there’s another institution patiently waiting in line to grab their share of your money: National Insurance. This money is used to fund the NHS, social security, job seeker’s benefits and the like. National insurance contributions highly confused me - but, good news, I’ve got them figured out!
The two important values for your NI contributions are the earning threshold and the upper earning limit. The earning threshold is currently set at £5,225 (does that value look familiar to you?
) and you are exempt from NI contributions up to this amount. For any annual income that lies between the earning threshold and the upper earning limit of £34,840 you need to contribute 11% of your salary (if it’s any consolation: your employer needs to pay 12.8% for your whole salary, without caps). Anything beyond £34,840 is taxed at 1%, which means that those poor folks paying 40% income tax get at least a little relief with NI.
Now you are probably thinking: “Those numbers really confuse me… I just want to know what money is gonna come into my account each month… Does it have to be this difficult?” The answer is - No.
I’ve been procrastinating hugely and set up an Excel sheet that will give you a detailed breakdown of all the things I’ve discussed in this post - but with numbers relevant to your situation! All you have to do is download the spreadsheet here, type in your annual salary (as given in your contract) and any bonuses you might be expecting. Once you’ve done that and also resisted the urge of changing the formulae behind the individual cells, you’ll see a breakdown of
- your share of taxes at 10%, 22% and 40% (if applicable)
- your total tax contributions for the tax year 2007/08
- your annual salary after tax deductions
- your NI contributions at 11% and 1% (if applicable)
- your annual NI contributions
- your annual salary after tax and NI contributions
- and finally: your net monthly salary, i.e. the money that should end up in your hands/pockets/wallet/purse
Hope you enjoy playing with the Excel sheet… I certainly do…
Once I’m actually receiving that salary I’ve based my own calculations on, I will let you know whether my predictions came out right! Any questions? Leave a comment.
Update: Upon request I have updated the Excel sheet to include student loan repayments. According to Student Finance Direct you must earn at least £15,000 per annum to be required to pay back your student loan. If you exceed this amount, you need to repay 9% of everything beyond this threshold, i.e. if you get £20,000 a year, you are required to pay 9% of (£20,000 - £15,000 =) £5,000 back to the loan company.
The spreadsheet does not account for your individual circumstances. That means, if the calculated amount exceeds what you have left to pay back, you’re lucky!
Since the student loan repayments won’t necessarily apply to everyone out there who might think this spreadsheet could be of any use, you will see two different numbers for monthly salaries in the spreadsheet now: before and after student loan repayments.
Enjoy!

















OK, I have a question for you. PhD income is
Luke Church | April 13, 2007 | 3:41 pmOK, I have a question for you. PhD income is not taxable through some mechanism that I don’t understand.
My question is how much can I earn *as well* as my PhD stipend before I start paying income tax, further, once I start paying tax, I assume that I only pay tax on my income, I don’t suddenly have to magically start paying tax on my PhD stipend as well?
(And don’t worry, I know that ‘not a lawyer stuff’, I’m not asking you for an opinion to stand up in court, it just seemed that it might be of interest to your audience)
That's a tough one. Ok, based on my understanding and
Kirsten | April 13, 2007 | 4:00 pmThat’s a tough one. Ok, based on my understanding and assuming the information you were given that the PhD money won’t be taxed is correct, you should be able to earn an additional 5,225 pounds (or whatever the personal allowance is) a (tax) year…
Having said that, the government might well not use the common sense approach here (i.e. special rules/regulations applying for PhD students), so to be on the safe side I would simply contact the University… they should know for sure. And if they don’t, HM Revenue & Customs will hopefully be able to give you a conclusive answer…
(get it in writing!)
PS: No one ever asked me to mention the money
Kirsten | April 13, 2007 | 4:02 pmPS: No one ever asked me to mention the money from my scholarship in my tax forms… hence I believe the PhD allowance should be *reasonably* safe
Hey That's a useful spreadsheet, but seeing as your shiny new
Sparkie | April 13, 2007 | 7:49 pmHey
That’s a useful spreadsheet, but seeing as your shiny new site has a ’student’ theme to it can you add another expense to the list: Student Loan repayments!
Cheers
Rob
Done :-)
Kirsten | April 13, 2007 | 8:54 pmDone
Thank you - now I can see even more money
Sparkie | April 14, 2007 | 12:40 amThank you - now I can see even more money disappearing away
** Decides to delay getting a job and worrying about earnings **
Great spreadsheet :-) Just thought I'd point out something that might
Adrien | April 15, 2007 | 4:34 pmGreat spreadsheet
Just thought I’d point out something that might get misinterpreted:
I believe the earning threshold is actually on a weekly basis ( about £100/week ). Whilst this makes no difference to full-time employees, it does mean that students are unable to claim back NI contributions for say summer internships - even if their total income over the year was under £5225, their weekly income probably was over £100, hence the contributions.
Thanks for clarifying :-) I didn't know that... but then
Kirsten | April 16, 2007 | 6:08 pmThanks for clarifying
I didn’t know that… but then my NI for the summer internship was messed up anyway, which is why I didn’t bother to even try to claim any of it back 
Great little tool Kirsten! Having recently been given a pay
Money Watch | April 16, 2007 | 9:34 pmGreat little tool Kirsten! Having recently been given a pay rise, and not knowing how much I was going to be earning a month, this has helped me out.
Cheers,
Rob
http://money-watch.co.uk
How Much Tax Will I Pay?... An Excel sheet to help
Money Watch | April 16, 2007 | 10:25 pmHow Much Tax Will I Pay?…
An Excel sheet to help you work out how much Income Tax and National Insurance you pay.
……