Dear seniors how am prepares the ESI of employees in excel sheet send the excell sheet in which ESI prepare. THANKS ANJNA
From India, Chandigarh
Hi, hope this will clear how to prepare the ESIC calculation.
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls ESIC CAL FORMAT JAN11.xls (19.0 KB, 863 views)

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.
From India, Bangalore
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

From India, Chandigarh
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.......

From India, Hyderabad
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.

From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.