How to Customize Your Salary Structure with This Editable Excel Tool for 2009-10

Hi all,

Please find attached an Excel file without a password so that you can add or remove salary heads (HOP) as per your organization's salary structure. Hope this will help everyone.

Thank you for your suggestions. Keep replying.

Best regards,
Joseph

[Link to an external website removed for security reasons]

Hi,

Today, none of the uploads are downloading. Please try tomorrow. I will email those who have provided the files.

Regards,
Joseph

Hi Kavita, Vaibhav,

Email sent alternatively. You can try downloading the ZIP file.

Regards,
Joseph

Please try this – it's been working for the last 3 years, and I've been using it for our organization's employees. Please send any advice to the author for necessary changes if required.

Regards,
Dhiraj

Hi, in your Excel file, we are not able to clear the PF contribution because in our company, it's not mandatory to deduct the PF as we are still not 20 years old yet.

Hi users,

If you are using this Excel sheet and experiencing any problems regarding PF, city, or senior citizen, please follow these steps:

- For non-PF, you can set the percentage to 0.
- For city, you can choose between metro or non-metro, and the applicable rate of exemption will vary accordingly.
- For senior citizen, male, and female, there is an option on the right side of the Excel sheet where you can set your parameters.

Regards,
Dhiraj

Hi Joseph,

Thanks for this.

Just a clarification, is this tax calculator aligned with the recent budget? I understand that the savings exemption is up to 1.5L, whereas in the calculator, it accepts only 1L.

Kindly reply.

Thanks for your post. A little correction in your explanation: Disability Dependent is not applicable under section 80G. Rather, expenses on the medical treatment of a dependent who is a person with a disability are applicable under section 80DD. Section 80G is applicable when donations are given to certain funds and charitable institutions.

Please do correct me if I am wrong.

Regards,
Jai

Hi Joseph,

I need to just enter the amount, and it will display the right amount. There are so many items, but in all companies, there are only fewer perquisites. What you have posted is very good. I recommend preparing another Excel sheet mentioning only the main perquisites.

Thanks,
HR Guru

Hi all,

Please find attached an Excel file without a password so that you can add or remove salary heads (HOP) as per your organization's salary structure. Hope this will help everyone.

Thank you for your suggestions. Keep replying.

Best regards,
Joseph

Hi all,

File attached without a password.

Regards,
Joseph

Hi Dear All,

This is Jagdish. I am working as an HR executive in one of the automobile industries. I want to know more about the Leave Act, leave calculation, and leave encashment.

Dear all,

Please find the another Excel file for income tax calculation. Hope everyone will find this useful.

Regards,
Manish Jain 😊

Attached file with password. From the first page, you can download the file without a password.

Hi all,

Thank you, Joseph, for your support. Can you please help me with how to calculate the PLI? I can see it on my salary slip, but I am unsure of how to calculate it. When I compared it with past salary slips, it only made me more confused. Your assistance in this matter would be greatly appreciated.

Hi All,

I would like to know the following:

1. What is the minimum that Basic should be of the gross, or is there a minimum and maximum that you can play around with while making the structure?

2. Everything attracts the FBT; are there any items that don't attract FBT?

Regards,
Aparna

I am in Power Grid (PSU) Corporation of India Ltd. Please send me the income tax calculator.

Dear Rajashekar,

Incorporate your state PT; it will be considered for tax exemption.

Regards,
Joseph

File attached for 2009-10.

---

I have corrected the spelling and grammar errors in the user's input and ensured proper formatting with a single line break between paragraphs.