/
/
Check subcontractor payments in Procore against Rillet
For accounts payable teams who want Procore commitment payments compared with Rillet bill payments by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Payments released in Procore are not checked in the ledger
Subcontractor payments are recorded in Procore and again in Rillet, and checked against each other by hand. A payment never posted, or posted for another amount, can sit unnoticed for weeks.
Without PopdockAI
- Export commitment payments from Procore
- Export bill payments from Rillet
- Match them by invoice number and compare amounts and dates
- Look up the bill for each payment that does not match
With PopdockAI
- Payments are read from both systems and matched
- Missing bills and unpaid bills are told apart
- Small date gaps are warnings, not mismatches
- Gaps are totalled and nothing is recorded
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For project `{project-name}`, compare the commitment payments recorded in Procore with the bill payments posted in Rillet for payments dated on or after `{payment-date-from}` (default: the last 60 days), and report every payment that is missing, differs in amount or differs in date.
**Step 1: Read the Procore payments**
Call `procore-get-contract-payments` filtered by `project-name` and `payment-date.from`. Keep `payment-id`, `commitment-number`, `invoice-number`, `payment-date`, `payment-funded-date`, `amount`, `status` and `check-number`. If nothing comes back, say so and stop.
**Step 2: Read the Rillet payments**
Call `rillet-get-bill-payments` with `payment-date.from` set to `{payment-date-from}`. Match each Procore payment to a Rillet payment where the Rillet `expense-number` equals the Procore `invoice-number` (ignore case and spaces). When one invoice has several payments on either side, match them in date order and compare the sums as well.
For each unmatched Procore payment, call `rillet-get-bills` with `expense-number` set to the invoice number and report whether the bill exists but is unpaid, or the bill does not exist at all.
**Step 3: Report**
A table with one row per Procore payment: commitment number, invoice number, Procore amount and date, Rillet payment id, Rillet amount and date, difference, and a verdict (matched, amount differs, date differs, bill unpaid in Rillet, no bill in Rillet). Then list Rillet payments in the period with no Procore payment, labelled Rillet only. End with counts and the total value of the gaps.
**Rules & Guidelines:**
* `procore-get-contract-payments` is on the Procore server. `rillet-get-bill-payments` and `rillet-get-bills` are on the Rillet server.
* Read-only. Do not call `rillet-add-bill-payment`, `rillet-add-bill`, `rillet-update-bill` or any Procore create, update or delete tool.
* Compare Procore `payment-funded-date` to the Rillet `payment-date` when the funded date is present, otherwise compare `payment-date`. State which one you used.
**Validation:**
* If a Procore payment has no `invoice-number`, list it as unmatchable.
* A date difference of up to 3 days is a warning, not a mismatch.
* If the two systems use different currencies, report both amounts and do not convert.Who it's for
One answer, three teams that use it
Accounts payable
Confirm payments reached the ledger
See which payments released in Procore have no matching payment in Rillet.
Which Procore payments on Northwind Plaza in the last 60 days are missing from Rillet?
Project accountants
Catch amount and date differences
Compare the amount and date on each payment between systems and see the difference.
Reconcile Riverside Tower subcontractor payments with Rillet and show amount differences.
Finance controllers
Total what is unreconciled
Get the value of missing and differing payments in one list before cash is reported.
Give me the total value of Procore payments for Contoso Warehouse that do not match Rillet.
How it works
What PopdockAI does when you ask
You name the project and your AI assistant reads both systems. It states which date it compared and never records or changes a payment.
Ask
You name the project and, optionally, the payment date to start from.
Read
It reads the commitment payments from Procore and the bill payments from Rillet.
Match
It matches by invoice number and checks unmatched payments for an unpaid or missing bill.
Report
You get a verdict per payment, Rillet only payments, counts and the value of the gaps.
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-contract-payments
rillet-get-bill-payments
rillet-get-bills
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
Every released payment checked against the ledger
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)
