Template

Snagging list template

A defect register with the columns that make a list work and none of the ones that make it a chore — severity and priority kept apart, and a two-stage close so an item is never signed off by the trade that fixed it.

16columns
2-stageclose
Exceldownload
£0no sign-up

Most snagging lists are written to prove something was found. The useful ones are written to get it put right — once, by the right trade, without anybody ringing you to ask what you meant.

Download the Excel template Defect register with drop-downs and a live status count · .xlsx, 12 KB · no sign-up, no email

The template

Four example rows, so the format is obvious. Delete them and start.

RefDate raisedBlock / levelUnitRoom / elementDefectSeverityPriorityTradeTarget dateStatusPhotoFixed byDate fixedClosed byDate closed
SNG-00123/09/2026Block B · L02Flat 12KitchenWorktop join at the sink run is open and unsealedModerateMediumRidgeway Joinery07/10/2026OpenYes
SNG-00223/09/2026Block B · L02Flat 12HallwayArchitrave mitre open at the head of the door, about 3 mmMinorLowRidgeway Joinery07/10/2026In progressYes
SNG-00323/09/2026Block B · L02CorridorEmergency lightingEmergency light at the lobby end does not illuminate on key testSignificantHighRidgeway M&E26/09/2026OpenYes
SNG-00422/09/2026Block B · L01Flat 09BathroomSilicone to the bath edge cracked along the full runModerateMediumPrime Finishes06/10/2026Fixed – to checkYesT. Nowak23/09/2026

What each column is for

ColumnWhy it earns its place
RefA number that never changes and never gets reused. It is how the item is referred to in an email six weeks later.
Block / level, Unit, RoomThree separate columns, so the list can be filtered by any of them. “Second floor” on its own sends somebody hunting.
DefectWhat is wrong, where on the element, and how much of it. Describe the defect, never the fix.
SeverityHow bad it is: cosmetic, minor, moderate, significant.
PriorityHow soon it must be dealt with. Driven by the programme and by what is about to be covered up — not by severity.
TradeA named subcontractor. Unassigned items do not get fixed, they get discussed.
Target dateWithout one, everything is equally urgent, which is the same as nothing being urgent.
StatusOpen, in progress, fixed – to check, closed, rejected. Five is enough; ten is a taxonomy nobody follows.
Fixed by / Closed byTwo separate pairs of columns, deliberately. See below.

Severity and priority are not the same thing

Severity is how bad the defect is. Priority is how soon it has to be dealt with. A cosmetic scratch on a panel that is about to be boxed in is low severity and high priority, and a list with only one of these columns cannot express that — which is why the panel gets boxed in.

The two-stage close

This is the single change that does most for a list, and it is the reason the template has four columns at the end rather than two.

  1. The trade puts the defect right and marks the item fixed – to check, with their name and the date.
  2. Somebody from your side looks at it on site and marks it closed, with their name and the date.

An item is never closed by the party that fixed it. Without that rule, “closed” means “somebody said so” and the list stops being evidence. With it, every closed item carries two names and two dates, and a dispute is a five-second lookup instead of an afternoon.

How to describe a defect

Weak

“Bad plaster in bedroom.”

Better

“Plaster to the bedroom window reveal is hollow over about 400 mm at low level and cracked at the corner bead.”

Write what you can see, where it is, and what is wrong with it — in that order, in one sentence a trade can act on without ringing you.

Issuing it

Send each trade only their own items, as one document, with the photographs in it. A spreadsheet of the whole job filtered by a column heading gets ignored, reasonably, because it asks the reader to do your filing for you. In Excel that means a filter and a save-as per trade, every time the list moves.

What a spreadsheet cannot do

Hold the photographs with the items. Tell you what is overdue without you sorting it. Stop two people overwriting each other on the same row. Pin an item to a spot on the drawing so nobody has to go looking. Issue one document per trade in a tap. Those five things are the whole argument for a register that is not a spreadsheet.

Stop rebuilding the list by hand

Pin it, photograph it, assign it, date it — and let the register work out what is overdue and issue one PDF per trade.