I need help from seniors to create a salary format for an employee who newly joins a company in which the below headings are mandatory: BASIC, HRA, CONVEYANCE - TOTAL GROSS, PF - Employer & Employee share, ESI - if applicable according to their salary criteria, Bonus - yearly payable on Gross * 8.33%, Gratuity - (On Basic/12)/26*15, CTC, and lastly Net Payable.
With all these columns, I require a salary structure to fix a salary for a newly joined employee. For example, if my reporting manager asks me to prepare a salary format for an employee with a CTC of 20k and inquire about their take-home pay, I need to calculate the amount using all the mentioned columns.
Can anyone please help me create a format?
Regards,
Suman
From India, Bangalore
Acknowledge(0)
Amend(0)
2With all these columns, I require a salary structure to fix a salary for a newly joined employee. For example, if my reporting manager asks me to prepare a salary format for an employee with a CTC of 20k and inquire about their take-home pay, I need to calculate the amount using all the mentioned columns.
Can anyone please help me create a format?
Regards,
Suman
From India, Bangalore
Acknowledge(0)Amend(0)
Attached CTC Structure File
Please find the attached CTC structure file. I hope it can help you prepare the CTC along with the salary details provided. The file is opened with a formula editor to display the formulas used in specific fields.
Regards,
Sunil Verma
AM-HR (Indiabulls)
Acknowledge(0)Amend(0)
Please find the attached CTC structure file. I hope it can help you prepare the CTC along with the salary details provided. The file is opened with a formula editor to display the formulas used in specific fields.
Regards,
Sunil Verma
AM-HR (Indiabulls)
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Salary structure CTC 15000.xlsx
Salary calculation.doc