pbskumar2006 Started The Discussion:
Dear Friends,

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.
19th February 2007 From India, Kakinada
Attached Files
Shared By Cite.Community Member "pbskumar2006"
File Type: xls bhavishyanidhi__pf_formats_989.xls (175.5 KB, 13920 views)

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.
21st February 2007 From India, Delhi
hI KUMAR, You have submitted a very good file for returns, keep up the excellent work. Thanks s
22nd February 2007 From India, Mumbai
please find the pf file... i am able to open this file...
22nd February 2007 From India, Pune
Attached Files
Shared By Cite.Community Member "vmandviya"
File Type: xls pf_calc_447.xls (175.5 KB, 5151 views)
dear,friend it is very useful article.thank u so much.keep posting. with regards and best wishes suresh(09247299593) sureshbabuhr@yahoo.co.in hr-executive
22nd February 2007 From India, Hyderabad
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 .
24th February 2007 From India, Nagpur
Mr Prasanth,

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.



25th February 2007 From India, Kakinada
Attached Files
Shared By Cite.Community Member "pbskumar2006"
File Type: doc employeesequalpf_101.doc (36.5 KB, 3111 views)
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 nextechssn@yahoo.com.

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.
26th February 2007 From India, Nagpur
Dear Prashant, Thanks for your valuable response. Will you please share your development software with our citehr friends. May be very useful for everone. Regards, PBS KUMAR
27th February 2007 From India, Kakinada
Dear PBS Kumar,

Thank You for showing interest in our EPF Management Software.

I am eager to share our software which took 3-4 years to develop with satisfying a lot of suggestion, queries & with practical experience of many HR Managers & concerned personnel with EPF.

By using this software (EPF Management Software) you have to enter monthly wages applicable to PF deduction for each employee. And all the calculations and reports generation will be performed by software. It will take only 10 minutes to feed 100 employees' wages in software.

By this feeding this information you can get following reports.

1) Monthly Challan (for remittance of PF in Bank)
2) Form 12A (for submission to PF office)
3) Monthly Register (for reference purpose)
4) Form No. 5
5) Form No 10

& By using this software month to month you can get all your annual returns will be ready at just click to save on you last month (Feb) wages which are following

6) Form No. 3A
7) Form No. 6A
& last
8)Reconciliation Statement for year

It means all returns required for PF will be done totally by software in a very few time & with 100% accuracy. (for e.g. if you having 100 employees, 10 min for 1 month, 120 for 12 months i.e. your complete yearly work about PF can be finished in just 2 hours)

Near about 150-160 organisation are using EPF Management Software, some of them multinational organisations.

To help atomization of PF work this is the best software and economical too.

Please contact us at nextechssn@yahoo.com for further information.


Prashant Patil
Marketing Manager
NexTech Software Solutions
27th February 2007 From India, Nagpur


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.

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network