Hr Executive
+1 Other

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hi All can anyone share the excel sheet or some program to calcuate CTC of an employee...... please help!!!.....its really urgent Regards Hitesh
From India, New Delhi
From India, Mumbai

Attached Files
File Type: xls pmast_264.xls (15.5 KB, 4077 views)

hi friends wots the reason i cant see the excel sheet or any other attacthments.please help me. regards reeshma

HI Smita,
PF Ad mean if you have any additional Provident Fund other then...from your and company contribution assigned by the company.
You can contribute more on your PF if you want to...all you need to do is contact your accounts department. You will have to fill up a form or it should be available on your company intranet.
Check it out :)
Take care and have a nice day.

Hi, You can use the one attached below... I got this from Cite HR itself and its very useful.... Thanks to the author !! ( I dont recollect the name)... Rgds Deepa
From India, Bangalore

Attached Files
File Type: xls salary_break_up_calculator_262.xls (17.5 KB, 2361 views)

Hi Reeshma!!!
You must not b logged in at the time u were seeing the article .......... thats y u were not able to see the attachment............. firstly log in on cite HR n then u wud be able to see the attachment for sure
Hope it helps

From India, Delhi
Hi Hitesh/Smita I m attaching a salary breakup format & excel sheet with formulats........... Hope u find it useful..... Regards Monika
From India, Delhi

Attached Files
File Type: xls master_193.xls (400.0 KB, 1649 views)
File Type: xls salary_break_up_format_195.xls (69.5 KB, 1534 views)

Sir, ur sheet is not correct. Calculation of Leave Pay,PF looks confusing. Further DA should have been entered. Anyway think more & help us.
From India, Haora
hello friends I am haresh vala and new join to personnal department and hr please basic,hra,other,spl,medical,edu, information to compalet salary format
From India, Surat
Is EPF & ESIC calculated on Basic salary or CTC? Further, I wanted to know Ee’s & Er’s contribution. Sir please help me.
From India, Pune
Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™