Pbskumar2006
Sr.manager-hr
Kewal.kumar
Human Resorce
Vmandviya
Salaried
Ashu Gupta
Manager Hr & Personnel
Varsha_pink
Hr Executive
Cravi_pdy
Software Consultant
+11 Others

Thread Started by #pbskumar2006

The submission of Provident Fund Annual Returns for the year end are fast approaching. For easy tabulation of PF Annual Returns the enclosed attachment may useful for every one. From this PF Returns made easy.
19th February 2007 From India, Kakinada

Attached Files
Membership is required for download. Create An Account First
File Type: xls bhavishyanidhi__pf_formats_989.xls (175.5 KB, 14782 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
please find the pf file... i am able to open this file...
22nd February 2007 From India, Pune

Attached Files
Membership is required for download. Create An Account First
File Type: xls pf_calc_447.xls (175.5 KB, 5490 views)

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.

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


25th February 2007 From India, Kakinada

Attached Files
Membership is required for download. Create An Account First
File Type: doc employeesequalpf_101.doc (36.5 KB, 3235 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.

Regards

Prashant Patil

Marketing Manager

NexTech Software Solutions
27th February 2007 From India, Nagpur
Hi, The excel Sheets for annual return are excellent. These forms will help all of us for easy and fast calculation. Thanks for forwarding. Regards, Varsha
27th February 2007 From India, Pune
This is the original message i received by Mr. PBS Kumar on 27th Feb 2007

....start(

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.....
.....end)

For that My reply is

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

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 for further information.

Regards

Prashant Patil

Marketing Manager

NexTech Software Solutions......
27th February 2007 From India, Nagpur
All citeHR members,
IF Annual returns of PF is wrongly submitted it brings a lot of difficulty to you and your organisation.
If actual due is shown more than the payment remitted by you will attract 17% to 37% damages, penalty & interest to basic amount.
It isnt really a damages?
Regards
27th February 2007 From India, Nagpur
Hello,
I am tried to use this file to make pf annual returns. But I think it is not a easy task. Mr. prashant patil is saying correct that there is absence of formula & other things.
Can anyone suggests me more easy way to make PF annual returns?
Preeti Agrawal
6th March 2007
Hi
We are from dynotech Sotware. We would like to introduce ourself we have been doing outsourcing work for various applications for last 10 years. Now submission PF Annual returns form3a, form6a, we may have to submit in another 2 months time.
we will be able to migration and do this type of report within single day. what ever data you are having in any format.
If anyone wants to complete this type of work, please call me 094436 16603
19th February 2008 From India, Pondicherry
Dear Mr. Patil,
Could you please forward the details of your software and the price on my email ID please?Thanks and best regards. Nrupesh
31st May 2008 From India, Delhi
hi this is purush posting for the first time. I do have some difficulties in preparing the annual and monthly reports. i would be interested in getting the software mr.prasanth is telling. for further details please mail me at
31st May 2008 From India, Madras
Dear Sir, It’s very good posting from your side, You are a very good guide for new entrance. Regards, Anil Bhoite
2nd June 2008 From India, Mumbai
Dear sir, kindly to be send me PF Annual Returns format How can paper required Best Regards Selvaraj
2nd July 2008 From India, Bangalore
Mr. Prashant can you telll me in 3-A, and 6-A.. do we have to enter actual wages or contribution limit wage as 6500/-.
21st July 2008 From India, Jaipur
Dear Friends,.............In that you have to submit Form 3A & Form 6 for Annual retures to be submit to the PF Office.Regards,PBS KUMAR
7th August 2008 From India, Kakinada
:icon1:Hii.. I'm also request you to attach the content what you have in your software, it may very help full to our HR Community to do their duty without error and save their time and they grow very shortly.
regards
Lingaraju.N

24th October 2008 From India, New Delhi
Dear Prasant ji,I tryed its more worthy, but its dom version. How to get the full version please.REgards,PBS KUMAR
16th March 2009 From India, Kakinada
Hi, Please help to tell me How can I open the attachments? When I click on it, it has been asked for username and password. I am helpless to use these attachments, ....please help
29th January 2010 From India, Ludhiana
hi,
i am very new to this PF & would like to know abt PF transfer & withdrawal of employees. please let me know the procedure. For PF withdrawal we need to submit 19 & 3A & pf transfer we need to submit form 13. few of our employees are asking for transfer & few are asking for withdrawal. i want to know abt
1. PF transfer from old employer to new (our co.) employer
2. Pf withdrawal of resigned employees.
3. PF transfer to new employer of resigned employees from our organisation.
if anyone provide these details, i would be greatful to them. plz send to my personal id
18th May 2010 From India, Bangalore
Hi Kumar,
Since i am finding very difficuilt in preparing form 3A, 6A & 12A i thought yr excel sheet would help me out but unfortunately i failed to open the sheet which you 've attached. Could you please help me out?
Aside Mr. Prashanth,
As Kumar said y don't u share yr software wit everyone? if u r so keen on the points which u 've mentioned then let everyone 've yr software, which makes work easy. wat say!
4th August 2010 From India, Mumbai
Pls help me know that pf annual return is submitted for each employees separetly,pls help.
6th October 2010 From India, Mumbai
hi friends; i m new to H.R. field,just joined recently. Can you pl suggest where i can find complete detail of filing P.F. and E.S.I returns bipin
30th November 2010 From India, Chandigarh
Hi Everyone, I just want to know What are all the documents to be attached with While enclosing the PF Annual & Half yearly returns to PF authorities Regards, Selva
26th December 2012 From India, Chennai
how to calculate man physical working days and absent days please send in excel format
10th February 2017 From India, Bangalore
#Anonymous
Dear sir, please send PF & ESI brief. Thanks & Regards Sriram
25th February 2017 From India, Varanasi
#Anonymous
how could i know wether we are exempted or un exempted to bill filed annual Return for provident funds
25th October 2017 From India, Hyderabad
Dear All,
Kindly let me know that do we still need to file PF Annual return? as we are raising challan every month, if we still need to file pf annual return kindly let me know how to do it please...
13th April 2018 From India, Suri
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™