What Will Be The Deduction Amount Of Pf? - XLS Download

If the basic salary is 15000/-
then what will be the deduction amount of PF on
1)Employee Contribution
2) Employer Contribution- Pension (8.33 %)
3) Employer Contribution-PF (balance on 3.67 ).
Please advise on calculation with total deduction of PF amount.

Answer to your above queries
1) Employee contribution - Rs. 1800
2) Pension contribution - Rs. 541
3) Employer's share in PF - Rs. 1239
Abbas.P.S

HI,
Can change as per your requirement do let me know need any modification or any help . It was made by me If in case my Payroll wont work, so cant stop employees Salary
So invented a Format which really help to cross verify from payroll

i have already download File Type: xls SALARY SHEET May 2013.xls , but unable to open this ,because it is protect by password. kindly tell me pass word to open this file.

Hello Mr. Shyam Sundardas,
Please give me the password to open your salary excel sheet

Use this Excel sheet to make ECR

@preeta
you can visit this thread to get your excel
https://www.citehr.com/66182-mis-rep...ats-excel.html

Please give me the password to open your salary excel sheet
thank you.

Hi i tried to open file but unable to do so.Kindly provide password.

i have already download File Type: xls SALARY SHEET May 2013.xls , but unable to open this ,because it is protect by password. kindly tell me pass word to open this file.