# Salary Slip Format: Components, Sample and Excel Template

> Salary slip format for India: every component explained, a filled sample slip, a copy-ready template, Excel formulas, and how to get slips from HR.

Canonical: https://tryelip.ai/blog/salary-slip-format
Last updated: 2026-11-20

Published 2026-11-20.

A salary slip is the monthly statement your employer gives you with your salary. It lists what you earned (basic pay, allowances, overtime), what was deducted (PF, professional tax, income tax and any recovery), and the net amount paid into your bank account. The standard salary slip format in India has four blocks: company and employee details, attendance, earnings and deductions, and net pay. This page explains each component, shows a filled sample, gives a format you can copy into Word or Excel, and covers how to get your slips from HR.

To see how your CTC turns into the net pay on your slip, use our [in-hand salary calculator](https://tryelip.ai/tools/in-hand-salary-calculator), or read [CTC meaning](https://tryelip.ai/blog/ctc-meaning) for the full breakdown.

## Is a salary slip compulsory?

Yes. Section 50(3) of the [Code on Wages, 2019](https://www.indiacode.nic.in/bitstream/123456789/15793/1/aA2019-29.pdf) says "Every employer shall issue wage slips to the employees in such form and manner as may be prescribed." The Code came into force on 21 November 2025, according to the [Labour Ministry's release on PIB](https://www.pib.gov.in/PressReleasePage.aspx?PRID=2192463). Section 50(4) exempts an employer only to the extent that it employs not more than five people for agriculture or domestic purposes.

For establishments under the central government's sphere, rule 52 of the [Code on Wages (Central) Rules, 2026](https://egazette.gov.in/WriteReadData/2026/272365.pdf) requires wage slips "electronically or in physical form" in Form V, "on or before payment of wages". Other establishments follow the rules their state government makes under the Code. For monthly-paid staff, section 17(1) of the Code says wages are paid before the seventh day of the following month, so your slip should reach you by then.

## What the official wage slip (Form V) contains

Form V in the [central rules](https://egazette.gov.in/WriteReadData/2026/272365.pdf) lists these fields. Most company payslips carry them, plus a few more.

- Date of issue, name and address of the establishment, and the period
- Name of employee, and father's, mother's or spouse's name
- Designation
- UAN (Universal Account Number for PF)
- Bank account number
- Wage period
- Rate of wages payable: basic, DA and allowances
- Total attendance or units of work done
- Overtime wages
- Gross wages payable
- Total deductions: PF, ESI and others
- Net wages paid
- Employer or pay-in-charge signature (needed if the register is kept on paper)

## Salary slip components explained

### Employee and company details

- **Company name, address and logo.**
- **Employee name, employee ID, designation and department.**
- **Date of joining.**
- **PAN:** used for income tax deducted at source (TDS).
- **UAN and PF number:** link your PF across jobs with the same UAN.
- **ESI number:** only if you are covered by ESI.
- **Bank name and account number:** usually shown partly masked.
- **Pay period:** the month, for example November 2026.

### Attendance

- **Days in month:** 28, 29, 30 or 31.
- **Days paid:** days you are paid for, including paid leave and holidays.
- **Loss of pay (LOP) days:** unpaid absences. Many companies work out the deduction as monthly gross divided by the days in the month, multiplied by the LOP days. Your company's policy sets the exact method.

### Earnings

- **Basic pay:** the base salary. PF and gratuity are calculated on it.
- **Dearness allowance (DA):** common in government and some manufacturing jobs; linked to inflation.
- **House rent allowance (HRA):** an allowance towards rent.
- **Conveyance or transport allowance.**
- **Special allowance:** the balancing figure that makes up fixed pay.
- **Overtime:** extra hours, where paid.
- **Bonus, incentive or commission:** shown in the month it is paid.
- **Arrears:** back pay, for example after a hike applied from an earlier month.
- **Gross earnings:** the total of the earnings column.

Under section 2(y) of the [Code on Wages](https://www.indiacode.nic.in/bitstream/123456789/15793/1/aA2019-29.pdf), if allowances such as HRA, conveyance and overtime exceed half of total pay, the excess counts as wages. That is why many slips now show basic pay at about half of gross pay.

### Deductions

- **Provident fund (employee share):** 12% of PF wages. The [EPFO's FAQ](https://pmvbry-cdn.epfindia.gov.in/wp-content/uploads/2026/09/EPFO_Wage_Ceiling_FAQs.pdf) says the wage ceiling is 25,000 a month from 17 September 2026, and where wages exceed it, the statutory contribution may generally be restricted to the ceiling unless the employee contributes on higher wages. If your employer caps PF, the deduction is at most 3,000 a month.
- **ESI:** for employees covered by the Employees' State Insurance scheme.
- **Professional tax:** a state tax. Some states do not levy it, and under [Article 276(2) of the Constitution](https://www.constitutionofindia.net/articles/article-276-taxes-on-professions-trades-callings-and-employments/) it cannot exceed 2,500 rupees a year in total.
- **Income tax (TDS):** your employer deducts it monthly based on your expected tax for the year.
- **Loan or advance recovery, canteen, transport or other recoveries.**
- **Total deductions:** the total of the deductions column.

Section 18 of the Code on Wages lists the deductions an employer may make, and the [Model Standing Orders, 2026](https://egazette.gov.in/WriteReadData/2026/272341.pdf) for the service sector repeat that no deductions are made except those the Code authorises.

### Employer contributions (shown for information)

Some slips show the employer's PF and gratuity alongside. These are part of your CTC but are not paid to you and do not change your net pay. The [EPFO's FAQ](https://pmvbry-cdn.epfindia.gov.in/wp-content/uploads/2026/09/EPFO_Wage_Ceiling_FAQs.pdf) shows the employer's 12% split into 8.33% for the pension scheme and 3.67% for the provident fund.

### Net pay

- **Net pay = gross earnings minus total deductions.** This is the amount credited to your bank account. Many slips also write it in words.

## Sample salary slip (filled)

This sample is for a monthly-paid employee in a private company, for November 2026, with basic pay at about half of gross. The figures are an example; your company's slip will differ.

**Company and employee details**

- Company: Sample Technologies Pvt. Ltd., 2nd Floor, MG Road, Pune 411001
- Payslip for the month of: November 2026
- Employee name: Neha Joshi
- Employee ID: ST1042
- Designation: Associate, Operations
- Date of joining: 1 July 2025
- PAN: XXXXX1234X
- UAN: 1012XXXXXXXX
- Bank account: XXXXXXXX4521

**Attendance**

- Days in month: 30
- Days paid: 30
- Loss of pay days: 0

**Earnings**

- Basic pay: 25,000
- House rent allowance: 10,000
- Special allowance: 12,000
- Gross earnings: 47,000

**Deductions**

- Provident fund (12% of 25,000): 3,000
- Professional tax (example figure; your state sets it): 200
- Income tax (TDS): 0
- Total deductions: 3,200

**Net pay**

- Net pay: 43,800 (Rupees forty-three thousand eight hundred only)

**Employer contributions (not paid in hand)**

- Employer PF (12% of 25,000): 3,000

Why the TDS is nil: Neha's yearly gross is 47,000 × 12 = 5,64,000. After the 75,000 standard deduction her taxable income is 4,89,000, well under the 12 lakh up to which, according to the [Budget 2025-26 speech](https://www.indiabudget.gov.in/budget2025-26/doc/budget_speech.pdf), no income tax is payable in the new regime. The new regime rates for FY 2026-27 are unchanged, according to the [Budget 2026 memorandum](https://www.indiabudget.gov.in/doc/memo.pdf).

## Salary slips in special months

Some months look different, and the slip should show why.

- **Joining month:** you are paid for the days from your joining date. Using the sample above, if Neha had joined on 16 November, she would be paid for 15 of 30 days: 47,000 ÷ 30 × 15 = 23,500 gross, with PF on the reduced basic of 12,500.
- **After a hike:** the new rates appear from the month the hike is processed. If it applies from an earlier month, the difference shows as arrears.
- **Unpaid leave:** the loss of pay days and the deduction appear in the attendance block and reduce gross earnings.
- **Bonus month:** the bonus is shown as an earning, and TDS that month can be higher because your employer recalculates your expected tax for the year.
- **Last month (full and final):** the slip or a separate settlement statement shows salary up to your last working day, leave encashment if your policy allows it, and any recovery for unserved notice. Section 17(2) of the [Code on Wages](https://www.indiacode.nic.in/bitstream/123456789/15793/1/aA2019-29.pdf) says wages of an employee who has resigned are paid within two working days of the resignation.

## Salary slip format (copy this)

Paste this into Word, Google Docs or the first column of an Excel sheet and fill in the brackets.

> [Company Name]
> [Company Address]
> 
> Payslip for the month of [Month YYYY]
> 
> Employee name: [Name]
> Employee ID: [ID]
> Designation: [Designation]
> Department: [Department]
> Date of joining: [DD Month YYYY]
> PAN: [PAN]
> UAN: [UAN]
> ESI number: [Number, if covered]
> Bank account: [Bank Name], [Account Number, partly masked]
> 
> Days in month: [Number]
> Days paid: [Number]
> Loss of pay days: [Number]
> 
> EARNINGS
> Basic pay: [Amount]
> Dearness allowance: [Amount]
> House rent allowance: [Amount]
> Conveyance allowance: [Amount]
> Special allowance: [Amount]
> Overtime: [Amount]
> Bonus / incentive: [Amount]
> Arrears: [Amount]
> Gross earnings: [Total]
> 
> DEDUCTIONS
> Provident fund: [Amount]
> ESI: [Amount]
> Professional tax: [Amount]
> Income tax (TDS): [Amount]
> Loan / advance recovery: [Amount]
> Other deductions: [Amount]
> Total deductions: [Total]
> 
> NET PAY: [Gross earnings minus total deductions]
> Net pay in words: [Rupees ... only]
> 
> Employer contributions (not paid in hand)
> Employer PF: [Amount]
> Employer ESI: [Amount]
> 
> This is a system-generated payslip. / [Authorised signatory, name and designation]

## Salary slip format in Excel: the formulas

Set it up once and copy the sheet for each month. This layout puts labels in column A and amounts in column B.

1. **Rows 1 to 12:** company and employee details as in the format above.
2. **B14:** days in month. **B15:** loss of pay days.
3. **B18 to B22:** the monthly rates for basic, HRA, conveyance, special allowance and other earnings.
4. **Gross before LOP, B23:** =SUM(B18:B22)
5. **LOP deduction, B24:** =ROUND(B23/B14\*B15,0) (gross divided by days in month, times LOP days; change it if your company uses a different method).
6. **Gross earnings, B25:** =B23-B24
7. **Provident fund, B27:** =ROUND(MIN(B18,25000)\*12%,0) if PF is capped at the 25,000 wage ceiling, or =ROUND(B18\*12%,0) if it is on full basic. If basic is reduced for LOP, use the reduced figure.
8. **Professional tax, B28, TDS, B29, and other deductions, B30:** enter the amounts.
9. **Total deductions, B31:** =SUM(B27:B30)
10. **Net pay, B33:** =B25-B31

Format the amount cells as numbers and lock the formula cells before you share the sheet.

## Which salary slips banks and visa offices ask for

- **Personal loans:** SBI's [personal loan FAQ](https://sbi.bank.in/web/faq-s/faq-personal-loan) lists "6 months' Salary Slips" and the latest ITR or Form 16 among the documents for salaried applicants.
- **Visas:** the Swiss visitor visa [checklist for India](https://www.vfsglobal.com/one-pager/switzerland/india/english/pdf/Checklist_Visitor-EN-2025.pdf) asks employed applicants for the last three months' salary slips and salary account statements.
- **Rental agreements and new employers** may also ask for recent slips.

Some lenders ask for a salary certificate instead of, or as well as, slips. Our [salary certificate format](https://tryelip.ai/blog/salary-certificate-format) explains the difference and has samples.

A slip from your company's payroll system usually carries the line "This is a system-generated payslip and does not require a signature." If an office wants a signed copy, ask HR to sign and stamp a printout.

## How to get your salary slips from HR

Most companies publish slips on the HR or payroll portal each month. If you cannot find them, or need older ones, email HR.

> Subject: Request for salary slips: [Your Name], [Employee ID]
> 
> Dear [HR Contact's Name],
> 
> I need my salary slips for [Month YYYY] to [Month YYYY] for [a loan application / a visa application / my records].
> 
> I could not find them on the payroll portal. Could you please share them by email, [signed and stamped if possible], by [DD Month YYYY]?
> 
> Thank you,
> [Your Name]
> [Employee ID]
> [Designation], [Department]
> [Phone Number]

If you have left the company, write to the HR email address and attach your relieving letter or employee ID. Our [relieving letter format](https://tryelip.ai/blog/relieving-letter-format) covers what to keep when you leave.

## How to check your salary slip each month

1. **Days paid:** match it with your attendance and approved leave.
2. **Earnings:** match each line with the breakup in your [offer letter](https://tryelip.ai/blog/offer-letter-format). After a hike, check that the new rates and any arrears appear; our [salary hike calculator](https://tryelip.ai/tools/salary-hike-calculator) helps you check the percentage.
3. **PF:** check it against your basic, then check the credit in your PF passbook on the EPFO member portal.
4. **TDS:** if it jumps, ask HR whether your tax regime choice or investment declarations were recorded.
5. **Net pay:** match it with the credit in your bank statement.

## Finding your next role

[Meet Elip](https://tryelip.ai/), an AI career agent. Add your resume and say what you want. Each morning it brings you a few jobs that fit, each with the reason. It rewrites your resume for each role, with your approval. It is free for candidates.

## Sources

- Code on Wages, 2019 (India Code), sections 2(y), 17, 18 and 50: [https://www.indiacode.nic.in/bitstream/123456789/15793/1/aA2019-29.pdf](https://www.indiacode.nic.in/bitstream/123456789/15793/1/aA2019-29.pdf)
- Ministry of Labour and Employment (PIB), "Government Makes the Four Labour Codes effective" (21 November 2025): [https://www.pib.gov.in/PressReleasePage.aspx?PRID=2192463](https://www.pib.gov.in/PressReleasePage.aspx?PRID=2192463)
- Code on Wages (Central) Rules, 2026, G.S.R. 343(E), 8 May 2026 (Gazette of India), rule 52 and Form V: [https://egazette.gov.in/WriteReadData/2026/272365.pdf](https://egazette.gov.in/WriteReadData/2026/272365.pdf)
- Model Standing Orders, 2026, S.O. 2312(E), 8 May 2026 (Gazette of India): [https://egazette.gov.in/WriteReadData/2026/272341.pdf](https://egazette.gov.in/WriteReadData/2026/272341.pdf)
- EPFO, "Frequently Asked Questions: Revision of EPFO Statutory Wage Ceiling": [https://pmvbry-cdn.epfindia.gov.in/wp-content/uploads/2026/09/EPFO\_Wage\_Ceiling\_FAQs.pdf](https://pmvbry-cdn.epfindia.gov.in/wp-content/uploads/2026/09/EPFO_Wage_Ceiling_FAQs.pdf)
- Constitution of India, Article 276: [https://www.constitutionofindia.net/articles/article-276-taxes-on-professions-trades-callings-and-employments/](https://www.constitutionofindia.net/articles/article-276-taxes-on-professions-trades-callings-and-employments/)
- Ministry of Finance, Budget 2025-2026 speech: [https://www.indiabudget.gov.in/budget2025-26/doc/budget\_speech.pdf](https://www.indiabudget.gov.in/budget2025-26/doc/budget_speech.pdf)
- Ministry of Finance, Memorandum explaining the provisions in the Finance Bill, 2026: [https://www.indiabudget.gov.in/doc/memo.pdf](https://www.indiabudget.gov.in/doc/memo.pdf)
- State Bank of India, Personal loan FAQs: [https://sbi.bank.in/web/faq-s/faq-personal-loan](https://sbi.bank.in/web/faq-s/faq-personal-loan)
- Embassy of Switzerland in India via VFS Global, visitor visa checklist (2025): [https://www.vfsglobal.com/one-pager/switzerland/india/english/pdf/Checklist\_Visitor-EN-2025.pdf](https://www.vfsglobal.com/one-pager/switzerland/india/english/pdf/Checklist_Visitor-EN-2025.pdf)

## Frequently asked questions

### What is a salary slip?

A salary slip, or payslip, is the monthly statement of your pay. It shows your earnings, such as basic pay and allowances, the deductions, such as PF, professional tax and income tax, and the net amount paid to your bank account. Section 50(3) of the Code on Wages requires every employer to issue wage slips.

### What is the format of a salary slip?

A salary slip has four parts: company and employee details (name, ID, designation, PAN, UAN, bank account), attendance (days paid and loss of pay), earnings and deductions side by side, and the net pay in figures and words. The official central format, Form V, also lists overtime, gross wages and total deductions.

### How do I make a salary slip in Excel?

Put labels in column A and amounts in column B. Add the earnings with a SUM formula, subtract any loss-of-pay amount, work out PF as 12% of basic (or of the 25,000 ceiling if your employer caps it), add the deductions with another SUM, and subtract total deductions from gross earnings to get net pay. Copy the sheet for each month.

### Is a salary slip without a signature valid?

A payslip generated by the company's payroll system usually says that no signature is needed, and many offices accept it. Some banks, embassies and landlords ask for a signed and stamped copy. In that case, ask HR to sign and stamp a printout, or to issue a salary certificate on letterhead.

### How many months of salary slips do banks ask for?

It depends on the bank and the loan. SBI's personal loan FAQ asks for six months of salary slips, and the Swiss visa checklist for India asks for three months. Check the document list for your application, and keep the last six months of slips saved where you can find them.

### What is the difference between a salary slip and a salary certificate?

A salary slip is issued every month and shows that month's earnings, deductions and net pay. A salary certificate is a one-time letter on company letterhead, signed by HR, confirming your employment and your salary, usually your gross and net monthly or yearly pay. Banks and embassies ask for one or the other, sometimes both.

### Why is PF deducted on only part of my salary?

PF is 12% of your PF wages, which are mainly basic pay (and DA, if any), not your full gross pay. Many employers also cap PF at the EPFO wage ceiling, which is 25,000 a month from 17 September 2026, so the deduction stops at 3,000 a month. Your employer's policy decides which method applies.

## Related

- [All posts](https://tryelip.ai/blog)
