/
/
Check what a vendor billed against what was delivered
For finance teams who want a Procore materials order compared with Rillet bills by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Billed and delivered are tracked in two places
The order and its receipts live in Procore and the vendor's bills live in Rillet. Checking one against the other takes two systems, and bills ahead of or behind deliveries are easy to miss.
Without PopdockAI
- Open the purchase order and its receipts in Procore
- Note ordered, received and outstanding quantities
- Search Rillet for the vendor's bills
- Judge by eye whether billing matches deliveries
With PopdockAI
- The order is found and stops if several match
- Only posted receipts count as received
- Bills tied by vendor and date alone are labelled as such
- A clear verdict is given and nothing is changed
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 Procore materials purchase order matching `{purchase-order-name}`, compare what has been received on site with what the vendor has been billed in Rillet, and say whether the order is under-billed, over-billed or in line. Narrow to project `{project-name}` if given (optional).
**Step 1: Find the order (Procore resource management)**
Call `procore-get-materials-mgmt-purchase-orders` with `name.contains` set to `{purchase-order-name}` and, if a project was given, `project-name.contains` set to `{project-name}`. If more than one order matches, list them (name, project, vendor, status) and stop. If none match, say so and stop. Keep `name`, `vendor`, `project-name` and `status`.
**Step 2: Read what was ordered and received (Procore)**
Call `procore-get-materials-mgmt-purchase-orders-line-items` with `purchase-order-name` set to the order name. Keep `item-name`, `quantity-ordered`, `quantity-received`, `quantity-outstanding`. Call `procore-get-materials-mgmt-receipts` with `purchase-order-name` and keep each receipt's `name`, `status` and `date-posted`. Count only posted receipts as received.
**Step 3: Find the vendor's bills (Rillet)**
Call `rillet-get-vendors` once and match the order's `vendor` to a Rillet vendor `name` (ignore case, punctuation and endings such as Inc and LLC). Take its `vendor-id` and call `rillet-get-bills` with `vendor-id`. Keep the bills whose `expense-number` or lines mention the purchase order name; if none do, keep the vendor's bills dated on or after the earliest posted receipt and say the link is by vendor and date only. For each kept bill call `rillet-get-bill-lines` with `expense-number` and sum the line `amount` values.
**Step 4: Report**
First the order header: name, project, vendor, status, ordered, received and outstanding quantities. Then a table of receipts (name, date posted) and a table of bills (expense number, bill date, status, total). End with a verdict: nothing billed yet, billed less than received, in line, or bills exist but no receipts are posted. Procore quantities have no prices here, so do not compute a money difference; state this.
**Rules & Guidelines:**
* `procore-get-materials-mgmt-purchase-orders`, `procore-get-materials-mgmt-purchase-orders-line-items` and `procore-get-materials-mgmt-receipts` are on the Procore resource management server. `rillet-get-vendors`, `rillet-get-bills` and `rillet-get-bill-lines` are on the Rillet server.
* Read-only. Do not call any Rillet `rillet-add-*`, `rillet-update-*`, `rillet-apply-*`, `rillet-unapply-*`, `rillet-record-*`, `rillet-set-*` or `rillet-setup-*` tool, and do not call any Procore create, update, delete, sync or bulk tool.
**Validation:**
* If the vendor is not in Rillet, report the order as present in Procore and absent from Rillet and stop after Step 2.
* If a bill cannot be tied to the order by reference, label it as a vendor and date match and let the user confirm.
* If the two systems use different currencies, show both and do not convert.Who it's for
One answer, three teams that use it
Accounts payable
Check a bill against deliveries
See whether the vendor has billed ahead of what was received before you approve payment.
For PO-1187, has the vendor billed more than we have received?
Project managers
Confirm deliveries are being billed
Check that what arrived on site is turning into bills, order by order.
On Northwind Plaza, compare the concrete order with what Contoso Concrete has billed in Rillet.
Procurement managers
Review an order at close out
See ordered, received and outstanding quantities next to the vendor's billing for a final check.
Give me the receipts and Rillet bills for purchase order PO-0932 and say if it is in line.
How it works
What PopdockAI does when you ask
You name the order and your AI assistant reads Procore and Rillet. It stops if more than one order matches and labels any bill linked only by vendor and date.
Ask
You name the purchase order and, optionally, the project.
Find
It finds the one matching order in Procore and reads ordered and received quantities and posted receipts.
Match
It finds the vendor in Rillet and picks the bills that mention the order, or labels a vendor and date link.
Verdict
You get the receipts, the bills and whether the order is under billed, over billed or in line.
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-materials-mgmt-purchase-orders
procore-get-materials-mgmt-purchase-orders-line-items
procore-get-materials-mgmt-receipts
rillet-get-vendors
rillet-get-bills
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
A clear view of billed versus received
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)
