UPDATE: 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 get your free copy of the South African Tax Tables for 2013/ 2014- spreadsheet calculator please click here to
To learn how to do all this in Excel, attend our training courses.
Below some of the other calculators we have:
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!
Goto the next duplicate in Excel When working with lists of data you sometimes need to work through the duplicates to decide which you can leave and which can be deleted, or alternatively which need to be investigated for reconciliations. … Continue reading
Numbers seen as text in Excel A common problem, especially when importing data from other systems is numbers seen as text in Excel and not being treated like numbers e.g. they don’t add up and you get VALUE error messages. … 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.