Hi All, I have formualated Salary Structure Calculator for the use of our members in HR and Finance. Appreciate your comments/suggestions to make more effective and useful. Best Regards, Dada
3-Generate Salary Slip
4-Print Out Salary Slip
4-Track Employees' Leave history
5-Track Income Tax of All Employee
6-Print out Leave History of Employee
8-Master Data sheet of All Employees
9-Leave Calculation sheet
For more Free Excel Cration For Home/Office and Free Books visit
Free Excel Programs-Softwares-Books-Novels
in your excel sheet, with eample figures, the pf contribution amount of the employer seems incorrect- basic pay is Rs 20,667 and pf contribution which should be 12% (Rs2480) instead of Rs 780/ , pls advice
As per rule employer need to pay only up to 12% of 6500 if the basic pay is above 6500/-.
and as per rule employee also has 2 options
1.pay 12% of the basic pay or just 12% of 6500/- if his basic pay falls above 6500
2. he can make voluntary contributions too. But employer need to bother only up to the ceiling specified as per PF Act-ie 6500/-.
Let me know if not correct,thanks.
PF deduction issue:
the rule is that whatever the Basic + DA of existing employee(PF contibution purpose), employer has to pay 12% along with Emplyees share of 12% with other admin Exp.
no. 2 is that Employer's will contribute 8.33% to pension fund upto Rs. 541/- and rest of money will be diverted to employess provident fund.
hence wether empoyee earned basic + da to 6,500 or 10,000/- employer has to pay 12% plus admin chgs (0.5% & 1.1%)
hope i make u all clear
Why Vote? User validation is extremely important for good content to prosper.