COI tracking: spreadsheet vs. software, and when to switch

A spreadsheet is enough when your list of subs is short and steady and one person owns the renewal dates. Switch to software when expiries start slipping past you, when several people edit the file, or when chasing certificates is crowding out the rest of the job.

Most general contractors start in Excel or Google Sheets, and that's a sensible first move. The question is when the sheet stops being the cheapest way to stay covered.

What a spreadsheet does well

A well-kept sheet handles the basics:

1. A row for each active sub, with trade and contact.
2. Expiry dates for general liability, workers' comp and auto.
3. A reminder or conditional formatting 30 days before each date.
4. A link to the latest PDF.

With one project at a time and the same person updating it every week, that can hold for years.

How spreadsheets fail

Nobody forgets to make the spreadsheet. The trouble is that it stops matching what's true:

• Stale rows. The cell still shows last year's date because nobody updated it after the renewal, or it shows a date someone typed without the certificate.
• Several editors. One project manager updates job A, the office updates job B, and nobody reconciles duplicates or subs who've left.
• No endorsements. The sheet tracks dates, not whether the additional insured or waiver of subrogation endorsements exist. See certificate vs. additional insured.
• No history. When an owner asks whether a sub was insured on June 12, a sheet rarely shows which document you had that day.

None of these are rare. They're what happens to a sheet when a contractor wins more work.

Signs it's time to switch

Switch when two or more of these are true:

Sign	What it looks like in the office
Missed renewals	You find an expired certificate after the sub is already on site
Shared ownership	Several people edit the sheet and nobody owns it
Many projects	The same sub works several jobs with different requirements
Owner or lender requests	A request for proof of coverage takes half a day
Admin overload	Chasing certificates crowds out estimating or project work

If none apply, keep the sheet.

What software should do

For a general contractor, useful COI tracking software does five jobs:

1. Keeps the current certificate for each sub, and the earlier ones.
2. Warns before expiry, by email or text.
3. Lets the sub upload renewals through a link, so you're not the only one chasing.
4. Shows gaps against what you require: limits, additional insured status, workers' comp.
5. Produces a list you can hand to an owner, lender or auditor.

If a product can't do those five, it isn't replacing your spreadsheet.

Switching too early or too late

Too early costs a subscription and an afternoon of setup for a problem you don't have yet. Too late costs the hours of emergency chasing, and the risk of a claim from a sub whose coverage lapsed while the sheet said otherwise.

The crossover usually comes when chasing certificates has become a weekly job for someone who should be running projects.

Moving over

1. Export your current list: names, emails and expiry dates.
2. Load it into the tool and attach the PDFs you already have.
3. Turn on expiry alerts before you invite any subs.
4. Invite the busiest or highest-risk subs to upload first.
5. Keep the old sheet read-only for 30 days, then archive it.

TradeGuard follows that path: import your list, get expiry alerts at 90, 60 and 30 days by default, and let subs upload renewals through a link with no account. You can start a 14-day trial with your own roster.

FAQ

Is a spreadsheet ever enough for COI tracking?

Yes, for a short, steady list of subs with one person who updates it every week. It stops being enough when expiries slip or several people edit the file.

When should a GC switch from a spreadsheet to COI software?

When you've missed a renewal, when chasing certificates has become a weekly job, or when owners and lenders ask for proof of coverage you can't produce quickly.

What features matter most in COI tracking software?

The current certificate for each sub, expiry alerts, an upload link for subs, checks against your requirements, and a list you can export.

Do I lose my history when I switch?

Not if you load your existing certificates into the new tool. Keep the old PDFs, so you still have a dated record of what was on file.