#query {background: #ebf5fd; color: #4f4f4f; letter-spacing: 1px; padding: 5px; border: 1px #001b31 solid; text-indent: 3%; font-size: small;} form#search_query { color: #FDFCFB; text-align: left; margin: 0px; }
Abhi16march
Manager Hr
Chandu0147
Employee
ShaliniAmit
Hr Professional
Darshan.palkar
Mba-biotechnology,hr
Patroap
Service
Saurav1314
Payroll,hr-shared Service
Mugeshm
Working
Gopala_hr
Hr Executive
Jpyadav8792@gmail.cm
Hr Assistant Manager
+13 Others

Thread Started by #abhi16march

Dear All,
I m submitting herewith the combined sheet of PF calculation sheet and challan sheet in excel format as per requirement of our some HR felloz.Hope it will be useful for you.

Provident Fund :

Note :PF always calculated on BASIC + DA
Total PF contribution : 25.61%

Employers Contribution :12% (3.67% PF +8.33%Pension) +1.61%Administrative charges (1.10% Adm charges +.50 % EDLIF Charges) =13.61%

Note: Pension value 8.33% is always constant whther PF value can be variable depending on the Basic & DA
Pls study following cases:

Case :1 if Basic + Da = 6500 then then contri wil be like ths Pension 8.33% ( 541) and PF value wil be (239)

Case II 1 if Basic + Da > 6500 then then contri wil be like ths Pension 8.33 %( constant value 541) and PF will be : exess amount - 541 as exp IF Basic + DA is 12000/- then it wil be like ths Pension will be 541/- and PF will be 899/-
( cal.: 12000*12% -541 = 899/-)

Case III : if Basic + Da < 6500 then then contri wil be like ths Pension 8.33% and PF 3.67% of basic +DA
Exp : if basic is 5500/- then Pension wil be 5500*8.33% =458 and PF will be 5500*3.67% = 202/-

Employess Contribution:12% goes to PF amount only.

PF Calculation Sheet:
1.Mention your location name if existing
2.No of empls elidgible for PF
3.PF salary ths is Basic + DA amount
4.Emps contri 12% fix value
5.Emplrs contri for PF Variable ( calculation has defined above)
6.Emplrs contri 8.33% fix value
7.PF>6500 means Basic +DA >6500 ( See case II)

Some other useful info regarding PF:
Form No. Purpose

13 (revised) For transferring the Provident Fund account of a member from one establishment another establishment covered under the act / scheme

19 To be submitted by a member to withdraw his Provident Fund dues on leaving service/retirement/termination.
10-C For claiming - Refund of Employer share.( with form no.19)
10-D To be submitted by the first claimant i.e.- member or - widow/widower or- orphan nominee as the case may be
31 For the use of Provident Fund members to avail advances / withdrawals as provided in the scheme
Rate of Interest:8.5%

Note :Formula are given asked pls whre r u confused and if stil confuse then I ll submit a demo sheet……pls revert back to me

Thankx
8th August 2008 From India, Pune

Attached Files
 Membership is required for download. Create An Account First PF CHALLAN & CALCULATION SHEET.xls (34.5 KB, 33474 views)

thanxxxxxx alotzzzzzzzzzzzz vijeta i hv designed it for easy calculation.....any confusion can be revert back to me....
9th August 2008 From India, Pune

Provident Fund :

Note :PF always calculated on BASIC + DA
Total PF contribution : 25.61%

Employers Contribution :12% (3.67% PF +8.33%Pension) +1.61%Administrative charges (1.10% Adm charges +.50 % EDLIF Charges) =13.61%

Note: Pension value 8.33% is always constant whther PF value can be variable depending on the Basic & DA
Pls study following cases:

Case :1 if Basic + Da = 6500 then then contri wil be like ths Pension 8.33% ( 541) and PF value wil be (239)

Case II 1 if Basic + Da > 6500 then then contri wil be like ths Pension 8.33 %( constant value 541) and PF will be : existing amount - 541
> As exp IF Basic + DA is 12000/- then it wil be like ths Pension will be 541/- and PF will be 899/-
( cal.: 12000*12% -541 = 899/-)

Case III : if Basic + Da < 6500 then then contri wil be like ths Pension 8.33% and PF 3.67% of Basic +DA
Exp : if Basic is 5500/- then Pension wil be 5500*8.33% =458 and PF will be 5500*3.67% = 202/-

Employess Contribution:12% goes to PF amount only.

PF Calculation Sheet:
1.Mention your location name if existing
2.No of empls elidgible for PF
3.PF salary ths is Basic + DA amount
4.Emps contri 12% fix value
5.Emplrs contri for PF Variable ( calculation has defined above)
6.Emplrs contri 8.33% fix value
7.PF>6500 means Basic +DA >6500 ( See case II)

Note :Formula are given in sheet and Pls ask whre r u confused and if stil confuse then I ll submit a demo sheet……pls revert back to me

Thankx
12th August 2008 From India, Pune
Dear
Thank you for the nice information given by u. It is very simple and short which can be understood by the majority of the people.
One thing i want to know more if you can help me out.
what will be the the calculation of pension given by the RPFC for an employee who retires on attaining the age of 58 and his basic salary is Rs6500 and DA is Rs1400.
It will be very much useful to me if you can revert.
Many thanks
regards
Bhupesh Joshi
13th August 2008 From India, Mumbai
Hi tiwari
Thanks a lot , the information which is provided by u is excellent , it has all the clarities and a new person can follow the sheet
Once again I thank u for providing me the details of PF calculation
Regards
Venu
13th August 2008 From India, Hyderabad
hi venu.really its a very motivative for me.........hope ths wil be useful for u all..........thanx a lotzzzzzzzzzz
13th August 2008 From India, Pune
Ours is steel manufacturing and ingot division. I want to know the importence of workmens' body protection from heat and flying metals.
Is it really necessary to provide leather appron (full slivs).
What is the rule saying?
Regards
Debajit Roy
14th August 2008 From India, Mumbai
Dear All,
This is chandra sekhar, (HR/ Dept.)
Thanks for pf calcu. sheet.to Mr.Abshiek tiwari, I had made sample of sheet with has been used for our company in a sample format purpose i hope you like this & it may helpfull to all.

Regards,
Chandra sekhar
HR.executive
(ROSHNI DEVELOPERS/ INDU GROUP)
9848335631/ 9963144154

14th August 2008 From India, Hyderabad

Attached Files
 Membership is required for download. Create An Account First Calcu. pf Emp.eps.epf sample sheet for HR site..xls (28.5 KB, 2587 views)

Dear Sir,
I want to know how final amount of PF is calculated including the interest rate
my kast basics was 6000 & PF was 12% i.e. 720
i worked there for 9 months
Then i want to calculate the final PF amount that i will gate
i have submitted PF withdrawal form.
Please informed me if you know this
Thanks for your posting
Darshan Palkar
Pune
14th August 2008 From India, Pune
Dear Mr.Darshan, gud quest Your contri wil be like ths Empr 720/- Emp 720/- total contri 1440/- PM Note: Rate of interest on PF amount is 8.5%
14th August 2008 From India, Pune
As askd by sme of my HR felloz regarding forms and Rate of interest. Pls find the following details.
Form No. Purpose

13 (revised) For transferring the Provident Fund account of a member from one establishment another establishment covered under the act / scheme

19 To be submitted by a member to withdraw his Provident Fund dues on leaving service/retirement/termination.
10-C For claiming - Refund of Employer share.( with form no.19)
10-D To be submitted by the first claimant i.e.- member or - widow/widower or- orphan nominee as the case may be
31 For the use of Provident Fund members to avail advances / withdrawals as provided in the scheme
Rate of interset : 8.5%
14th August 2008 From India, Pune
Dear Abhi, Could you tell me something about the withdrawal of PF fund. Which part can be withdrawn and what are the necessities to withdraw. Thanks & Regards Rakesh Bisht
14th August 2008
Dear Abhisekh Sir,

I am working in HR Dept. I am new to PF field. Cud you clear some of my doubts as under.

1. Is there any eligibility Age limit & for an employee for PF contributions & Pension contribution ? if, so. how much?

2. Wht about the deduction applicablility of PF & Pension for EEs. geting more than 6500 basic+da.

3. Wht about the deduction applicablility of PF & Pension for EEs. more than 58 yrs.

4. Our company has no basic limit for PF remittance purpose.

Kindly Help..
Regards.

Arabindo Patro.
09379187533
14th August 2008 From India, Mumbai
heyii patro sure i ll send u .......asap...........nd thanx for ur appreciation...ur many queries will be solve pls read the total article..........and all other detail i ll send u .. thanx
14th August 2008 From India, Pune
Hi Abhisek, Good and very usefull for all new comers, I would apprciate if you could focus on gratuity and benefits to employees. Regards, Ravi
14th August 2008 From India, Hyderabad
Dear Mr.Abhi
If an employee is willing to contribute more percentage of amount to PF up to what limit he can contribute and what is the formalities to be met if an employee willing to contribute more percentage than 12%.If an employee whose salary is more than 6500/- month and not willing to contribute for PF is there any provision available for him for doing so.If So How?
Regards
Suman

14th August 2008 From India, Hyderabad
Dear Abhi,
thanks a lot for the information u hv provided....
Let me introduce myself first of all....my name is DIPAK. I am a post graduate guy with a specialization in H R. did my p g from gujarat university....I am from AHMEDABAD....recently got an assignment in one U S pharma company....
Thanks a lot for the detailed information ....be in touch ....my personal id is ...
thanks once gain...
take care...HAPPY INDEPENDECE DAY, HAPPY RAKHI & HAPPY WEEKEND BUDDY......:-D
15th August 2008 From India, Ahmadabad
Dear Abhishek,
thanks a lot for ur PF calculation divisions and examples. Which really helped me and cleared my long days confusion and doubt. Once again thanks a lot for ur help.
Regards
Gopal.

18th August 2008 From India, Mumbai
Hello,
Could you please let me know about the P.F. registration rules at the earliest..
1) Is it that if the co. has flat 20 employees - registration is mandatory irrespective of basic
OR
2) Is it that employees whose basic is < 6500, if such 20 employees are on roll then we have to register for PF
OR
Is it that now the 6500 slab is revised to Rs. 10,000 for the IT sector.
Could you please give me details of any site which will give latest PF rules.
Your help would be of great significance.
Thanks,
Shalene
20th August 2008 From India, Mumbai
As per new amendment, 10 employees then registration is memdatory, current maximum Basic+DA limit is Rs.6500/-PM one can take permission to pay above 6500/-p.m.
The slab for IT sector I belive is the same.

21st August 2008 From India, Ahmadabad
As per rules, 10 or above employees then registration is memdatory, current maximum Basic+DA limit is Rs.6500/-PM after 6500/- amount automatically calculation will be done. They no such rules. to pay above 6500/-p.m.
because. Already i am working on it. Mine is construction co. and I had made several sheet & already in the sheet with was attached to every one subcribe related to Hr cite. it was done by me. not by abhi.

Chandra sekhar.
HR exective..
22nd August 2008 From India, Hyderabad
Can i tell u one thing pf sheet has been sent by me.
sorri to say abhi as posted one sample sheet. In the same for i had corrected cleared with the adminstration charges given with the proper challan copy. where i had already highlighted my name in the pf wages sheet as K.Chandra Sekhar.
22nd August 2008 From India, Hyderabad
Chandu: As you said you cannot download the pf sheet.
I just sent you the attachment coopy with the excel statement.
Maid id: for the info. mail me
ok
Regards,
Chandra sekhar.
9848335631/ 9963144154.
22nd August 2008 From India, Hyderabad

Attached Files
 Membership is required for download. Create An Account First Calcu. pf Emp.eps.epf sample sheet for HR site..xls (28.5 KB, 546 views)

pl answer to my query/ whether PF deduction is to be made under PF Misc Provision act, if the payment is less than Rs.6500/-.
22nd August 2008
Dear all Let me know how to apply pf for employees, what are all the documents we need to submit
27th August 2008 From India, Madras
Hi,
This is chandra sekhar. As you had the calcu. wages sheet wich done by me. and you where asking about pf apply for employee. if you got my send copy of calc.sheet in i had added some names. after that you need to added to your name of employee who is new comers to your co. and relaised the pf.no once then and give him a form Employees provident fund organisation which include the form allotment SSN will be given and given this particulars to your pf. consultant. we will regularised the pf no. aslo.
or
IF ur asking for PF with drawl apply means.
You need to fill form of
1) Form 19* EPFSchmene 1952
2) Form 10 c- (eps) *EPS 1995 & with this attach copy of SSN FORM.
Regards,
Chandra sekhar.

9848335631
29th August 2008 From India, Hyderabad
Hi all,
I have some bsc queries..plz throw sm lite.
> Are there any slabs in pay structure for deducting PF?(means any minimum/maximum basic salary amt,less than which PF can't b deductd)
> how to prepare a salary structure for a new joinee supposed to get a in hand salary of 10,000(plz show wd example).
> lastly,what are the rules & regulations for esi..how it wd b deducted from mnthly basic pay and is there also a minimum & maximum salary limit too for esi??
im waiting 4 feedback of all my helpful friends on citehr..
31st August 2008 From India, Delhi
Hello friends,
I want to enter in share market pl. give guidens me, e.g. how to open account, how to purchase share, how to analyies market condition & company information, what in divinded calculation & on which value is paid.
Thanks in advance.
31st August 2008 From India, Kolhapur
Hi Dear, But what to do in the calculation sheet PF>6500 SHUOLD we enter as 1 or 12000? Please confirm this.. otherwise you have done a gr8 work thnkx a lot...:icon1: Priya
13th October 2008 From India, Bangalore
Thanx nayan,priya,chandu,brinal ,bhatti and thanx to all of u....for ur appreciation................... Priya pls see case III.or wat exactly u want to kno pls specify......i ll let u kno........
14th October 2008 From India, Pune
Abhi in the xls there a cloumn whr its mentioned pf>6500 what shuld we enter in tht column?:icon1: abhi if u dont mind can i hav urs any other mail id so tht i can be in touch with u 4 any queries.. thanks a lot again...
Priya

20th October 2008 From India, Bangalore
Dear Abishek Tiwari,
It was really useful, thanks for sharing
Please let me know that what i should mention in the 7th column (PF>6500), i mean i am asking the exact figure that i should put if my Basic plus DA is equal to Rs.13802/-
Should i put Rs.7302 which is the excess difference between my actual salary and Rs.6500? Kindly confirm
Thanks,
Venkat
21st October 2008 From India, Madras
May i know how many employee should requried for deducting PF & ESI and what should be Salary amount ?
13th November 2008 From India, Delhi
Hi Abhi
thanx for your help, but one more thing i would like to clear what is the full form of EDLIP( A/c 21 = Total basic*.50% Which is the part of administrative charges of employer side)
Abha Singh
28th March 2009 From India, Mumbai
Hi Abhi
thanx for your help, but one more thing i would like to clear what is the full form of EDLIP( A/c 21 = Total basic*.50% Which is the part of administrative charges of employer side)
Abha Singh
28th March 2009 From India, Mumbai
Hi to all,
Instead of using excel for PF challans and other returns the software is very easy and good way. That kind of software can be downloaded from http://www.nextechss.com/EPF30Installer.exe
13th May 2009 From India, Nagpur
good job but need some modification in the format and please change the word "OFGANISATION" it is ORGANISATION, and other wise Good.
19th June 2009 From India, Mumbai
Dear HRfriends All of you are doing great service to our HR community. I ve been immensely benefitted . Kindly do one more favour by sending me the ESI Declaration in Form No. 1 Thanks Regards Kumar
27th June 2009 From India, Hyderabad
Hi Dear I have put some formula for 6500 clause,you have to put basic,rest every thing will get calculated.Please let me know your view. Thanks Saurav
2nd August 2009 From India, Madras

Attached Files
 Membership is required for download. Create An Account First pf cal.& challan.xls (49.5 KB, 360 views)

Hello Everyone,
I have question that my company is small scale company and we are 10 people.
We want to start PF.So can you tell me that can we start it? if yes then what is the process and if not then why?
Plz ans me.
Regards
Deepali
10th October 2012 From India, Pune
Theres lot of consusion with many organization where some take 12 % as EE and ER and some 12 % as EE and 13.61 % as ER, What is the present rate of % for EE & ER as per laws
1st March 2013 From India, Bangalore
Dear Sir, how can i fill esic monthly challan from salary sheet send me all data step by step. Regards Gaurav Mehta
1st June 2013 From India
Please advice on how to calculate PF if the basic salary is 15000 per month and also advice eligibility to get PF in karnataka
10th May 2017 From Oman, Muscat
Sir
Mery id pe daunlod nahi hota

14th October 2017 From India, New Delhi
Dear Sir,
Would somebody would provide one sample Excel sheet of PF contribution of employer and employees under different AC no for the month of January -2018 ,
Regards
Bijay

19th February 2018 From India, Bhubaneswar
kya feb and march 2017 ke liye bhi iss excel sheet ko use kr skte hai if no plz update and snd new version.
8th April 2018 From India, Moradabad
please send new format for pf contributions uploading files
13th April 2018 From India, Vijayawada
sir
please update with information for EPF send the new rates list for epf
thanking you
8427974037
28th June 2018 From India, Nabha
i am a private school teacher my total salary is Rs9000 i want to calculate epf on Rs6500 ,is it possible or not.
1st June 2019 From India, Lucknow

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™