sabby_001 Started The Discussion:
how to create salary slip in ms excel....
Member Opinions In This Discussion
India, Madras
Manager- Hr & Ir
India, Bangalore
Working Professional
India, Mumbai
Hr Manager
India, Bangalore
India, Ghaziabad
Voice And Accent Trainer
India, Chennai
Executive Hr
India, Hyderabad
Fresher-searching For A Job In Hr
India, Delhi
India, Ambala
Taxation Officer
India, Jaipur
Hr Generalist Profile
+10 Others

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

Hello, Please have a look at the attachment. Thanks, Sachin.
Attached FilesProvided by community member Sachindi. Register to join your network of peers.
File Type: xls salary_slip_format_136.xls (42.0 KB, 9870 views)
Hi I can give you automated excel payslip generator if you provide the earnings and deductions of payroll. rgds Vishwanath
Hi Vishwanath, Can u plz send me the automated payroll system in my email id: Madhumita
Hi viswanath please send me the automated payroll system to my id: I will do the deductions/addition formulae rgds muralee
Hi Vishwanath, Can u plz send me the automated payroll system in my email id:

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!

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
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. Register to join your network of peers.
File Type: xls Book2.xls (15.5 KB, 2259 views)


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.

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