Connectors

/

Procore

/

Check Procore insurance before paying Rillet bills
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Check Procore insurance before paying Rillet bills
List the open Rillet bills due in the next 30 days and flag any vendor whose insurance in Procore has expired or expires within 30 days.
18 open Rillet bills are due in the next 30 days, and 4 belong to vendors with insurance problems. - Expired: Fabrikam Concrete, bill due 12 December, policy ended 30 November - Expires within 30 days: Contoso Steel, policy ends 9 December - No insurance on file: Adventure Works Paving - Approximate vendor match: Northwind Elec, check before relying on it Want the full row for each of the 18 bills?
Procore
Sample figures. Your results come from your own account.
rillet-get-bills
rillet-get-vendors
procore-get-vendors-insurances

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It lists the unpaid Rillet bills due by then and attaches each vendor name.

rillet-get-bills
rillet-get-vendors
procore-get-vendors-insurances

Check

It reads each vendor's insurance in Procore and compares expiry with the due date.

No items found.

Report

You get a row per bill, expired first, with counts and the vendors to chase.

Your AI tool

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.

get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) from Rillet.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
get-data

procore-get-vendors-insurances

Returns the insurance policies recorded against Procore vendors, with policy type, effective and expiration dates and status.
Read only.Nothing in Procore Changes

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.

How Popdock AI secures your data

The outcome

No payment run released to a lapsed vendor

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation