How To Calculate Salary In Excel Pdf Download
CiteHRCiteHR
 
HOME RISE NEW TEAM →|

saravsist Started The Discussion:
Hi Guys,

I have to prepare the salary statement, can anyone help me how to calculate in excel and i need formula for basic by which keying gross salary and no of days present,,,

Please help me out,, its very urgent,,,

Thanks
Saravanan
Hi All,

Herewith I am attaching a Salary sheet .

Salary Sheet Format.xls


Hope this information would help you.
I do not think there is any rule as to the dividing factor i.e. 31/30 or 26. It depends from organization to organization. Organizations either take 30 or 31 as they give advantage to the employees for LOP deductions. Presently, organizations like to be lenient because of intense competition. On the contrary most of the employees do not what dividing factor is considered while calculating LOP. But 26 days can be considered. For eg. If salary is 30,000, an organization stands to gain Rs.186 for one day's LOP, so if there are average 100 LOPS in an organization in one month, organization saves 18600 each month.
Hi I am interested to know about this. Can you please send me the same to my mail id. Thanking you in advance. Regards, Veena e-mail id: veena_aneev@yahoo.co.in
hi , im not able to download the attached excel sheet, pls forward one on my id — > raj_dev_2k@yahoo.com. i am attaching one sample herewith , pls check and correct if i m wrong. devarajan:-P
Attached FilesProvided by community member devarajan_2k. Register to join your network of peers.
File Type: xls Salary_break_up_calculator_(1).xls (17.5 KB, 6567 views)
Please send me the salary excel sheet format to my mail id sureshkumar_2040@yahoo.co.in suresh:confused:
Hello HR Members, Here i am attaching the Excel Salary Format,U can Do Salaries in Excel.If u have any doubt in that u can contact to me throug My ID.sandhyahr.12@gmail.com Regards Sandhya
scrana 
Hi Please find the excel sheet with furmula of salary structure. Regards chennairana@gmail.com
Attached FilesProvided by community member scrana. Register to join your network of peers.
File Type: xls Salary Format.xls (36.5 KB, 4463 views)
hi please send me to my mail id hrd@ubxpress.in
Hi, Can anyone help me out in calculating the salary. Can you plz send me the format to tis mail i.d. ram.sowmiya@gmail.com Its very urgent.



 
 
 
 






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