8
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
From India, Chennai
Acknowledge(0)
Amend(0)
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
From India, Chennai
Acknowledge(0)Amend(0)
Hello, Please have a look at the attachment. Thanks, Sachin.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Hi I can give you automated excel payslip generator if you provide the earnings and deductions of payroll. rgds Vishwanath
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
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
From India, Jaipur
Acknowledge(0)Amend(0)
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
From India, Jaipur
Acknowledge(0)Amend(0)
Hi, i am working in a HR Services company as a Team leader-HR, only problem in our company is we do not have a salary slip & no other deductions except PFT, i am looking out for a change in job but how can i produce a salary slip for the new joining company.
Salary of 9000 net
PFT-300
Incentives+ commission varies monthly
please anybody help me in this regard. please awaiting for anybody's re[ply at the earliest
From India, Mangalore
Acknowledge(0)Amend(0)
Salary of 9000 net
PFT-300
Incentives+ commission varies monthly
please anybody help me in this regard. please awaiting for anybody's re[ply at the earliest
From India, Mangalore
Acknowledge(0)Amend(0)
Why should you depend on excel sheet? We can offer you Payroll processing software free for 3 months and if happy to continue, you can continue by subscribing. If interested, please let me know
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
hi i want to take 500 employees salary slips i am having the salary statement in excel, can any body help me in this regard
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Hi,
Please find the salary slip template in Excel and Word format here.
Thank you.
From India, Bengaluru
Acknowledge(0)Amend(0)
Please find the salary slip template in Excel and Word format here.
Thank you.
From India, Bengaluru
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Salary-Note.doc
SALARY SHEET CALCULATION.xls