Ehs Specialist
+4 Others

Dear All,
Please help me out for designing a salary for my organization. I'm little bit confused about the deductions on salary. Please find attached sheet with the structure designed by me. Also, please suggest if there TDS deduction should have to added, as I do't have idea about taxation.

From India, Delhi

Attached Files
File Type: xls New Microsoft Office Excel Worksheet.xls (18.5 KB, 217 views)

Hie Pratyasha, I think professional tax is missing to deduct apart from PF you should check that out.
From India, Ahmadabad
I was not aware that your organization belongs from Delhi
Yeah it's not applicable there
For what kind of sector you belong from ?
is it manufacturing setup / Service industry ?
Have you included bonus & Gratuity part in CTC ?

From India, Ahmadabad
Yes Prateek.. My mistake, I haven't write in my msg. Ours is a financial service industry. further, we don't use to include bonus & gratuity part in ctc. Can you please also help me out about the deduction of TDS. Should it be there?
Best Regards,

From India, Delhi
PFA the tax calculator for TDS working and your futher help. Regards, Rahul K
From India, Mumbai

Attached Files
File Type: xls Tax Calculator FY 2011-12_1.xls (45.5 KB, 109 views)

Dear Pratyasha,
Seems you are more concerned about a proper salary structure. I have done some work on the sheet uploaded by you and the same is attached. hope this would be of help.
Satheesh Kumar

From India, Delhi

Attached Files
File Type: xls salary structure.xls (25.0 KB, 178 views)

How to design a salary structure? e.g for salary 10,00,000/=per annum what % should be what? jimmii
From India, Delhi
First try to keep your Basic Salary between 40 to 50% of the CTC to be offered. Keep a standard for basic salary.
You have asked for Salary Breakup but you have uploaded a salary slip breakup. Though both are not different but there are other components also in CTC which does not refelects in salary slip.
Also TDS is compulsory only if the emp. is falling under the tax slab and have not provided any proof of investment so, we can not show the same in Salary Breakup. But if tax is deducted then it need to be refelected in the Salary Slip.

From India, Pune
Thanks Rahul for sending the excelllent tool. i believe his is the same calculator i hv found on . Thaks again for the concern, it’s very useful.
From India, Delhi
Thanks Jeetendra, I have taken basic as 45% of the Gross salary but not CTC. Shuc I change the same? I know 1 important part that I hv left id Employer contribution in PF i.e, Rs.780/- for our org.
From India, Delhi

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™