How to create salary slip in ms excel.... - hr services Xls Download

sabby_001 Started The Discussion:

how to create salary slip in ms excel....

Gowrishankar -  Member Since: Oct 2007
Enter all the head you have in salary slip starting from earnings and end with the deductions and the net Amount to be diplayed with all your company information.

For Ex:-

Payslip for the month of "oct 07 "

Personal Details like this to come first

Name : PF Number :
Emp id : Esi Number :
Dept : D.O.J :
Design : D.O.B :

then earnings column

Basic : D.A : Allowances: Gross: "Add all the columns you will get the gross amount"

then Deduction column

Pf: (Basic + da ) *12% ESI: Gross*1.75% Total deduction :PF + ESI

Net amount : Gross - Total deduction

by this way you can create in Excel

or if you in detail send me your sample payslip will clear your doubt


Sachindi -  Member Since: Jun 2007
Hello, Please have a look at the attachment. Thanks, Sachin.

Attached FilesProvided by community member Sachindi. Join us to learn and grow with your peers.
File Type: xls salary_slip_format_136.xls (42.0 KB, 5913 views)
vishwa2 -  Member Since: Sep 2007
Hi I can give you automated excel payslip generator if you provide the earnings and deductions of payroll. rgds Vishwanath

madhumitaparija -  Member Since: Nov 2007
Hi Vishwanath, Can u plz send me the automated payroll system in my email id: Madhumita

PSKC -  Member Since: Aug 2008
Hi viswanath please send me the automated payroll system to my id: I will do the deductions/addition formulae rgds muralee

sarveshbansal -  Member Since: Aug 2008
Hi Vishwanath, Can u plz send me the automated payroll system in my email id:

mba_suneetha -  Member Since: Dec 2008

You can download Payroll Champion software online from

Here you can find automated excel payslip generator and also PDF.

It is very simple, generate automatic payslip in the Payroll Champion and save in excel and PDF farmat.

Try one!

Suneetha -  Member Since: Jan 2008
Hi Vishwanath Can you plz extend ur help to me as well and email the automated payroll system to my id I would be very thankful to you. Regards

jitendrasingh_ajmer -  Member Since: Oct 2008
Gross=rate/month Day* Paid Days
Pf = Round(basic+da If Applicable)*12/100,0),0) Upto 6500 Rate Applicable
Esi= Ceil((gross All*1.75%),1) Upto 10000 Rate Applicable
Net Pay= Gross-pf-esi-advance-any Other

Feed All These In Atteched Format, U Will Find Your Pay Slip In Ms Excel

Attached FilesProvided by community member jitendrasingh_ajmer. Join us to learn and grow with your peers.
File Type: xls Book2.xls (15.5 KB, 1516 views)


  • 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.

    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Share This Discussion:

    3M Users, 100K+ Documents & 450K+ Discussions
    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