How To Generate Salary Slips Automatically Using Excel Xls Download
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > CiteHR > New To The Forum?
binumstvm Started The Discussion:

Dear Friends

I am using Excel for preparing Salary Statements.I want to know
how excel can be used to prepare payslips automatically.Can
any one tell me the process/function which is used to convert
salary statement into salary slips.I am expecting a quick and
positive response from you....Please help me friends....:-P

Thanks In advance
BINU.M.S

joydeep25 - Member Since: Mar 2008
Hi,

lets see if I can help you a bit.

suppose if you are preparing salary statement in "SHEET1" then in sheet 2
you first prepare a salary slip format what information you want viz, basic, hra,cca etc.
and just link the particular cell with sheet 1.

I hope you got it.

Bye..............Joydeep

sohini basu roy - Member Since: Jan 2008
hello, heres a format which will help you in preparing a salary slip........... pls check it out...i hope this will be of your help.................


Attached FilesProvided by community member sohini basu roy. Join us to learn and grow with your peers.
File Type: xls CTC_SALARY_SLIP_FORM_(legal)(1).xls (27.5 KB, 4285 views)
kapildevbakshi - Member Since: Jul 2008
hi all, This is kd bakshi. I am joining today and anticipate a good help from u all . My self is master in management sciences and law graduate from pune

binumstvm - Member Since: Jun 2008
I am really thankful to all of you for your valuable replies.:-P Anyone who have other ideas about this Subject Please Share it... Regards BINUMS

jhini000 - Member Since: Aug 2008
Hi,
Today I have joined.
In my office I am maintaining the salary statements in excel 2003. In my office during the Durga Puja Festival , an amount of Rs.2000.00 is paid to each grade IV employee(Peon) with the condition that the entire advance will be recovered in ten equal instalments @ Rs.200 from the salary .
I want to make it such a way that after recovering the advances @Rs. 200.00 per moth for 10 months , in the 11th monts this should be Zero automatically.
Kindly help me pleade.
waiting for reply eagerly. Further querry in the matter is highly appreciated.
Thanks in advance.
jhini000

shetty uday - Member Since: Jul 2013
Dear all.

For the information in our company around 200 people are working so presently they all are asking salary payslip but in our process it takes some long time for salary process days so its difficult to mange the employes so i would like to request to you ,if any one knows esay to create the payslip method plz discuss with me . i hope to yours for clear solution .

Thanks and Regards.
UDAY

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.


PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE



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