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

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

During third party verification is there any chance that they can trace a company's name and address details

During third party verification is there any chance that they can trace a company's name and address details with PF Number provided

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

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.

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

Hi
I have to design a qustionnaire on Compensation for management trainee.if anyone has format,please provide,would be really helpful.

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.

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