Gas Safe Certificate Tracking: Stop Using Spreadsheets

You know the spreadsheet. The one with your engineers' Gas Safe numbers, ACS categories, expiry dates, and maybe a column for "notes" that says things like "check with Dave."

It works until it doesn't. And when it doesn't work — when an engineer's registration lapses and they do a gas job anyway — the consequences aren't a spreadsheet problem. They're a legal problem.

This post explains what you should be tracking, why spreadsheets fail, and what the software alternatives look like.

What you're legally required to track

Under the Gas Safety (Installation and Use) Regulations 1998, anyone working on gas appliances, fittings, or flues must be Gas Safe registered. That's not guidance — it's criminal law. Working on gas without registration is an offence punishable by a fine, imprisonment, or both.

As a business owner employing gas engineers, you're responsible for ensuring:

Per engineer

Per job

Per customer (landlord properties)

Why spreadsheets fail

A spreadsheet can hold this data. The problem isn't storage — it's what happens around the data.

Problem 1: Nobody updates it. Your spreadsheet is only as current as the last person who edited it. If Dave renewed his ACS last Tuesday and nobody updated the sheet, the spreadsheet says he's expired when he isn't — or worse, says he's current when he isn't.

Problem 2: No alerts. Spreadsheets don't send you an email 90 days before an engineer's CCN1 expires. You have to remember to check. Every month. For every engineer. For every category. If you have 8 engineers with 4 ACS categories each, that's 32 expiry dates you need to manually monitor.

Problem 3: No connection to jobs. When you assign Engineer A to a boiler installation, the spreadsheet doesn't check whether Engineer A has the right ACS category for that appliance type. You're relying on memory or a separate manual check.

Problem 4: Audit risk. Gas Safe can audit your business at any time. When they do, they want to see organised records of every engineer's registration, categories, and the certificates they've produced. Handing over a spreadsheet with conditional formatting and a "notes" column doesn't inspire confidence.

Problem 5: Landlord reminders. If you manage gas safety checks for landlords, you need to track every property's annual due date and send reminders in advance. In a spreadsheet, this means manually filtering by date every week and sending individual emails or texts. One missed property is one unhappy landlord — or one illegal tenancy.

What proper tracking software does

The difference between a spreadsheet and purpose-built software isn't features — it's automation.

Registration and category tracking

• Each engineer has a profile with their Gas Safe ID, registered ACS categories, and expiry dates
• The system alerts you at 90, 60, and 30 days before any registration or category expires
• When you assign an engineer to a job, the system checks their categories against the job requirements
• If an engineer's registration has lapsed, they can't be assigned to gas work

Certificate generation

• CP12 and gas safety records are generated from the job data — not typed into a separate system
• Appliance details, readings, and engineer information are pre-populated
• Certificates are stored against the job, the customer, and the property
• Customers can access their certificates through a portal

Landlord gas safety management

• Every landlord property has its last CP12 date recorded
• The system calculates the next due date (12 months)
• Automated reminders go to you (or the landlord) at 60 and 30 days before expiry
• When the reminder goes out, a new job is created automatically for the annual check
• The cycle repeats every year without manual intervention

Audit readiness

• All records are searchable by engineer, property, date, or certificate type
• Export to PDF or CSV for Gas Safe audits
• Full history: who did what, when, and what certificate was produced
• No missing data, no "check with Dave" notes

The current software options

Gas Engineer Software

The most popular cert app for gas engineers. Over 6,000 users.

• CP12 generation: Yes
• Gas Safe tracking: Yes
• ACS tracking: Yes
• Landlord reminders: Yes
• Automated expiry alerts: Basic
• Job management: Basic calendar
• Invoicing: Basic (no payment links)
• GPS: No
• AI: No
• Price: £15-30/user/mo

Gas Engineer Software covers the cert and tracking essentials. Where it falls short is everything around the certificate — scheduling, invoicing, fleet tracking, and customer communication. If all you need is cert generation and basic tracking, it works.

Muster

Full job management with gas-specific compliance features.

• CP12 generation: Yes (from job data)
• Gas Safe tracking: Yes (per engineer)
• ACS tracking: Yes (per category, per engineer)
• Landlord reminders: Yes (automated cycle)
• Automated expiry alerts: Yes (90/60/30 days)
• Job management: Full (drag-and-drop scheduling, route optimisation)
• Invoicing: Yes (with Muster Pay payment links)
• GPS fleet tracking: Yes
• AI receptionist: Yes
• Price: £179/mo flat (Starter)

Muster covers tracking and certificates AND everything else: scheduling, invoicing, fleet management, AI, and payments. The flat-rate pricing means your cost doesn't scale with headcount.

Manual (spreadsheet + paper)

• CP12 generation: Paper or Word template
• Tracking: Manual spreadsheet
• Alerts: None (you remember or you don't)
• Everything else: Separate tools or nothing
• Price: Free (plus your time, plus the risk)

The free option isn't free when you account for the time spent maintaining it and the risk of a lapsed registration going unnoticed.

The real cost of getting it wrong

Scenario 1: Lapsed ACS category

Your engineer's CENWAT category expired 3 weeks ago. Nobody noticed because the spreadsheet wasn't checked. He installs an unvented hot water cylinder. The installation fails. The customer's ceiling collapses from water damage.

Result: Your insurance may not cover the claim (the engineer wasn't qualified for the work). Gas Safe investigates. The engineer faces disciplinary action. Your business faces prosecution.

Scenario 2: Missed landlord renewal

A landlord property's annual gas safety check was due in October. Nobody sent a reminder. The landlord doesn't chase it. In December, the tenant reports a carbon monoxide alarm. The property has no valid CP12.

Result: The landlord faces prosecution under the Gas Safety Regulations. You lose the landlord as a customer. If someone was harmed, the consequences are criminal.

Scenario 3: Gas Safe audit

Gas Safe audits your business. They ask for records of all engineers' registrations, categories, and certificates produced in the last 12 months. You hand over a spreadsheet with gaps, out-of-date entries, and missing certificates.

Result: At minimum, a warning and increased scrutiny. At worst, suspension from the register while you sort your records out. Suspension means your engineers can't work.

None of these scenarios are hypothetical. They happen to real businesses every year. The spreadsheet is the common factor.

Making the switch

If you're currently using a spreadsheet, here's the migration path:

Week 1: Export your spreadsheet data. Sign up for proper tracking software. Import engineer details, Gas Safe numbers, and ACS categories.

Week 2: Enter all current landlord properties with their last CP12 dates. The system calculates next due dates automatically.

Week 3: Start generating certificates from the new system instead of paper/Word templates. Old certificates stay in your files — new ones are digital from this point forward.

Week 4: Confirm all expiry alerts are set. Test by checking the next 90 days of upcoming renewals. Verify nothing has been missed.

From this point, the system handles reminders, tracks qualifications, generates certificates, and keeps you audit-ready. The spreadsheet becomes an archive.

The bottom line

Spreadsheets are fine for static data. Gas Safe compliance isn't static. It changes every time an engineer renews (or doesn't), every time a landlord's annual check comes due, and every time you assign someone to a job.

The question isn't whether to move to proper software. It's how many close calls you want to have before you do.