Excel to ECR export

Dear All,

Many of us generate text file from Excel file to upload on EPF portal by following very tedious process:

1.compiling details in excel file
2.saving excel file in CSV format
3.open file in text file and replacing character to #~#, remove unwanted rows
4.save to text format
5.upload text file on EPF portal
6.if errors found then make necessary corrections in the excel file and again follow above steps.

Which is tedious and very time consuming process. To ease the process I have created excel file which save lot of time. Also rectification can be done easily on particular line item having errors.


This file can be used for generating monthly ECR text file, bulk KYC upload such as aadhar/ Date of Joining/ Date of exit/ bank/ PAN etc. 

Kindly download the file from below link, replace dummy data with your data. copy data from mentioned cell and paste it to new notepad file and then upload on epfo portal. 

If any challeges faced then let me know at pbw1980@gmail.com

Thanks and have a great day.
Prashant Wagh

search kyewords:
excel to ECR converter Free download , excel data to text in pf format , Bulk UAN upload, KYC upload format , Bulk aadhar upload to UAN , Bulk exit date upload

Comments

Post a Comment

Popular posts from this blog

Guide to Tax Saving Through National Pension System (NPS)

Image
Guide to Tax Saving Through National Pension System (NPS) [with illustration on tax saving for corporate employees] Tax Savings through NPS  One of the key advantages of retirement planning through NPS is that while saving for your future, you get to enjoy tax benefits today, as NPS comes with a unique mix of Tax advantages. We are presenting an illustration, which will provide you with a brief idea as to the amount of tax you can save under NPS. The illustration has been prepared with the following assumptions that: Assuming standard deduction NPS is your only Tax Saving component tax rate as per financial year 2018-19 Under the present tax regime, if your annual salary (basic +DA) is Rs. 4 or 10 Lakh; your contribution is Rs. 0.40/1.00 Lakh, you can claim the complete amount as tax deduction u/s 80 CCD(1) within the overall ceiling of Rs. 1.50 Lakh. But if your annual salary is Rs.20.00 Lakh and your NPS contribution is Rs.2.00 Lakh, ...
Read more