Free Payroll Templates for Excel & Google Sheets
Salary slip, pay slip, and payroll templates for Indian small businesses and HR teams — with earnings, deductions, EPF, ESI, TDS, and net pay formulas built in.
Under the Payment of Wages Act and various state Shops and Establishments Acts, employers must issue a salary slip to every employee for each pay period showing earnings, statutory deductions, and net pay. This category gives you compliant salary slip and payroll formats you can run manually — no payroll software required.
Ideal for small businesses, agencies, shops, and HR teams handling monthly payroll for a handful of employees. Every template is designed to be printable, PDF-exportable, and clean when submitted to banks (for loan documentation) or during audits.
Templates in this category
A free salary slip template for Excel and Google Sheets. Enter earnings and deductions once, and gross pay, total deductions, and net salary calculate automatically.
What to look for in a payroll template
- Separate sections for employee details, earnings, deductions, and net pay
- Statutory line items shown separately: EPF, ESI, professional tax, TDS
- Formulas that auto-calculate gross pay, total deductions, and net pay
- Support for common allowances: HRA, conveyance, medical, special allowance
- Company header block with logo space and pay period
- Print-ready layout that fits on a single A4 page
Frequently asked questions
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 showing earnings, deductions, and net pay. Both physical and electronic (PDF) formats are accepted.
Which deductions must appear on an Indian salary slip?+
Statutory deductions include Employee Provident Fund (EPF), Employees' State Insurance (ESI) where applicable, professional tax, and TDS (income tax deducted at source). Other deductions such as loan repayments or advances should be listed as separate line items so the employee can verify each one.
How is net salary calculated?+
Net salary is gross earnings minus total deductions. Gross earnings usually include basic pay, HRA, conveyance, medical, and other allowances. 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.
Can I use a rent receipt template alongside the salary slip for HRA?+
Yes. To claim HRA exemption, employees typically submit both their salary slip (showing HRA received) and monthly rent receipts (proving rent paid). Our Rent Receipt Template in the Accounting category is designed specifically for this purpose.