Hr And Ir
Assistant Hr Executive
18th April 2012 From India, Madras
Help me plz urgently. I can generate excel file but when i am converting the excel file into .csv it is not appearing in notepad but instead it gets converted into excel file only what to do?
For reference i am attaching the .csv file .
6th March 2013 From India, Mumbai
1st Step: Complate Resigned employee Formality in epfo site then member then exit bulk or for individual go to profile make employee exit as per his last working day.
2nd step: make your new employee joined in epfo portal throug register and for bulk joining (epfo site- member- register individual / bulk).
3rd Step: Download UAN Base ECR Excel file for further process.(epfo site-payment-ecr/return filling-ecr upload-select Nov-16- select type of "ECR" download excel file) if file not open please rename ecr.xls ".xls" don't forget.
4th step: feel uan base ecr file and kindly remove exit processed employee from it and add new registered member uan and name in this file and tally with pay register
5th Step: example sheet attached with this post for more information please email me only no call please
6th step: refer contribution rate of pf and manually feel account 22,21,and 2 as per contribution rate
7th step: mention number of total employee in manually in challan with their gross wages and finally upload it
8th step: approve ecr file and download it
9th step: verify and pay online through same portal
thanks and regards,
5th January 2017 From India, Rajkot
Have attached the new ECR format for your reference.
Although, as you know, these Excel sheets are prone to lot of errors and is a very time consuming activity. The alternative to this would be to shift to a cloud payroll software. It takes care of all the grunt work, is a 100% compliant and drastically reduces processing time.
23rd January 2017 From India, Bengaluru
#AnonymousI UPLOAD THIS EXIT TEXT FILE (100564037783#~#17/12/2016#~#D) BUT IT SHOWS (File name should not contain any spaces) PLZ ANY OF ONE GIVE THE SOLUTION FOR THIS...
3rd February 2017 From India, Chennai