Struggling with Salary Statements in Excel? Need Help with Deductions and Format!

I am working in a private limited company in Mumbai. This company is involved in sales and support services of hi-tech instrumentation used in the field of Hydrography and Oceanography. I have been given the responsibility of preparing the salary statement, including knowledge of the tax part in Excel. Please help me with the format and deductions part in Excel. Knowledge about deductions (TDS/P.F./Professional Tax, etc., whatever is required.) Gross salary minus deductions equals net salary.

Hello,

I am attaching the file for updating your knowledge and queries. You would just need to input the working day, and the automatic calculation will take place. You would need to adjust the percentages according to your slabs. Please revert if you have any queries.

Thank you,
Meeca

Dear Bhumica,

Could you please send me the attachment as well for computing the salary for Pvt. Ltd. companies?

Thank you,
Sashmita

I would like to share the information on calculating salary:

The components are:
1. Basic salary
2. HRA
3. Conveyance
4. Spl. allowance
5. Gross salary
6. Days actually present (including approved leave)
7. Earned basic on the basis of 6.
8. Earned HRA
9. Earned Conveyance
10. Earned Spl. allowance
11. Earned Gross salary
12. Any incentive
13. Less PF
14. Less ESI
15. Less TDS
16. Less P. Tax
17. Total deduction
18. Net Salary after deduction.

Hope this will help you.

Regards,
Subhabrata Dasgupta