Ultimate UK PAT Testing 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.

For office managers, facilities and health and safety leads, landlords, schools, shops, workshops and in-house testers in the UK. It follows HSE guidance: equipment must be maintained so it is safe, with inspection and test intervals chosen by the type of equipment and where it is used. It is a record-keeping tool, not electrical safety advice.

▶ Easy Start Here guide included – video tutorial coming to our YouTube channel

Works in Microsoft Excel and Google Sheets, with no macros.

What it does for you

• 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)
• 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
• Statuses: OK, due soon, overdue, not tested, failed - do not use, retired, plus a check for an invalid interval
• Test Log (3,000 tests): visual inspection, earth continuity, insulation resistance, polarity, overall result, tester and notes; the newest test updates the Register
• Labels: 24 printable PAT labels per A4 page with asset ID, test date, next test, result and tester
• Settings: business, warning days, default interval, locations, testers and 14 example equipment types with retest intervals (up to 30)
• Data checks for duplicate IDs, unknown IDs, future dates and missing results
• Start Here tab with a health check, data validation and protected formulas (no password)

How it works (3 steps)

1. Settings: business, locations, testers and equipment types with a retest interval for each (about 5 minutes)
2. Register: add every appliance once with a unique asset ID, type and location
3. Test Log: add a row for every test; the Register, Dashboard and Labels update themselves

What's included

• PAT-Testing-Register.xlsx: filled with a fictional example business (56 appliances, 89 tests) so you can see how it all works
• PAT-Testing-Register-BLANK.xlsx: empty, with the example equipment types and intervals ready to edit
• Works in Google Sheets: upload the .xlsx to Google Drive and open it with Google Sheets (tested: formulas and charts kept)
• Start-here.pdf: one-page quick-start guide, including how to open it in Google Sheets

Compatibility

• Microsoft Excel 2010 or newer (Windows & Mac) and Microsoft 365
• Google Sheets (free Google account). Set File > Settings > Locale to United Kingdom for £ and UK dates
• Not designed for Apple Numbers or mobile-only editing. A computer is recommended
• No macros, add-ons or subscriptions

Instant download

This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you. Stuck or have a question? Email info@phkmedia.co.uk and I'll gladly help you set it up.

Good to know

• Cream (pale yellow) cells are for your input. White and grey cells are worked out for you, and the sheets are protected (no password) so formulas are not overwritten by mistake
• Checked on HSE in November 2026: the Electricity at Work Regulations 1989 require electrical equipment that could cause injury to be maintained in a safe condition. They do not make PAT testing, or testing every year, a legal requirement
• HSE: how often to inspect and test depends on the type of equipment and where it is used, and records and labels are not required by law but are a useful way to manage and show your maintenance scheme
• The example intervals are a starting point only. Set your own from your risk assessment and your competent tester
• FAQ: Does it check my readings? No. The readings are kept for your records; the competent person who tests decides pass or fail
• FAQ: Can several people use it? Yes. Upload it to Google Drive and open it with Google Sheets, then share it with your team
• More UK health and safety tools from PHKSheets.
• One licence for one business

DISCLAIMER

This workbook is a record-keeping tool, not electrical safety advice. Inspection and testing must be done by a competent person. Based on HSE guidance checked in November 2026. All names and figures in the example file are fictional.

Licence: Licensed for use by one business (any number of sites it runs). Please do not resell, share or redistribute the files.

AI disclosure: This template and its listing images were designed by PHK MEDIA LTD with the help of AI tools. All formulas were tested and the files were reviewed and finalised by the seller.

© PHK MEDIA LTD

Licence: Licensed for use within one business or household. You may edit and print the files for that business. You may not resell, share or upload them for others.