Automatic calculations
Minimum wage, overtime, and premiums calculated automatically
Payroll planning workbook with minimum pay checks, compliance summary, and sample employee rows. Figures are examples only.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Hourly rate | Weekly hours | Weekly pay (€) | Monthly pay (€) |
| 2 | Alex Morgan | 15.50 | 40 | 620.00 | 2.684,60 |
| 3 | Jordan Lee | 18.00 | 20 | 360.00 | 1.558,80 |
| 4 | Sam Taylor | 14.00 | 35 | 490.00 | 2.121,70 |
| 5 | Sam Taylor | 16.50 | 30 | 495.00 | 2.143,50 |
| 6 | Casey Brown | 13.90 | 40 | 556.00 | 2.407,48 |
| 7 | Riley Green | 19.00 | 25 | 475.00 | 2.056,75 |
| 8 | Jamie White | 17.00 | 38 | 646.00 | 2.797,18 |
| 9 | Taylor Gray | 15.00 | 32 | 480.00 | 2.078,40 |
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.
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.
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.
A clear payslip has three parts: header (employer and employee identifiers, pay period), body (earnings and deductions), and footer (net pay and payment method). Missing items can trigger penalties or employee disputes.
| 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.
How to produce a payslip with the template:
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.
The payslip shows the path from gross pay to net pay.
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.
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.
Payslips use shorthand. This legend helps employees and managers read them:
| 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.
Not every worker fits a standard hourly or salaried line. Plan separate rows or tabs for these situations:
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.
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.
Cut payroll errors and save hours every week
Minimum wage, overtime, and premiums calculated automatically
No manual re-entry — your accountant gets digital exports
Automation keeps manual work to a minimum
Automatic checks help prevent costly payroll mistakes
Discover more free Excel templates for workforce planning, scheduling, and HR.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Yes. This page offers a free payroll template Excel file with gross, deductions, and net sections plus an instructions sheet. Open it in Excel or Google Sheets, enter employee and period data, and export for handout. For recurring payroll with exports, explore Ordio payroll.
Excel alone is a spreadsheet, not payroll software. For a free payroll template, download the structured workbook on this page. For ongoing payroll with time data and exports, compare dedicated tools—Ordio payroll connects hours and master data. Start with the template; scale when volume grows.
Enter your contact details for instant access
Free · No spam · Unsubscribe anytime