Online PF ECR File Creator for Payroll Excel
Techmin HR Solutions’ PF ECR File Creator helps employers and payroll teams prepare an ECR text draft from a structured Excel payroll sheet. Upload the required payroll columns, review validation results, calculate Employee PF, EPS and Employer EPF, and download a contribution-summary PDF.
This browser-based utility is not an EPFO portal or official government service. Contribution eligibility, wage ceilings, age-related pension rules and the final ECR format must be checked against current EPFO instructions before submission.
1. Establishment details
Enter these details in the Excel template before uploading, or fill them here after upload. They will appear on the PDF contribution summary.
2. Select wage period
3. Upload payroll Excel
Upload your payroll sheet and generate an EPFO-compliant ECR file instantly—ready for direct upload to the EPFO portal.
Use the Techmin Excel template with worksheet PF Data and only these 8 input columns: Universal Account No., Employee Name (As per EPFO/UIDAI), Gross Wages, PF Wages, Pension Wages, EDLI Wages, NCP/LOP Days and Refund of Advances. Employee PF is calculated by the tool as 12% of PF Wages, rounded to the nearest rupee. EPS and Employer EPF are then calculated by the tool. All age checkboxes start unchecked; tick only employees confirmed as above 58 years.
Supported: .xlsx and .xls. Your workbook is processed in this browser.