Salary Sheet (Excel)
Prepare a monthly salary statement with gross pay, deductions and net salary calculated automatically.
Download the template
Download salary-sheet.xlsx Excel workbook (.xlsx), 10 KB. Works in Microsoft Excel, LibreOffice Calc and Google Sheets.
What is inside
- Salary: Employee rows with basic, HRA, allowances, gross pay, PF, other deductions, total deductions and net salary, plus a totals row.
Key columns and cells
- HRA % and PF %: set once at the top; they apply to every employee.
- Allowances and other deductions: enter amounts per employee.
- Net salary: gross pay minus total deductions.
How to use it
- Replace the example employee.
- Enter the percentages that apply to you.
- Add each employee's basic pay, allowances and other deductions.
- Check the totals row and keep the sheet with your records.
Notes and assumptions
- The percentages are examples only. Salary components, tax and statutory deductions are governed by law, so confirm them with a qualified professional.
- This is a calculation aid, not payroll software.
Frequently asked questions
Does it calculate income tax?
No. Add an 'other deductions' amount that you have calculated separately.
Can I add more columns?
Yes. Insert columns before Gross pay and include them in the formulas.