Question no. 1 regarding PF:
Formula applied in excel sheet for employee contribution of 12% is Pf@12% of 15000/basic?
So should i calculate it as 12% of 15000 even if basic is 20k or 25k?
Q.no.2 regarding Payroll :
Please share the excel sheet in which the formula is already applied on an excel sheet for employee and employer PF contribution as per the current total percentage of employee i.e., 12% and for employer?
Q.no. 3 regarding PF:
After the amendments in the PF Employer contribution in April what is the total percentage on which employer contribution calculation has to be done and if its 13% or 13.16% whats the break up values of EPF, EPS, EDLI and admin charges ..etc. ?
From India, Delhi
1Formula applied in excel sheet for employee contribution of 12% is Pf@12% of 15000/basic?
So should i calculate it as 12% of 15000 even if basic is 20k or 25k?
Q.no.2 regarding Payroll :
Please share the excel sheet in which the formula is already applied on an excel sheet for employee and employer PF contribution as per the current total percentage of employee i.e., 12% and for employer?
Q.no. 3 regarding PF:
After the amendments in the PF Employer contribution in April what is the total percentage on which employer contribution calculation has to be done and if its 13% or 13.16% whats the break up values of EPF, EPS, EDLI and admin charges ..etc. ?
From India, Delhi
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
1. Yes you can calculate on 20k or 25k, if this is the basic salary for employees. 3. Its 13.61% EPF 4.33% EPS 8.33% EDLI .5% EDLI admin charges 0.01% EPF Admin Charge 1.1
From India, Mohali
From India, Mohali
Salary Sheet & PF PT Calculation & Challan Nov 2010.xls