Free template
Free subcontractor insurance tracker template
A ready-made spreadsheet for keeping track of your subcontractors' certificates of insurance. Download it, add your subs, and the expiry column changes colour as renewal dates get closer.
What's in it
Columns
- Subcontractor
- Policy type (PL, EL, CAR or PI)
- Insurer
- Policy number
- Cover level (£)
- Expiry date
- Days left
- Status
Policy types listed
- Public liabilityPL
- Employers' liabilityEL
- Contractors' all risksCAR
- Professional indemnityPI
Colour bands on the status column
An example tab with made-up rows, so you can see how it works before you delete them.
How to use it
- 1
Add one row per policy, not one row per subcontractor. Most subs will have two or three.
- 2
Copy the expiry date and cover level straight from the certificate, not from an email.
- 3
Sort by “days left” every Monday and chase anything red, orange or amber.
- 4
Keep the certificate PDF somewhere you can find it, so you can match it back to this row when you need to double check a detail.
Where spreadsheets fall down
A spreadsheet only works if someone opens it. It can't email a subcontractor for their new certificate, and it won't tell you when the person who kept it up has left.
Tired of updating this by hand?
CoverTrack keeps your subcontractors' certificates in one place and shows you what's expiring, so nothing slips through a spreadsheet.
The template is a record-keeping aid. It doesn't tell you what cover a particular job needs.
CoverTrack checks the certificates you upload against the requirements you set. It doesn't confirm policy status with insurers or brokers, and it doesn't provide insurance or legal advice.
Looking for something else? Approved contractor pack for property managers