8
Enter all the details you have on the salary slip starting from earnings and ending with the deductions, and display the net amount along with all your company information.
For Example:
Payslip for the month of "Oct 07"
Personal details should be listed first:
Name: PF Number:
Emp ID: ESI Number:
Dept: D.O.J:
Design: D.O.B:
Next, display the earnings column:
Basic: D.A: Allowances: Gross: "Add all the columns to get the gross amount"
Then, move on to the Deduction column:
PF: (Basic + DA) * 12% ESI: Gross * 1.75% Total deduction: PF + ESI
Net amount: Gross - Total deduction
By following these steps, you can create the payslip in Excel. If you need more detailed guidance, feel free to send me a sample payslip and I will help clarify any doubts.
Regards,
Gowrishankar.G
From India, Chennai
Acknowledge(1)
Amend(0)
For Example:
Payslip for the month of "Oct 07"
Personal details should be listed first:
Name: PF Number:
Emp ID: ESI Number:
Dept: D.O.J:
Design: D.O.B:
Next, display the earnings column:
Basic: D.A: Allowances: Gross: "Add all the columns to get the gross amount"
Then, move on to the Deduction column:
PF: (Basic + DA) * 12% ESI: Gross * 1.75% Total deduction: PF + ESI
Net amount: Gross - Total deduction
By following these steps, you can create the payslip in Excel. If you need more detailed guidance, feel free to send me a sample payslip and I will help clarify any doubts.
Regards,
Gowrishankar.G
From India, Chennai
Acknowledge(1)Amend(0)
Hello, Please have a look at the attachment. Thanks, Sachin.
From India, Mumbai
Acknowledge(4)
Amend(0)
From India, Mumbai
Acknowledge(4)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) 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
Acknowledge(1)Amend(0)
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
Acknowledge(1)Amend(0)
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
Acknowledge(0)Amend(0)
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
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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Salary-Slip-Tem plate.doc
CTC SALARY SLIP FORM.xls