You might want to change the income to taxable income : net income - deductions listed on last tax declaration.
3 Likes
Why? The deductions reflect our personal tax situation. I leave the whole thing as it is, just add a bit more income at the input end.
1 Like
I like to keep information about margin tax rate and effective tax rate overall for each year. A good indication and good comparison. Looking at real estate and moving, I made a list of ~12 municipalities and calculated margin + effective rates at 5 different (joint) income levels and compared. Not the primary factor but factor nonetheless. Both tax rates are important to keep in mind.
Go back and change the entries for income level and zip code, keeps deductions like kids.
3 Likes
Maybe not the simplest way, but I looked up the thresholds to compute it exactly, see illustrative example below. Then add it up with a simple lookup formular and chart the area or granularity relevant to you.
My previous comment was meant for @PhilMongoose So that people calculate their actual margin tax rate correctly.
Where do you find the exact thresholds and rates for federal and cantonal taxes? Bonus points if they go back several years… 
I picked them from the official resrouces and updated once in a while. Doesn’t change a lot. See for example here for federal tax or here for Zurich. Use “Steuertarife” for an online search.
The link provided by @UACcorp seems even better. It has the data under “basic data”, “tax rates” in incremental steps and for several years. It’s a great resource, I wonder if that was already available a few years back.
1 Like
You can also use this calculator
I always use „taxable income“ section
It tells you your total tax but also marginal tax.
https://taxes.helvetia.vlot.ch/v1/taxes/incometax?utm_source=website&utm_content=steuerchecks-pv
2 Likes
Normally just type “steursatz ‘name of canton/gemeinde’” and you get the local tax administration website. They typically have tables for a few years.
Though maybe there are free providers who have collected this information somewhere in a database already?
I tagged a link which has this information incorporated in their tool
2 Likes
There are, in ESTV’s tax calculator linked above 
It’s not including 2024 rates, yet, though.
1 Like
I see it now. It seems you select the year, data you want. I don’t see a ‘download all’ kind of feature.
Although I can’t figure out the formulas e.g. looking at BL, can anyone give an example how to use the formulas to work out tax due e.g. if you earn 120k:
and match it with the calculator here: Menu-NP-Ord.jsp
Your friendly tax office 
Seriously, I got curious, didn’t even know some places have splitting in place.
Found this Excel on their page which includes the formulas. Matches with the calculator online.
1 Like
I only checked briefly, but also only noticed single Kanton, single year, no export all. Still more convenient compared to looking through PDFs for the numbers needed
Annoyingly, I’ve seen that excel before but forgot about it. The difference I had was in the formulas they use natural log, but on the website they say log (which I take to mean base 10). The other annoying thing is that this caught me the last time I looked at it and I just forgot!
2 Likes
Sounds familiar.
Wikipedia sums up the log notation nicely. However, they don’t include tax authorities’ preferences.
Either way, the initial survey lacks “yes” as an option . One reason I made a table for a range of income (and a bar chart for my spouse) back then was to calculate the impact of pillar 2 buy-ins. If you use this option, and as long there’s enough limit left, you can basically pick your desired marginal rate for a while.
I challenge the statement that in maths it is common to use log to mean natural log. Mathematicians are lazy as hell and for sure will write ln\ x instead of log\ x or log_e\ x whenever possible.
2 Likes