Results 1 to 7 of 7

Thread: Salaries and 2007/08 taxes

  1. #1
    just me duncan drennan's Avatar
    Join Date
    Jun 2006
    Location
    Cape Town
    Posts
    2,642
    Thanks
    119
    Thanked 94 Times in 77 Posts

    Salaries and 2007/08 taxes

    I set up the attached spreadsheet (in both MS and OOo format) just for keeping track of salaries and payroll liabilities. I thought that it might be useful for some people. It is based on the 2007/08 tax rates

    BE CAREFUL and check that everything is correct before going ahead and basing your payments on this spreadsheet. It is provided "as is" and may contain errors. I take no responsibility for any liabilities which you may incur making use of this spreadsheet. I am not an accountant or a financial advisor. If you have a bad hair day as a result of this info, don't phone me.

    Other than that, I think it is pretty much okay You should be able to easily modify it to suit your particular situation. Please let me know if you do find any errors, and I'll correct them and repost.
    Attached Files Attached Files
    [SIGPIC]Engineer Simplicity[/SIGPIC]
    Turn ideas into products | The Art of Engineering blog

  2. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,980
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    I've had a quick look. There are a few bugs - UIF for starters. (should be IFF ?)
    We'd also need to break up the income categories - some are handled differently so a total lump sum approach doesn't do the trick.

    A great idea, though. Let's see if we can massage this into something spot on.
    The trouble with opportunity is it normally comes dressed up as work.

  3. #3
    just me duncan drennan's Avatar
    Join Date
    Jun 2006
    Location
    Cape Town
    Posts
    2,642
    Thanks
    119
    Thanked 94 Times in 77 Posts
    Quote Originally Posted by Dave A View Post
    There are a few bugs - UIF for starters. (should be IFF ?)
    Huh?
    [SIGPIC]Engineer Simplicity[/SIGPIC]
    Turn ideas into products | The Art of Engineering blog

  4. #4
    Administrator I Robot's Avatar
    Join Date
    May 2006
    Posts
    783
    Thanks
    0
    Thanked 15 Times in 14 Posts
    It's giving the maximum threshold - R116.62 - on a R2k per month salary.

  5. #5
    just me duncan drennan's Avatar
    Join Date
    Jun 2006
    Location
    Cape Town
    Posts
    2,642
    Thanks
    119
    Thanked 94 Times in 77 Posts
    Quote Originally Posted by Administrator View Post
    It's giving the maximum threshold - R116.62 - on a R2k per month salary.
    Maybe just check that...the amount that I had in there was 20k. If you change it it should update the UIF values.
    [SIGPIC]Engineer Simplicity[/SIGPIC]
    Turn ideas into products | The Art of Engineering blog

  6. #6
    Administrator I Robot's Avatar
    Join Date
    May 2006
    Posts
    783
    Thanks
    0
    Thanked 15 Times in 14 Posts
    Column D employee 1?

  7. #7
    just me duncan drennan's Avatar
    Join Date
    Jun 2006
    Location
    Cape Town
    Posts
    2,642
    Thanks
    119
    Thanked 94 Times in 77 Posts
    D13 = UIF = IF(D2>11662;116.62;D2*0.01)

    We're missing each other somewhere here....just try adjusting the gross monthly salary and see if it works okay.
    [SIGPIC]Engineer Simplicity[/SIGPIC]
    Turn ideas into products | The Art of Engineering blog

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •