A simple salary slip format for Indian businesses. The Excel file works out PF, ESI and net pay for you. There is also a daily wage slip, a Hindi slip, and a tool to make a slip online.
Free · No sign-up · No email needed
This is what the format looks like, filled in for one employee.
| Employee name | Ramesh Kumar | Employee ID | EMP0012 |
|---|---|---|---|
| Designation | Store assistant | Department | Sales |
| Date of joining | 01-04-2024 | PAN | |
| UAN (PF number) | ESI number | ||
| Days in month | 31 | Paid days | 30 |
| Earnings | Full month (₹) | This month (₹) | Deductions | Amount (₹) |
|---|---|---|---|---|
| Basic | 12,000 | 11,613 | PF (employee 12%) | 1,394 |
| HRA | 4,800 | 4,645 | ESI (employee 0.75%) | 146 |
| Conveyance | 1,600 | 1,548 | Professional tax (PT) | 200 |
| Special allowance | 1,600 | 1,548 | Income tax (TDS) | 0 |
| Overtime | — | 0 | Advance / loan | 1,000 |
| Gross earnings | 20,000 | 19,354 | Total deductions | 2,740 |
| Net pay | ₹16,614 |
|---|---|
| Net pay in words | Sixteen thousand six hundred fourteen rupees only |
Pick the file you like to work with. All are free.
| Format | Excel | Word | |
|---|---|---|---|
| Monthly salary slip | Excel ↓ | Word ↓ | PDF ↓ |
| Daily wage / labour slip | Excel ↓ | Word ↓ | PDF ↓ |
| Salary slip in Hindi (वेतन पर्ची) | Excel ↓ | Word ↓ | PDF ↓ |
Excel: type in the yellow cells and the rest works out by itself. Word: change the sample details to yours. PDF: page 1 is a sample, page 2 is blank to print and fill by hand.
Need one sheet for all your staff? See the salary sheet format in Excel →
Every line of the format, in simple words.
In the sample above: basic for 30 of 31 days is ₹12,000 × 30 ÷ 31 = ₹11,613. PF is 12% of ₹11,613 = ₹1,394. ESI is 0.75% of ₹19,354 = ₹146, rounded up.
Type the details. The slip updates as you type. Then print it or save it as a PDF.
| Employee name | Employee ID | ||
|---|---|---|---|
| Designation | Loss of pay days | ||
| Days in month | Paid days |
| Earnings | Full month (₹) | This month (₹) | Deductions | Amount (₹) |
|---|---|---|---|---|
| Basic | PF (employee 12%) | |||
| HRA | ESI (employee 0.75%) | |||
| Conveyance | Professional tax (PT) | |||
| Special allowance | Income tax (TDS) | |||
| Overtime | — | Advance / loan | ||
| Bonus | — | Other deduction | ||
| Gross earnings | Total deductions |
| Net pay | |
|---|---|
| Net pay in words |
BizlumoAI makes every payslip for you. Free for up to 10 employees.