Need Urgent Help Creating a Salary Slip for CTC Rs. 9000 with All Allowances and Deductions

Can anyone help me out with a salary slip for CTC Rs. 9000/- including basic, DA, HRA, other allowances, with PF and ESI? Please provide as soon as possible. This is very urgent.

Please see below:

Salary Breakdown

- Basic: 4950
- HRA: 2475
- Conv-Allow: 500
- Med-Allow: 800
- Spl-Allow: 275
- Gross: 9000

Deductions

- PF: 594
- ESI: 158
- PT: As applicable
- Tot. Ded: 752 + PT
- Net: 8248 - PT as applicable

Regards,

Please find the attached Excel Sheet (Salary Breakup). Hope this will fulfill your requirement.

Regards.

I think Guna has asked for the break-up of CTC, but all your replies are regarding Gross. CTC is different from gross. I don't know if I am right or wrong. Also, basic calculations vary from company to company.

Break Ups Amount

Basic + DA: 2700
HRA: 900
Other Allowance: 650
Gross Salary: 4250

Employee's ESI: 74
Employee's PF: 324
Take Home: 3852

Employer's ESI: 202
Employer's PF: 324
CTC: 9026

Seniors, please suggest the right answer.

Hi, I do agree that since he asked for CTC, we should ensure that the basic wages are not less than the minimum wages. As per my knowledge, nowhere in India are minimum wages less than 4200 for any category.

Sorry, Jeevarathnam, I have wrongly calculated:

Salary Breakdown

Basic + DA: 4950
HRA: 2250
Other Allowance: 1000
Gross Salary: 8200

Deductions

Employee's ESI: 144
Employee's PF: 594
Take Home: 7463

Employer Contributions

Employer's ESI: 390
Employer's PF: 594

Cost to Company (CTC)

CTC: 9184
CTC = Gross + Employer's Expenses towards Employees

That's perfect. You can even set the CTC at Rs. 9000/-, and the difference of Rs. 184 shall be adjusted into the Other Allowance. This means that the gross salary will also be reduced.

Gross Salary: ₹9000/-

Breakdown of Salary Components

Basic: ₹4500/-

HRA: ₹3600/-

Conveyance: ₹500/-

Medical Allowance: ₹400/-

Deductions

PF (12.5%): ₹562.5/-

Net Pay: ₹8437.5/-

Regards,
Meenu

Dear Jeevarathnam, can you please tell me the exact breakdown of the salary percentage? It's confusing me a lot.

There is no fixed percentage to calculate the salary breakup. These are just designed to reduce the burden of TDS and should be considered in accordance with the statutory requirements.

Thank you.

Regards

Jeevaratnam, please help me out with the breakup samples for CTC 18,300, including basic salary, HRA, DA, special allowances, conveyance, PF, and ESI.

Thank you.

You can follow the details below:

Salary Breakdown

- Basic: 9000
- HRA: 4500
- Conveyance: 800
- Medical: 1250
- Special Allowance: 1865

The difference between ₹18,300/- and the above total is ₹885/-, which will be the Employer's Contribution to EPF. The Employee PF amount will be ₹780/-. As the Gross Pay is above ₹15,000/-, ESI is not applicable.

Regards

Please find attached the worksheet. You can set the CTC at any amount you prefer, and you will receive the breakdown. Please note, if the gross amount exceeds Rs. 15K, you can exclude the contributions towards ESI in this calculation.

Regards.