Salary Slip Format: Free Download in Excel, Word, PDF
Every month, someone in your office asks for a salary slip. It might be a new hire, a staff member applying for a loan, or an accountant who needs last quarter’s records building the document from scratch each time wastes effort. A ready-made- salary slip format fixes that.
On this page you can download a clear, editable format in three file types. You will also find a plain explanation of that goes into a payslip and how the final pay is worked out.
Salary Slip Download Format
Download Salary Slip Format in Excel:
Best if you want automatic totals. Enter the amounts and the gross pays, deductions net pay and amount in words update themselves.
Download Salary Slip Format in word:
Best if you want to change the layout, add a logo or adjust the wording by hand.
Download Salary Slip Format in PDF:
Best for a quick look at the layout, or for printing a blank copy to fill in by pen.
What Is a Salary Slip?
A salary slip, also called a payslip, is a monthly document from an employer. It shows what the employee earned, what was deducted what was finally paid. Under the code on wages, 2019 employers in India are expected provide one every day cycle.
Why You Need a Salary Slip
It is your everyday proof of income. Banks ask for it when you apply for a loan or credit card. Embassies check it for visa applications. You will also want it when filing income tax returns or negotiating pay at a new job. Keep at least the last six months saved.
What a Good Salary Slip Format Includes
A proper format should have these parts:
- Company detail: name, address and logo if you have one.
- Employee details: name, ID, designation, department, PAN and bank account number.
- Pay period: The month and year, plus working days and days paid.
- Earnings: basic salary, house rent allowance, spending allowance and any other pay.
- Deductions: provident fund, professional tax, TDS and anything else withheld.
- Totals: gross salary, total deductions and net pay.
- Signature area: for the employer and the employee.
Salary Slip Formula
- Gross Salary = Basic + HRA + Allowance + Bonuses
- Total Deduction = PF + TDS + Professional Tax + Other deductions
- Net Salary = Gross Salary – Total Deductions
If an employee is paid for fewer days than the month has, the earnings are scaled down: Earned amount = Monthly amount * Days paid / Working days.
Quick Example
Take an employee earning Rs 20000 basic Rs 12000 HRA and Rs 8000 special allowance.
Cross salary is Rs 50000. Provident fund is 3600 and professional tax is 200, so deductions are Rs 3800. Net salary is Rs 46200.
How to Fill in the Format
Start with the company and employee details. Then enter the month, working days and days paid. Add each earning and each deduction. In the Excel file, the totals fill in automatically. In Word, calculate then yourself and enter them. Read the figures once more before you share the slip, because a wrong PF of tax number causes trouble later.
Frequently Asked Questions
- Is a salary slip mandatory in India?
- Yes, Employers are expected to provide one under wage regulations.
- Can I edit the Excel file?
- Yes, Change only the input cells and the rest recalculates.
- Can I print it?
- Yes, The format fits on one A4 page.