Creating a Salary Slip in MS Excel: Step-by-Step Guide for Beginners

To create a salary slip in MS Excel, you can follow these steps:

1. Open a new Excel spreadsheet.
2. Enter the necessary details such as employee name, employee ID, designation, department, and the month for which the salary slip is being generated.
3. Create separate columns for earnings and deductions.
4. Under the earnings section, list the components like basic salary, allowances, bonuses, and overtime pay.
5. In the deductions section, include items such as taxes, insurance premiums, and any other deductions applicable.
6. Calculate the total earnings and total deductions.
7. Subtract the total deductions from the total earnings to get the net salary.
8. Format the spreadsheet to make it more presentable by using borders, colors, and appropriate fonts.
9. You can also add your company logo for a professional touch.
10. Save the file and print or email it to the employee.

By following these steps, you can easily create a salary slip using MS Excel.

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

Hello,

Please have a look at the attachment.

Thanks,
Sachin.

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.

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.

Hi,

Please find the salary slip template in Excel and Word format here.

Thank you.

Creating a Payslip Using Excel and Word

You can create an Excel sheet with all pay and deduction details and then proceed with a mail merge in Word after setting up the basic payslip format.