/
/
See what a vendor has billed and been paid, with insurance
For project managers who want a Procore vendor traced into Rillet spend by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
A vendor's record and its spend live in two systems
To answer what a vendor has been paid you check Procore for the record and insurance and Rillet for the money. Putting the two together by hand is slow and risky bills are missed.
Without PopdockAI
- Find the vendor and its insurance in Procore
- Find the same vendor in Rillet
- Pull bills, payments and charges for the period
- Total them and check dates against insurance
With PopdockAI
- The vendor is found in both systems for you
- Bills, payments and charges are totalled
- Insurance and inactive dates are checked against bills
- Missing data is reported as absent, never as zero
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the vendor named `{vendor-name}`, show the Procore record, any insurance, and everything Rillet holds for that vendor: bills, payments and charges since `{date-from}` (default: the last 12 months).
**Step 1: Find the vendor in Procore**
Call `procore-get-vendors` with `name.contains` set to `{vendor-name}`. If more than one vendor matches, list them and stop. Keep `vendor-id`, `name`, `email-address`, `business-id`, `active`. Then call `procore-get-vendors-insurances` with `vendor-name` set to the matched name and keep the policies.
**Step 2: Find the vendor in Rillet**
Call `rillet-get-vendors`. Pick the vendor whose tax id equals `business-id`, else whose email equals `email-address`, else whose name matches after dropping case and suffixes. If none match, report the vendor as present in Procore and absent from Rillet, and stop after Step 4's Procore section. If several match, list them and stop.
**Step 3: Pull the ledger activity (Rillet)**
With the Rillet `vendor-id`, call `rillet-get-bills` with `bill-date.from` set to `{date-from}`, `rillet-get-bill-payments` with `payment-date.from` set to `{date-from}`, and `rillet-get-charges` with `charge-date.from` set to `{date-from}`. Use `rillet-get-bill-lines` for the bills if a breakdown by account code is useful.
**Step 4: Report**
Sections: Procore profile (status, insurance dates); Rillet bills (count, total, unpaid); payments (count, total, last date); charges (count); and an outstanding balance (bills less payments). Flag any bill dated while the vendor was inactive or its insurance had expired.
**Rules & Guidelines:**
* `procore-get-vendors` and `procore-get-vendors-insurances` are on the Procore server. The Rillet tools named here are all on the Rillet server.
* Read-only. Do not call `rillet-add-bill`, `rillet-update-bill`, `rillet-add-bill-payment` or any create, update or delete tool.
**Validation:**
* If a Rillet tool returns nothing, say none were found rather than assuming zero.
* Report amounts per currency and do not convert.Who it's for
One answer, three teams that use it
Project managers
Know what a vendor has been paid
Get bills, payments and the balance outstanding for a vendor without asking accounts for a report.
What has Contoso Electrical billed and been paid in Rillet in the last 12 months?
Risk managers
Check insurance against billing
See whether a vendor was billing while its insurance had expired or it was inactive.
For Fabrikam Plant Hire, flag any Rillet bills dated after their Procore insurance expired.
Accounts payable
Check a vendor before paying
See the vendor's Procore status and Rillet position together before releasing a payment.
Show Northwind Steel's Procore status, insurance and unpaid Rillet bills.
How it works
What PopdockAI does when you ask
You name the vendor and your AI assistant reads Procore and Rillet. It stops if the vendor is ambiguous and reports absence rather than assuming zero.
Ask
You name the vendor and, optionally, the date to look from.
Find
It finds the vendor in Procore with its insurance, and stops if more than one vendor matches.
Pull
It finds the vendor in Rillet and reads its bills, payments and charges.
Report
You get the profile, totals, outstanding balance and flags for inactive or uninsured dates.
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.
procore-get-vendors
procore-get-vendors-insurances
rillet-get-vendors
rillet-get-bills
rillet-get-bill-payments
rillet-get-charges
rillet-get-bill-lines
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
Vendor spend and risk in one view
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)
