Pikorua Security vs. Manual Spreadsheet COI Tracking

What a spreadsheet actually tracks

A COI spreadsheet usually has a row per vendor and columns for the insurer, policy numbers, each limit and each expiration date. Every value is copied by hand from the ACORD 25 front page. That page is a summary prepared by the vendor's insurance agent, and it says so: the form states it is issued as a matter of information only and confers no rights upon the certificate holder.

The coverage that protects you lives in the endorsements attached to the vendor's policy. Whether you are an additional insured for completed operations, whether the vendor's insurance is primary and non-contributory to yours, and whether the carrier has waived subrogation against you are all questions the spreadsheet has no column for. The ADDL INSD and SUBR WVD columns on the certificate are single letters, and a Y in either tells you nothing about which form is attached or which edition it is.

That is why spreadsheet tracking misses roughly 70% of endorsement defects even when every row is accurate. Pikorua Security reads the endorsement pages themselves and verifies them at 99.4% accuracy across ISO forms.

Where the 71% defect rate hides

The AGC Risk Committee Audit puts the share of subcontractor and vendor COIs with a material deficiency on first review at 71%. Pikorua Security's 2026 benchmark breaks that down by category (a file can have more than one), and the breakdown explains why spreadsheets catch so little of it.

The two categories a spreadsheet handles well, low limits and expiration dates, are the smallest on the list. The three largest endorsement categories sit on pages the spreadsheet never records.

• Missing CG 20 37 completed operations: 64% of deficient files. Invisible on the front page.
• Named insured mismatch: 48%. Visible only if the reviewer compares the certificate with the subcontract's legal entity name.
• No waiver of subrogation (CG 24 04 or WC 00 03 13): 41%. The SUBR WVD column can show a Y without the form.
• Primary and non-contributory wording absent: 37%. Only on the endorsement or in the policy.
• Limits below the contract exhibit: 29%. Visible, and usually caught.
• Expired or expiring within 30 days: 22%. The one thing spreadsheets are built to catch.

What the spreadsheet costs a $50M contractor

Take a commercial general contractor with $50M in annual volume and 150 active subcontractors a year. At a 71% defect rate, about 106 of those subcontractors have a material coverage problem in their files. Reviewing and chasing them by hand takes about 4 hours per subcontractor per year across the initial review, renewals and follow-up, or 600 hours in total. At a $45 loaded hourly cost for a project manager, that is $27,000 a year in administrative payroll, spent mostly on work that still misses the endorsement defects.

The larger number is the exposure. When a subcontractor's carrier denies an additional insured tender, the general contractor's average out-of-pocket litigation and SIR loss runs $150,000 or more, according to IRMI construction risk analysis. One denied tender costs more than a decade of COI software.

Pikorua Security Professional costs that contractor $8,388 a year. It recovers about 520 of the 600 administrative hours, verifies every endorsement against the subcontract exhibit, and holds payment through the Procore, Yardi or AppFolio connector until deficiencies are fixed.

Moving off the spreadsheet in a week

You do not have to rebuild anything. Export the spreadsheet as CSV and Pikorua Security maps the columns to vendor records, matching names to your ERP or project management vendor list. Upload your subcontract or vendor insurance exhibit and the rule builder turns each requirement into a check, from limits and AM Best thresholds to required forms and editions.

Then send every vendor a zero-login upload link copied to its insurance agent. Pikorua Security reads each returned packet in about 15 seconds, flags what fails, and chases the gaps on a 60, 30, 15 and 0 day cadence. Most teams retire the spreadsheet inside the 14-day free trial.