Every organization has different procedures regarding EL. As per the Factory Act, for eligibility, a person should have 240 working days within a year, excluding rest and holidays. If an employee joins in the middle of the year, then two-thirds of their attendance will be checked during the calculation. In my organization, we provide 15 days of EL to employees. 1.25 days will be calculated for every 20 days of working. Here is how we calculate it:
Example - Suppose from January to December, a person has 280 working days, excluding rest days and holidays. To find out the number of EL days in a year, EL Due = IF(ROUND((total days, i.e., 280)/20,0) > 15, 15, ROUND((total days)/20,0)). This formula helps us determine how many EL days will go into their account. Then, the total EL = (EL due - EL availed) + holidays and national holidays. The third step will be to calculate the total amount as (Salary * 12/365) * total EL.
I hope this information helps you. For any assistance, please email me at rath_ratikanta@yahoo.com.
RATIKANTA RATH (HR MANAGER)