PAYE deduction formula

Hi there,

I am based in South Africa implementing ERPnext. I have a slight problem with implementing the deductions formula. I the government has supplied us with a tax table in following format

How would i go about implementing in the right format, considering the variables for age also in the formula because the ages comes in ranges.

Any help will be greatly appreciated.

1 Like

Can anyone assist on this. I need help on this one

1 Like

Hello and welcome to ERPNext!

Here’s a thread that may help you How to Map Requirement in Formula in Salary Structure - #7 by yefritavarez

1 Like

@ Lukerosa did you progress in this i too need some help

Hi Lukerosa, did you get the Tax RSA Tax issue right? I’m struggling with same. Syntax errors all the way

Hi,

Currently in ERPNext, it only takes percentage and not amount in the tax slabs i.e. the payroll period. This is a feature development itself.

Regards,
Reema

@Lukerosa and @senoamadi

You can try achieve this by defining the formulas in the salary components.

I will share links for NHIF, NSSF and PAYE, NHIF rates are close to the PAYE table you’ve given above.
Then I will share a list of salary components, and how we achieved for each case.

You can even import the salary components into a test environment and review the formulas, remember to include conditions for age in your case.

Links, they give tables of each (PAYE, NHIF and NSSF)

https://www.michezoafrika.com/kenya-paye-tax-calculator

https://www.michezoafrika.com/utils/nhif

https://www.michezoafrika.com/utils/nssf

Link to sample salary components file.
https://drive.google.com/file/d/1UFdM2Uo8pJOGcERVxALBgVaXd0gD06Wq/view?usp=sharing

1 Like

Thanks @Lukerosa! I’ll check it out. Heck this thing can be very complicated.

@Lukerosa did you ever map the South African income tax tables for ERPNext? If so, I would greatly appreciate if you could export a set for the 2021 tax year that I can import on my side, also currently building a lab to test ERPNext for deployment.

Did you ever get the solution,and if so may you kindly share have been stuck at it .The taxes are calculated wrong for South Africa

Hi. Can you please send detailed information on what you want to really do so that I can at least try and find a way to help

1 Like