HR template
Salary Slip
Earnings and deductions with HRA, PF and loss-of-pay worked out, and net pay that adds itself up.
- ✓Instant download
- ✓Every later version free
- ✓Commercial use
- ✓No watermark
- 7
- live formulas, each one recalculated and checked
- 3
- columns: Component, Type, Amount
- 13
- figures worked out for you
Need more than one? All 10 HR templates for $39 — $126 bought separately. All 70 for $99.
Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 20 November 2026.
There are free templates. Why this one?
There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 7 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.
It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No watermark, and you can use it commercially.
About this Salary Slip template
A salary slip has to show how gross pay becomes take-home pay. This Excel template lists earnings and deductions, works out HRA and provident fund from basic salary at the rates you set, and calculates loss of pay from days in the month and days paid.
The pay summary shows gross earnings, total deductions and net pay, plus the employer's PF contribution. Add any allowance or deduction as a new row marked Earning or Deduction and the totals include it.
Good for
- →Small employers issuing monthly payslips
- →HR and accounts staff preparing salary statements
- →Employees checking their own pay calculation
What it works out for you
Pay summary
- →Gross earnings
- →Total deductions
- →Net pay
- →Employer PF contribution (not deducted)
What is inside the Salary Slip template
The table has 3 columns. Calculated columns fill themselves in; the rest are yours to type over.
- →Component
- →Type
- →Amount
Settings in the “Rates” box
- →HRA (% of basic)
- →PF rate (% of basic)
- →PF wage ceiling (0 = none)
Settings in the “Employee and period” box
- →Employee name
- →Employee ID
- →Designation
- →Pay month
- →Days in month
- →Paid days
How to use the Salary Slip in Excel
HRA, PF and loss of pay follow Basic and the rates below. Mark new rows Earning or Deduction.
The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.
Shaded, boxed cells below the table are settings the formulas read from. Change those first — every row that depends on them updates at once.
Functions and formulas it uses
Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.
IFMINROUNDSUMIFQuestions about the Salary Slip
How is PF calculated?
Basic salary times the PF rate, capped at the PF wage ceiling if you enter one. Set the ceiling to 0 to apply the rate to the full basic.
How is loss of pay worked out?
Gross earnings times unpaid days divided by days in the month. Set paid days equal to days in the month for no deduction.
Can I use it outside India?
Yes. Rename the components, set HRA and PF to 0% and add your own deductions. The totals work on whatever rows you mark Earning or Deduction.
What you get with the Salary Slip
- ✓7 formulas, every one recalculated and checked
- ✓Opens with sample rows already filled in
- ✓Excel, Google Sheets and LibreOffice Calc
- ✓Set up to print on one page wide
- ✓Commercial use, no attribution needed
- ✓Every later version included free
Get the Salary Slip for $7
One payment. The file downloads straight away, and every later version of it is yours at no extra cost.
Buying a few? All 10 HR templates for $39, or all 70 for $99.
More hr templates
See all HR →Salary Slip
One payment, yours to keep