HR & attendance
Payslip Template: Free Excel Download and Filled Example
A payslip (pay stub) tells an employee exactly what they earned in a pay period, what was deducted and what they actually receive. A clear payslip saves a lot of back-and-forth: employees can check their own pay, and the employer has a record if a question comes up months later.
This page gives you a free payslip template in Excel, explains every field, walks through a filled example with overtime and deductions, and lists the mistakes that most often cause payroll complaints. Tax and contribution rates change every year and differ by country, so the deduction amounts in the example are illustrations only; always calculate real deductions from the current official tables.
What is a payslip?
A payslip is a statement issued with each payment of wages. It lists the gross pay broken down by item (base pay, overtime, allowances, bonuses), every deduction (income tax withholding, social security or national insurance, pension and health contributions, other agreed deductions) and the resulting net pay. Good payslips also show the hours behind variable pay such as overtime and the rate used to calculate it.
In many countries a payslip is a legal requirement. In the UK, for example, workers have a right to an itemised payslip on or before payday. In the US there is no federal payslip rule, but many states require employers to provide wage statements. Even where it is not required, a payslip is the simplest way to show that pay was calculated correctly.
When do you need a payslip?
- Every payday, for every employee, including part-time and hourly staff
- When overtime, shift premiums or bonuses change the amount from month to month
- When someone joins or leaves mid-period and pay is pro-rated
- When an employee needs proof of income for a loan, lease or visa
- When you need a record to answer a pay query or an audit
Payslip template fields and how to fill them
The downloadable file contains these fields. Keep earnings and deductions in separate blocks so the net pay is easy to check.
Employee and pay period
| Field | How to fill it in | Example |
|---|---|---|
| Employee name and ID | Full name plus an employee number. Avoid full tax IDs unless your local rules require them. | Emily Carter, EMP-0418 |
| Department / job title | Where the employee works and their role. | Customer Support, Team Lead |
| Pay period | Start and end date covered by this payment. | 1–31 October 2026 |
| Payday | The date the money is paid. | 5 November 2026 |
Earnings
| Field | How to fill it in | Example |
|---|---|---|
| Item | Name of each pay element. | Base salary, overtime, allowance |
| Basis / calculation | How the amount was worked out: hours × rate × premium for overtime. | 6 h × $25.00 × 1.5 |
| Amount | Amount for this item in the pay currency. | $225.00 |
Deductions and net pay
| Field | How to fill it in | Example |
|---|---|---|
| Deductions | Each deduction on its own line: tax withholding, social contributions, pension, benefits. | Income tax withholding $420.00 |
| Gross pay | Total of all earnings before deductions. | $4,375.00 |
| Net pay | Gross pay minus total deductions; the amount transferred. | $3,575.00 |
| Year-to-date totals (optional) | Cumulative gross, tax and net for the year, useful at year end. | YTD gross $43,750.00 |
Filled payslip example
An October payslip for a support team lead paid monthly. Deductions are entered as negative numbers so the column total equals net pay. The deduction amounts are illustrative only.
| Employee | Emily Carter, EMP-0418 (Customer Support) |
|---|---|
| Pay period | 1–31 October 2026 |
| Payday | 5 November 2026 |
| Net pay | $3,575.00 |
Earnings and deductions
| Item | Basis | Amount |
|---|---|---|
| Base salary | Fixed monthly salary | $4,000.00 |
| Overtime | 6 h × $25.00 hourly rate × 1.5 | $225.00 |
| Phone allowance | Flat monthly allowance | $150.00 |
| Income tax withholding | Example amount, use current tables | -$420.00 |
| Social security / national insurance | Example employee share | -$260.00 |
| Health plan contribution | Example employee share | -$120.00 |
| Net pay | $3,575.00 |
Check: gross pay $4,375.00 − deductions $800.00 = net pay $3,575.00. Overtime uses a 1.5× premium, the US federal rule for non-exempt employees over 40 hours a week; other countries use different premiums.
Free download
Free, no sign-up. Opens in Excel, Google Sheets, Numbers, Word, Google Docs and LibreOffice.
Open the downloaded file in Nobami, our web office, to edit it right away.
How to prepare a payslip each month
- Close the timesheets. Confirm hours worked, overtime and leave for the period, and have the employee or manager approve them.
- Work out the rates. Confirm the hourly rate used for overtime and the premium that applies under the law or contract.
- Enter every earning on its own line. Show the basis for each line so anyone can recompute it.
- Calculate deductions from current tables. Use this year's official tax and contribution tables, never last year's figures or the example amounts.
- Check, issue and keep a copy. Confirm gross minus deductions equals net, send the payslip on or before payday and archive it with the payroll records.
Payslip rules in the UK and US
In the UK, employees and most workers have the right to an itemised payslip on or before the day they are paid. It must show gross pay, net pay, the amounts of any variable deductions and, where pay varies with time worked, the number of hours paid. The payslip can be paper or electronic.
In the US there is no federal law requiring payslips, but the Fair Labor Standards Act requires employers to keep accurate payroll records, and many states require a wage statement with hours, rates and deductions. Check the rules of each state where you have employees.
Because tax and social contribution rates change, calculate deductions with your payroll software or the official tables for the current tax year rather than copying fixed amounts.
Sources
- GOV.UK: Payslips (checked November 13, 2026)
General information, not tax or legal advice. Payslip and payroll rules differ by country and state; check current official guidance or a payroll professional.
Common payslip mistakes
- Showing an overtime amount without the hours and the rate behind it
- Using last year's tax or contribution rates
- Mixing earnings and deductions so net pay cannot be checked
- Not issuing payslips to part-time or hourly staff
- Printing full tax or social security numbers on every payslip
- Issuing the payslip after payday or not keeping a copy
Payslip FAQ
What must a payslip include?
At minimum: employee identification, pay period, gross pay by item, each deduction, and net pay. Where pay depends on hours, include the hours and rates. Local law may require more.
Can payslips be sent electronically?
Usually yes. In the UK electronic payslips are allowed. Make sure the employee can open, save and print them.
Is a payslip the same as a pay stub?
Yes. Payslip is common in the UK and Commonwealth countries, pay stub in the US. Both mean the statement issued with wages.
Can I use the deduction amounts in the example?
No. They only show the layout. Calculate real deductions from current official tables or payroll software.
How long should payslips be kept?
Keep them with your payroll records for as long as your local rules require; several years is common for tax purposes.