This is very simple and easy to prepare the ECR file, just login into the employer portal and download the ECR Instructions.
The format is attached for your ready reference, delete the first row when you enter the whole data then save the excel file as comma delimited, then replace all "," with "#~#" as per instruction file.
Hope above will help you.
10th April 2012 From India, Solan
10th April 2012 From India, New Delhi
Kindly give us the formula for each column
I have given the formulas as given belwo, pls tell me if it is correct:-
EPF Wages - Basic + DA
EPS Wages _ Basic + DA
EPF Cont (EE Share ) - 12%
EPF Cont (EE share remitted) -12%
EPS cont due - 8.33%
Eps cont. being remitted - 8.33%
Diff EPF & EPS - 3.67%
Diff EPF & EPS being remitted - 3.67%
Pls let us know where we should mention the admin charges of 1.1%, 0.5% & 0.01% resp.
Kindly reply ASAP
Thanks & regards,
10th April 2012 From India, Bharuch
EPF Wages - Basic + DA ok
EPS Wages _ Basic + DA There is celling Rs.6500.00
EPF Cont (EE Share ) - 12% ok
EPF Cont (EE share remitted) -12% ok
EPS cont due - 8.33% 8.33% up to 6500.00, maximum EPS amount 541.00
Eps cont. being remitted - 8.33% See above comment
Diff EPF & EPS - 3.67% If basic and DA =<6500 than ok
Diff EPF & EPS being remitted - 3.67% See above comment
Pls let us know where we should mention the admin charges of 1.1% (of EPF Wages - Basic + DA), 0.5% (EPS Wages _ Basic + DA) & 0.01% (EPS Wages _ Basic + DA) resp.
Mukesh Kumar Saini
11th April 2012 From India, Bareli
All formulas seems okay except the following:-
1) EPS wages = if(basic+da>6500,6500,basic+da)
2) Diff EPS & EPS = EPF Cont (EE Share )- EPS cont due - 8.33% i.e. 3.67% but sometimes higher due to 8.33% on max. 6500.
The admin charges A/c 2 @ 1.1, A/c 21@ 0.5% on Max, 6500/-and A/c 22 @ .01% are to be calculated mannually and will be enter later when you proceeded for ECR upload.
Hope the above will help you..............
14th April 2012 From India, Solan
I m quite confuse to prepare the text file with the specified ECR Format because for the employee's who are under non EPS what's the content for EPS Contribution due. Also i need the formula to calculate the columns content like EPF Contribution due,Eps contribution Due etc.Will you please post ur uploaded file it would really helpful for us. Waiting for ur post........
23rd April 2012 From India, Madurai
If you see
Dear Employers !!
EPFO Launches online receipt of Electronic Challan cum Return (ECR) from the Month of April 2012 (March paid in April). Employers are requested to Register their establishments and create their user id and password through this portal. The registered employers can upload the Electronic Return and the uploaded return data will be displayed through a digitally signed copy in PDF format. It will be available for printing also. Once approved by the employer online Challan will be popped based on uploaded return. The employer may choose to make the payment through internet banking of SBI or take a print out of the Challan and pay at any designated branch of State Bank of India (SBI).
> No paper return to be prepared and submitted to EPFO.
> No need to submit other returns viz Form 5/10/12A,3A and 6A.
> Employers will get the confirmation of payment through SMS instantly.
> The contribution will be credited to the members' account on monthly basis.
> Employers can view the annual accounts slip for accounting year 2011-12 online.
> For earlier years employers can request for the annual slips through this portal.
Employer Registration starts from 20.03.2012
5th May 2012 From India, Delhi
We are doing the EPF, ESI related works of various organisation on Outsourcing basis. The work like ECR preparation from Raw data, Recover the old data lost on E-Return Tool, ESI Challan preparation(Excel file upload), conversion of PDF documents to word or excel file, data entry...etc. So please contact me for any of the related works mention above @ low charge.
Arun Vignesh N
Executive-HR & Personnel
30th October 2013 From India, Coimbatore