ESI Calculation if Base is Beyond Limit mid year

[Former Member]

Sorry. I was bit confused in putting my requirement in the earlier post.

We know that the limit for ESI now in 15,000.

Lets say an employee has ESI base of 12,000 in April'2010. Hence if we run the payroll in April'2010, ESI will be based on 12,000. Now lets say his ESI base becomes 14,000 in May'2010. Hence if we run his payroll in May'2010, ESI will be based on 14,000. Till now everything is correct.

Now let his ESI base become 17,000 in June'2010. Now this is out of limit. However if payroll is run for June' 2010, ESI gets deducted till September'2010. However while deducting, it considers this 17,000. Ideally it should consider 15,000, which is the upper limit.

How do I achieve this?

[sikindar_a · Accepted solution]

Now let his ESI base become 17,000 in June'2010. Now this is out of limit. However if payroll is run for June' 2010, ESI gets deducted till September'2010. However while deducting, it considers this 17,000. Ideally it should consider 15,000, which is the upper limit.

Are you sure about this can you let us know wht are the values for wage type /112 and /113

ideally his ESI nominal basis will be 15000 and ESI basis shd be 17000

[Former Member · Accepted solution]

I have created a test case with ESI basis becoming 31,598.00. Now ESI has got deducted on this 31,598.00.

/112 is 31,598.

/113 is 100000.00 31,598.00

Last month the base was 10,528 and it got deducted based on that.

This month it should have got deducted on15,000 base.

[sikindar_a · Accepted solution]

Hope you have applied this note chekc the below thread ESI slab rate change

[Former Member · Accepted solution]

Yes we have applied this.

This has made 15,000 as the upper limit. Earlier also we were facing the same issue with 10,000 as the upper limit.

One imp issue. We have some 6 wage types which actually form the ESI Base. However for none of these WTs we have Cumulation Class 13 (ESI Basis Nominal) ticked. We only have Cumulation Class 12 (ESI Basis) ticked.

[sikindar_a · Accepted solution]

Then have a look at the documentation of CC 12 and CC 13 and Processing class 71,72

[Former Member · Accepted solution]

Tried various combinations in these.But not useful

[Former Member · Accepted solution]

Can anyone let me know, what is to be done. I am sure this is a common issue which is faced by several organizations.

[Former Member]

You can achieve this by writing a costume rule or function..

[Former Member]

Can you help me out in that. I am new to Rules and Functions

Is it not achievable by standard settings for wage type properties in Processing Class and Cumulation Class?