/
/
Check vendor insurance before paying Rillet bills
For payables teams who ask their AI assistant which open Rillet bills belong to vendors with expired or expiring insurance in Procore.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Bills get approved without checking the vendor's cover
Insurance is recorded against vendors in Procore, but bills are approved in Rillet. Unless someone looks up each vendor first, a payment can go out to a vendor whose policy has already lapsed.
Without PopdockAI
- Export the open bills due soon from Rillet
- Look up each vendor's insurance in Procore
- Compare each policy's expiry with the due date
- Notice the lapse after payment
With PopdockAI
- Open bills due soon are read from Rillet with vendor names
- Each vendor's policies are read from Procore
- A policy ending before the due date counts as expired
- Approximate vendor matches are flagged, and no bill is paid or edited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List the open Rillet bills due on or before `{due-before}` (default: 30 days from today) and flag every one whose vendor has lapsed or expiring insurance in Procore (expiring within `{warning-days}` days, default 30).
**Step 1: Read the open bills (Rillet)**
Call `rillet-get-bills` with `due-date.to` set to `{due-before}`. Keep bills whose `status` shows they are unpaid and not voided. Keep `bill-id`, `expense-number`, `vendor-id`, `bill-date` and `due-date`. Then call `rillet-get-vendors` once and attach each vendor `name`. If there are no open bills, say so and stop.
**Step 2: Read the insurance (Procore)**
For each distinct vendor name, call `procore-get-vendors-insurances` with `vendor-name` set to that name. Keep `status`, `policy-number`, `effective-date` and `expiration-date`. If there are no results for an exact name, retry once with `vendor-name.contains` set to the first significant word and mark the match as approximate. If still nothing, mark the vendor as no insurance on file.
**Step 3: Report**
A table with one row per open bill: Rillet bill, vendor, due date, insurance verdict (valid, expires within the warning window, expired, none on file, approximate match) and the latest expiration date. Sort expired first. End with counts and the vendors to chase.
**Rules & Guidelines:**
* `rillet-get-bills` and `rillet-get-vendors` are on the Rillet server. `procore-get-vendors-insurances` is on the Procore server.
* Read-only. Do not call `rillet-add-bill-payment`, `rillet-update-bill`, `procore-create-vendor-insurance` or any other create, update or delete tool.
* A vendor with several policies is valid only if every required policy is current; report each policy.
**Validation:**
* A policy whose expiration date is before the bill due date counts as expired for that bill.
* If a vendor name is ambiguous in Procore, list the candidates and do not pick one.Who it's for
One answer, three teams that use it
Accounts payable
Check cover before a payment run
See which bills in the run belong to vendors with expired or expiring insurance, before approving them.
Which Rillet bills due this month belong to vendors with expired insurance in Procore?
Risk managers
Chase lapsing policies
Get the vendors whose policies expire inside your warning window, with the latest expiry date.
Which vendors with open Rillet bills have insurance expiring within 60 days in Procore?
Controllers
Review exceptions
See no-insurance and approximate matches separately, so each exception is dealt with deliberately.
List open Rillet bills due by 31 December where the vendor has no insurance on file in Procore.
How it works
What PopdockAI does when you ask
You give the due date and your AI assistant compares bills with insurance. It only reads, and it never pays or changes a bill.
Ask
You give the due date to check up to and how many days count as expiring.
Read
It lists the unpaid Rillet bills due by then and attaches each vendor name.
Check
It reads each vendor's insurance in Procore and compares expiry with the due date.
Report
You get a row per bill, expired first, with counts and the vendors to chase.
What PopdockAI provides
The tools behind the answer
Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.
rillet-get-bills
rillet-get-vendors
procore-get-vendors-insurances
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
No payment run released to a lapsed vendor
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
