Salary Slip Format in Excel

[COMPANY NAME]
[Company address · City, State PIN]
Salary slip for the month of October 2026

Employee name	[EMPLOYEE NAME]			Employee ID	[EMP-001]
Designation	[DESIGNATION]			Department	[DEPARTMENT]
Date of joining	2024-04-01			PAN	[ABCDE1234F]
UAN (EPF)	[UAN]			ESIC IP number	[IP NUMBER or N/A]
Bank account (last 4 digits)	[XXXX]			Pay month (any date in it)	Oct 2026
Days in month	31			Loss of pay (LOP) days	1
Paid days	30

Earnings	Monthly rate (full month)	Earned this month		Deductions	Amount (₹)
Basic	25,000	24,194		Provident fund (EPF) — employee	1,800
Dearness allowance (DA)	0	0		ESI — employee	0
House rent allowance (HRA)	10,000	9,677		Professional tax	200
Conveyance allowance	1,600	1,548		Income tax (TDS)	1,500
Special allowance	8,400	8,129		Loan / advance recovery	0
Overtime	— enter earned	0		[Other deduction]	0
Bonus / incentive	— enter earned	0
[Other earning]	— enter earned	0
Gross earnings	45,000	43,548		Total deductions	3,500

NET PAY (₹)	40,048
Net pay in words	Rupees Forty Thousand Forty-Eight Only

Employer contributions (not deducted from pay)
EPF — employer total	1,800		Leave summary (optional): opening [ ] · availed [ ] · closing [ ] Remarks: [ ]
of which pension (EPS)	1,250
of which EPF account	550
ESI — employer	0
Cost to company this month	45,348

Employee signature: ______________________				For [COMPANY NAME] — Authorised signatory
This is a salary slip template. Yellow cells: your data. Blue cells: calculated.
Template — check with your payroll adviser. © Layers (layers.md) · CC BY 4.0

Settings — rates used by the slip
Change them if your establishment’s rules differ.

EPF employee rate	12%	Employee share on basic + DA (PF wage).
EPF employer rate (total)	12%	Employer share, split into EPS and EPF account.
PF wage ceiling (₹ per month)	15,000	Statutory wage ceiling for compulsory PF contributions.
Restrict PF to the ceiling?	Yes	Yes = contributions on min(PF wage, ceiling). No = on the full PF wage.
ESI employee rate	0.75%	Deducted from employees covered by ESI.
ESI employer rate	3.25%	Paid by the employer for covered employees.
ESI wage ceiling (₹ per month)	21,000	Coverage limit used when “ESI applies” is Auto.
ESI applies to this employee?	Auto	Auto = if the monthly rate total is within the ceiling. Coverage is decided for the whole contribution period — set Yes/No if you know it.
EPS (pension) rate	8.33%	Part of the employer share, on PF wage up to the ceiling.


■ Sources and checks
EPF and EPS rates and the ₹15,000 wage ceiling: EPFO. ESI rates and the ₹21,000 limit: ESIC.
Professional tax is set by each State; enter the monthly amount for your State and slab.
TDS: enter the monthly amount from your payroll tax computation (old or new regime).
The four Labour Codes are in force from 21 November 2025 (PIB). See the “Wage check” sheet.


Template — check with your payroll adviser. © Layers (layers.md) · CC BY 4.0

Code on Wages, 2019 — 50% check
Section 2(y): if excluded allowances exceed half of total remuneration, the excess is treated as wages.

Earning (from the slip)	Earned (₹)	Excluded from “wages”?	Note
Basic	N('Salary Slip'!C14)	No	Basic pay, DA and retaining allowance are wages.
Dearness allowance (DA)	N('Salary Slip'!C15)	No
House rent allowance (HRA)	N('Salary Slip'!C16)	Yes	HRA, conveyance, overtime and statutory bonus are listed as excluded.
Conveyance allowance	N('Salary Slip'!C17)	Yes
Special allowance	N('Salary Slip'!C18)	No	Allowances not in the exclusion list usually count as wages — check yours.
Overtime	N('Salary Slip'!C19)	Yes
Bonus / incentive	N('Salary Slip'!C20)	Yes
[Other earning]	N('Salary Slip'!C21)	No

Total remuneration	SUM(B5:B12)
Excluded items	SUMIF(C5:C12,"Yes",B5:B12)
Excluded as % of total	IF(B14=0,0,B15/B14)
Amount added back to wages	MAX(B15-B14/2,0)
Result	IF(B17>0,"Above 50%: ₹"&TEXT(B17,"#,##0")&" may count as wages for PF, gratuity and bonus — check with your adviser.","Within 50% — no add-back.")


Template — check with your payroll adviser. © Layers (layers.md) · CC BY 4.0

Helper for amount in words (0–99). Do not edit.
0
1	One
2	Two
3	Three
4	Four
5	Five
6	Six
7	Seven
8	Eight
9	Nine
10	Ten
11	Eleven
12	Twelve
13	Thirteen
14	Fourteen
15	Fifteen
16	Sixteen
17	Seventeen
18	Eighteen
19	Nineteen
20	Twenty
21	Twenty-One
22	Twenty-Two
23	Twenty-Three
24	Twenty-Four
25	Twenty-Five
26	Twenty-Six
27	Twenty-Seven
28	Twenty-Eight
29	Twenty-Nine
30	Thirty
31	Thirty-One
32	Thirty-Two
33	Thirty-Three
34	Thirty-Four
35	Thirty-Five
36	Thirty-Six
37	Thirty-Seven
38	Thirty-Eight
39	Thirty-Nine
40	Forty
41	Forty-One
42	Forty-Two
43	Forty-Three
44	Forty-Four
45	Forty-Five
46	Forty-Six
47	Forty-Seven
48	Forty-Eight
49	Forty-Nine
50	Fifty
51	Fifty-One
52	Fifty-Two
53	Fifty-Three
54	Fifty-Four
55	Fifty-Five
56	Fifty-Six
57	Fifty-Seven
58	Fifty-Eight
59	Fifty-Nine
60	Sixty
61	Sixty-One
62	Sixty-Two
63	Sixty-Three
64	Sixty-Four
65	Sixty-Five
66	Sixty-Six
67	Sixty-Seven
68	Sixty-Eight
69	Sixty-Nine
70	Seventy
71	Seventy-One
72	Seventy-Two
73	Seventy-Three
74	Seventy-Four
75	Seventy-Five
76	Seventy-Six
77	Seventy-Seven
78	Seventy-Eight
79	Seventy-Nine
80	Eighty
81	Eighty-One
82	Eighty-Two
83	Eighty-Three
84	Eighty-Four
85	Eighty-Five
86	Eighty-Six
87	Eighty-Seven
88	Eighty-Eight
89	Eighty-Nine
90	Ninety
91	Ninety-One
92	Ninety-Two
93	Ninety-Three
94	Ninety-Four
95	Ninety-Five
96	Ninety-Six
97	Ninety-Seven
98	Ninety-Eight
99	Ninety-Nine