Help to input slabs

aishwary2003

i am creating a model for tax calculation and it includes 2 regimes with different slab structure,i am calculating tax for 10 employees on their gross salary ,for regime i have a list includes old,new regime names and i have included a line item for selecting regimes of data type list.But i am unable to get an idea how to enter the slabs and do the tax calculation ,as both regimes have different number of slabs and rate of %. I have also created a module to keep single line data need for gross salary calculation but i don't know what to do for slabs.

Below i am attaching screenshot of data given to me and what i have done so far.

Also attaching an example of calculation i need to do with slabs.

Screenshot 2024-07-03 121132.png

Screenshot 2024-07-11 123237.png

Screenshot 2024-07-11 123431.png

Screenshot 2024-07-11 123458.png

Screenshot 2024-07-11 123615.png

ShubhamCh

Hi @aishwary2003

Let's assume you have 4 slabs in Old Regime and 6 slabs in New Regime. Create a list 'Slabs' with six items in it. Now we need to define ranges and rate% for these slabs specifically to Old and New Regime.

Create a module with Regime list, Slabs list with 4 line items as shown below:-

I have a SYS/Cal module for Employees where I can select their regime

Now to calculate deduction for these slabs, create a module with Employee list and Slab list:-

Finally directly refer Emp & Slab.Tax in your SYS/Cal module and it'll show you the deduction based on slabs and rate%. There are some specific deduction based on regime selected, you can account them using some more line items.

Thanks!