How to calculate income tax based on taxable slab

Frappe HR
1

Hi,

I have created taxable slabs in payroll period please see in attached image.

If salaray per year < 600,000 there is no tax paid
If salary is > 600,000 & <12,00,000 there will be 5% tax to be paid
If salary is >12,00,000 & <18,00,000 then the tax payable 30,000 plus 10% of the amount exceeding 12,00,000

What formula or conditions do I need to calculate the correct income tax.

28
281366×642 30.5 KB

I have created salary component also please have the image below

28
281366×642 32.5 KB

For income tax salary component I have checked Variable Based On Taxable Salary option.

28
281366×642 27.3 KB

Salary structure is as follow

28
281366×642 21.5 KB

2

If resolved, please share learned lessons

1 Like
3

Hi @Usman_Khan. Did you manage to find a solution to your issue? I think I need the same too. Would be grateful if you shared any suggesstions.

4

Hi @nmami, did you also find solution to this? Please share with me and i will be grateful.

5

This thread is now quite old, and I’m not sure if the original poster ever found a solution, but I suspect that the problem with OP’s set up is that the salary structure is trying to use both income tax slabs and a formula at the same time. When using a slab structure, no formula should be defined.

6

Best result I reach

7

Have you tried this ?
I have tried the same steps , but if fails also
If you succeed , tell me