How to Generate Payslips from Excel

Q: How do I make one payslip template for all employees?

Build the layout once and use `VLOOKUP` or `XLOOKUP` keyed on Employee ID. Changing the ID in one cell redraws the entire slip for that employee.

Last updated: 27 June 2026 · Formulas tested in Excel 2010 and later.

To generate payslips from Excel, keep one salary sheet where each row is an employee, then build a single payslip template that pulls that employee's figures with VLOOKUP (or XLOOKUP) against an Employee ID. Change the ID, and the template redraws the whole slip — name, earnings, deductions and net pay — ready to print to PDF or email. One template serves the entire workforce.

Key takeaways

A payslip has a header (company, employee, period), an earnings block, a deductions block and a net pay line in words and figures.
Build it once with VLOOKUP/XLOOKUP keyed on Employee ID — one template covers everyone.
Net pay = total earnings − total deductions, the same identity as the salary sheet.
Show EPF, ESI, professional tax and TDS as separate deduction lines so the slip is transparent and audit-ready.
Use Excel's Print to PDF (or a simple mail-merge) to issue one slip per employee.
A payslip is good practice and often legally expected under wage law — keep a copy for your records.

Fact box. A payslip is a written statement of an employee's earnings and deductions for a pay period, showing gross pay, each statutory deduction (EPF, ESI, professional tax, TDS) and the resulting net pay. Issuing wage slips is standard practice under Indian wage law — the exact obligation varies by state rules, so confirm with your state's labour/wage department.

What should a payslip include?

A compliant payslip carries identifying details, the pay period, a full earnings-and-deductions breakup and the net pay. The recommended layout:

Section	Fields
Header	Company name, address; Employee name, ID, designation; pay month; paid days / LOP
Earnings	Basic, DA, HRA, Conveyance, Special allowance, Gross
Deductions	EPF (employee), ESI (employee), Professional tax, TDS, advances/LOP, Total deductions
Summary	Net pay (figures and words); bank A/c; UAN; PAN
Footer	"Computer-generated payslip" note; date of issue

How do I pull each employee's data into the template?

Use a lookup keyed on Employee ID so one template serves every employee. Put the ID in a single input cell (say B2) and reference the salary sheet:

Field	Formula
Name	`=VLOOKUP($B$2,Salary!$A:$Z,2,FALSE)`
Basic	`=VLOOKUP($B$2,Salary!$A:$Z,4,FALSE)`
HRA	`=VLOOKUP($B$2,Salary!$A:$Z,6,FALSE)`
EPF	`=VLOOKUP($B$2,Salary!$A:$Z,10,FALSE)`
Net pay	`=VLOOKUP($B$2,Salary!$A:$Z,14,FALSE)`

In Excel 2021 / Microsoft 365 use XLOOKUP for clearer references: =XLOOKUP($B$2,Salary!EmpID,Salary!Basic). Change B2 to any ID and the whole slip updates.

Tip: Wrap each lookup in IFERROR(...,"") so a blank or wrong ID shows an empty field instead of #N/A, keeping printed slips clean.

Fact box. A single Excel payslip template driven by VLOOKUP/XLOOKUP on Employee ID can generate slips for an entire workforce — you change one cell, the layout redraws, and you print or export to PDF. No separate file per employee is needed. (Source: Excel best practice.)

How do I show net pay in words?

Many payslips show net pay in words (e.g. "Rupees Forty-Five Thousand Only"). Excel has no built-in function for this, so either:

Maintain a small helper area with a custom formula, or
Add a one-line SPELLNUMBER VBA user-defined function and call =SpellNumber(NetPay).

If you prefer no macros, type the amount in words manually in a labelled cell — for a small team this is quick and avoids enabling VBA.

How to generate and issue payslips step by step

Finalise the salary sheet (gross, deductions, net pay per employee).
Build a payslip template sheet with the header, earnings and deductions blocks.
Add an Employee ID input cell and VLOOKUP/XLOOKUP formulas for every field.
Set the print area to the slip and check the page layout.
For each employee, change the ID and Print to PDF (or use Word mail-merge from the Excel data).
Email each PDF, or share securely.
Keep a copy of every issued slip for your records.

How Ankeshan helps: Ankeshan generates a payslip per employee straight from your Excel salary sheet — earnings, statutory deductions and net pay in words — and exports them to PDF for printing or email, with no macros to maintain. (Launching soon — join the waitlist for the free template, no sign-up.)

Frequently asked questions

Is it legal to issue payslips made in Excel? Yes. There is no prescribed format; a payslip made in Excel is valid as long as it shows earnings, deductions and net pay accurately for the pay period. Keep a copy on record.

How do I make one payslip template for all employees? Build the layout once and use VLOOKUP or XLOOKUP keyed on Employee ID. Changing the ID in one cell redraws the entire slip for that employee.

Can Excel email payslips automatically? Excel can export each slip to PDF; emailing can be done manually, via Word mail-merge, or with a short macro. For most small teams, exporting to PDF and attaching to email is simplest.

What deductions must a payslip show? The statutory ones that apply — EPF (employee), ESI (employee), professional tax and TDS — plus any advances or loss of pay, each on its own line so the net pay is transparent.

Sources

Code on Wages / state wage rules — wage-slip practice (obligation varies by state; confirm with your state's labour or wage department).
Standard Indian payroll practice (payslip contents).

General information, not professional advice. Verify on the official portal for your case. Reviewed by a Chartered Accountant; last updated 27 June 2026.