/
/
Find projects where stage and contract values do not agree
For executives and finance leaders who want every project's stage and estimate checked against its prime contract and commitments, asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Portfolio numbers and contract numbers never meet
The portfolio view of stage and estimated value sits apart from prime contract and commitment figures. Nobody lines them up, so projects whose numbers disagree are found at year end.
Without PopdockAI
- Export the project list with stage and estimated value
- Look up the prime contract for each project
- Add up commitment invoices and payments
- Compare the lot in a spreadsheet and hope the names match
With PopdockAI
- Projects are read with stage and estimated value
- The prime contract and commitment totals are added for each
- No contract is shown as no contract, never as zero
- Near name matches are shown, never used silently
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 projects matching `{project-type}` (default: all types) that started on or after `{start-date-from}` (default: no limit), compare the stage and estimated value in Procore core with the prime contract and commitment totals in the financials server, and flag the ones that do not line up.
**Step 1: Read the projects (core server)**
Call `procore-get-projects` with `project-type` and `actual-start-date.from` when given. Keep `project-name`, `stage`, `active`, `estimated-value`, `total-value` and `actual-start-date`. If more than 30 projects come back, take the 30 with the largest `estimated-value` and say so.
**Step 2: Read the contract side (financials server)**
For each project call `procore-get-prime-contracts` with `project-name` and keep `revised-contract-amount`, `payments-received` and `status`. Call `procore-get-commitment-contracts-summary` with `project-name` and add up `approved-change-total`, `total-invoices-amount` and `total-payments-amount`.
**Step 3: Report**
A table per project: name, stage, estimated value, revised prime contract amount, difference, payments received, commitment invoices total, commitment payments total. Flag: a project with no prime contract, an active project whose stage is a closed or completed stage, a prime contract more than 20 percent away from the estimated value, and commitments paid above payments received. End with portfolio totals.
**Rules & Guidelines:**
* Tools named `procore-get-requisitions`, `procore-get-lien-waivers` and the other financial reads live on the Procore construction financials server (procore-construction-financials). Project, vendor, insurance, people and task tools live on the Procore core server (procore-core). Both servers must be connected; if a tool is missing, say which server is not connected and stop.
* Read-only. Do NOT call any create, update or delete tool on either server.
**Validation:**
* A project with no contract rows is shown as no contract, never as zero.
* If `estimated-value` is empty, skip the variance flag for that project and say it was skipped.
* If `project-name` matches no contract rows but a near match exists, show the near match and do not use it silently.Who it's for
One answer, three teams that use it
Executives
Check the portfolio before it is reported
See which projects have no contract, a wrong stage or an estimate far from the contract, before figures go to the board.
Which active projects have a prime contract more than 20 percent away from the estimated value?
Finance directors
Catch payments that run ahead
Find projects where commitments paid are above payments received, so cash exposure is raised early.
On which projects have we paid more on commitments than we have received?
Portfolio analysts
Keep stages honest
Spot active projects sitting at a completed stage or the reverse, so reporting by stage means what it says.
List active projects whose stage is a completed or closed stage.
How it works
What PopdockAI does when you ask
You ask for the review. Your AI assistant sets stage and estimate beside the prime contract and commitments for each project, and flags where they do not line up.
Ask
You give a project type and a start date, or leave both open.
Read
It reads each project's stage and estimated value, up to the thirty largest.
Compare
It reads the prime contract and commitment totals for each project and sets them side by side.
Report
You get a table per project, flags for the gaps and portfolio totals.
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
procore-get-prime-contracts
procore-get-commitment-contracts-summary
procore-get-requisitions
procore-get-lien-waivers
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
Disagreements found while they can still be fixed
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)
