Skip to content
Workflow · Finance close · Opening soon

Certificate of insurance tracking

Export your certificate log from Excel and include the expiry dates for general liability, auto, and workers comp. Mammoth checks each row and sets the insurance status to Agree when expiry is more than 30 days away, Expiring soon when it is within 30 days, and Expired when it is past due.

Early access opens shortly. Check back soon.

Someone typed

“check the certificate log and show each subcontractor’s insurance status: Agrees when expiry is more than 30 days away, Expiring soon when it’s in the next 30 days, Expired if it’s already past due”

The agent read it as

check the Certificate log and show each subcontractor’s insurance status: Agrees when expiry is more than 30 days away, Expiring soon when it’s in the next 30 days, Expired if it’s already past due

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Certificate log
    CSV export · 30 rows
  2. Step
    Set insurance status
    Step 1
  3. Result
    Insurance expiry status
    30 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 30 rows came out.

What you get back

The result of that run, the rows to look at first.

Insurance expiry statusSample data30 rows
SubcontractorInsurance statusCoverage typeExpiry date
Blue Ridge Drywall Inc.ExpiredGeneral Liability2026-10-31
Delta Line Electric LLCExpiredGeneral Liability2026-11-11
Ironvale Roofing Co.ExpiredGeneral Liability2026-11-09
Apex Framing LLCExpiring soonAuto Liability2026-11-28
Blue Ridge Drywall Inc.Expiring soonWorkers Comp2026-12-05
Cedar Peak Plumbing Co.Expiring soonAuto Liability2026-11-19
Delta Line Electric LLCExpiring soonWorkers Comp2026-12-18
Evergreen Masonry GroupExpiring soonAuto Liability2026-11-25
Evergreen Masonry GroupExpiring soonWorkers Comp2026-12-02
Falcon Sitework Ltd.Expiring soonAuto Liability2026-11-20
Falcon Sitework Ltd.Expiring soonGeneral Liability2026-12-08
Granite Demo ServicesExpiring soonWorkers Comp2026-11-27
30 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Insurance expiry status workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Insurance expiry status: questions

How do you track subcontractor COI status from an Excel export?
Export your certificate log from Excel and include the expiry dates for general liability, auto, and workers comp. Mammoth checks each row and sets the insurance status to Agree when expiry is more than 30 days away, Expiring soon when it is within 30 days, and Expired when it is past due.
What file should you export for COI tracking?
Export the certificate log from Excel. Include one row per subcontractor and the expiry dates you want to check.
What happens to rows that do not match the rules?
Rows that do not meet the date rules are marked based on the values in the export. If a row is missing the needed expiry date, it cannot be classified from that field.
How do you change the status rules in words?
Edit the rule so expiry more than 30 days away becomes Agree, expiry within the next 30 days becomes Expiring soon, and dates already past become Expired.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →