Salary Structure Calculator - pf deduction Xls Download.. CiteHR
CiteHRCiteHR
 
HOME RISE NEW TEAM →|

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, 17254 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




 
 
 
 





POSTING RULES OF CONDUCT
  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.

  • Found This Useful? +Vote Up This 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.

    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Share This Discussion:


    3M Users, 100K+ Documents & 450K+ Discussions
    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