Excel spreadsheet for personal tax?

in Cutting tax
11 replies 558 views
gravlaxgravlax Forumite
111 Posts
Second Anniversary 10 Posts
Does anyone know of or have a link to an Excel spreadsheet? Something that has all the UK personal tax bands and allowances (ideally editable) where you then enter all our sources of income, salary, self-employed, capital gains, pension, interest, dividends etc. and can calculate the tax?

Have tried making one, but calculation never quite matches results on websites with online calculators. The whole UK tax method appears wilfully complicated! Things like working out the savings allowance can only be done after working other income, but personal allowances have to be applied to other income before savings income, etc. So you go round in a loop. I'm sure someone must have set out a nice simple Excel file that calculates the tax in logical steps somewhere?

Help! Thanks.


Sign In or Register to comment.
Latest MSE News and Guides

British Gas prepay meter users...

...to pay less for gas from 1 April

MSE News

The 'odd Easter flavours' thread 2023

What bizarre food stuffs have you spied?

MSE Forum

Energy Price Guarantee calculator

How much you'll likely pay from April

MSE Tools