Templates › Salary Sheet

Salary Sheet Excel Template

Work out monthly pay for the whole team. Gross and Net Pay are calculated from basic, allowances and deductions.

⬇ Download free (.xlsx)Free · No sign-up · 17 KB · Works in Excel and Google Sheets

See it filled with data

Salary Sheet Excel template filled with sample data

The file has two sheets: a blank one for your own data, and this filled Example so you can see how it works.

What is inside

  • Gross = Basic + HRA + Allowances
  • Net Pay = Gross − deductions
  • Total gross, deductions and net pay on top

How to use it

  1. Add one row for each employee.
  2. Fill Basic, HRA, Allowances and the deductions.
  3. Net Pay is ready for each person.
  4. Total Net Pay on top is the money you need this month.

Formulas used: IF SUM COUNTA

⬇ Download the Salary Sheet template

More free templates

InvoiceQuotationPayment TrackerExpense TrackerMonthly BudgetSales TrackerStock InventoryAttendance SheetTask TrackerLead TrackerLoan EMI Calculator

← All templates