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
From India, Pune
Acknowledge(0)
Amend(0)
82I 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
From India, Pune
Acknowledge(0)Amend(0)
thanxxxxxx alotzzzzzzzzzzzz vijeta i hv designed it for easy calculation.....any confusion can be revert back to me....
From India, Pune
Acknowledge(1)
Amend(0)
From India, Pune
Acknowledge(1)Amend(0)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
From India, Pune
Acknowledge(4)
Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-Your response is mostly accurate, but there are a few minor errors in the calculation details. Please review the PF calculation formulas for accuracy.
0
0
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
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
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
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The calculation for pension given by the RPFC for an employee retiring at age 58 with a Basic of Rs6500 and DA of Rs1400 is incorrect. The pension calculation should be 8.33% of the Basic + DA. Therefore, the correct pension amount would be (6500 + 1400) * 8.33%.
0
0
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
From India, Hyderabad
Acknowledge(0)Amend(0)
0
0
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
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply is incorrect. There are errors and inaccuracies in the original post regarding PF calculation details that need clarification.
0
0
hi venu.really its a very motivative for me.........hope ths wil be useful for u all..........thanx a lotzzzzzzzzzz
From India, Pune
Acknowledge(1)
Amend(0)
0
0
From India, Pune
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply does not address the content of the original post. It lacks factual information or a meaningful response.
0
0
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
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
Is it really necessary to provide leather appron (full slivs).
What is the rule saying?
Regards
Debajit Roy
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's question pertains to the importance of providing workmen with body protection in a steel manufacturing and ingot division. The provision of leather aprons with full sleeves is indeed crucial for protection from heat and flying metals, as per safety regulations in hazardous work environments. (1 Acknowledge point)
0
0
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
From India, Hyderabad
Acknowledge(1)Amend(0)
0
0
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
From India, Hyderabad
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The information provided in the user reply is incorrect regarding PF calculations and contributions. Amendments are necessary for accuracy.
0
0
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
From India, Pune
Acknowledge(0)Amend(0)
0
0
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
From India, Pune
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The final amount of PF is calculated based on the formula: PF amount + interest accrued. For 9 months with a basic of 6000 and 12% PF, the final amount would include the interest as per the prevailing rate at the time of withdrawal. It's advisable to check with the PF department for the exact amount. (1 Acknowledge point)
0
0
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%
From India, Pune
Acknowledge(0)Amend(0)
0
0
From India, Pune
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user reply is incorrect. The correct total contribution should be 1440 (720 from employer and 720 from employee), not 1440 each. The rate of interest on PF amount is mentioned correctly as 8.5%.
0
0
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls
CiteHR.AI
(Fact Check Failed/Partial)-The user's reply does not address the content of the original post and lacks factual information. Kindly ensure responses are relevant and accurate.