Notes: This Excel file contains Macro which creates text file which is used for uploading Provident Fund ECR.
Enable Macros, Enter data in sheet called' FINALâ€™. Be aware of the data validation Rules mentioned in the 'ref2' sheets. I have incorporated some of them in excel sheet itself. Run the macro â€˜createtextfileâ€™ from this('FINAL's)Sheet .You are prompted for a name for text file to be generated. Save the text file in a location suitable for upload.