how to create salary slip in ms excel....
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Technology in HR - HRIS ERP

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

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

Regards
Gowrishankar.G

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, 5531 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: parijamadhu_p@rediffmail.com. Madhumita

PSKC - Member Since: Aug 2008
Hi viswanath please send me the automated payroll system to my id: pmd@skcmanagement.com. 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: sarveshbansal016@gmail.com

mba_suneetha - Member Since: Dec 2008
Team,

You can download Payroll Champion software online from www.processweaver.in/

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!

Thanks,
Suneetha

annienparker@gmail.com - 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 annienparker@gmail.com. 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, 1425 views)


Found This Useful? +Vote Up This Page 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.




Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


3
LIKES

14767
VIEWS

20
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


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

Share »

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