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.
Thanks
lokesh
From India, Delhi
9i 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.
Thanks
lokesh
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
From India
From India
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?
From India, Kochi
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?
From India, Kochi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Employee excel sheet.xls