Monthly calculation of salaries on an excel sheet
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Employee Compensation & Benefits

Monthly calculation of salaries on an excel sheet

saddy_ Started The Discussion:

Hi This Is Saddy Can Any body tell me the calculation of the salary on monthly basis in the Excel Format

nabomita1979 - Member Since: Apr 2006
Greetings,

You would the templates and sample sheets in the link below, as a point of reference. You would design the one which is relevant to your company on the basis of following areas:
  • Salary budget allocated for each hire : Few roles would have a bigger budget than others . Hence, you may have to include Car allowances and sodexho. But for lesser amount you would have to keep the basic format.
  • Benefits allocation based on the business model you may offer a detailed mediclaim plan for the employee and his/her family from the day the employee joins. You may even change it for the plan to be activated post probation to avoid administrative costs on attrition. the sum assured would depend entirely on your organization budget. Other benefits such as relocation, city allowance are based purely on business needs .
  • Legal and sectoral standards to be maintained: Please make a study on the mandatory legal standards to be maintained . You may have to follow the salary format which prevalent in your sector.

Hope this helps. Blog your queries and allow us to contribute to your learning .

Salary guide

Regards,
Nabomita

Quote:
Originally Posted by saddy_ View Post
Hi
This Is Saddy
Can Any body tell me the calculation of the salary on monthly basis in the Excel Format

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


2081
VIEWS

1
REPLY

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