firstname.lastname@example.org Started The Discussion:
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
Please find Attachment for Payroll,Attendance Program in Excel here You can trace
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
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.
good work! although u can improve it further by adding more allowances & Name of employee, other details along with co. name to make it more presentable & professional.
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
Found This Useful? +Vote Up This Page Via Google.
Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas
Topic Categories >> annual salary statement basic pay company profile data entry employers contribution esi limit excel formulas existing employee income tax Location-India-Bangalore minimum wages payroll sheet payroll system pf deduction salary break up salary calculation salary structure tax slab uk payroll Complete List Of Categories
Interesting Relevant Discussions