A spreadsheet that keeps every subcontractor's insurance, accreditations and CIS status in one place, flags what expires in the next 30 days, and checks each policy against the cover you require. Excel and Google Sheets. One-time price, no subscription.
What it does
- One row per policy, one row per accreditation. Insurer, policy number, dates, limit of indemnity, indemnity to principal, waiver of subrogation.
- Status on every row: Valid, Expiring (within 30 days, or a warning period you choose), Expired, Missing.
- Requirement check: set requirement profiles with your own minimum limits and conditions. Each policy shows "Meets requirement" or exactly what falls short.
- Missing cover count: if a profile needs employers' liability and there's no policy row for it, the subcontractor is flagged.
- CIS status per subcontractor (your HMRC verification result), an overall status and a one-page dashboard.
What's included
| Tab | Purpose |
|---|---|
| Start here | Four-step setup and what each status means |
| Dashboard | Counts by status for subcontractors, insurance and accreditations |
| Subcontractors | Up to 200 companies with contacts, CIS status and requirement profile |
| Insurance | Up to 600 policies |
| Accreditations | Up to 400 accreditations and registrations (SSIP membership, Constructionline, Gas Safe, NICEIC) |
| Requirements | Your own minimum limits and conditions per profile |
| Lists | Types of cover, profile names, warning period |
| Changelog | Version history |
Works with
Excel 2016 or later (Windows and Mac) and Microsoft 365. Google Sheets via a make-a-copy link. A4 print layout, DD/MM/YYYY dates. No macros, no add-ins, no account.
What it isn't
- Not insurance or tax advice. It ships with requirement limits blank, and CIS is a status column only: it does no deduction maths.
- Not a subcontract. It records what you've checked.
- Not software. No logins and no per-subcontractor fees.
Licences
| Licence | Who | Launch price |
|---|---|---|
| Single | One person in one business | £23 |
| Team | Up to 10 people in one company | £57 |
Lifetime free updates. Licence terms · Refunds
FAQ
Does it work in Google Sheets? Yes. Your download includes a make-a-copy link that puts your own copy in your Google Drive.
Which Excel do I need? Excel 2016 or later on Windows or Mac, or Microsoft 365.
Can I change the 30-day warning? Yes. Set any number of days from 1 to 365 on the Lists tab.
Does it tell me what cover to require? No. Requirements come from your contracts and your broker. You enter them once per profile.
Is there a version with the training matrix? Yes: the Subcontractor Compliance Kit includes both.
Fernoth research, sources checked 21 Nov 2026. This tracker is a record-keeping aid. It does not guarantee that any insurance is adequate, that any accreditation covers the work, or that CIS deductions are correct.