Vendor compliance folder and expiration date tracking spreadsheet — "Subcontractor liability incident uncovered without active general liability policy"
Why the manual spreadsheet breaks financial controls and how a deterministic workflow replaces it.
Certificates of insurance are dropped into a vendor folder and expiration dates are typed into a tracker, so a lapsed policy is noticed only when someone opens the sheet.
A subcontractor works without active general liability coverage, and the company discovers the gap only after an incident.
OCR insurance verification that binds each certificate to the vendor record and blocks purchase orders or site access when coverage is expired or insufficient.
Coverage assertion: a purchase order or site badge cannot issue to a vendor whose required policy is missing, expired, or below the stated limit on the check date.
Three-stage comparison between manual workbook reconciliation and automated rule-based execution.
Expirations typed into a sheet that no one checks before a job starts.
Vendors work without active coverage because the tracker is not a gate.
Coverage is verified on the vendor and blocks work when it lapses.
A PO or badge cannot issue when a required policy is missing, expired, or under limit.
Adjacent spreadsheet failure modes in the same APQC Category 9 process group.
Vendor onboarding packet folder and risk management checklist
Control-owner RACI workbook and SoD conflict log
Ethics-attestation tracker and policy-version spreadsheet
Scope the replacement architecture for manual tracking of vendor insurance certificates & coi expirations or combine multiple failure modes in the directory.
