I am working in pvt ltd co in mumbai.
This co is into sales & support service of hi-tech instrumentation used in the field of Hydrography & Oceanography.
I have been given a responsibility of preparation of salary statement including tax part knowledge in excel.
Please help me out for the format , deductions part . format in excel.
Knwoledge about deduction (tds / P.F. / Prof Tax etc whatever is required.)
Gross salary - to = net salary.
From India, Mumbai
This co is into sales & support service of hi-tech instrumentation used in the field of Hydrography & Oceanography.
I have been given a responsibility of preparation of salary statement including tax part knowledge in excel.
Please help me out for the format , deductions part . format in excel.
Knwoledge about deduction (tds / P.F. / Prof Tax etc whatever is required.)
Gross salary - to = net salary.
From India, Mumbai
7
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 you.
Regards
Subhabrata Dasgupta
From India, Calcutta
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 you.
Regards
Subhabrata Dasgupta
From India, Calcutta
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Career - How to Prepare Your Curriculum Vitae (Revised Ed McGraw Hill).pdf