pbskumar2006 Started The Discussion:
The submission of Provident Fund Annual Returns for the year end are fast approaching. For easy tabulation of PF Annual Returns the enclosed attatchment may useful for every one. From this PF Returns made easy.
Bhavishyanidhi is Hindi language.
hi kumar ji, This .xls file is really useful in calculating pf annual returns. Thanks for sharing this.Plz keep it up in future. Ashu Gupta. Hr. Executive. Overseas Trade Linkers, Agra.
The .xls file you are using for the remittance of annual returns of provident fund is having many mistakes. For eg. it does not consider the fact that Pension Fund accounts has limit of 541 Rs. or 8.33 whichever is less. means if basic wages is 10000, in pension fund there will be only 541 Rs. maximum. And there are lot of mistakes in other retuns (forms) which is difficult to mention here.
But, you can use a software named as "EPF Management Software" for filling Annual retuns such as 3A,6A and reconciliation statement. It does not require to fill each form. Just fill form of 3A, & you other forms such as 6A & Reconciliation statement will be automatically ready without any extra work. It is also useful for Monthly Challan, Form No 12A, Form No.5, Form No. 10, Monthly Register. If you use software month to month your annual returns will be automaticaly ready after your last wages of the year (Feb). Please, contact me for further details at .
Thanks for your comment, However please the following details as given t-in the PF Act.
!) PF Return for Annual is (a) Form-3A and Form-6 only The Reconciliantion of challans are Annexure of Form-6.
2) The remaining things in the xl formate is PF returns supported document i.e. PF Return made easy.
Clarification about Contribution :
After revision in wage ceiling from Rs.5000 to Rs.6500 w.e.f. 1.6.2001 per month, the government will continue to contribute 1.16% upto the actual wage of maximum Rs.6500 per month towards Employees’ Pension Scheme. The employer’s share in the Pension Scheme will be Rs.541 w.e.f. 1.6.2001.
Under Employees’ Deposit-Linked Insurance Scheme the contribution @ 0.50% is required to be paid upto a maximum limit of Rs.6500.
The employer also will pay administrative charges @ 0.01% on maximum limit of Rs.6500 whereas an exempted establishment will pay inspection charges @ 0.005% on the total wages paid.
The above clarification is given by taking wages upto a maximum of Rs.6500 towards wage (basic+DA). Since an excluded employee i.e. drawing wages more than Rs.6500 can also become member of the Fund and the Schemes on joint request and if, for instance, such an employee is getting Rs.10,000 per month, his share towards provident fund contribution will be Rs.1200 e.g. 12% and employer’s share towards provident fund contributioin will be Rs.659 and Rs.541 towards Employees’ Pension Fund.
Mr. Pbskumar, Thanks for your reply
Your Clarification about contribution is good.
But my points as following,
1) If any employee is having salary 10,000, out of them only 8.33% on 6500 will go to Pension Fund i.e. 541. In .xls file provided by you if anyone enter 10,000 salary in basic column, in Pension Fund it takes 833, which is incorrect. You have not considered limit of 541 in Pension fund.
2) In form 3A, provided by you after entering wages in amount of wages column subsequent columns such as workers share, Provident Fund 3.67, PF 8.33 's value are not changing accordingly. (absence of formula)
3) If any company or establishment is having 50 employees, I have to enter their wages first into Emp.no.PF sheet & then copy (prepare) Form 3A for every employee mannually & after then add their total in Form 6A, sheet. there is not cross linking of sheets. It will take too much time. I think it will be not a proper way to make PF annual returns easily. It will be a laboures & error prone work, isn't it Mr. Pbskumar?
4) Your .xls file does not consider the employees age having more than 58 years (means no Pension Fund). There is no such facility of date of birth in it.
5) I know that monthly challan, Form 12A, are not annual. But if you enter wages month to month in software, the annaul returns will be ready after you feed wages for the month of Feb & with that you will also get reports & returns such as monthly challan, Form 12A. It means all PF work will be a computerised, automated & error free. Such software is developed by me & more than 150 organisation are using it with satisfaction, some of them are multinational organisations. For furhter infomation please contact firstname.lastname@example.org.
Finally there are numerous other points which cannot be described here due to lack of space, time & other many resons.
Your try is good by providing .xls file to make PF annual return easy, but I think it is laboures & error prone.
Found This Useful? +Vote Up This Page Via Google.
Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas
Topic Categories >> provident fund annual return pf withdrawal hr managers pension scheme form 3a form 6a pension fund excel sheets pf deduction exempted establishment pf annual return annual salary statement pf act pf return Location-India-Kakinada pf form annual returns Complete List Of Categories
Interesting Relevant Discussions