Connectors

/

Procore

/

Trace a Procore commitment's spend to Rillet
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Trace a Procore commitment's spend to Rillet
Trace subcontract SC-014 on Riverside Tower from the Procore contract through to Rillet and show where they stop agreeing.
SC-014 on Riverside Tower agrees on contract value but Rillet is behind on billing. - Contract: original 500,000, revised 540,000 after 2 approved change orders - Billed: Procore 360,000, Rillet 315,000 - Paid: Procore 300,000, Rillet 280,000 - Gap: invoice INV-0422 is in Procore but not posted in Rillet Want the full table by invoice number?
Procore
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Find

It finds the one commitment in Procore, with its values and change orders, and stops if it is missing or ambiguous.

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

Trace

It collects the invoices and payments, then looks each one up as a bill and payment in Rillet.

No items found.

Report

You get contract, billed, paid and balance lines, an invoice table and a reading of where the gap is.

Your AI tool

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.

get-data

procore-get-purchase-order-contracts

Returns Procore purchase order contracts with number, vendor, status and amounts.
get-data

procore-get-work-order-contracts

Returns subcontract (work order) commitments from Procore, with contract amounts, invoiced and paid. Read-only.
get-data

procore-get-commitment-change-orders

Returns change orders on Procore commitments, with status and amounts. Read-only.
get-data

procore-get-contract-payments

Returns Procore commitment (contract) payments with payment number, check number, amount and date. Filter by date range.
get-data

procore-get-requisitions

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) from Rillet.
get-data

rillet-get-bill-payments

Returns payments made against vendor bills from Rillet.
Read only.Nothing in Procore Changes

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.

How Popdock AI secures your data

The outcome

The gap in a commitment's spend, pinned down

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation