/
/
Catch Rillet bills from vendors Procore has deactivated
For finance teams who want bills checked against inactive Procore vendors by asking their AI assistant.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Deactivated vendors still send bills
A vendor is made inactive in Procore, but the ledger is not told and bills keep coming. The two vendor lists are rarely compared, so the bill is often paid before anyone notices.
Without PopdockAI
- Export the inactive vendors from Procore
- Pull recent bills and vendors from Rillet
- Match names and tax ids in a spreadsheet
- Miss the variants with a different suffix
With PopdockAI
- Inactive vendors and recent bills are read for you
- Matching uses tax id first, then name
- Active records of the same name are ruled out
- Weak matches are labelled and nothing is edited
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find bills dated on or after `{bill-date-from}` (default: the last 90 days) in Rillet whose vendor is inactive in Procore.
**Step 1: Read the inactive vendors (Procore)**
Call `procore-get-vendors-inactive`. Keep `id`, `name`, `business-id`, `parent-name` and `date-updated`. If none come back, say so and stop.
**Step 2: Read the Rillet bills**
Call `rillet-get-bills` with `bill-date.from` set to `{bill-date-from}`. Call `rillet-get-vendors` once and attach each vendor name, email and tax id to its bill.
**Step 3: Match across**
Match Rillet vendors to the inactive Procore vendors by tax id against `business-id`, then by name after dropping case, punctuation and suffixes such as LLC, Inc and Ltd. Keep only bills whose vendor matched. As a check, call `procore-get-vendors` with `name` set to the vendor name and drop the vendor if Procore also holds an active record of that name.
**Step 4: Report**
One row per bill: expense number, Rillet vendor, bill date, due date, status, the matched inactive Procore vendor and how you matched it. Group by vendor and end with counts and the vendors to review.
**Rules & Guidelines:**
* `procore-get-vendors-inactive` and `procore-get-vendors` are on the Procore server. `rillet-get-bills` and `rillet-get-vendors` are on the Rillet server.
* Read-only. Do not call `rillet-update-bill`, `rillet-add-bill-payment`, `procore-update-inactive-vendor` or any other create, update or delete tool.
**Validation:**
* A name-only match is possible, not confirmed; label it so.
* If no bills match an inactive vendor, say that rather than listing near misses.Who it's for
One answer, three teams that use it
Accounts payable
Check bills before you pay them
See whether a bill in the queue comes from a vendor the project team has deactivated.
Flag any Rillet bills from the last 90 days where the vendor is inactive in Procore.
Finance controllers
Tighten vendor controls
Find where the vendor status in Procore and the ledger have drifted apart, vendor by vendor.
Which inactive Procore vendors have bills in Rillet since 1 February?
Procurement managers
Confirm a deactivation held
Check that a vendor you stopped using has not carried on billing.
Has Contoso Scaffolding billed us in Rillet since we made them inactive in Procore?
How it works
What PopdockAI does when you ask
You give a date range and your AI assistant compares the vendor lists across Procore and Rillet. Weak matches are labelled, and vendors and bills are never edited.
Ask
You give a start date, or use the last 90 days.
Read
It reads the inactive vendors in Procore and the bills in Rillet since that date.
Match
It matches vendors by tax id, then by name, and drops any that also have an active Procore record.
Report
You get each bill with its match method, grouped by vendor with counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
procore-get-vendors-inactive
rillet-get-bills
rillet-get-vendors
procore-get-vendors
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
Stop payment to vendors you deactivated
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)
