Salary Structure Calculator - Pf Deduction
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Forms, Formats & Questionnaires

Salary Structure Calculator - Pf Deduction

View Poll Results: Whether this tool is useful & user friendly?
Yes 233 90.66%
No 3 1.17%
Cannot Say 21 8.17%
Multiple Choice Poll. Voters: 257. You may not vote on this poll


dada.ignou@gmail.com 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


Attached FilesProvided by community member dada.ignou@gmail.com. Join us to learn and grow with your peers.
File Type: xls Salary Structure Calculator.xls (37.5 KB, 15315 views)
kapi_dha - Member Since: May 2007
Dada, This is really a great inputs......Very helpful sturcture to design the cost. Keep posting

jiguparmar - Member Since: Dec 2008
Please find Attachment for Payroll,Attendance Program in Excel here You can trace

1-Attendance Register
2-Payroll Register
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
7-Overtime Monitor
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

raghuvirks - Member Since: Feb 2010
dear dada,
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
thanks
raghuvir

nutangonehalli - Member Since: Oct 2009
The salary module is fantastic It is very good for small concern who have lts of adjustments.

hr@techwyseintl.com - Member Since: Oct 2008
Quote:
Originally Posted by raghuvirks View Post
dear dada,
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
thanks
raghuvir

Raghuvir,

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.

Thanks
Bindu

husain6285 - Member Since: Feb 2010
your calculator never gets downloaded ..........its in bad format i guess .Kindly post the files in a format that can be easily downloaded Thanks

kalapu - Member Since: Feb 2007
To all the contributors, This is a great effort and i appreciate one and all. Keep it up. Regards Chakradhar Reddy

manishgupta1981 - Member Since: Jan 2010
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.

to Bindu:
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

Manish Gupta

dada.ignou@gmail.com - Member Since: Apr 2009
Hi Husain, It is excel 97-2003 format, it will work with version MS office 97 and above. Best, Dada



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

Interesting Relevant Discussions


DISCUSSSION STATISTICS


8
LIKES

38298
VIEWS

103
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network