Salary Slip Format in Excel

I have attached salary slip format in excel.


M/s HR Out Source Services Gurgaon                  Principal Employer M/s Rico Auto Ltd Gurgaon
    Salary Detail For Month: July 2011
Emp
ID
Employee Name Prt. Days E L W / P R-> Basic HRA CONV SP_ALLOW ATT_
BON
Total
Add
ESI PF TDS WEL_FUND ADV. MEAL DED. LOAN                      EMI OTHER
DED.
TOTAL
DED
NET
PAY
Balance Leave
Father’s Name Paid Days S.L ABS P-> CL SL EL
Designation C L HLD A->
P.F No(ESI No)
HR 542 BHUPENDER YADAV 25 0 0 R-> 5000 2650 2250 2000 11900 5 6 1
SH. CHANDER BHAN 31.0 0 0 P-> 5000 2650 2250 2000 0 11900 209 600 0 5 0 0 0 0 814 11086
HR EXECUTIVE 1 5 A-> 0 0 0 0 0
Employer Singature Employee Signature
M/s HR Out Source Services Gurgaon                  Principal Employer M/s Rico Auto Ltd Gurgaon
    Salary Detail For Month: August 2011
Emp
ID
Employee Name Prt. Days E L W / P R-> Basic HRA CONV SP_ALLOW ATT_
BON
Total
Add
ESI PF TDS WEL_FUND ADV. MEAL DED. LOAN                      EMI OTHER
DED.
TOTAL
DED
NET
PAY
Balance Leave
Father’s Name Paid Days S.L ABS P-> CL SL EL
Designation C L HLD A->
P.F No(ESI No)
HR 542 BHUPENDER YADAV 23 0 0 R-> 5000 2650 2250 2000 11900 5 6 1
SH. CHANDER BHAN 31.0 0 0 P-> 5000 2650 2250 2000 0 11900 209 600 0 5 0 0 0 0 814 11086
HR EXECUTIVE 0 8 A-> 0 0 0 0 0
Employer Singature Employee Signature
M/s HR Out Source Services Gurgaon                  Principal Employer M/s Rico Auto Ltd Gurgaon
    Salary Detail For Month:September 2011
Emp
ID
Employee Name Prt. Days E L W / P R-> Basic HRA CONV SP_ALLOW ATT_
BON
Total
Add
ESI PF TDS WEL_FUND ADV. MEAL DED. LOAN                      EMI OTHER
DED.
TOTAL
DED
NET
PAY
Balance Leave
Father’s Name Paid Days S.L ABS P-> CL SL EL
Designation C L HLD A->
P.F No(ESI No)
HR 542 BHUPENDER YADAV 24 0 0 R-> 5000 2650 2250 2000 11900 5 4 1
SH. CHANDER BHAN 30.0 2 0 P-> 5000 2650 2250 2000 0 11900 209 600 0 5 0 0 0 0 814 11086
HR EXECUTIVE 0 4 A-> 0 0 0 0 0
Employer Singature Employee Signature

 

Click Here To Download Payslip Format