Templates
Payroll – & workplace-ready free
Free payroll template excel for Excel and Google Sheets. Mandatory payroll fields, gross/net structure, and clear settlement layout. Download now.
- 100% free
- Workplace-ready
- Excel & Google Sheets
What is a payslip and why do you need a template?
A payslip (pay stub in the US) documents how pay was calculated for a period: gross pay, deductions, and net pay. Employees need it for personal records, mortgages, and tax filings; employers need it to show lawful pay and withholdings.
A payroll template gives you ready-made rows for earnings, taxes, and net pay instead of rebuilding a sheet every month. Salary usually means fixed monthly pay; wages often mean hourly or variable pay—both can use the same layout with different inputs.
Small teams in hospitality, retail, and services often start in Excel: enter hours and rates, let formulas calculate deductions. For growing teams, Ordio Payroll can pull hours from time tracking and scheduling. The free Ordio template is a practical first step before full automation.
United States
Federal law does not require a specific payslip format for all employers, but many states mandate itemised wage statements (hours, rates, deductions). The FLSA underpins minimum wage and overtime; state rules may add daily overtime, meal premiums, and pay transparency.
United Kingdom
Under the Employment Rights Act 1996 (as amended), workers must receive a written itemised pay statement before or when wages are paid, showing gross pay, variable deductions, fixed deductions, and net pay, with additional detail where pay varies by time worked.
Operating in Germany? German pay slips follow different mandatory lines (tax class, social insurance, etc.)—use local payroll software or your tax adviser for statutory German layouts.
Structure and required fields on a payslip
| Area | United States (typical) | United Kingdom (typical) |
|---|---|---|
| Header | Employer name, employee name/ID, pay period, pay date | Employer name, employee name, tax period, payment date |
| Body | Gross pay, hours/rate where applicable, federal/state tax, Social Security, Medicare, other deductions | Gross pay, income tax (PAYE), National Insurance, pension, other deductions |
| Footer | Net pay, bank details, YTD totals where shown | Net pay, payment method, hours where pay varies by time |
Incorrect payslips can lead to back pay claims, tax corrections, and fines. Issue a corrected statement when you find an error. A structured template reduces typos and omitted lines. For automation, Ordio Payroll keeps calculations aligned with current rules in your configured locale.
Create a payslip: step-by-step
How to produce a payslip with the template:
- Check master data: Legal name, cover letter, tax identifiers, pay rate, and bank details are current.
- Collect hours: Import regular hours, overtime, and unpaid breaks. With Ordio time tracking, hours can flow from the rota automatically.
- Calculate gross: Hourly rate × hours plus premiums (e.g. night or weekend where your policy applies) and allowances.
- Apply deductions: US: federal/state income tax, FICA, benefits. UK: PAYE, employee National Insurance, pension contributions, student loan if applicable.
- Net pay: Gross minus all deductions; verify against your payment file.
- Issue and archive: Deliver by secure email, employee portal, or print; retain copies per your retention policy.
Pay employees on the agreed schedule (e.g. monthly or biweekly). Digital delivery is common; keep proof of issue. Ordio Payroll can calculate from captured hours and master data—useful when headcount grows beyond manual Excel.
Calculation: gross, deductions, and net
The payslip shows the path from gross pay to net pay.
United States
Gross includes base pay, overtime (typically 1.5× for non-exempt hours over 40 in a workweek under federal rules—states may differ), commissions, and taxable benefits. Common deductions: federal income tax withholding, state/local tax where applicable, Social Security and Medicare (FICA), health insurance, retirement contributions, and garnishments. Verify federal and state minimum wage; tipped employees have separate rules.
United Kingdom
Gross includes salary, hourly pay, bonuses, and taxable benefits. Deductions often include PAYE income tax, employee National Insurance, workplace pension (auto-enrolment), and student loan repayments. Pay must meet National Minimum Wage / National Living Wage for the worker’s age band.
After all deductions, net pay is the amount paid to the employee. Bonuses and irregular payments may have different tax treatment—update template rates annually or use software that tracks law changes. Ordio Payroll reduces manual formula maintenance as rules evolve.
Abbreviations on the payslip
| Abbreviation | United States | United Kingdom |
|---|---|---|
| FIT / Fed W/H | Federal income tax withheld | — |
| SIT / State W/H | State income tax withheld | — |
| FICA / SS / Med | Social Security and Medicare | — |
| PAYE | — | Pay As You Earn (income tax) |
| NI | — | National Insurance |
| YTD | Year-to-date totals | Year-to-date totals |
| ER / EE | Employer / employee share (e.g. benefits) | Employer / employee share |
Clear labels on the template reduce HR questions. The Ordio payroll template uses an understandable structure—use it in Excel or as a bridge to Ordio Payroll.
Special cases: part-time, tipped, and variable pay
Not every worker fits a standard hourly or salaried line. Plan separate rows or tabs for these situations:
United States
- Part-time and variable hours: Track hours for non-exempt staff; salaried exempt staff may not need daily hours on the stub but keep policy documentation.
- Tipped employees: Show cash wage, tips, and tip credit only if your state allows—rules vary widely.
- Contractors: Independent contractors are usually paid via invoice, not a wage payslip with tax withholding—do not misclassify employees.
- Supplemental pay: Bonuses may use different withholding methods—confirm IRS guidance or your payroll provider.
United Kingdom
- Zero-hours and variable contracts: Payslips must still show hours where pay depends on time worked.
- Apprentices: Apply the correct minimum wage apprentice rate.
- Statutory payments: Sick pay, parental pay, or redundancy may need separate lines—follow HMRC guidance.
The Ordio template offers flexible earning and deduction rows; complex cases benefit from Ordio Payroll or your accountant. Link pay to scheduling so hours and pay periods stay aligned.
Payslip template from Ordio
The Ordio payroll template is a free Excel file with gross pay, tax and contribution lines, and net pay—ready to adapt for US or UK labels. Download, enter your data, and issue payslips for small teams or pilot payroll runs.
Planning note: Spreadsheets are not a substitute for certified payroll software in every jurisdiction. Use this template for structure and internal review; involve a payroll provider or counsel for statutory filings and audit-ready archives.
Formats: Excel is best for formulas; save as PDF for distribution. Word is less common for calculated pay. If your accountant needs exports, Ordio Payroll can reduce manual re-entry as you scale.
Download the payroll template now—no registration. Pair it with the timesheet template for hours capture. With Ordio, time tracking, scheduling, and payroll can live in one workflow.
Automate payroll with Ordio
Cut payroll errors and save hours every week
Automatic calculations
Minimum wage, overtime, and premiums calculated automatically
Direct accounting export
No manual re-entry — your accountant gets digital exports
Save 10 hours per week
Automation keeps manual work to a minimum
95% fewer errors
Automatic checks help prevent costly payroll mistakes
With Ordio:
See how Ordio simplifies payroll
See automated calculations save hours · No obligation · 15 minutes
More free templates
Discover more Excel templates for planning, time tracking and HR.
Frequently asked questions about Payroll – free & workplace-ready
What must be on a payroll bill?
Include employer and employee names, pay period, gross pay, each deduction, and net pay. US pay stubs often show federal and state taxes, FLSA-related hours or rates where relevant, and year-to-date totals; UK payslips must show gross, tax, National Insurance, and net under PAYE. The Ordio payroll template lists standard fields—confirm mandatory items with your payroll provider.
How do I create a pay bill?
Gather master data, approved hours, gross pay, deductions, and net pay. With the Ordio Excel template you fill each section, then review before issuing. For automation, Ordio Payroll connects time data and exports—useful when FLSA overtime or UK Working Time Regulations hour records feed straight into pay runs.
What are the mandatory details of a pay bill?
At minimum: who was paid, for which period, gross amounts, itemised deductions, and net pay. US workers expect clear overtime and federal minimum wage context on hourly roles; UK workers expect tax and National Minimum Wage compliance via PAYE. Incomplete payslips can be challenged—use the Ordio template as a checklist.
How is a wage bill established?
Structure header (employer, employee, period), earnings and deductions, then net pay and payment method. The Ordio template follows this layout for Excel or Google Sheets. Pair it with timesheets that support US FLSA records and UK hour documentation.
What do the abbreviations mean on the payroll?
Labels differ by country. US stubs may show FWT (federal withholding), SIT (state tax), FICA, and overtime (OT). UK payslips show PAYE income tax and NI. The Ordio template uses clear row names—map them to your payroll software or accountant's chart.
Payroll template Excel for free?
Yes. Download the Ordio payroll Excel template free, fill the fields, and issue payslips for your team. Combine with the timesheet template for hours. Scale to Ordio Payroll when you need integrated US or UK payroll workflows.
Create wage billing as PDF?
Save the completed Excel sheet as PDF and email or file it. PDF suits employee archives. Ordio Payroll also delivers digital payslips in-app for US and UK teams.
Wage billing with Word or Excel?
Excel is better for gross-to-net maths. Word suits cover letters only. The Ordio template is Excel-first; export PDF when needed. Automate with Ordio Payroll for recurring runs.
DATEV pay bill template?
This English template is aimed at US and UK payroll layouts, not German DATEV export. If you run German payroll, use your tax adviser's tools. For US and UK small teams, the Ordio Excel file is a practical payslip draft before you adopt full payroll software.
Payroll Minijob - what does it need?
Low-hour roles still need clear gross pay and any withholdings. In the US, check federal minimum wage and FLSA rules for covered workers; in the UK, confirm National Minimum Wage and tax treatment. The Ordio template gives a simple structure—payroll software handles complex rules.
Pay bill for 450 Euro Job template?
This page targets US and UK pay documentation, not German mini-job rules. Use the template for straightforward hourly or salaried US and UK payslips with gross, deductions, and net. Consult a payroll specialist for cross-border or legacy German setups.
Payroll Midijob - Special features?
Variable-hour and part-time pay need accurate hours and correct tax treatment. US mid-range earners may trigger FLSA overtime; UK workers fall under PAYE and National Minimum Wage bands. The free Ordio template supports basic payslip layout; use certified payroll for complex cases.