/
/
Spot won Procore work that Rillet never booked
For finance teams who want bid board proposal totals checked against Rillet contract values by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Won work and booked contracts drift apart unseen
Proposal totals live on the Procore bid board and contract values live in Rillet, and someone compares them by hand. Won work that was never booked, or booked at another value, is easy to miss.
Without PopdockAI
- Open each bid board project and note the proposal total
- Find the customer and contracts in Rillet
- Match projects to contracts by name in a spreadsheet
- Miss the project that was won but never booked
With PopdockAI
- Proposals are read for every project of the customer
- Each project is paired with the Rillet contract carrying its name
- Differences and statuses sit side by side in one table
- Currencies are never converted 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 customer `{customer-name}`, compare the proposal totals on their Procore bid board projects with the contracts held in Rillet, limited to projects with status `{status}` (default: every status).
**Step 1: Find the projects (Procore Preconstruction server)**
Call `procore-get-estimating-bid-board-projects` with `customer-company-name.contains` set to `{customer-name}`, and `status` set to `{status}` when it is not empty. If nothing matches, say so and stop. If the matches belong to more than one customer name, list the names and stop.
**Step 2: Read the proposals (Procore Preconstruction server)**
Call `procore-get-estimating-bid-board-projects-proposals` once per project, filtering on `bid-board-project-name`. Keep `name`, `type`, `total` and `bid-board-project-status`.
**Step 3: Find the customer and contracts (Rillet server)**
Call `rillet-get-customers` and find the customer whose `name` or `invoicing-name` matches `{customer-name}`. Take its `customer-id` and call `rillet-get-contracts` with `customer-id` set to it. If the customer is not in Rillet, report every proposal as unbooked and stop.
**Step 4: Compare**
Pair each project with the Rillet contract whose `name` contains the project name. Report proposal `total` against contract `total-value`, with the difference and the contract `status`.
**Step 5: Report**
A table with one row per project: project, status, proposal total, Rillet contract, contract total-value, difference. Then list projects with no contract and contracts with no project.
**Rules & Guidelines:**
* Procore tools are on the Procore Preconstruction server; Rillet tools are on the Rillet server.
* Read-only. Do not call `rillet-add-customer`, `rillet-update-customer`, `procore-update-bid-board-project` or any other create, update or delete tool.
* Only compare amounts in the same currency; if the Rillet `currency` differs from what the proposal implies, flag it and do not convert.
**Validation:**
* Several proposals on one project: list each one and compare against the latest by `date-updated`.
* A project name that matches more than one contract: list them all and do not pick one.Who it's for
One answer, three teams that use it
Finance controllers
Catch won work that was never booked
See which won projects have no contract in Rillet and which carry a different value, before month end rather than after.
Compare the Procore bid board proposals for Contoso with their Rillet contracts and tell me which projects have no contract.
Estimating managers
Confirm proposals became contracts
Check that the total you proposed is the value that was booked, project by project, with the difference shown.
For Fabrikam, show each won proposal total next to the Rillet contract value and the difference.
Revenue accountants
Find contracts with no project behind them
Spot Rillet contracts that match no bid board project, which can point to renamed projects or bookings made without a bid.
Which Rillet contracts for Northwind Traders do not match any Procore bid board project?
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant reads Procore and Rillet for you. It stops if the customer is ambiguous and never converts currencies.
Ask
You name the customer and, optionally, a bid board status.
Find
It reads the customer's bid board projects and proposals in Procore and stops if the name matches more than one customer.
Match
It finds the customer in Rillet and pairs each project with the contract carrying its name.
Report
You get proposal total against contract value per project, with the difference and contract status.
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-estimating-bid-board-projects
procore-get-estimating-bid-board-projects-proposals
rillet-get-customers
rillet-get-contracts
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 won project checked against its contract
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)
