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
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
Hi I can give you automated excel payslip generator if you provide the earnings and deductions of payroll. rgds Vishwanath
From India, Bangalore
From India, Bangalore
Gross = rate/month Day * Paid Days
Pf = Round(basic + da if applicable) * 12 / 100, 0), 0) up to 6500 Rate Applicable
Esi = Ceil((gross all * 1.75%), 1) up to 10000 Rate Applicable
Net Pay = Gross - pf - esi - advance - any other
Feed all these in attached format. You will find your payslip in MS Excel.
From India, Jaipur
Pf = Round(basic + da if applicable) * 12 / 100, 0), 0) up to 6500 Rate Applicable
Esi = Ceil((gross all * 1.75%), 1) up to 10000 Rate Applicable
Net Pay = Gross - pf - esi - advance - any other
Feed all these in attached format. You will find your payslip in MS Excel.
From India, Jaipur
Hi, I am working in an HR services company as a Team Leader - HR. The only problem in our company is that we do not have a salary slip and no other deductions except Provident Fund (PFT). I am looking for a job change, but how can I produce a salary slip for the new company I am joining?
My net salary is $9000, with a PFT deduction of $300. Additionally, incentives and commission vary monthly.
I would greatly appreciate it if someone could help me with this matter. I am eagerly awaiting a reply at the earliest.
From India, Mangalore
My net salary is $9000, with a PFT deduction of $300. Additionally, incentives and commission vary monthly.
I would greatly appreciate it if someone could help me with this matter. I am eagerly awaiting a reply at the earliest.
From India, Mangalore
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
From India, Bangalore
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
From India, Madras
Hi,
Please find the salary slip template in Excel and Word format here.
Thank you.
From India, Bengaluru
Please find the salary slip template in Excel and Word format here.
Thank you.
From India, Bengaluru
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.