← All posts

Spreadsheet tracking

Construction Document Tracking Spreadsheets: Where They Break and What to Use Instead

Spreadsheets are how most GC offices start tracking subcontractor COIs and compliance docs. Here is how to build one that holds up, the specific points where it will fail as your sub list grows, and what to change when it does.

Start with a spreadsheet — but build it right

A spreadsheet is the right first tool for most GC offices. It costs nothing, it works with how your team already operates, and it creates at least one place to look instead of three inboxes and a folder called "Subs — Insurance 2023."

The problem is not that spreadsheets do not work. The problem is that most COI tracking spreadsheets are not built to do what they need to do. They track what was collected, not what needs to happen next. They have dates but no status. They have rows for every sub you have ever used, including ones you have not called in two years. And they depend entirely on someone remembering to open them.

If you are starting from scratch or cleaning up an existing sheet, here is how to structure it so it stays useful.

How to structure the spreadsheet

One tab for active subcontractors. One row per sub. The columns that matter:

Column	What goes here
Subcontractor name	Legal business name — matches what's on the COI
Trade / scope	Electrical, framing, HVAC, etc.
Primary contact	Name and email for the person who sends certificates
GL expiration	Date from the current certificate on file
WC expiration	Date or "exempt" with state-specific basis noted
Umbrella expiration	Date or "not required"
Status	Current / Expiring soon / Expired / Missing / Needs review
Certificate file	Link or path to the saved PDF
Last reviewed	Date and initials of whoever checked the certificate
Next reminder date	60 days before the earliest expiration
Notes	Renewal pending, wrong cert holder, follow-up date, etc.
Active on jobs	Which current projects this sub is working
W-9 on file	Yes / No

Use conditional formatting on the GL expiration column: yellow for 60–90 days out, red for under 60 days, darker red for expired. That gives whoever opens the sheet an instant visual scan without reading every cell.

Keep inactive subs on a second tab, not deleted. You may need their certificate history for an old project audit. But do not let them clutter the active view.

Where the spreadsheet breaks — and what to do about it

Break 1: The document is not where the row says it is

Someone updates the status column to "current" but the PDF is in an email thread from six months ago that the original recipient has since deleted. The row says the certificate is on file. It is not findable in two minutes.

The fix is a document naming and saving convention that everyone on your team uses the same way. Before any row gets marked current, the PDF has to be saved in one agreed folder with a consistent name: SubName_GL_MMYYYY.pdf or similar. The cell in the spreadsheet should link directly to that file — not to the folder, to the file.

If your team does not have this habit yet, it is the single highest-value change you can make to the spreadsheet before anything else. The spreadsheet is only as trustworthy as the files it points to.

Break 2: The reminders are manual and they fall through

The "next reminder date" column tells you when to send a renewal request. But unless someone opens the spreadsheet every Monday and looks at that column, nothing happens. Calendar events help, but they get buried. Conditional formatting highlights the date, but only if you look.

There is no way to fully fix this inside a spreadsheet. You can improve it by making the Monday review a standing 15-minute meeting on the calendar for whoever owns COI tracking — and treating the review as a non-optional part of the week, not a nice-to-have. But the spreadsheet will not send the reminder for you.

If your office misses renewal reminders more than once or twice a year, that is a sign the manual review is not happening reliably enough. At that point, a tool that sends reminders automatically is worth the change.

Break 3: Only one person knows how the sheet works

If the admin who maintains the spreadsheet is out sick, on vacation, or leaves the company, the entire COI tracking process stops. Everyone knows where the sheet lives, but nobody else knows which version is current, what the status labels mean, what the follow-up protocol is, or where certificates are saved.

The fix is documentation that lives next to the sheet — a short note that explains the status labels, the file naming convention, the weekly review steps, and where to find certificates. Write it for someone who has never seen the sheet before, because someday that will be the situation.

Keep the sheet in a shared location that at least two people have access to and permissions to edit. Do not let it live in one person's personal drive or desktop.

Break 4: The sheet grows to include everyone you have ever worked with

After a few years, the spreadsheet has 200 rows. Forty of those subs are active. The others are old, archived, or companies that no longer exist. Every time someone opens the sheet, they have to scroll past all of it.

Clean this up on a quarterly basis. Move any sub you have not worked with in 12 months to an archive tab. The active view should be manageable enough that someone can scan it and spot problems in under five minutes.

When to move beyond the spreadsheet

The spreadsheet stops being the right tool when:

• You have more than 30 to 40 active subcontractors and the weekly review takes more than an hour
• Missed renewals are causing job-start delays or owner-audit scrambles more than occasionally
• More than one person needs to access and update the tracker, and version conflicts are creating errors
• Your admin spends meaningful time each week hunting for PDFs that are "somewhere in email"

The fix does not have to be a full construction management platform. That is overkill if the problem is specifically COI tracking and renewal reminders. What you need is a tool that centralizes certificate intake, keeps expiration dates visible, sends reminders automatically, and makes certificates searchable and retrievable without an inbox archaeology project.

Keep the spreadsheet for exports, audit summaries, and anything your accountant or project owner wants in a simple format. A good tracking tool should make it easy to export data, not lock it in.

A spreadsheet that everyone trusts and nobody updates is more dangerous than no spreadsheet at all. It tells you the system is working when it is not.

Keep reading

• Subcontractor compliance checklist
• COI renewal reminder email templates