Hi, Can anyone share with me the excel sheet of all the components of the salary that is basic salary, HRA, PF, ESIC(if applicable), TDS, Allowances, PT as per 2021? The sheet should contain every components a salary might have. (salary range from 10000- 100000 in one sheet).
Thanks & Regards.

From India, Delhi
Pan Singh Dangwal
Joint Manager
Taxblock India Pvt.Ltd
Tax Professional

Pan Singh Dangwal

Dear Member,
This forum provide solutions where the other members find difficulty.

You are asking for a ready made solution in single shot.

Let me clear, every establishment have different measures for drafting the Salary Structure (even for same salary there could be a big difference). Though the HRA, PF & ESIC are more or less same for all, but TDS and Allowance could be different. PT is not applicable in all States.

Moreover, you have not mentioned for how many employees you need the structure. That is all the more important.

As per my opinion the excel sheet can be helpful for employees less than 100.

If so first of all you should find some structures in the Forum or thru Google. Apply your skills and knowledge area. Wherever you find any difficulty than ask others opinion.

It is also advisable to provide more detail of your company (Designations of Down to Top, management approach whether it is Tax Friendly or Compliance Preference, In House Salary or through Payroll Services).

Hope you will not mind my comments and take it as suggestion. Believe me in long run these could be very useful.

From India, Delhi
are not feeling to share than whats the point of writing this thesis. Everyone does here I myself provided some of the working sheets. But you don't dare to say "You are asking for a ready made solution in 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.

And thank you for your advice. Let other reply. If you dont feeling to share or send 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
Taxblock India Pvt.Ltd

The below 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

Adv. Shivam Kumar

From India, Pune

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server