Pf Deduction - Xls Download - Pf Deductions

i want to know about the salary details for deducting pf amount?can anybody reply me please
7th March 2010 From India, Madras

Refer this It may Help You

Please find new version of Salary Master with new Feactures..

Totally Usefriendly program.
You can enter your Company name,Address,Department,Designations
You can set Categoeries of Fixed earning-Other Earning-Fixed deduction-Other deduction in Salary Slip.
You can set limit of ESI,P.F,Income Tax Slab for Man and Woman,Surchage setting,Professional Tax.

Program is Designed on Two mode
(1) In Auto mode salary slip will be generated as per Your predefined data given in "Company Detail Sheet"
(2) In Manual mode Salary Slip will be generated as per Manual detail given by You.It will not concern with the data given by you in "Company detail sheet"
Ex: We need to generate salary for Regular Employee as per company Policy for that You may put this employees on Auto mode and it will generate Salary slip as per your predefined data (If Basic is 25% of Gross than auto calculate it)But Some Employees are Temperaroy or We don't Follow Rules as per Regular employee so that This Type of Employee Put on Manual mode and enter your Data manually(here You have manually enter Basic and other details).

Software Contains:

1-Attendance Register.
2-Payroll Register.
3-Generate Salary Slip.
4-Track Employees' Leave history.
5-Track Income Tax of All Employee.
6-Print out Leave History of Employee.
7-Overtime Monitor.
8-Master Data sheet of All Employees.
9-Leave Calculation sheet.
10-ESI Calculation(Set Your Requirements)
11-P.F Calculation
(Here there are Two Options one is if Basic<=6500 than Basic*12% otherwise 6500*12%
Second is 12% of Basic)
12-Pension Scheme (not more than 541 rs submission)
13-TDS Calculation
14-Annual Salary statement of Employee and Employer
15-Employer Monthly Salary statement
16-Income Tax Calculations
17-Generation of Form No-6 (For ESIC)
18-Generation of Form no-3A (PF)
19-Generation of Form no-6A(PF)

Limitation: You have monitor Leave of employee each month when It goes minius Red indication is glow on that cell so You have to Put it on LWP otherwise minus leave will effect on salary sllip generation.
Requied Attention: Please be vigilant about Auto and Manual mode and P.F Selection.

If You find this is useful for You than Don't miss to deop Thanks...

LINK: https://www.citehr.com/234112-salary...ml#post1062605
8th March 2010 From India, New Delhi

Pls find attached salary calculation sheet. I hope will help you. pls let me know your comments in to it
8th March 2010 From India, Delhi

Attached Files (Download Requires Membership)

Sample Salary Calculation Format.xls (50.5 KB, 2831 views)

pf contribution from employe 12% will be deducted from employer 12% will be contributed for admonstration charges employer contributed 1.67% extra so employer contribution is 13.67%
8th March 2010 From India, Hyderabad

No it is not required since leave encashment is not regular wage to deduct PF on it. Not only PF even ESI is also not required to deduct on leave encashment.
8th March 2010 From India, Hyderabad

Epf deduction should be made on the basic+da component of the wage.
In case of low profile employees or even causal labourers, the pf wage ( basic+da) should not be less than the minimum wages for the respective category for the respective area.
Prasiddh 9765664475
9th March 2010 From India, Karwar

Dear all If an employee joins today, when should I start deducting the PF. Whether first month or third month onwards? Rajarajan
9th March 2010 From India, Madras

Dear Challagolla,
I would like to correct as to the charges paid by the employer is 1.61% not 1.67%.
kindly find enclosed the details..
PF admin charge = Employer has to pay 1.1 % of basic
EDLIS: Employer has to pay 0.5% of basic
EDLIS admin charge :Employer has to pay 0.01% of basic
Total additional percentage employer has to pay: 1.61% of basic
So employer has actually to pay 13.61 % of Basic and employee has to pay only 12% of basic.
Employees complete 12% goes to PF account while employer contributions' 8.33% goes to Pension fund and 3.67% goes to PF fund.
Thanks and Regards,
Deepak Sabharwal
9th March 2010 From India, Gurgaon

Dear Team,
Any person who is for work of an establishment or employed through contractor in or in connection with the work of an establishment where salary is less than Rs. 6500/- pm (Basic+Da) and optionaly covered where salary exceed Rs. 6500/- p.m.
Shyam Pandirkar
9870166192
9th March 2010 From India, Mumbai

I don't know what is pf. First i need to understand the pf then i will send you information about pf. I think it means provident fund. It is suite able for you.
+Remediation Testing Equipmen
Mold Certification Training
9th March 2010 From Pakistan