Posted in

5 Free Salary Slip Templates in Excel

5 Free Salary Slip Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 10, 2026

A salary slip template gives every employee a clear, written record of what they earned in a pay period, what was deducted and what they actually received. On this page you can use the free salary slip calculator above to work out gross pay, deductions and net pay in seconds, then download five free salary slip templates in Excel: a standard monthly salary slip, a payslip with year-to-date totals and a monthly payroll register that summarises the whole team, plus a salary revision worksheet and a bonus and incentive payslip.

Each file is a real, editable .xlsx spreadsheet created for this page. Gross earnings, total deductions and net pay are calculated automatically from the amounts you type in the yellow cells, so the slip always adds up. The templates also open in Google Sheets and LibreOffice Calc, and each slip prints on a single page or saves as a PDF to email to the employee.

Salary Slip Calculator

Gross pay: 0.00   Provident fund: 0.00   Total deductions: 0.00
Net pay: 0.00

Runs in your browser; nothing is sent or saved. Basic and allowances are pro-rated by days paid; provident fund is a % of basic. Tax rules differ by country, so enter your own tax figure.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a Salary Slip?

A salary slip, also called a payslip or pay stub, is a document an employer gives an employee for each pay period. It shows the employee’s details, the pay period, every earning (basic salary, allowances, overtime and bonuses), every deduction (income tax, provident fund or pension, social security, loan repayments and advances) and the resulting net pay.

In many countries employers are legally required to give employees a payslip, and employees need them to apply for loans, rent a home, check that tax was deducted correctly and settle any disagreement about pay. A clear, consistent slip also saves the payroll team from answering the same questions every month.

How to Use the Salary Slip Calculator

Enter the basic salary and total allowances for a full month, any overtime or bonus, the number of working days and the number of days paid. If an employee joined mid-month or took unpaid leave, the calculator pro-rates basic salary and allowances by days paid. Then enter the income tax for the period, the provident fund percentage and any other deductions.

The calculator shows gross pay, the provident fund amount, total deductions and net pay as you type. With the example figures, a basic salary of 50,000 and allowances of 23,000 give gross pay of 73,000, and deductions of 7,500 leave net pay of 65,500. Change days paid to 11 and you will see the pro-rated result. The calculator runs entirely in your browser and nothing is saved or sent anywhere.

Download the Free Salary Slip Templates

The five Excel files below cover a single employee’s monthly slip, a slip with running year-to-date figures and a register for the whole payroll.

Salary Slip Template

This is the standard monthly salary slip. It has a header for the company name and address, an employee details block (name, ID, designation, department, pay period, pay date, working days and days paid), side-by-side earnings and deductions tables, and a bold net pay line. Signature lines for the employer and employee sit at the bottom.

Salary slip template in Excel with earnings, deductions and net pay

Payslip With Year-to-Date Totals

This version adds a year-to-date section for gross pay, tax and net pay so far this year. Employees often need YTD figures for tax returns and loan applications, and showing them on every slip saves a separate request at the end of the year.

Payslip template in Excel with year-to-date totals

Monthly Payroll Register

The payroll register lists every employee on one sheet with basic salary, allowances, overtime, gross pay, deductions and net pay. Totals at the bottom show the full payroll cost for the month, which is the figure you need to fund the bank transfer and post to your accounts.

Monthly payroll register template in Excel with gross, deductions and net pay

Salary Revision Worksheet

Salary revision worksheet template in Excel with current salary, increase percent and new salary

Plans pay rises before they reach the payslip. List each employee with their current salary, the proposed increase percentage and the effective date; the sheet works out the new salary, the average increase and the total extra cost to payroll. Compare that cost with your budget before approving. HR teams use this during the annual review cycle and for promotions. Once the increases are approved, update the salary on the monthly salary slip from the effective month.

Bonus and Incentive Payslip

Bonus and incentive payslip template in Excel with performance bonus, sales incentive, tax and net payment

A separate payslip for one-off payments, so the regular monthly slip stays clean. Enter the performance bonus, sales incentive and any other allowance, then the tax and other deductions on those amounts. The sheet works out the gross special pay and the net bonus payment. The header holds the employee, payslip number, pay date and period. Many employers pay bonuses in a separate run; giving staff a clear slip for it answers the usual question about why the tax looks higher than on a normal month.

What to Include in a Salary Slip

A complete salary slip should show:

  • Employer details: company name, address and, where required, a registration or tax number.
  • Employee details: full name, employee ID, designation and department.
  • Pay period and pay date: the month or week covered and the date of payment.
  • Attendance: working days in the period and days paid, so pro-rated pay is easy to check.
  • Earnings: basic salary, house rent allowance, transport, medical, overtime, bonus and any other allowance, each on its own line.
  • Deductions: income tax, provident fund or pension, social security, loan repayments, salary advances and any other agreed deduction.
  • Gross pay, total deductions and net pay.
  • Payment method: bank transfer, cheque or cash, with a reference where useful.
  • Signatures or an authorised stamp, if your organisation uses them.

How to Fill In the Salary Slip Template

  1. Type the company name and address in the header.
  2. Enter the employee details and the pay period. The pay period cell is formatted to show the month and year.
  3. Enter the number of working days and days paid.
  4. Type each earning in the earnings table. Leave unused rows at zero.
  5. Type each deduction in the deductions table.
  6. Check the gross earnings, total deductions and net pay cells, which update automatically.
  7. Enter the payment method, save a copy named with the employee ID and month, and print or export to PDF.

For the next month, copy the sheet, change the pay period and update only the figures that changed. Keeping one workbook per employee per year, with one sheet per month, makes year-to-date totals easy to add up.

Earnings and Deductions Explained

Basic salary is the fixed core pay agreed in the employment contract. Many allowances and deductions, such as provident fund, are calculated as a percentage of basic, so it is worth showing it separately.

Allowances are extra amounts paid for specific purposes, such as house rent, transport, meals or medical costs. Some allowances are taxable and some are partly exempt, depending on local rules.

Overtime and bonuses vary from period to period. Show them on separate lines so the employee can see exactly what was paid on top of the regular salary.

Income tax is usually withheld by the employer and paid to the tax authority. The amount depends on local tax tables, the employee’s annual income and any allowances or exemptions, so enter the figure from your payroll software or tax calculator.

Provident fund or pension contributions are often a fixed percentage of basic salary, sometimes matched by the employer. The employee’s share is a deduction; the employer’s share is usually shown separately or not at all on the slip.

Loan repayments and advances are agreed amounts recovered from salary. Keep a separate record of the outstanding balance so both sides know when the loan is fully repaid.

Pro-Rated Salary for Partial Months

When an employee joins or leaves partway through a month, or takes unpaid leave, you need to pay only for the days worked. The usual method is to divide the monthly salary by the number of working days (or calendar days, depending on your policy) and multiply by the days paid. The calculator above uses working days. Whichever method you choose, apply it consistently and write it in your payroll policy so employees know how partial months are worked out.

Salary Slip Best Practices

  • Issue slips on time. Send each slip on or before pay day so employees can check it before the money arrives.
  • Keep the layout consistent. Use the same template every month so employees know where to look.
  • Protect privacy. Send slips individually, password-protect PDFs if your email system allows it, and never share one employee’s slip with another.
  • Keep records. Store a copy of every slip and the monthly register for as long as local law requires, often several years.
  • Explain changes. If a deduction or allowance changes, add a short note on the slip or tell the employee before pay day.
  • Reconcile every month. The total net pay on the payroll register should match the bank transfer, and total tax withheld should match what you pay to the tax authority.

Using the Payroll Register

The register is the summary behind the individual slips. Fill in one row per employee, check that each row matches that person’s slip, and use the totals to fund payroll and record the expense. Comparing this month’s register with last month’s is a quick way to catch mistakes, such as a missing employee or a bonus entered twice.

If you also track hours, pair the register with the employee time sheet templates so overtime on the slip can be traced back to approved hours.

Sending Salary Slips as PDF

To email a slip, use File > Save As or File > Export and choose PDF in Excel, or File > Download > PDF in Google Sheets. The print area is already set, so each slip fits on one page. Name the file with the employee ID and month, for example “E-1024-October-2026.pdf”, so it is easy to find later.

Related Templates

You can also check these important templates like the payroll templates for running the full monthly payroll, and the expense report templates for reimbursing employee expenses separately from salary.

Frequently Asked Questions

What is the difference between a salary slip and a payslip?

There is no real difference. Salary slip, payslip and pay stub are different names for the same document showing earnings, deductions and net pay for a pay period.

How is net pay calculated?

Net pay is gross earnings minus total deductions. The template adds all earnings, adds all deductions and subtracts one from the other automatically.

Does the template calculate income tax?

No. Tax rules differ by country and by employee, so you enter the tax figure from your payroll software or the official tax tables. The template then includes it in total deductions.

Can I use the salary slip template in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas and layout keep working.

How do I calculate salary for a partial month?

Divide the monthly amount by the working days in the month and multiply by the days paid. The calculator above does this for basic salary and allowances.

How long should I keep salary slips?

Keep copies for as long as your local employment and tax laws require, which is often five to seven years.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.