Excel is where most GCs start with COI tracking. It’s free, it’s familiar, and it works — until it doesn’t. Here’s the honest breakdown of when spreadsheet-based COI tracking is perfectly fine, and exactly when it becomes a liability.
Excel COI tracking gets a bad reputation that’s only half-deserved. For a GC managing a handful of regular subcontractors with stable insurance situations, a well-maintained spreadsheet is genuinely adequate. The problem isn’t the tool — it’s that most teams keep using it past the point where it can do the job safely.
When Excel Works Fine for COI Tracking
A spreadsheet is a reasonable COI tracking tool when all of the following are true:
- You have fewer than 15–20 active vendors with insurance requirements
- Your vendor roster is stable — not many new subs being added regularly
- You have one person responsible for compliance who can realistically monitor the spreadsheet
- Your projects have standard, consistent insurance requirements (no complex endorsement needs)
- You’re not running Procore, Autodesk, or an ERP that needs compliance data from a separate system
In these conditions, a spreadsheet with columns for vendor name, COI expiration date, coverage amounts, and a column for “renewal reminder sent” does what it needs to do. It’s not elegant, but it works.
Exactly Where Excel Breaks Down
It doesn’t collect COIs — you do
A spreadsheet tracks what you tell it. It doesn’t reach out to subcontractors to request certificates, follow up when they don’t respond, or send renewal reminders before expiration. Every action in the compliance lifecycle is manual — and every manual action is a potential miss.
It can’t review endorsements
Excel can record that a COI was received. It cannot tell you whether the CG 20 10, CG 20 37, or Primary and Non-Contributory endorsements are actually present and correct. You have to read every certificate manually — which at scale is where most teams start cutting corners.
It goes stale the moment you stop touching it
A spreadsheet is current on the day someone updates it. The moment a policy renews, an insurance carrier changes, or a coverage limit changes, the spreadsheet is wrong — and you don’t know it. A database with real-time data isn’t a spreadsheet.
It doesn’t connect to your other systems
Your Procore projects don’t know what’s in your COI spreadsheet. Your AP system doesn’t know. Your ERP doesn’t know. Every system that needs compliance information gets it through someone copy-pasting from the spreadsheet — which means every system has a different, potentially stale version of the truth.
It doesn’t scale with your team
When a compliance coordinator goes on vacation, leaves the company, or gets sick, the spreadsheet knowledge goes with them. Who knows which vendors are coming up for renewal? Where’s the folder with the PDF certificates? The institutional knowledge that makes a spreadsheet work isn’t in the spreadsheet.
The Real Cost of Spreadsheet-Based Compliance
Labor cost
A compliance coordinator tracking 200 COIs manually spends roughly 10–15 hours/week on collection, review, and follow-up. At $40–50K salary, that’s $20K+ annually in labor for tasks that software handles automatically.
Exposure cost
When a spreadsheet miss lets an uninsured sub work on your project, the potential liability from a single on-site incident far exceeds any software investment. One denied claim can cost millions.
AP hold cost
When your ERP fires an AP hold because compliance data wasn’t updated on time, your AP team stops, investigates, follows up, and re-processes. Multiply that by any week with several expired COIs.
Audit cost
When an owner or insurer requests a compliance audit, a spreadsheet requires someone to manually gather, verify, and organize certificates that may live across multiple folders and email threads.
Free COI Tracking Template for Excel
If you’re still in the spreadsheet phase, Billy’s free COI tracking template is a significantly better starting point than a blank sheet. It includes:
- Vendor information columns with fields for legal name, EIN, and contact information
- Coverage columns for GL, WC, Auto, and Umbrella with limits and expiration dates
- Endorsement tracking fields for AI status, PNC, and Waiver of Subrogation
- Status indicators and conditional formatting for expiring and expired certificates
- A renewal tracking column with target outreach dates
Download it, adapt it to your requirements, and use it. When you outgrow it — and you will — the transition to Billy is straightforward because the data structure maps directly.
When to Switch to Dedicated COI Tracking Software
The decision to move off Excel isn’t about reaching a specific vendor count — it’s about recognizing when the manual overhead and exposure risk have exceeded what the spreadsheet savings justify. These are the signals:
- You’ve had an AP hold that required manual resolution — A compliance miss that caused a payment delay is the clearest signal that your current process isn’t working at your current scale.
- You’re managing 50+ active vendors — At this volume, manual tracking consumes meaningful staff time and creates coverage gaps that compound weekly.
- You’ve added Procore, Autodesk, or an ERP — The moment your compliance data needs to live in two systems, the spreadsheet becomes a bottleneck rather than a solution.
- You’re not reviewing endorsements — If your team is accepting COIs without verifying CG 20 10, CG 20 37, and PNC, you’re taking on endorsement risk that scale makes increasingly likely to matter.
- Renewal tracking is a recurring fire drill — If January and July renewal seasons cause visible stress across your compliance and AP teams, you’ve outgrown the spreadsheet.
See how teams make the transition in our guide to COI tracking at scale, and how to evaluate platforms in our honest 2026 comparison of COI tracking software.
Ready to Move Off the Spreadsheet?
Billy replaces your Excel COI tracker with automated collection, AI review, and ERP sync — with free tools for your subcontractors.
Book a Demo →
