Template Overview
A salary slip is the monthly pay statement an employer gives to an employee, showing earnings, deductions, and the final net salary payable. This template keeps the format simple and professional: fill in company details, employee details, salary month, earnings such as basic pay and HRA, and deductions such as provident fund, professional tax, or TDS. The sheet automatically totals gross earnings, total deductions, and net salary payable. It is useful for small businesses, HR teams, accountants, and founders who need a clean payroll document without setting up full payroll software.
Features
- Auto-calculates gross earnings, deductions, and net salary
- Separate earnings and deductions sections
- Includes employee, company, bank, and salary month fields
- Editable for PF, professional tax, TDS, bonus, and allowances
- Works in Excel, Google Sheets, and LibreOffice
Instructions
- Download the file and open it in Excel, Google Sheets, or LibreOffice.
- Replace the company name, address, and contact details at the top.
- Fill in the employee name, ID, designation, department, bank account, and salary month.
- Enter earnings such as basic salary, HRA, conveyance allowance, special allowance, or bonus.
- Enter deductions such as provident fund, professional tax, TDS, loan recovery, or other deductions.
- Review the gross earnings, total deductions, and net salary payable before sharing the slip.
- Save a copy as PDF before sending it to the employee.
FAQ
Is this salary slip template free?
Yes. It is free to download and edit for personal and business use.
Does the net salary calculate automatically?
Yes. Gross earnings, total deductions, and net salary payable are formula-driven and update as soon as you change the amounts.
Can I edit the earnings and deduction names?
Yes. You can rename every component, add allowances, remove unused rows, and adapt the template to your payroll structure.
Does it work in Google Sheets?
Yes. Upload the file to Google Sheets and the formulas carry over.