UPDATE: The South African Tax Spreadsheet Calculator for 2016/ 2017 at the 2016/ 2017 tax tables page. – NOW AVAILABLE
We have released a free copy of the South African Tax Spreadsheet Calculator 2013/ 2014.
Using the new tax tables (see adjacent) 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.
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. 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
Please fill in your details below to receive the free monthly Audit Excel newsletter which covers free Excel tips tricks and shortcuts.
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
As per our financial modelling course we highly recommend that negative numbers are clearly shown as such and we prefer brackets around a negative number and that the negative numbers are in red. There are several options to achieve this … Continue reading
One of the most common formatting requests is how to get Excel negative numbers in brackets (and red) instead of just a negative sign (-) in front of the number. The actual issue is not an Excel issue but rather at … Continue reading
Adrian was really good. He explained everything really professionally- Bookkeeper.– Excel Testimonials
It dealt with my daily challenges at work- IS Management Accountant.
There was nothing I did not like about the workshop. Adrian was fantastic- Accountant.