Excel spreadsheet for personal tax?

111 Posts

in Cutting tax
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.
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.
0
Latest MSE News and Guides
Replies
https://www.thesalarycalculator.co.uk/salary.php
I'm looking for something editable to download in Excel, and which allows you to input multiple sources of income on the one calculation (employment, dividends, interest, capital gains, etc.)
OK maybe the replies are having a laugh. Not sure why. I thought the question was reasonable.
Only three criteria:
1. UK personal tax calculator
2. In Excel available to download and edit
3. Tax calculation on multiple sources of income
Telling you what tax you pay on just salary or just dividends or anything else in isolation doesn't help calculate the total tax bill if you have rental income, dividends, capital gains, interest etc. to factor in. I'm looking for a single Excel file that allows for a full calculation.
Maybe none exists. Having tried, and failed, it is complicated!
https://www.uktaxcalculators.co.uk/tax-calculators/personal-tax-calculators/multiple-income-tax-estimate/
https://www.absolutetax.co.uk/products/absolute-taxpert-tax-planning-apps
It is interesting to search on Google. Here is one person asking how to work out the tax on dividends in Excel. As you can see, it didn't work. Nobody explained why. There are complex nested IF formulae involved that might be better with VLOOKUP formulae. When I have some time I might try to look at it:
https://www.mrexcel.com/board/threads/dividend-formula.1170385/
=IFS(P12<12570,P12,P12<=100000,12570,P12>125140,0,TRUE,12570+(P12-100000)/2)
I was hoping to find the optimum/maximum amount of each income type for maximum income without any tax, i.e. using personal, savings, dividend, and cgt allowances and then once all allowances have been used, see which income type is most tax efficient thereafter. I think dividends, but could be non-property capital gains, or even interest. Or maybe the most tax efficient source of income changes again once you exceed the Basic Rate band.