Help to input slabs
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.
Best Answer
-
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!
1