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.
16th February 2007 From India, Mumbai

Hr Professional
Working As An Accounts Executive

I am attaching the file for updating your knowledge and qurries.
You would just need to punch the working day and the automatic calculation will take place. YOu would need to change the percentages according to your slabs
revert still if the querry pertains
20th February 2007

Attached Files
Registration required. Create all access/no charge Cite.Co account first.
File Type: xls salary_format_191.xls (22.5 KB, 2739 views)
Dear bhumica, Cud you plz send me the attachement as well for computing the salary for pvt. ltd cos. :) Thnx Sashmita
26th February 2007 From India, Delhi
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.
Subhabrata Dasgupta
29th February 2008 From India, Calcutta
Please login to participate in this discussion. Discuss problems, ideas, solutions with industry peers. Stay up-to-date with what's new and what's happening in the industry. Create Account (No Registration Charges)

About Us - Advertise - Contact Us - RSS   On Google+  
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network