How to Make a Salary Slip in Excel (Step-by-Step + Free Template)

A salary slip — also called a pay slip or salary payslip — is one of the most important documents an Indian employee receives every month. It proves your income, breaks down your earnings and deductions, and is what banks, tax officers, and visa authorities ask for as evidence of employment. If you're an employer paying salaries, issuing one is legally required. This guide shows you how to make a clean, compliant salary slip in Excel — with a simple salary slip format you can adapt, real calculations for HRA, EPF, ESI, and TDS, and a free salary slip template to download.

Who needs a salary slip

• Employees — to verify your pay is correct, claim HRA at tax time, and prove income for loans, credit cards, or visas
• Employers and HR teams — to comply with the Payment of Wages Act and state Shops and Establishments Acts, which require issuing a slip each pay period
• Small business owners paying even a single employee — the law does not exempt small businesses; a proper salary slip protects both parties
• Freelancers or consultants — even if you don't get a formal slip, a self-issued "salary/income statement" in this format works for loan and visa applications

What a salary slip should include

A practical salary slip must include the following sections. Missing any of these can cause the slip to be rejected by a bank or tax officer:

• Company details — company name, registered address, email, phone number, and (optionally) logo
• Employee details — employee name, employee ID, designation, department, date of joining, and bank account number
• Salary period — the month and year the slip belongs to (e.g. "Salary for July 2026")
• Earnings — basic salary, House Rent Allowance (HRA), Dearness Allowance (DA), conveyance, medical, special allowance, bonus, and any other earnings
• Deductions — Employee Provident Fund (EPF), Employees' State Insurance (ESI), professional tax, TDS (income tax), loan recovery, and any other deductions
• Gross earnings — the total of all earnings (a formula, not a hard-coded number)
• Total deductions — the total of all deductions
• Net salary payable — gross earnings minus total deductions, the amount actually credited to the bank

The exact components vary by company, industry, and country, so treat the format as a payroll document you can adapt — but keep every section labelled clearly.

Salary slip vs pay slip vs salary certificate vs Form 16

These four terms confuse a lot of people. They are related but different:

• Salary slip / Pay slip — the two are the same thing. Different companies use different names. It is a monthly document showing one month's earnings, deductions, and net pay.
• Salary certificate — a summary letter from the employer stating designation, duration of employment, and annual salary. Usually issued on request (for a bank loan, visa, or new job).
• Form 16 — an annual tax document issued by employers under the Income Tax Act showing salary paid and TDS deducted across the financial year. Required for ITR filing.
• Offer letter / appointment letter — the initial employment contract stating agreed pay and terms. Not proof of ongoing salary.

Banks and visa officers usually ask for 3 recent salary slips + latest Form 16 + bank statement. Salary certificate is requested separately if needed.

Basic salary vs gross salary vs net salary — what's the difference?

This is where most people get confused. Three numbers appear on every salary slip:

• Basic salary — the fixed base component decided at hiring. Most other components (HRA, EPF, gratuity) are calculated as a percentage of basic. Typically 40–50% of gross for most private companies.
• Gross salary (Gross earnings) — Basic + HRA + DA + all allowances + bonus. The full "cost to company" before any deductions. This is what banks look at for loan eligibility.
• Net salary (Take-home / In-hand) — Gross salary minus all deductions (EPF, ESI, professional tax, TDS). This is the amount actually credited to your bank account.

Example for an employee with ₹50,000 gross salary:

• Basic: ₹20,000 | HRA: ₹10,000 | Conveyance: ₹1,600 | Special allowance: ₹18,400
• Gross: ₹50,000
• EPF (12% of basic): ₹2,400 | Professional tax: ₹200 | TDS: ₹2,000
• Net take-home: ₹45,400

Step-by-step: create a salary slip in Excel

1. Create the header. Add your company name, address, contact details, and the title "Salary Slip" or "Pay Slip". Add "For the month of [Month] [Year]" prominently.
2. Add employee information. Include employee name, employee ID, designation, department, joining date, bank account, PAN, and UAN (for EPF).
3. Build the earnings table. Add rows for basic salary, HRA, DA, conveyance allowance, medical allowance, special allowance, bonus, and any other earnings. Amount column on the right.
4. Build the deductions table. Add rows for EPF, ESI, professional tax, TDS, loan recovery, and any other deductions.
5. Add formulas. Use SUM to calculate gross earnings and total deductions. Then calculate net salary as Gross Earnings minus Total Deductions.
6. Add signature space. Employer/HR signature line at the bottom right; "This is a system-generated slip" line if you don't sign physically.
7. Review before sharing. Check employee details, salary month, tax deductions, and final net salary. Save as a password-protected PDF before sending.

Useful Excel formulas

You only need simple formulas — no complex macros:

• Gross earnings: =SUM(earnings_range)
• Total deductions: =SUM(deductions_range)
• Net salary: =gross_earnings-total_deductions

For per-component calculations, common patterns are:

• HRA = 40% or 50% of basic (metro vs non-metro): =basic_salary*0.50
• EPF (employee contribution, 12% of basic): =basic_salary*0.12
• Professional tax (varies by state, flat monthly): a hard-coded amount is fine, e.g. =200 for most Maharashtra/Karnataka bands
• Round-off net salary to nearest rupee: =ROUND(net_salary,0)

Keep formula cells in locked/protected ranges if multiple people edit the sheet.

How each component is calculated (with example numbers)

Understanding the maths helps you (as employee) verify your slip or (as employer) explain it. Using ₹50,000 gross monthly salary:

• HRA exemption for tax: the exempt portion is the least of (i) actual HRA received, (ii) rent paid − 10% of basic, (iii) 50% of basic in metros / 40% in non-metros. Use monthly rent receipts to prove rent paid — our Rent Receipt Template is designed for this.
• EPF (Employee Provident Fund): 12% of basic salary from both employee and employer. On ₹20,000 basic, that's ₹2,400 from each side. Employer's ₹2,400 splits into ₹1,750 to EPS (pension) and ₹650 to EPF.
• ESI (Employees' State Insurance): applies only if gross salary ≤ ₹21,000/month. Employee contributes 0.75% of gross, employer 3.25%. Skip this line if the employee earns more than ₹21,000.
• Professional tax: state-specific, flat monthly amount (₹200 in Maharashtra/Karnataka on higher slabs; nil in Delhi/UP). Check your state's slab.
• TDS (Income tax deducted at source): based on the employee's declared investments and annual tax slab, divided by 12 for monthly deduction. Actual calculation is done by HR using the current year's income-tax slabs — the salary slip just shows the monthly amount deducted.

What can you do with a salary slip?

A salary slip is not just an HR formality — it unlocks several real-world uses:

• HRA claim at tax time — submit last 12 months of slips (plus rent receipts) to your employer to reduce TDS, or use them to compute HRA exemption when filing ITR
• Home loan / personal loan / credit card — banks universally require last 3 months of slips as income proof
• Visa application — most tourist and work visas need 3-6 months of slips
• ITR filing — cross-check TDS deducted in your Form 26AS against your salary slips
• Provident Fund withdrawal / transfer — need slips as proof of employment period
• New job negotiation — recruiters often ask for a recent slip to verify your CTC

Given this, keep a well-organised folder of your monthly slips — ideally as PDFs named "salary-slip-2026-07.pdf" for each month.

Common mistakes to avoid

• Forgetting the salary month — old slips become impossible to file when the period is missing
• Mixing earnings and reimbursements — reimbursements (travel expenses, phone bill) are NOT salary; keep them in a separate reimbursement voucher
• Using hard-coded totals instead of formulas — one wrong entry corrupts the net pay; formulas catch this
• Sending editable Excel files — always export to PDF before sending; the recipient (bank, employer, tax officer) expects PDF
• Not password-protecting — salary is sensitive data; add a password (usually employee's PAN or DOB in DDMMYYYY format) before emailing
• Ignoring EPF/ESI/PT rules for your state — statutory deductions vary; verify PF, ESI, and professional tax rules for your state before official use
• Skipping the employer signature or system-generated note — an unsigned slip can be rejected by banks

Save time with a free template

Instead of building the layout and formulas from scratch, download our free salary slip template. It includes company header, employee details, standard earnings and deductions sections, automatic gross pay, total deductions, and net salary payable — all with live formulas. Just enter the numbers for your employee.

If you also manage cash flow and expenses, our cash book template and business expense tracker keep payroll-related spending organized. For rent-receipt-based HRA claims, use the Rent Receipt Template for HRA alongside your salary slip.

Summary

A good salary slip is clear, formula-driven, statutorily compliant, and easy to verify. Create separate sections for company details, employee details, earnings (basic + HRA + allowances), and deductions (EPF, ESI, professional tax, TDS). Use SUM formulas for gross and totals, then subtract to get net salary. Save as password-protected PDF each month — you'll need those slips for HRA, loans, visas, and ITR filing over the coming years.

FAQ

Is a salary slip legally required in India?

Yes. Under the Payment of Wages Act and state Shops and Establishments Acts, employers must provide a salary slip (or pay slip) to every employee for each pay period. It must show earnings, deductions, and net pay. Both physical and electronic (PDF) formats are accepted.

Which deductions must appear on a salary slip?

Statutory deductions that must be shown separately include Employee Provident Fund (EPF), Employees' State Insurance (ESI) where applicable, professional tax, and TDS (income tax deducted). Other deductions such as loan repayments or advances should also be listed as separate line items so the employee can verify each one.

Can I email a salary slip in Excel format?

Better to export the Excel salary slip as a password-protected PDF before emailing. PDF prevents accidental edits, looks the same on every device, and is what banks and other institutions expect when the employee submits it for loans or visa applications.

How do I calculate net salary?

Net salary is gross earnings minus total deductions. Gross earnings usually include basic pay, HRA, conveyance, medical, and any allowances or bonuses. Deductions include EPF, ESI, professional tax, and TDS. In Excel, set net pay as a simple SUM(earnings) minus SUM(deductions) formula so it updates automatically as you edit the components.