How to Track Subcontractor Insurance Expiry Without a Spreadsheet

You've got a spreadsheet with every subcontractor's name, their public liability insurance expiry date, maybe a column for White Cards or trade licences. It worked fine when you had five subbies. Now you've got thirty, working across four sites, and someone's public liability lapsed three weeks ago and nobody noticed until a client asked for proof of currency.

This is the most common compliance failure in construction, trades and labour hire businesses: not a lack of policy, but a lack of a system that actually flags problems before they become problems.

Why the spreadsheet always breaks down

A spreadsheet is a static record. It only tells you what someone typed into it, on the day they typed it. It doesn't:

• Check today's date against the expiry date and tell you anything
• Remind anyone before a certificate lapses
• Distinguish between who last updated a row, or when
• Stop someone from overtyping an expiry date without saving the old certificate
• Show you, at a glance, who's actually compliant right now

Every one of those gaps relies on a person remembering to check the spreadsheet, on a regular basis, forever. That's not a system — it's a hope.

The real cost of missing an expired certificate

If a subcontractor's public liability insurance has lapsed and they're injured or cause damage on your site, you can be exposed to the claim yourself. Head contractors and principal certifiers increasingly ask for proof of current insurance before allowing subbies on site, and if you can't produce it fast, you risk delays or being pulled off a job. None of this is about ticking a box — it's about who actually carries the risk when something goes wrong.

What tracking should actually look like

Instead of one flat list, subcontractor insurance tracking needs a few things working together:

• Separate records for contractors and employees. Subcontractors carry their own insurance and licences, and that record shouldn't get mixed up with your own staff's certifications.
• Automatic reminders before expiry, not after. Alerts at 90, 60, 30, 14, 7 and 1 day out, plus one on the day it actually lapses, give you time to chase renewals before a subbie is on site uninsured.
• A live status view. One dashboard showing every subcontractor as valid, expiring soon, or expired — no scrolling through date columns doing mental maths.
• An audit trail. A record of who updated which document and when, so there's no argument later about whether a certificate was ever actually current.
• Exportable reports. When a principal contractor or auditor asks for proof of compliance across your whole subcontractor base, you need a CSV in minutes, not an afternoon of digging through emails.

Where ComplianceVault fits in

ComplianceVault is built to do exactly this. It tracks insurance, licences and certifications separately for employees and contractors, sends automatic expiry reminders at 90, 60, 30, 14, 7 and 1 days out (and on the day itself), and gives you a live dashboard showing every subcontractor's status. Every update is logged in a full audit trail, and you can pull a CSV report whenever a client or head contractor needs proof of currency.

If you're still relying on a spreadsheet and a mental note to "check that soon," it's worth seeing what a proper system looks like. ComplianceVault has plans from $49/month AUD, with a 14-day free trial and no card required to start — head to compvault.com.au and see how much time it saves the next time a certificate is about to lapse.