Re: Pf Calculation Sheet In Excel - Xls Download

Hi Amith How are you? Wish you a very happy diwali. You have lots of good information that will help me lots. Thanks & Regards Akhil Asst.Mgr — HR & Admin
17th November 2007 From India, Kota

Thank you Manoj,
Very helpful contribution. If you have any other labour law's excel sheets please share with me.
I have good experience in the softskill activities but I think in HR I am lacking all these exposure, so i need your help to upgrade my knowledge.
pl help.
Regards,
Vishal Trivedi
09825413635
19th November 2007 From India, Kalol

During third party verification is there any chance that they can trace a company’s name and address details
13th July 2008 From India, Madras

During third party verification is there any chance that they can trace a company’s name and address details with PF Number provided
13th July 2008 From India, Madras

Hi payal
Please find enclosed attachment for deduction of PF and ESIC
For gratuity this is the formula
BASIC + DA [as applicable] *15*NO of year of service
____________________________________________

26
as per the acts applicable
best of luck
Santosh

22nd August 2008 From India, Mumbai

Attached Files (Download Requires Membership)

PF ESIC.xls (15.0 KB, 2391 views)

Dear All, Please Check the Calculation for P.F, I think we need to calculate by using the upper value of Basic & DA. Please check this and then move forward.
16th September 2008 From India, Madras

1LCI0001192109/18/2007Jitendra prasad MauryaCarpenterHighly Skilled07/24/1979Ram Awadh prasad4300363616206 397 198 198 198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04 1LCI0001192109/18/2007Jitendra prasad MauryaCarpenterHighly Skilled07/24/1979Ram Awadh prasad4300363616206 397 198 198 198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04

Sl. No.EMP. CODEDOJNAMEDESIGNATIONGradeDOBFather's Name Salary OT-01/07/08 to 31/07/08OT-01/07/08 to 31/07/08Total OTOT<=16 Hrs in a monthSite Allowance(OT>16 hours)Days Jul' 08Days Aug' 08 Earnings Deductions Net payable salary Net payable salary (Rounded) PF Wages Employee's Contribution Employer's contribution PF Admn Charges (1.10%) EDLI Wages EDLI Charges (.5%) EDLI Admin Charges (.01%) WDWD Basic ( Conv All Site All. HRA OT Project All. Total Earning PF (12%) Reg. amt Recv. Total Deduction EPF (12%) Total EPF (3.67%) EPS (8.33%) Total 1 198 662 827 2,480 48 48 2,432 2,430 397 48 48 15 33 48 4 397 2.00 0.04
16th September 2008 From India, Mumbai

Hi I have to design a qustionnaire on Compensation for management trainee.if anyone has format,please provide,would be really helpful.
18th September 2008 From United States, Plano

Dear friends,
Please help me on this issue as.
I was joined one company call elcome as network engineer at that time my Pf no. was MH-95817-A-187 . But after 6 mounth I was tranfered to another company called elcosoft and my probation increased and payrolled also changed. At this time new pf no. was given as xxxxxxxxx-026.
now perivious company elcome is not a part of elcosoft now. So they provied me new PF no.

Please guide me how can I confirm that my pf is not digest by company.

6th October 2008

Pl let me the percentage of contribution in PF either from Employer side and employee side and % of employers contribution in pension scheme and so on
22nd November 2008 From India