Certificate Tracker
COMPLIANCE / CERTIFICATE TRACKER
Insurance certificates by urgency.
Sorted soonest-to-expire. The table below is the working list.
Read-only view. Renewing or replacing a certificate happens via the magic-link upload flow at uploads.blackflowcodeai.com. This page surfaces what needs action — it does not action it.
URGENCY / SNAPSHOT
Triage at a glance.
EXPIRED
33
block payment until renewed
CRITICAL · <30 DAYS
10
43 need action now
WARNING · 30-60 DAYS
5
watch list
SOON · 60-90 DAYS
1
queue renewal
HEALTHY · 90+ DAYS
18
of 67 total
AWAITING OCR
3
pending metadata extraction
PENDING REVIEW
3
uploaded, not verified
CERTIFICATES / FULL LIST
Block payment, ping the sub.
Every certificate in the system, sorted by expiration. Negative days are already expired.
| URGENCY | SUBCONTRACTOR | CERT TYPE | POLICY # | CARRIER | EXPIRES | DAYS | STATUS |
|---|---|---|---|---|---|---|---|
| expired | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Turner Construction | Workers Comp | WC-2026-00982 | Zurich Insurance | May 5, 2026 | -62 days | expired |
| expired | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Webcor Builders | Workers Comp | WC-2026-00982 | Zurich Insurance | May 5, 2026 | -62 days | expired |
| expired | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Hensel Phelps | Workers Comp | WC-2026-00982 | Zurich Insurance | May 5, 2026 | -62 days | expired |
| expired | Premier Plumbing & HVAC David Martinez · hello@blackflowcodeai.com Direct | General Liability | GL-PP-2024-001 | Berkshire | May 12, 2026 | -55 days | expired |
| expired | Ironworks Steel Fabrication Sarah Johnson · sarah@ironworks.com Direct | General Liability | GL-IS-2025-001 | CNA | May 14, 2026 | -53 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Turner Construction | Workers Comp | WC-AP-2025-001 | Liberty Mutual | May 18, 2026 | -49 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Balfour Beatty | Workers Comp | WC-AP-2025-001 | Liberty Mutual | May 18, 2026 | -49 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com DPR Construction | Workers Comp | WC-AP-2025-001 | Liberty Mutual | May 18, 2026 | -49 days | expired |
| expired | Elite Roofing Contractors Robert Taylor · robert@elite.com Direct | General Liability | GL-ER-2024-001 | Liberty Mutual | May 19, 2026 | -48 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com DPR Construction | General Liability | GL-AP-2025-001 | Chubb | May 20, 2026 | -47 days | expired |
| expired | Skyline Electrical Services Mike Chen · hello@blackflowcodeai.com Direct | Auto Liability | AL-SE-2025-014 | — | May 20, 2026 | -47 days | pending |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Turner Construction | General Liability | GL-2025-11290 | Nationwide | May 20, 2026 | -47 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Balfour Beatty | General Liability | GL-2025-11290 | Nationwide | May 20, 2026 | -47 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com DPR Construction | General Liability | GL-2025-11290 | Nationwide | May 20, 2026 | -47 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Turner Construction | General Liability | GL-AP-2025-001 | Chubb | May 20, 2026 | -47 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Balfour Beatty | General Liability | GL-AP-2025-001 | Chubb | May 20, 2026 | -47 days | expired |
| expired | Sterling Landscaping Amanda Rodriguez · amanda@sterling.com Direct | General Liability | GL-SL-2025-001 | Travelers | May 22, 2026 | -45 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com DPR Construction | General Liability | GL-AE-2024-001 | Hartford Insurance | Jun 1, 2026 | -35 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Turner Construction | General Liability | GL-AE-2024-001 | Hartford Insurance | Jun 1, 2026 | -35 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Balfour Beatty | General Liability | GL-AE-2024-001 | Hartford Insurance | Jun 1, 2026 | -35 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com McCarthy Building | General Liability | GL-AE-2024-001 | Hartford Insurance | Jun 1, 2026 | -35 days | expired |
| expired | Elite Roofing Contractors Robert Taylor · robert@elite.com Direct | Workers Comp | WC-ER-2025-001 | Nationwide | Jun 10, 2026 | -26 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com McCarthy Building | General Liability | GL-2024-00441 | Travelers Insurance | Jun 15, 2026 | -21 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Balfour Beatty | General Liability | GL-2024-00441 | Travelers Insurance | Jun 15, 2026 | -21 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com DPR Construction | General Liability | GL-2024-00441 | Travelers Insurance | Jun 15, 2026 | -21 days | expired |
| expired | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Turner Construction | General Liability | GL-2024-00441 | Travelers Insurance | Jun 15, 2026 | -21 days | expired |
| expired | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Hensel Phelps | Workers Comp | WC-IH-2025-001 | State Farm | Jun 25, 2026 | -11 days | expired |
| expired | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Turner Construction | Workers Comp | WC-IH-2025-001 | State Farm | Jun 25, 2026 | -11 days | expired |
| expired | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Webcor Builders | Workers Comp | WC-IH-2025-001 | State Farm | Jun 25, 2026 | -11 days | expired |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Turner Construction | Auto Liability | AL-2025-33071 | Progressive Commercial | Jun 30, 2026 | -6 days | pending |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com DPR Construction | Auto Liability | AL-2025-33071 | Progressive Commercial | Jun 30, 2026 | -6 days | pending |
| expired | Apex Plumbing Inc Denise Calloway · admin@apexplumbing.com Balfour Beatty | Auto Liability | AL-2025-33071 | Progressive Commercial | Jun 30, 2026 | -6 days | pending |
| expired | Apex Concrete Solutions Jennifer White · jen@apex.com Direct | General Liability | GL-AC-2025-001 | Zurich | Jul 1, 2026 | -5 days | expired |
| critical | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Turner Construction | General Liability | GL-IH-2025-001 | Zurich | Jul 10, 2026 | 4 days | active |
| critical | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Webcor Builders | General Liability | GL-IH-2025-001 | Zurich | Jul 10, 2026 | 4 days | active |
| critical | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Hensel Phelps | General Liability | GL-IH-2025-001 | Zurich | Jul 10, 2026 | 4 days | active |
| critical | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Turner Construction | General Liability | GL-2025-77403 | Liberty Mutual | Jul 10, 2026 | 4 days | active |
| critical | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Hensel Phelps | General Liability | GL-2025-77403 | Liberty Mutual | Jul 10, 2026 | 4 days | active |
| critical | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Webcor Builders | General Liability | GL-2025-77403 | Liberty Mutual | Jul 10, 2026 | 4 days | active |
| critical | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Turner Construction | Workers Comp | WC-2025-08832 | Hartford Financial | Aug 1, 2026 | 26 days | active |
| critical | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com McCarthy Building | Workers Comp | WC-2025-08832 | Hartford Financial | Aug 1, 2026 | 26 days | active |
| critical | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Balfour Beatty | Workers Comp | WC-2025-08832 | Hartford Financial | Aug 1, 2026 | 26 days | active |
| critical | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com DPR Construction | Workers Comp | WC-2025-08832 | Hartford Financial | Aug 1, 2026 | 26 days | active |
| warning | Ironworks Steel Fabrication Sarah Johnson · sarah@ironworks.com Direct | Workers Comp | WC-IS-2025-001 | Travelers | Aug 30, 2026 | 55 days | active |
| warning | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Turner Construction | Workers Comp | WC-AE-2024-001 | Travelers | Sep 1, 2026 | 57 days | active |
| warning | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com Balfour Beatty | Workers Comp | WC-AE-2024-001 | Travelers | Sep 1, 2026 | 57 days | active |
| warning | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com DPR Construction | Workers Comp | WC-AE-2024-001 | Travelers | Sep 1, 2026 | 57 days | active |
| warning | Alpha Electric LLC Marcus Webb · ops@alphaelectric.com McCarthy Building | Workers Comp | WC-AE-2024-001 | Travelers | Sep 1, 2026 | 57 days | active |
| soon | Sterling Landscaping Amanda Rodriguez · amanda@sterling.com Direct | Workers Comp | WC-SL-2025-001 | Chubb | Sep 10, 2026 | 66 days | active |
| good | Apex Concrete Solutions Jennifer White · jen@apex.com Direct | Workers Comp | WC-AC-2025-001 | AIG | Oct 20, 2026 | 106 days | active |
| good | Advanced Fire Protection Chris Wilson · chris@advanced.com Direct | General Liability | GL-AF-2025-001 | CNA | Nov 1, 2026 | 118 days | active |
| good | Premier Plumbing & HVAC David Martinez · hello@blackflowcodeai.com Direct | Workers Comp | WC-PP-2024-001 | Cincinnati | Nov 15, 2026 | 132 days | active |
| good | Metro Glass & Glazing Tom Anderson · tom@metro.com Direct | Workers Comp | WC-MG-2025-001 | Chubb | Dec 15, 2026 | 162 days | active |
| good | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Webcor Builders | professional | TEST-POL-001 | — | Jan 1, 2027 | 179 days | pending |
| good | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Hensel Phelps | professional | TEST-POL-001 | — | Jan 1, 2027 | 179 days | pending |
| good | Ironclad HVAC Services Ray Okafor · contracts@ironclad-hvac.com Turner Construction | professional | TEST-POL-001 | — | Jan 1, 2027 | 179 days | pending |
| good | Skyline Electrical Services Mike Chen · hello@blackflowcodeai.com Direct | General Liability | GL-SE-2025-001 | AIG | Jan 15, 2027 | 193 days | active |
| good | Diamond Painting Services Lisa Brown · lisa@diamond.com Direct | Workers Comp | WC-DP-2025-001 | Berkshire | Jan 30, 2027 | 208 days | active |
| good | Skyline Electrical Services Mike Chen · hello@blackflowcodeai.com Direct | Workers Comp | WC-SE-2025-001 | Nationwide | Feb 1, 2027 | 210 days | active |
| good | Precision Door Systems Mark Davis · mark@precision.com Direct | General Liability | GL-PD-2025-001 | Zurich | Feb 14, 2027 | 223 days | active |
| good | Metro Glass & Glazing Tom Anderson · tom@metro.com Direct | General Liability | GL-MG-2025-001 | Hartford | Mar 1, 2027 | 238 days | active |
| good | Precision Door Systems Mark Davis · mark@precision.com Direct | Workers Comp | WC-PD-2025-001 | AIG | Mar 28, 2027 | 265 days | active |
| good | Diamond Painting Services Lisa Brown · lisa@diamond.com Direct | General Liability | GL-DP-2025-001 | State Farm | Apr 15, 2027 | 283 days | active |
| good | Advanced Fire Protection Chris Wilson · chris@advanced.com Direct | Workers Comp | WC-AF-2025-001 | Hartford | May 20, 2027 | 318 days | active |
| good | Skyline Electrical Services Mike Chen · hello@blackflowcodeai.com Direct | general_liability | PENDING OCR | — | May 21, 2027 | 319 days | pending_review |
| good | Elite Roofing Contractors Robert Taylor · robert@elite.com Direct | general_liability | PENDING OCR | — | Jul 2, 2027 | 361 days | pending_review |
| good | Premier Plumbing & HVAC David Martinez · hello@blackflowcodeai.com Direct | general_liability | PENDING OCR | — | Jul 4, 2027 | 363 days | pending_review |
BREAKDOWN / BY CERT TYPE
What types are in the system.
| CERT TYPE | TOTAL | AT RISK | AVG DAYS REMAINING |
|---|---|---|---|
| General Liability | 30 | 25 | 12 |
| Workers Comp | 27 | 14 | 54 |
| Auto Liability | 4 | 4 | -16 |
| general_liability | 3 | 0 | 348 |
| professional | 3 | 0 | 179 |
Data normalization needed. cert_type appears in mixed casing (e.g. General Liability vs general_liability). Workflow 10 inserts snake_case while historical seed data is Title Case.
DISTRIBUTION / URGENCY BANDS
Certificates per urgency band.
expired
critical
warning
soon
good