How to prepare the monthly salary statements for pvt ltd co - tds
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Human Resource Section > Employee Compensation & Benefits

varshajrajani Started The Discussion:

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.

bhumica -  Member Since: Mar 2006
Hello,
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
Meeca


Attached FilesProvided by community member bhumica. Join us to learn and grow with your peers.
File Type: xls salary_format_191.xls (22.5 KB, 2042 views)
Udayarkumar -  Member Since: Feb 2007
Hello Ms. Bhumika I couldn’t able to find that file for preparing salary statements. If possible, can you mail the file to my id: career4uday@gmail.com regards udaya kumar HR Executive

SASHMITA -  Member Since: Feb 2007
Dear bhumica, Cud you plz send me the attachement as well for computing the salary for pvt. ltd cos. :) Thnx Sashmita

pmjamshi -  Member Since: Dec 2007
HI, Does HRA vary from state to state? How is DA and HRA calculated. Whats gratuity....? Kindly reply. Thanks in advance :) Jamsheer

subhabratadg -  Member Since: Feb 2008
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

JEYA PRADHABAN -  Member Since: Jul 2012
Nice work Subhabrata Dasgupta keep sharing the information’s Regards, JEYA PRADHABAN




 
 
 
 





POSTING RULES OF CONDUCT
  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.
  • Found This Useful? +Vote Up This Via Google.  

    Why Vote? User validation is extremely important for good content to prosper.
    Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.



    3M Users, 100K+ Documents & 450K+ Discussions

    Share »


    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Community Support & Professional Insights. Login or Register.
    Email/Username    
    Password  

    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network