Satpreet Kaur
Human Resource
Associate Executive
+2 Others

Thread Started by #lokeshsharma9

Dear members,
i need very urgent help from you.i want a excel sheet with formulas for automatic calculation of gross and ctc calculation.
For example if 12,000 is gross and i put this value then that sheet give me break up.
2.if i want same figure 12,000 breakup as ctc then that sheet give me all break up.
Please reply soon.
12th December 2011 From India, Delhi
Hi Lokesh, There are already lot of materials available. Write in 'Search' tab and check the files on the right hand side. Regards, Satpreet Kaur
12th December 2011 From India
Hi Lokesh Hope this will help you. Best Regards Shanu Dutta
12th December 2011 From India, Calcutta

Attached Files
Membership is required for download. Create An Account First
File Type: xls salary_break_up_calculator(1).xls (21.0 KB, 5128 views)

Gm every one
Please guide how to break annual ctc from gross, please share the excel sheet.
please guied how to break annaul ctc from esi, please share the details to excel sheet.
Thanks in advance..
6th August 2016 From India, Bengaluru
Dear Mr. Shanu Dutta,
Thank you for the Salary Break Up Calculator. However, I had one doubt, is it right (legally) to show Employer Contribution to PF as part of employees Gross Salary? It is surely a "Cost to Company" but can it be shown as a deduction from employee gross, even if it is credited to him in the first place.
this question is purely from a legal point of view and not the general practice that seems to be followed everywhere? Will this structure stand the scrutiny of law if, for any reason, this is produced and examined by a legal authority?
In the present excel sheet, How will his pay slip look like?
4th July 2017 From India, Kochi
Hello All
Please clarify and send sheet for new pf deduction without HRA and if any staff gross salary is 13000 and 15000 without HRA so what is the calculation of PF.
2nd May 2019 From India, undefined
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2017 Cite.Co™