Instant download · Excel & Google Sheets · no macros All templates

For office, facilities & H&S managers

7 reasons to keep every PAT test in one register

Look after the electrical equipment at work? This Ultimate UK PAT Testing Register keeps every appliance and every test in one spreadsheet, works out the next test date, flags failed, overdue and never-tested items, and prints PAT labels.

  • Excel & Google Sheets, no macros
  • Example + blank file
  • Start-here guide
  • One-off price, no subscription
PAT Testing Register: annotated screen from the example file

Screens from the included example file. All names and figures are fictional.

500appliances
3,000tests
24printable labels per A4 page
0macros, add-ons or subscriptions

The list

Why a ready-made register beats paper and a blank spreadsheet

01

Dashboard

Appliances in use, overdue, due soon, failed or not tested, a by-location table, a needs-action list (most urgent first) and three charts (tests passed and failed per month, appliances by status, retests due in the next 12 months)

PAT Testing Register: annotated screen 1 from the example
02

Register (500 appliances)

Asset ID, description, type, location, class, make, in use, interval override; last test, last result, next test date, days left and status worked out

PAT Testing Register: annotated screen 2 from the example
Get the register · £10.99 Instant download · Excel & Google Sheets
03

Statuses

OK, due soon, overdue, not tested, failed - do not use, retired, plus a check for an invalid interval

PAT Testing Register: annotated screen 3 from the example
04

Test Log (3,000 tests)

Visual inspection, earth continuity, insulation resistance, polarity, overall result, tester and notes; the newest test updates the Register

05

Labels

24 printable PAT labels per A4 page with asset ID, test date, next test, result and tester

06

Settings

Business, warning days, default interval, locations, testers and 14 example equipment types with retest intervals (up to 30)

07

Data checks for duplicate IDs, unknown IDs, future dates and missing results

Get the register · £10.99 Instant download · stuck? Email us for help

Compare

Three ways to keep these records

FeaturePaper or notesA blank spreadsheetThis register
Dashboard✗No~ If you build it✓ Built in
Register (500 appliances)✗No~ If you build it✓ Built in
Statuses✗No~ If you build it✓ Built in
Test Log (3,000 tests)✗No~ If you build it✓ Built in
Labels✗No~ If you build it✓ Built in
CostFree, plus your timeFree, plus your time£10.99 once

What's inside

Everything you download

3 files

  • XLSX PAT-Testing-Register.xlsxfilled with a fictional example business (56 appliances, 89 tests) so you can see how it all works
  • XLSX PAT-Testing-Register-BLANK.xlsxempty, with the example equipment types and intervals ready to edit
  • PDF Start-here.pdfone-page quick-start guide, including how to open it in Google Sheets

Also included

  • Start Here tab with a health check, data validation and protected formulas (no password)

Good to know

  • The example intervals are a starting point only. Set your own from your risk assessment and your competent tester
  • More UK health and safety tools from PHKSheets.
  • One licence for one business
PAT Testing Register: another screen from the example
PAT Testing Register Screens from the included example file. All names and figures are fictional.

Is it right for you?

Made for some, honestly not for others

A good fit if you…

  • office managers, facilities and health and safety leads, landlords, schools, shops, workshops and in-house testers in the UK
  • use Excel or Google Sheets on a computer
  • want to pay once, not another subscription

Not for you if you…

  • need Apple Numbers or mobile-only editing
  • want someone to do the records for you

How it works

Three steps, about 5 minutes to set up

  1. 1

    Settings

    Business, locations, testers and equipment types with a retest interval for each (about 5 minutes)

  2. 2

    Register

    Add every appliance once with a unique asset ID, type and location

  3. 3

    Test Log

    Add a row for every test; the Register, Dashboard and Labels update themselves

Microsoft Excel2010 or newer (Windows & Mac) and Microsoft 365
Google SheetsFree Google account. Upload the .xlsx, then set the locale to United Kingdom
0
No macrosNothing to enable, no add-ons or subscriptions. Not designed for Apple Numbers or mobile-only editing. A computer is recommended
PAT Testing Register preview
  • Instant download
  • Example + blank file
  • Start-here guide

The offer

Ultimate UK PAT Testing Register

£10.99one-off · no subscription

  • Filled with a fictional example business (56 appliances, 89 tests) (PAT-Testing-Register.xlsx)
  • Empty, with the example equipment types and intervals ready to edit (PAT-Testing-Register-BLANK.xlsx)
  • One-page quick-start guide, including how to open it in Google Sheets (Start-here.pdf)
  • Licensed for use within one business or household
Buy now · £10.99

Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.

Questions? Email info@phkmedia.co.uk Stuck after you buy? We'll help you set it up.

Digital download, nothing is posted. This workbook is a record-keeping tool, not electrical safety advice. Terms & licence.

FAQ

Questions people ask

Does it check my readings?

No. The readings are kept for your records; the competent person who tests decides pass or fail.

Can several people use it?

Yes. Upload it to Google Drive and open it with Google Sheets, then share it with your team.

What happens after I pay?

This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you.

Can I get help if I'm stuck?

Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.

Stop doing it the hard way. Get the PAT Testing Register.

Get the register · £10.99