/
/
Find Procore projects with no Rillet contract
For finance teams who want active Procore projects matched to Rillet contracts by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Project and contract values drift apart
Procore holds the project value and Rillet holds the contract value, usually checked from two exports. A project with no contract, or a changed value, goes unnoticed for months.
Without PopdockAI
- Export active projects from Procore
- Export contracts from Rillet
- Match them by number or name in a spreadsheet
- Miss the projects with no contract at all
With PopdockAI
- Active projects and contracts are read for you
- Projects are matched by number or name
- Both values are shown and several matches are listed
- Currency is 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 Procore projects at stage `{project-stage}` (default: all active projects), find the Rillet contract that represents each one and report missing contracts and value differences.
**Step 1: Read the projects (Procore)**
Call `procore-get-projects`. Keep projects where `active` is true, and where `stage` equals `{project-stage}` when given. Keep `project-id`, `project-name`, `number`, `stage`, `estimated-value`, `total-value` and `actual-start-date`. If none remain, say so and stop.
**Step 2: Read the contracts (Rillet)**
Call `rillet-get-contracts`. Keep `contract-id`, `name`, `customer-id`, `status`, `total-value`, `start-date` and `end-date`.
**Step 3: Match across**
Match a project to a contract when the contract `name` contains the project `number`, or equals the `project-name` ignoring case and punctuation. Where several contracts match, list them all. Compare Procore `total-value` (use `estimated-value` when `total-value` is empty and say so) with Rillet `total-value`.
**Step 4: Report**
A table with one row per project: project, number, stage, Procore value, Rillet contract, Rillet value, difference and verdict (matched, value differs, no contract, several contracts). Then list Rillet contracts that match no project. End with counts.
**Rules & Guidelines:**
* `procore-get-projects` is on the Procore server. `rillet-get-contracts` is on the Rillet server.
* Read-only. Do not call `rillet-record-contract-usage`, `rillet-add-invoice` or any create, update or delete tool.
**Validation:**
* If the two systems use different currencies, show both and do not convert.
* A difference under one currency unit is rounding.
* If either server returns nothing, state which one and stop.Who it's for
One answer, three teams that use it
Finance controllers
Find projects with no contract
See which active projects have no Rillet contract so the booking gap can be closed.
Which active Procore projects have no matching contract in Rillet?
Project controls
Catch value drift
Compare the project value you track with the contract value booked, project by project.
Show Procore project values against Rillet contract values for Pre-construction projects.
Revenue accountants
Spot contracts with no project
Find Rillet contracts that match no active project, which may be closed work or a naming difference.
List Rillet contracts that do not match any active Procore project.
How it works
What PopdockAI does when you ask
You choose a stage and your AI assistant reads both systems and pairs projects with contracts. Where several contracts match, all are listed.
Ask
You give a project stage, or leave it open for every active project.
Read
It reads the active projects in Procore and the contracts in Rillet.
Match
It matches by project number or name and lists every contract when several fit.
Report
You get each project's values, the difference and a verdict, then unmatched contracts.
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-projects
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 active project 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)
