/
/
Find requisitions missing from Rillet before month end
For accounts payable teams who want Procore subcontractor requisitions checked against Rillet bills by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Requisitions and bills are checked line by line in spreadsheets
Subcontractor requisitions sit in Procore and bills sit in Rillet, compared in spreadsheets. Invoices that were never posted or were keyed wrongly slip through to month end.
Without PopdockAI
- Export requisitions from Procore
- Export bills from Rillet
- Match invoice numbers and totals in a spreadsheet
- Chase the ones that do not line up
With PopdockAI
- Requisitions are read, with drafts and voids set aside
- Bills are matched by invoice number and totalled from lines
- Missing, differing and Rillet only bills are reported
- Unmatchable and duplicate numbers are listed, not guessed
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}`, reconcile Procore subcontractor requisitions against Rillet bills and report the ones that are missing from the ledger or carry a different amount. Only look at requisitions billed on or after `{billing-date-from}` (default: the last 90 days).
**Step 1: Read the requisitions (Procore)**
Call `procore-get-requisitions` filtered by `project-name` and `billing-date.from`. Keep `vendor-invoice-number`, `vendor`, `status`, `total-claimed-amount`, `current-payment-due` and `billing-date`. Ignore requisitions in a draft or void status, and say how many you ignored. If no requisitions come back, say so and stop.
**Step 2: Find the matching bills (Rillet)**
Call `rillet-get-bills` with `bill-date.from` set to the earliest billing date from Step 1. Match each requisition to a bill where the bill's `expense-number` equals the requisition's `vendor-invoice-number` (ignore case, spaces and leading zeros). Then call `rillet-get-bill-lines` with `expense-number` for each matched bill and add up the line `amount` values to get the bill total.
To check the vendor, call `rillet-get-vendors` once and compare the bill's `vendor-id` to the vendor whose `name` is closest to the Procore `vendor`. Treat a name difference as a warning, not a mismatch.
**Step 3: Report**
A table with one row per requisition: Procore invoice number, vendor, Procore total claimed, Procore payment due, Rillet bill id, Rillet bill total, difference, and a verdict (matched, amount differs, vendor differs, not in Rillet). Then list the Rillet bills in the same period that have no Procore requisition, labelled Rillet only. End with counts per verdict and the total value of the gaps.
**Rules & Guidelines:**
* `procore-get-requisitions` is on the Procore server. `rillet-get-bills`, `rillet-get-bill-lines` and `rillet-get-vendors` are on the Rillet server.
* Read-only. Do not call `rillet-add-bill`, `rillet-update-bill`, `rillet-add-vendor` or any Procore create, update or delete tool.
* Compare total claimed amount to the bill total, and say which of the two Procore amounts you used if the bill matches payment due instead. Rillet bills can be net of retainage.
**Validation:**
* If a requisition has no `vendor-invoice-number`, list it as unmatchable rather than guessing.
* If two bills share an expense number, list both and do not pick one.
* If either server returns no records for the period, state which one and stop.
* Treat a difference of less than one currency unit as rounding.Who it's for
One answer, three teams that use it
Accounts payable
Find invoices that were never posted
See requisitions with no bill in Rillet, so they can be posted before the period closes.
Which Northwind Plaza requisitions from the last 90 days have no bill in Rillet?
Project accountants
Catch mis-keyed amounts
Compare what the subcontractor claimed with what was booked, requisition by requisition.
On Riverside Tower, show requisitions where the Rillet bill total differs from the amount claimed.
Finance controllers
Close the month with fewer surprises
Get counts and the total value of each kind of gap in one pass before sign off.
Reconcile Contoso Warehouse requisitions with Rillet bills and give me the total value of the gaps.
How it works
What PopdockAI does when you ask
You name the project and your AI assistant reads Procore and Rillet and matches by invoice number. Nothing is changed in either system.
Ask
You name the project and, optionally, the billing date to start from.
Read
It reads the requisitions from Procore and ignores drafts and voids.
Match
It finds each bill in Rillet by invoice number, totals the lines and checks the vendor.
Report
You get a verdict per requisition, Rillet only bills, 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-requisitions
rillet-get-bills
rillet-get-bill-lines
rillet-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
Every requisition accounted for in 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)
