Re: Preprations Of Esi Of Employees - XLS Download

Dear seniors
how am prepares the ESI of employees in excel sheet
send the excell sheet in which ESI prepare.
THANKS
ANJNA

Hi, hope this will clear how to prepare the ESIC calculation.

Hi Anjana
179 is showing the employee contribtion part i.e 1.75% of Wages and 487 showing contri of employer i.e 4.75% when you press F2 in 179 and 479 it will clarify your doubts.

hi pankaj
thanks i am understand but both ESI contribution are decuted
for employees wage when iam press F2 then these two contribution decuted for
wages but total of wage remain same after ESI CONTIBUTION pls tel me
tnanks
anjna

Dear Pankaj,
While appreciating ur efforts, i wan to educate you on two issues..................First one...Employees whose average daily wages is less than Rs.70 they are called as Exempted employees. In respect of such employees no need to pay 1.75%, but employer's share of 4.75% to be deducted, this point was ignored while preparing your excel sheet.....
And second issue..........due to recent computerisation in ESI, now paying the ESI through manual challans is stopped and the calculation of Employees Share and Employer share will be looked after by the system only........Only you have to enter the no. of days and wages paid to the employee to generate the challan.....as payment through system generated challan is MANDATORY in ESI......
With regards.......

dear rohan,
form 37 is not available in excel.
i am busy in these days. please install a pdf to word convertor after converting you can copy and paste in excel format.
i am sending all the esic forms.