Connectors

/

Procore

/

Compare Procore project stage to contract values
Report

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.

Try PopdockAI free
Get a live demo
Compare Procore project stage to contract values
Compare stage and estimated value with prime contract and commitment totals for our active projects started since January.
30 projects checked, 7 do not line up with their contract figures. - No prime contract: 2 projects, Fabrikam Depot and Northwind Annex - Stage completed but still active: 1 project, Contoso Warehouse - Prime contract more than 20 percent from the estimate: 3 projects - Commitments paid exceed payments received: 1 project, Riverside Tower Want the full table with the portfolio totals?
Procore
Sample figures. Your results come from your own account.
procore-get-projects
procore-get-prime-contracts
procore-get-commitment-contracts-summary
procore-get-requisitions
procore-get-lien-waivers

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

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.

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

Your AI tool

Read

It reads each project's stage and estimated value, up to the thirty largest.

procore-get-projects
procore-get-prime-contracts
procore-get-commitment-contracts-summary
procore-get-requisitions
procore-get-lien-waivers

Compare

It reads the prime contract and commitment totals for each project and sets them side by side.

No items found.

Report

You get a table per project, flags for the gaps and portfolio totals.

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-projects

Returns the projects in Procore, with project number, name, stage, active flag and dates. Filter by name, number or status.
get-data

procore-get-prime-contracts

Returns Procore prime contracts with the owner, contract number, status and contract amounts. Filter by project or status.
get-data

procore-get-commitment-contracts-summary

Returns Procore commitment contract totals per project: original value, approved changes and revised value. Filter by project.
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

procore-get-lien-waivers

Returns lien waivers from Procore, with their status and the invoice or commitment they cover. Read-only.
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

Disagreements found while they can still be fixed

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