Landlord Gas Safety Tracker Excel - Free Template

1. Open the Properties sheet and replace or extend the sample records. Enter the Property ID, address, town or city, postcode, property type, landlord or agent, tenant, tenancy start date, active status and notes.
2. Use the Gas Safety Log sheet for one row per completed inspection. Select a Property ID from the list rather than retyping the property reference.
3. Enter the Last Check Date, engineer name, Gas Safe registration number, certificate reference and appliances checked. Select the inspection result from the available list.
4. Record whether remedial action is required, add its due date and enter the completion date when the work is finished. Also select whether the certificate has been received.
5. Review the calculated Next Check Due, Days Until Due, Compliance Status and Remedial Action Status columns. Do not overwrite these formula cells.
6. Open the Dashboard to review the 2026 sample data or your live records by status, town or city and certificate status.
7. Read the Instructions sheet before relying on the workbook as an administrative record. It states that the tracker does not replace professional legal or gas safety advice.

A private landlord with several rental properties can use this workbook to keep inspection records beside the property details they relate to. A letting agent can use the same structure to separate properties by Property ID while retaining the landlord or agent name, tenant name and contact notes.

The sample Properties sheet contains P001 at 14 Willow Road in London, P002 at 8 Market Street in Manchester and P003 at 22 Harborne Lane in Birmingham. These are illustrative records, not instructions to retain the supplied names or addresses. Replace them with your own property register before adding live inspections.

Weekly portfolio review

A portfolio manager might filter or review the Gas Safety Log after arranging contractor visits. For example, GSC-001 links to P001 and records a 14/02/2026 check, Daniel Hughes, registration number GS-582014, a certificate reference and the appliances Boiler, gas hob. The linked address, town or city and tenant appear from the Properties sheet rather than being typed again.

Monthly record checking

An agent managing 12 properties could use a monthly administration session to check each active property has a current log row and a certificate status. The Dashboard counts total properties and total gas safety records, so a difference such as 12 properties and 10 records gives you a specific gap to investigate rather than a vague sense that the register is incomplete.

The workbook is also suitable when inspections produce follow-up work. GSC-002 is an example with a Pass – Remedial Action result, a Yes entry for remedial action and a recorded due date. That combination lets the administrator keep the inspection outcome and the follow-up task in the same row.

The workbook separates information you type from outputs it calculates. You enter the Property ID, inspection date, engineer details, result, certificate information and remedial action fields. The address, town or city and tenant name are then returned with VLOOKUP from the Properties range, making the Property ID the key reference.

Dates and due calculations

Next Check Due is calculated as Last Check Date plus 365 days. If a check was recorded on 14/02/2026, the formula produces a date 365 days later. Days Until Due subtracts TODAY from that calculated date, so the number changes as the calendar moves rather than remaining a manually entered reminder.

The Compliance Status formula first checks the Result. An Unsatisfactory result produces Action Required; otherwise, a past due date produces Overdue, a due date within 30 days produces Due Soon, and other dated records produce Compliant. These labels describe the workbook's calculation and should not be treated as independent legal advice.

Controlled inputs and follow-up work

Property type, active status, Property ID, Result, Remedial Action Required? and Certificate Received? use list validation. Dates for tenancy start, Last Check Date, Remedial Action Due and Remedial Action Completed Date use date validation. This is preferable to free-text variations such as Yes, YES and Y, which would make later counts less reliable.

Remedial Action Status uses the action flag, completion date and due date. A completed date produces Completed; No produces Not Required; a missing due date produces Open; and a past due date produces Overdue. For example, P003 has an Unsatisfactory result and no certificate received, so the row needs administrative follow-up even before you examine the Dashboard totals.

The most damaging error is usually an incorrect Property ID. If an administrator types P01 instead of P001, the lookup formulas cannot return the address, town or city or tenant. The inspection may still contain a date and engineer name, but it is no longer reliably connected to the correct property.

Duplicate and incomplete references

Retyping addresses creates another risk. A property may appear as 14 Willow Road in one row and with a different spelling in another, making manual searches unreliable. Selecting P001 from the linked list avoids that duplication and allows the formula to return the stored address consistently across the log.

Blank certificate fields can also conceal unfinished administration. In the illustrative records, GSC-004 is not present; GSC-003 instead shows Certificate Received? as No and Notes stating that an engineer revisit is to be arranged. If a certificate is received later but the field remains No, the Dashboard certificate profile will continue to count that record as outstanding.

Misreading calculated statuses

A user might manually type a status over the formula in column R or T. That breaks the relationship between the result, dates and displayed status. For example, an inspection with a Last Check Date 40 days before its calculated due date should not be labelled Due Soon by hand: the formula uses the remaining days and will update as time passes.

Remedial action dates require equal care. If N is Yes but O is blank, the workbook returns Open. If O contains a date that has passed and P is blank, it returns Overdue. Entering a completion date before the work is actually complete would make the row display Completed even though the underlying task remains unresolved; use P only when your supporting records confirm completion.

Finally, the Dashboard should not be used without checking the source rows. Its totals are formula-driven, so a wrong Property ID, missing Check ID or overwritten formula can change the summary while leaving the page apparently populated.

Make the workbook part of a fixed property-management session rather than opening it only when a contractor calls. A practical routine is to update the Gas Safety Log after each inspection, then review the Dashboard during the next weekly administration block.

Use a repeatable review sequence

• Start with the Properties sheet and confirm new or ended tenancies, active status and contact notes.
• Move to the Gas Safety Log and check rows with Due Soon, Overdue or Action Required results.
• Review Remedial Action Status separately so an inspection result is not mistaken for completed follow-up work.
• Check Certificate Received? and investigate every No entry shown in the Dashboard certificate profile.

For example, an agent with 20 properties could review the Dashboard first, then open only the rows counted under Overdue, Action Required or outstanding certificates. This is more efficient than reading all 100 available log rows, especially when most records are already Compliant.

Protect the record structure

Keep Property IDs stable and use the supplied validation lists. Do not insert alternative result wording such as Failed or Awaiting works when the formulas expect Pass, Pass – Remedial Action or Unsatisfactory. Retain the Instructions sheet with the workbook so anyone taking over the routine understands which cells are inputs and which are calculated outputs.

As the portfolio grows beyond a manageable 100-row register, or when several users need simultaneous access, audit trails, document storage and automated reminders, assess whether a dedicated property-management system is more suitable. The workbook remains useful as an administrative tracker, but the Instructions sheet expressly says it does not replace professional legal or gas safety advice.