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

sabby_001 · 22-11-2007, 06:31 PM

Gowrishankar · 22-11-2007, 07:14 PM

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 · 22-11-2007, 07:59 PM

Hello,

Please have a look at the attachment.

Thanks,

Sachin.

Gowrishankar · 22-11-2007, 08:31 PM

but you need to do it manually for all

vishwa2 · 24-11-2007, 09:58 PM

Hi
I can give you automated excel payslip generator if you provide the earnings and deductions of payroll.
rgds
Vishwanath

Gowrishankar · 03-12-2007, 04:22 PM

can you send me a copy to

madhumitaparija · 07-01-2008, 06:26 PM

Hi Vishwanath,

Can u plz send me the automated payroll system in my email id:

.

Madhumita

PSKC · 11-12-2008, 10:29 AM

Hi viswanath
please send me the automated payroll system to my id:

. I will do the deductions/addition formulae
rgds
muralee

maunish.shah · 25-12-2008, 10:40 AM

can u send me the automated sheet on

sarveshbansal · 25-12-2008, 12:00 PM

Hi Vishwanath,

Can u plz send me the automated payroll system in my email id: