Re: Pf Calculation Sheet In Excel - Xls Download

Hi,
Can any ome help me in having one standard leave application form to avail pl cl and sl.

Sub: Bonus received letter format
Dear All,
can you please send received format of bouns letter which has good emphasis on recognizing the contribution made by employees and rewarding them on the basis of that.
Durga

Hi payal,
As per my opinion the EPF = is calculated 12% of Basic and hat would be the amount come, same amount would be added from employers side. ie. if the EPF comes "X" then the amount go in the employees account would be "X+X" every organization whose no of employees is more then 20 must registered EPF.
For ESI = Employees whose salary is more then 6500 and less then 10,000, falls under ESI. the deduction are
Employees' contribution - 1.75% of Basic
Employers contribution - 4.75% of Basic
and the employees whose Basic salary is more then 10,000 for them Pf is optional.
W
Regard,
~ Ashi

dear payal,
Now this limit is changed. Now this limit goes up to 15000. If any employee whose gross is under 15000, will be liable for ESI deductions.
To the excell sheet provided by grhrm, please apply a condition that If Gross > 10000, ESI contribution is Zero. So that it can directly read Zero value for people having salary greater than Rs.10000
Truly Yours,
Kumar.H.P[/QUOTE]

The excel sheet is wrong in because employers contribution to PF is not 12% . Along with 12% you need to add 1.61 as admin charges.
PF ceiling is 6500 not 10, 000. and ESIC ceiling is 15000.

Please provide information as follows for one day as per central government rules in madhya pradesh for B & C zone
Basic. 231 b zone & 186 for c zone
EPF. employee contribution
EPF Employer contribution
ESIC employee contribution
ESIC employer contribution
Workman compensation for Zone 'C' for each employee
January days are 31
February days are 28

hi am working at 9 month in one company, my PF deduction 1217, PF forms send to office, please need to answer how much credit in my account .

required formula of pf calculation for salary register
if Basic 15000 , less than 15000 and above 15000
one formula for all these rules.

New unified epf portal says to mention gross salary and epf wages. Edli and administrative charges to calculate on gross or epf wages please confirm for employers

How to calaculate Salary arrears w.e.f April 2017.
If it includes the cutting of ESIC , PF and LOP.
If yes pls send me the excel calculator for that...if found...