How to make a salary slip in Excel
- Put the employee details in the top rows and earnings in one column.
- Gross earnings:
=SUM(B10:B13) over your earnings rows.
- Provident fund:
=ROUND(MIN(B10,25000)*12%,0), where B10 is the PF wages (basic, plus any amount added back under the new wages rule). The ₹25,000 cap is the EPF wage ceiling from 17 September 2026; see the EPF wage ceiling guide.
- Total deductions:
=SUM(D10:D13).
- Net pay:
=B14-D14.
- Print or save each employee’s slip as a PDF, and name files consistently, for example
E1042-2026-11.pdf.
This works for a handful of people. By 10 employees you will be copying formulas across months, tracking leave and loss of pay by hand and redoing PF, ESI and TDS every time rates change. That is when payroll software pays for itself; see payslip generation software.
Common salary slip mistakes
- One lump “allowances” line. Employees cannot check it, and PF and tax become hard to explain.
- PF on the wrong wage. Deducting on the full gross when only wages up to the ceiling count, or the reverse.
- Missing UAN or PAN. The slip is then weak as income proof and the ECR may fail.
- Net pay that does not match the bank file. Always generate both from the same run.
- Late slips. The slip is due with the payment, not days later.
For employers: issue slips automatically
HivePayroll generates a payslip for every employee in each payroll run, calculates PF, ESI, Professional Tax and TDS, and makes the slip available to each employee. See what a salary slip is for the basics, and start free for up to 10 employees.
Frequently asked questions
What is a salary slip format?
A layout that shows the employer and employee details, the pay period, each earning and deduction, and the net pay. Common fields are listed in the sample above.
Is a salary slip mandatory in India?
Yes. The Code on Wages, 2019 requires employers to issue a wage slip, in electronic or physical form, on or before wage payment.
Can a salary slip be digital?
Yes. Electronic wage slips are allowed under Section 50(3) read with Rule 34 of the Code on Wages, 2019.
What should a salary slip contain?
Employer and employee details, pay period, days paid, each earning component, each deduction (PF, ESI, Professional Tax, TDS), the net pay and the date of payment. Check the prescribed form for your state for any extra fields.
Can I use a salary slip as income proof?
Banks usually accept the last three to six salary slips along with bank statements, but it depends on the lender. A complete slip with PAN and employer details is more likely to be accepted.
How long should an employer keep salary records?
The Labour Ministry’s compliance handbook says registers and records under the Code on Wages are to be preserved for five years.
Sources
Checked on 17 November 2026. The sample is for illustration. State rules may prescribe a form and extra fields. This is general information, not legal advice.