Salary Slip Format: Components, Sample and Excel Template

What goes on a salary slip, a filled sample with every line explained, a copy-ready payslip format, Excel formulas, and how to ask HR for slips.

A pencil drawing of an open ring binder holding a stack of monthly pay slips, one with a yellow tab
On this page
  1. Is a salary slip compulsory?
  2. What the official wage slip (Form V) contains
  3. Salary slip components explained
  4. Sample salary slip (filled)
  5. Salary slips in special months
  6. Salary slip format (copy this)
  7. Salary slip format in Excel: the formulas
  8. Which salary slips banks and visa offices ask for
  9. How to get your salary slips from HR
  10. How to check your salary slip each month
  11. Finding your next role
  12. Sources
  13. FAQ

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, or read CTC meaning for the full breakdown.

Is a salary slip compulsory?

Yes. Section 50(3) of the Code on Wages, 2019 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. 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 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 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, 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 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 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 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 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, 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.

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 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.

Template

[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 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 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 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.

Template

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 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. After a hike, check that the new rates and any arrears appear; our 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, 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

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.

What’s next for you?

Start with your resume. Tell Elip what you want to change.

Meet Elip