How to Make a Salary Slip in Excel (Step-by-Step + Free Template)

A salary slip is one of the simplest payroll documents, but it needs to be clear. Employees use it to understand their pay, banks may ask for it during loan checks, and employers use it as a monthly payroll record. You can create a clean salary slip in Excel without payroll software if you set up the right sections and formulas.

What a salary slip should include

A practical salary slip usually includes:

• Company details — company name, address, email, and phone
• Employee details — employee name, ID, designation, department, date of joining, and bank account
• Salary period — the month and year the slip belongs to
• Earnings — basic salary, HRA, allowances, bonus, or incentives
• Deductions — provident fund, professional tax, income tax/TDS, loan recovery, or other deductions
• Gross earnings — total of all earnings
• Total deductions — total of all deductions
• Net salary payable — gross earnings minus deductions

The exact components can vary by company and country, so treat the format as a payroll document you can adapt.

Step-by-step: create a salary slip in Excel

1. Create the header. Add your company name, address, contact details, and the title "Salary Slip".
2. Add employee information. Include employee name, employee ID, designation, department, joining date, bank account, and the salary month.
3. Build the earnings table. Add rows for basic salary, house rent allowance, conveyance allowance, special allowance, bonus, and any other earnings.
4. Build the deductions table. Add rows for provident fund, professional tax, TDS, loan recovery, and any other deductions.
5. Add formulas. Use SUM to calculate gross earnings and total deductions. Then calculate net salary as Gross Earnings minus Total Deductions.
6. Review before sharing. Check employee details, salary month, tax deductions, and final net salary. Save as PDF before sending.

Useful Excel formulas

You only need simple formulas:

• Gross earnings: =SUM(earnings_range)
• Total deductions: =SUM(deductions_range)
• Net salary: =gross_earnings-total_deductions

Keep the formulas in locked or protected cells if multiple people edit the sheet.

Common mistakes to avoid

• Forgetting the salary month — old slips become confusing when months are missing.
• Mixing earnings and reimbursements — keep payroll components clear.
• Using hard-coded totals — formulas reduce manual errors.
• Sending editable files — share a PDF copy when the slip is final.
• Ignoring local rules — statutory deductions vary, so verify PF, tax, and professional tax rules before official use.

Save time with a free template

Instead of building the layout and formulas from scratch, download our free salary slip template. It includes employee details, company details, earnings, deductions, automatic gross pay, total deductions, and net salary payable.

If you also manage cash and expenses, our cash book template and business expense tracker can help keep payroll-related spending organized.

Summary

A good salary slip is clear, formula-driven, and easy to verify. Create separate sections for employee details, earnings, deductions, and net pay — or start from a ready-made Excel template and customize it for your payroll process.