/
/
Follow a Procore commitment through to the Rillet ledger
For project teams who want one commitment traced from contract value to Rillet bills and payments by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
One subcontract, many screens, two systems
To see where a commitment's money stands you open the contract, change orders, requisitions and payments in Procore, then the bills and payments in Rillet. The gap is hard to pin down.
Without PopdockAI
- Open the commitment and its change orders in Procore
- List its requisitions and payments
- Look up each invoice in Rillet bills and payments
- Add up both sides and compare
With PopdockAI
- The commitment is found and stops if ambiguous
- Invoices and payments are collected for you
- Each invoice is checked in Rillet bills and payments
- Unposted invoices are recorded without guessing a reason
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For commitment number `{commitment-number}` on project `{project-name}`, trace the money from the Procore contract through its invoices and payments to the Rillet ledger, and show where the two systems stop agreeing.
**Step 1: Find the commitment (Procore)**
Call `procore-get-purchase-order-contracts` filtered by `number` and `project-name`. If it returns nothing, call `procore-get-work-order-contracts` with the same filters. If both return something, or either returns more than one row, list the matches and stop. Keep `original-contract-amount`, `revised-contract-amount`, `invoiced`, `payments-issued` and `remaining-balance-outstanding`. Also call `procore-get-commitment-change-orders` with `number` and `project-name` to list approved and pending change orders for context.
**Step 2: Get its invoices and payments (Procore)**
Call `procore-get-contract-payments` with `commitment-number` and `project-name`, and `procore-get-requisitions` with `project-name`, keeping only requisitions for this commitment. Collect every invoice number.
**Step 3: Find them in the ledger (Rillet)**
For each invoice number call `rillet-get-bills` with `expense-number`, then `rillet-get-bill-payments` with the same `expense-number`. Add up the Rillet billed and paid amounts.
**Step 4: Report**
Four lines: contract value (original and revised), billed (Procore against Rillet), paid (Procore against Rillet), and balance remaining. Then a table by invoice number showing where each one is present or absent in Procore requisitions, Procore payments, Rillet bills and Rillet payments. Finish with a one-sentence reading of where the gap is.
**Rules & Guidelines:**
* `procore-get-purchase-order-contracts`, `procore-get-work-order-contracts`, `procore-get-commitment-change-orders`, `procore-get-contract-payments` and `procore-get-requisitions` are on the Procore server. `rillet-get-bills` and `rillet-get-bill-payments` are on the Rillet server.
* Read-only. Do not call `rillet-add-bill`, `rillet-add-bill-payment`, `rillet-update-bill` or any Procore create, update or delete tool.
**Validation:**
* If the commitment is not found in either Procore tool, say so and stop.
* If the commitment has no invoices, report the contract values and stop before calling Rillet.
* If an invoice has no bill in Rillet, record it as not posted, and do not infer a reason.Who it's for
One answer, three teams that use it
Project managers
See where a subcontract stands
Get contract, billed, paid and balance for one commitment, with the Rillet side next to the Procore side.
Trace commitment SC-021 on Northwind Plaza through to Rillet.
Project accountants
Find the invoice that did not post
See which invoices appear in Procore but not as bills or payments in Rillet.
For purchase order PO-0455 on Harbour Depot, which invoices are missing from Rillet?
Commercial managers
Check a subcontract before final account
Review contract value, change orders, billed and paid in one view before agreeing the final position.
Show the full spend trace for subcontract SC-009 on Contoso Warehouse, including change orders.
How it works
What PopdockAI does when you ask
You give the commitment and project and your AI assistant follows the money from Procore into Rillet. Nothing is changed in either system.
Ask
You give the commitment number and the project.
Find
It finds the one commitment in Procore, with its values and change orders, and stops if it is missing or ambiguous.
Trace
It collects the invoices and payments, then looks each one up as a bill and payment in Rillet.
Report
You get contract, billed, paid and balance lines, an invoice table and a reading of where the gap is.
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-purchase-order-contracts
procore-get-work-order-contracts
procore-get-commitment-change-orders
procore-get-contract-payments
procore-get-requisitions
rillet-get-bills
rillet-get-bill-payments
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
The gap in a commitment's spend, pinned down
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)
