Certificate of insurance tracking in one spreadsheet.
Upload your subcontractors' ACORD 25 certificates and get every policy as a row: insured, insurer, policy number, limits and expiration date. Your Google Sheet or Airtable base shows what has lapsed and what is due.
Days left on every subcontractor's cover.
ParserBee reads the expiration date of each policy from the certificate. Your sheet subtracts today and colours the row. Watch six weeks pass: Copperline Drywall turns amber at 30 days and Peak Roofing's workers comp lapses on 2 November.
| Subcontractor | Expires | Days left |
|---|---|---|
| Peak Roofing Co.Workers comp and EL | 2026-11-02 | Expired 8 days ago |
| Copperline DrywallGeneral liability | 2026-11-30 | 20 days left |
| Blue Mesa Plumbing Inc.General liability | 2026-12-15 | 35 days left |
| Summit Electric LLCWorkers comp and EL | 2027-01-01 | 52 days left |
| North Fork HVACGeneral liability | 2027-02-14 | 96 days left |
| Vista Concrete LLCGeneral liability | 2027-05-20 | 191 days left |
How do I keep a spreadsheet of subcontractor insurance certificates and expiry dates?
Keep one row per policy, not one per subcontractor, because the policies on one certificate often expire on different dates. Let ParserBee read each certificate into those rows, and let a formula in your sheet flag what has expired, what is due and which limits are too low.
Build the template once from one ACORD 25 with the AI template builder. Then drop a backlog of up to 100 certificates into Data Lab, or let Zapier, Make or n8n send each new one from your inbox.
- Insured, producer and certificate holder
- Every policy: type, insurer, number, dates and limits
- The ADDL INSD and SUBR WVD boxes, as Yes or No
- Dates as dates and limits as numbers, ready for formulas
certs@lakeshore-agency.example
B: Harborline Specialty Insurance
C: Front Range Casualty Co.
1180 Mesa Park Road, Denver, CO 80216
400 Quarry Road, Denver, CO 80205
| LTR | Type of insurance | ADDL INSD | SUBR WVD | Policy number | Eff | Exp | Limits |
|---|---|---|---|---|---|---|---|
| A | Commercial general liability | Y | Y | GL-4471208 | 03/01/2026 | 03/01/2027 | Each occurrence $1,000,000 |
| A | Automobile liability | Y | Y | CA-4471209 | 03/01/2026 | 03/01/2027 | Combined single $1,000,000 |
| B | Umbrella liability | Y | Y | UMB-220871 | 03/01/2026 | 03/01/2027 | Each occurrence $5,000,000 |
| C | Workers comp and EL | Y | WC-9918832 | 01/01/2026 | 01/01/2027 | E.L. each accident $1,000,000 |
What to extract from an ACORD 25 certificate.
Most US certificates use the ACORD 25 form, so the boxes are always in the same place, but every agency fills them in its own way. These are the fields worth a column. The 2025/12 edition adds a line saying the limits shown may only be what the certificate holder asked for.
Top of the form
- Certificate date
- Producer: the agent or broker, with contact
- Insured: the subcontractor or vendor
- Insurers A to F, with NAIC numbers
Coverages table
- Coverage type and insurer letter
- Policy number
- Policy effective and expiration dates
- ADDL INSD and SUBR WVD boxes
Limits
- GL: each occurrence, general aggregate, products
- Auto: combined single limit
- Umbrella or excess: occurrence and aggregate
- Employers' liability: each accident, disease
Bottom of the form
- Description of operations (project, endorsements)
- Certificate holder: your company
- Certificate and revision numbers
- Any ACORD 101 remarks page
Catch a $500,000 limit when the contract asks for $1,000,000.
Send the rows to a linked Google Sheet or Airtable base. Add a column with your required limit, and one formula marks every policy as expired, too low, expiring within 30 days, or OK.
- Keep a small table of required limits per trade or per project
- Filter by project, trade or insurer
- ParserBee does not send reminders: an Airtable automation or a Zapier step can email you or the subcontractor
=IF(C2<TODAY(),"Expired",IF(D2<E2,"Limit too low",IF(C2-TODAY()<=30,"Expiring","OK")))| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Subcontractor | Coverage | Expires | Limit | Required | Status |
| 2 | Peak Roofing Co. | Workers comp and EL | 2026-11-02 | 1,000,000 | 1,000,000 | Expired |
| 3 | Vista Concrete LLC | General liability | 2027-05-20 | 500,000 | 1,000,000 | Limit too low |
| 4 | Copperline Drywall | General liability | 2026-11-30 | 1,000,000 | 1,000,000 | Expiring |
| 5 | Blue Mesa Plumbing Inc. | General liability | 2026-12-15 | 1,000,000 | 1,000,000 | OK |
| 6 | Summit Electric LLC | General liability | 2027-03-01 | 1,000,000 | 1,000,000 | OK |
When a COI service or platform is worth the price.
ParserBee removes the typing from certificate of insurance tracking. It is not a COI tracking service or a compliance platform. Pick something else if one of these is your main need.
You want someone to chase vendors
Certificate of insurance tracking services request renewals, follow up with agents and fix deficiencies for you. ParserBee does none of that. It reads the certificates your team collects.
You need endorsements verified
The ACORD 25 says a statement on the certificate gives the holder no rights in place of the endorsement. ParserBee reads the ADDL INSD and SUBR WVD boxes; reviewing the endorsements is still your job or your broker's.
You want a vendor portal
Dedicated COI platforms give vendors an upload link, keep compliance dashboards and send reminders on their own. If you track hundreds of vendors across many projects, compare them first.
One certificate, usually one page credit.
An ACORD 25 is one page; an ACORD 101 remarks page adds one more. No per-vendor fee. See pricing.
Try it on 25 certificates
FreeNew accounts get 25 free pages. An ACORD 25 is usually one page, so that is about 25 certificates. No credit card.
200 subcontractors a year
$29 a monthStarter gives 250 pages a month: enough for every new and renewed certificate of a busy general contractor.
1,000 vendors and more
$99 a monthScale gives 1,500 pages a month, for property managers and contractors with large vendor lists.
Their invoices, purchase orders and policies too.
83 ready-made document parser templates across 16 industries, plus any document you build a template for.
Insurance policies
Policy number, insured, insurer, dates, premium and coverage.
Insurance policy data extraction →Insurance documents
Claims, policies and explanation of benefits forms.
Insurance document templates →Certificate of insurance tracking questions
What is certificate of insurance tracking?
It is keeping a current record of the insurance your subcontractors, vendors and tenants carry: who is insured, by which insurer, under which policy numbers, with what limits, and when each policy expires. A certificate of insurance (COI), usually an ACORD 25 form, is the proof. Tracking means collecting a new one when a policy renews and acting before cover lapses.
Is there a certificate of insurance log template with automation?
Use a sheet with one row per policy: subcontractor, coverage type, insurer, policy number, effective and expiration dates, limits, ADDL INSD, SUBR WVD and the date received. ParserBee fills those rows from each certificate, so nobody types them, and a formula such as =IF(C2<TODAY(),"Expired",IF(C2-TODAY()<=30,"Expiring","OK")) flags each row. Link the Parser Template to a Google Sheet or Airtable base and new certificates add rows on their own.
Can I track COI expiration dates automatically?
Reading them, yes: ParserBee reads every policy's expiration date from each certificate. Sending reminders is a separate step that ParserBee does not do itself. An Airtable automation, a Google Sheets add-on or a Zapier step can email you, or the subcontractor, when a date is 30 days away.
Can ParserBee extract data from ACORD 25 certificates?
Yes. There is no ready-made certificate of insurance template yet, so upload one ACORD 25 to the AI template builder and it proposes the fields in about 20 seconds: insured, producer, insurers, and a list of policies with coverage type, policy number, dates, limits and the ADDL INSD and SUBR WVD boxes. Check them, run the test, then use the same template for every certificate, from any agency.
Does it check additional insured and waiver of subrogation?
It reads what the certificate says: the Y or N in the ADDL INSD and SUBR WVD columns and the text in Description of Operations. It does not verify the endorsements. The ACORD 25 itself says a statement on the certificate does not give the holder rights in place of the endorsement, so ask for the endorsement pages and have them reviewed.
Does it compare limits to my contract requirements?
Your sheet does. ParserBee gives each limit as a number, so a column with your required limit and a formula such as =IF(D2<E2,"Limit too low","OK") shows every gap. Keep a small table of requirements per trade or per project and look it up.
Which ACORD 25 edition does it read?
Both the 2016/03 edition and the 2025/12 edition. The layout of the boxes is the same; the newer edition adds a line saying the limits shown may only be the amounts the certificate holder asked for. ParserBee reads the limits that are printed, so if you need the full policy limits, ask the agent.
Can it read certificates that arrive by email?
Is ParserBee a certificate of insurance tracking service?
No. ParserBee is software you run yourself: it reads certificates into your spreadsheet. A tracking service requests certificates from your vendors, follows up and reviews them for you. If that is what you need, compare the dedicated COI platforms and their full-service plans.
How much does it cost?
One page credit per page, and an ACORD 25 is usually one page. New accounts get 25 free pages, no credit card. Starter is $29 a month for 250 pages and Scale is $99 a month for 1,500. See pricing.
Is my data used to train AI?
No. Your documents are never used to train AI models, and files travel to ParserBee over an encrypted (HTTPS) connection.