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.
From India, Mumbai
Acknowledge(0)
Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
Dear bhumica, Cud you plz send me the attachement as well for computing the salary for pvt. ltd cos. :) Thnx Sashmita
From India, Delhi
Acknowledge(0)Amend(0)
8From India, Delhi
Acknowledge(0)Amend(0)
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
From India, Calcutta
Acknowledge(0)Amend(0)
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
From India, Calcutta
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Salary breakup format.xls
SALARY EXCEL.zip