We have released a free copy of the South African Tax Spreadsheet Calculator 2013/ 2014.
Free Tax calculator: Latest South African Tax Spreadsheet calculator (with 3 years history)
Using the new tax tables (see below) we have provided the ability to enter your age category and salary and the spreadsheet will automatically calculate your taxes and the appropriate rebates based on your age.
As an added extra we have also included a comparative section to show the impact of declaring company profits as a salary/ bonus or as a dividend given the various company taxes. Makes for interesting analysis.
You can get quick answers from the online version of the latest South African Tax Spreadsheet calculator (which includes 3 years history) (see instructions on YouTube below).
It seems the sweet spot is at about a salary of R 500 000 which means that the rate on salary and effective tax rate is about the same.
To download the Tax Calculators (2013, 2014 and 2015) subscribe to our newsletter in the right hand side sidebar of this page. You are welcome to unsubscribe if we can’t help you but we guarantee that the Excel tips and tricks we provide will save you hours in your normal workday
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.