Skip to content

Templates

Employment Certificate Template – free for Word, PDF and Excel

Release

Version 2026.10

Markets

  • UK
  • IE
  • US

Formats

  • Excel (.xlsx)
  • Google Sheets
  • PDF (fillable)
  • Word (.docx)

Editable files: free, after a short form

Screenshot of the employment certificate template, “Certificate” sheet showing Employer name, PAYE reference, Contact (name, phone/email), Name and National Insurance number (P45 only)
“Certificate” sheet: Enter Employer name, PAYE reference, Contact (name, phone/email) and Name here.

Overview

At a glance

  • Sheets

    6

  • Checks

    6

  • Holiday years

    2026

  • Countries

    United Kingdom · Ireland · United States

  • Formula cells

    29

Sheets

What's in the template

Fill in

  • Employer name
  • PAYE reference
  • Contact (name, phone/email)
  • Name
  • National Insurance number (P45 only)
  • Job title
  • Contracted hours per week
  • Start date
  • Leaving date
  • Reason for leaving
  • Notice given on
  • Notice period (weeks)
  • Factual note (optional)
  • Redundancy / termination payment
  • Holiday paid in lieu (days)
  • P45 / certificate issued on

Automatic

  • Length of service (months)
  • Earliest end with notice
  • Pay periods entered
  • Gross pay in periods entered

Dropdowns

Reason for leaving: Dismissal, Resignation, Redundancy, End of fixed-term contract, Mutual agreement

“Certificate” sheet: Enter Employer name, PAYE reference, Contact (name, phone/email) and Name here.

How to fill in the template

How to fill in the template

  1. 1

    On “Certificate” fill in the yellow fields. Only what is needed – no date of birth, address or health data; NI number only for the P45.

  2. 2

    On “Pay 12 months” enter pay periods with gross pay and hours.

  3. 3

    Review “Checks” (notice, periods, issue date).

  4. 4

    Issue the P45 from payroll (final FPS) and give it to the employee.

  5. 5

    Keep a copy securely and only as long as needed.

Calculations

How the template calculates

  • Length of service (months)

    measures length of service or duration

    =IF(OR($B$17="",$B$18=""),"",$B$17+7*$B$18)

  • Earliest end with notice

    2026-09-12

    =COUNT('Pay 12 months'!A4:A15)

  • Pay periods entered

    simple reference/arithmetic

  • Check

    counts or raises ⚠ warnings

  • Required details complete

    counts or raises ⚠ warnings

  • P45 issued on leaving

    counts or raises ⚠ warnings

  • Note

    The template drops your entries into the text or form automatically. The checks verify required details, date logic and deadlines and show ✔ or ⚠.

  • Quick tips

    Fill in the yellow cells; grey cells calculate – don’t overwrite them. ✔ = OK, ⚠ = check. Enter times as hh:mm and dates as dates; add new dropdown values on the source sheet first. If you see #VALUE! or empty totals, press Ctrl+Z or reload the template.

Countries

Rules by country

Bank holidays and regions are on the holidays sheet when the workbook supports multiple countries.

verified·estimate·pending

  • United Kingdom

Legal basis and sources

RuleSource
P45 on leaving; final FPS through RTIGOV.UK
Statutory minimum noticeEmployment Rights Act 1996, s.86
Statutory redundancy payERA 1996, Part XI; GOV.UK
References: accuracy and fairnessAcas

Guidance only, not legal advice – contracts and collective agreements can differ. The file holds personal data (UK GDPR / GDPR): share it only with people who need it and delete it once the retention period ends.

Checks

Checks and dashboard

  • Required details complete

  • Leaving date not before start

  • Notice period respected

  • Pay periods complete (up to 12)

  • Periods within employment

  • P45 issued on leaving

Formats

Excel, Google Sheets, PDF or Word

  • Recommended

    PDF (fillable)

    Print it or fill it in on screen, without formulas.

    • Calculates automatically
    • Print
    • Edit in Word
    • Offline
  • Word (.docx)

    Edit the wording freely in Word or LibreOffice.

    • Calculates automatically
    • Print
    • Edit in Word
    • Offline
  • Excel (.xlsx)

    Calculate, check and archive on your computer – Excel 2016 or later, Microsoft 365.

    • Calculates automatically
    • Print
    • Edit in Word
    • Offline
  • Google Sheets

    Use it in the browser and share it with your team – via File › Make a copy.

    • Calculates automatically
    • Print
    • Edit in Word
    • Offline

Print, share, save

  • Print: File › Print → A4 (UK, Ireland) or US Letter (US), choose orientation, scale “Fit to width”, repeat frozen rows.

  • PDF/Excel: File › Download › PDF or Microsoft Excel (.xlsx).

  • Your own copy: File › Make a copy. Share: “Share” top right – ideally “Viewer” for the team.

Proof of employment: what people actually ask for

UK: the P45 is a separate, statutory document

Example: a letter for a landlord

Which document does the person actually need?

Sample wording: still employed vs left

Common mistakes

File the signed proof of employment with the employee record

The workbook drafts the letter. Ordio stores the signed copy.

  • Documents in one record

    Certificate, reference, and contract stay with the employee, including after they leave

  • A copy you can find

    Keep the preparation sheet and the BEA confirmation in the same file

  • Faster at exit

    Pay figures from payroll, so HR is not retyping them into the agency form

  • For sites with high turnover

    Hospitality, retail, and care teams issue these certificates often

See how Ordio supports compliant HR

See automatic checks improve audit readiness · No obligation · 15 minutes

Discover more Excel templates for planning, time tracking and HR.

Frequently asked questions about German employment certificate

What is the difference between an employment certificate and a reference?

An employment certificate confirms facts only: dates of employment, job title and, if asked, pay. A reference can also assess performance or conduct. In the UK an employer generally does not have to give a reference unless it has agreed to in writing or a regulator requires it, and any reference it gives must be fair and accurate. (Source: acas.org.uk)

Is an employment certificate the same as a P45?

No. The P45 is a statutory UK tax document given when someone leaves. A proof of employment letter is an informal confirmation of the job, dates and hours that you give on request.

Is the employment certificate template free, and does it work in Excel and Google Sheets?

Yes. You download it free of charge after a short form and get an Excel file (.xlsx, Excel 2016 or Microsoft 365) and a Google Sheets copy, plus a fillable PDF and a Word document. Excel and Sheets contain the same 6 sheets: Instructions, Certificate, Pay 12 months, Checks, Legal basis, Ordio.

Which countries does the template cover?

The template covers the United Kingdom, Ireland and the United States. The country notes in the file set out the rules for each: United Kingdom: The “Legal basis” sheet refers to UK law. P45 and RTI apply UK-wide; the notice rules in ERA 1996 s.86 apply in England, Wales and Scotland – check Northern Ireland separately. Ireland: there is no P45 any more – the employer reports the leaving date in the final payroll submission to Revenue. Minimum notice after 13 weeks’ service: 1 week (under 2 years) up to 8 weeks (15+ years) (Minimum Notice and Terms of Employment Act 1973, s.4). Statutory redundancy needs 104 weeks’ service: 2 weeks’ pay per year plus 1 bonus week, pay capped at €600 a week. United States: no federal law requires notice or an employment certificate; the WARN Act requires advance notice of covered plant