Hi, can anyone share with me the Excel sheet of all the components of the salary, such as basic salary, HRA, PF, ESIC (if applicable), TDS, allowances, PT as per 2021? The sheet should contain every component a salary might have (salary range from $10,000 to $100,000 in one sheet).
Thanks & Regards.
From India, Delhi
Thanks & Regards.
From India, Delhi
Dear Member,
This forum provides solutions where other members encounter difficulties.
You are seeking a ready-made solution in a single shot.
Let me clarify, every establishment has different measures for drafting the Salary Structure (even for the same salary, there could be a significant difference). Though the HRA, PF, and ESIC are more or less the same for all, TDS and allowances could vary. PT is not applicable in all states.
Moreover, you have not mentioned for how many employees you need the structure, which is all the more important.
In my opinion, an Excel sheet can be helpful for fewer than 100 employees.
If so, first, you should find some structures in the forum or through Google. Apply your skills and knowledge where needed. When you encounter difficulties, seek the opinions of others.
It is also advisable to provide more details about your company (designations from bottom to top, management approach – whether it is tax-friendly or compliance-oriented, in-house salary or through payroll services).
I hope you do not mind my comments and take them as suggestions. Believe me, in the long run, these could be very useful.
From India, Delhi
231This forum provides solutions where other members encounter difficulties.
You are seeking a ready-made solution in a single shot.
Let me clarify, every establishment has different measures for drafting the Salary Structure (even for the same salary, there could be a significant difference). Though the HRA, PF, and ESIC are more or less the same for all, TDS and allowances could vary. PT is not applicable in all states.
Moreover, you have not mentioned for how many employees you need the structure, which is all the more important.
In my opinion, an Excel sheet can be helpful for fewer than 100 employees.
If so, first, you should find some structures in the forum or through Google. Apply your skills and knowledge where needed. When you encounter difficulties, seek the opinions of others.
It is also advisable to provide more details about your company (designations from bottom to top, management approach – whether it is tax-friendly or compliance-oriented, in-house salary or through payroll services).
I hope you do not mind my comments and take them as suggestions. Believe me, in the long run, these could be very useful.
From India, Delhi
Are you not feeling like sharing? Then what's the point of writing this thesis? Everyone here does it; I myself provided some of the working sheets. But you don't dare to say, "You are asking for a ready-made solution in a single shot. Apply your skills and knowledge area." I have better knowledge than you about it; I just wanted to keep all those asked things in a single sheet.
Thank you for your advice. Let others reply. If you don't feel like sharing or sending, then don't participate. Why should I give my company information to you? Are you willing to apply for a job here?
From India, Delhi
Thank you for your advice. Let others reply. If you don't feel like sharing or sending, then don't participate. Why should I give my company information to you? Are you willing to apply for a job here?
From India, Delhi
The components that form part of the Income/Earnings side of the salary statement are:
- Basic Salary
- Dearness Allowance
- House Rent Allowance
- Conveyance Allowance
- Medical Allowance
- Special Allowance
- Less: Deductions (as applicable)
- Professional tax
- Tax Deducted at Source
- Employee Provident Fund
Regards,
Adv. Shivam Kumar
Visit us at: https://taxblock.in/
From India, Pune
- Basic Salary
- Dearness Allowance
- House Rent Allowance
- Conveyance Allowance
- Medical Allowance
- Special Allowance
- Less: Deductions (as applicable)
- Professional tax
- Tax Deducted at Source
- Employee Provident Fund
Regards,
Adv. Shivam Kumar
Visit us at: https://taxblock.in/
From India, Pune
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.