P.F ANNUAL RETURNS - Excel Sheets
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Labor & Employee Relations

P.F ANNUAL RETURNS - Excel Sheets

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.

Regards,

:)

PBS KUMAR

Bhavishyanidhi is Hindi language.


Attached FilesProvided by community member pbskumar2006. Join us to learn and grow with your peers.
File Type: xls bhavishyanidhi__pf_formats_989.xls (175.5 KB, 11409 views)
shreepad - Member Since: Dec 2006
Dear Kumar, Can u Plz send the format to my personal mail ID. I would like to have it at shreepadkulkarni@gmail.com Thanks in advance. regards, Shreepad

Ashu Gupta - Member Since: Feb 2007
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.

asdnats - Member Since: Dec 2006
hI KUMAR, You have submitted a very good file for returns, keep up the excellent work. Thanks s

vmandviya - Member Since: Feb 2007
please find the pf file... i am able to open this file...


Attached FilesProvided by community member vmandviya. Join us to learn and grow with your peers.
File Type: xls pf_calc_447.xls (175.5 KB, 4501 views)
sureshbabu - Member Since: Jan 2007
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

prashant_patil - Member Since: Feb 2007
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 .

pbskumar2006 - Member Since: Mar 2006
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.

Notes:

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.

Regards,

PBS KUMAR


Attached FilesProvided by community member pbskumar2006. Join us to learn and grow with your peers.
File Type: doc employeesequalpf_101.doc (36.5 KB, 2901 views)
prashant_patil - Member Since: Feb 2007
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.

pbskumar2006 - Member Since: Mar 2006
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



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

Interesting Relevant Discussions


DISCUSSSION STATISTICS


2
LIKES

29581
VIEWS

48
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network