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

Understand the behavioral aspects at individual as well as organizational level →
Promoted: IIM Raipur Executive Development Program In Human Resource Management
From India, Mumbai

Attached Files (Download Requires Membership)
File Type: xls pmast_264.xls (15.5 KB, 4684 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 (Download Requires Membership)
File Type: xls salary_break_up_calculator_262.xls (17.5 KB, 2761 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 (Download Requires Membership)
File Type: xls master_193.xls (400.0 KB, 1893 views)
File Type: xls salary_break_up_format_195.xls (69.5 KB, 1801 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

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server