Tools
Spreadsheet vs software for subcontractor document tracking
A spreadsheet is a reasonable starting point. At some point it stops being good enough. This guide covers where the line is, what actually breaks, and what the alternative looks like in practice.
Where a spreadsheet holds up
A spreadsheet does one thing well: it stores what you put into it. For a contractor managing three or four regular subcontractors, a shared Google Sheet with names, document types, and expiry dates is perfectly functional. You can see everything in one place, sort by date, and update it in thirty seconds.
At that scale, the spreadsheet is not broken. The overhead of switching to dedicated software would not be worth it. This guide is for contractors who have grown past that -who are managing ten, twenty, or thirty subcontractors and finding the spreadsheet is starting to work against them.
Where spreadsheets break
No proactive alerts. A spreadsheet is passive. If you do not check it on the day a CSCS card expires, you will not know it has expired. This works when you have four subcontractors and check the sheet every Monday. It does not work when you have twenty-five subcontractors and a full programme to run.
Single point of failure. In most small contractors, one person owns the spreadsheet. When they are on site, on leave, or leave the business entirely, the system falls over. Spreadsheets rarely get properly handed over -they become stale, and gradually stop being trusted.
The document is not the spreadsheet. The sheet records that a subcontractor has a valid insurance certificate. It does not contain the certificate. When a principal contractor asks you to produce a copy, you are back to searching through old emails, shared drives, and WhatsApp threads. Two separate systems that never quite connect.
No audit trail. When was this record last updated? Who changed it? Was the expiry date verified from the original document, or was it what the subcontractor said over the phone? A spreadsheet cannot answer any of these. In an audit or a dispute, that uncertainty matters.
It does not scale. Adding the fifteenth subcontractor, with eight document types each, to a sheet already full of conditional formatting and dependent formulas, is friction. Most contractors respond by simplifying the sheet -tracking fewer things -which means the compliance picture becomes less reliable over time.
The real cost of a missed renewal
When a subcontractor turns up with an expired CSCS card, the site manager turns them away. If they are on a day rate, that is a day's lost income for them and a day lost from your programme. They then need to apply for a renewal -which takes two to four weeks -during which they cannot return.
The cost of a 30-day reminder is zero. The cost of not having one, on a busy site, is real. That is the core argument for moving from a spreadsheet to dedicated tracking: the failure mode has a direct cost, and it is entirely preventable.
What a purpose-built tracker does differently
The fundamental difference is that a purpose-built tracker is active, not passive. Instead of waiting for you to check it, it sends an alert when action is needed. Instead of storing a date in a cell, it monitors that date against today and tells you what is coming up.
Is the switch worth it?
If you have fewer than eight subcontractors and have never had a document compliance incident, the switch probably is not worth it right now. A well-maintained spreadsheet with calendar reminders does the job at that scale.
It is worth switching if any of the following apply:
- You regularly manage more than ten subcontractors
- You've had a document compliance incident in the last year
- You are the only person who knows the state of your compliance records
- You cannot produce subcontractor documents quickly when asked
- Your spreadsheet has not been updated in the last month
ExpiryFlow takes under 10 minutes to set up. There is a 14-day free trial with no credit card required. The Pro plan is £19/month -less than the cost of a single day off site for a turned-away subcontractor.
If it does not work for you, you can export your data and go back to the spreadsheet. In practice, contractors who try dedicated tracking rarely do.
See what ExpiryFlow costs
£19/month for unlimited subcontractor document tracking, automatic reminders, and CSV export. 14-day free trial, no credit card required.
No credit card required