Connectors

/

Procore

/

Match Procore projects to Rillet contracts
Report
Cross-Connector

Find Procore projects with no Rillet contract

For finance teams who want active Procore projects matched to Rillet contracts by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Procore projects to Rillet contracts
Match our active Procore projects at the Construction stage to contracts in Rillet and tell me where values differ.
6 Construction projects: 4 matched, 1 value differs and 1 has no contract. - Riverside Tower: Procore 2,000,000, Rillet 1,950,000, value differs by 50,000 - Harbour Depot: Procore 480,000, Rillet 480,000, matched - Westgate Fit-out: no Rillet contract found Want the Rillet contracts that match no project listed too?
Procore
Sample figures. Your results come from your own account.
procore-get-projects
rillet-get-contracts

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

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.

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

Your AI tool

Read

It reads the active projects in Procore and the contracts in Rillet.

procore-get-projects
rillet-get-contracts

Match

It matches by project number or name and lists every contract when several fit.

No items found.

Report

You get each project's values, the difference and a verdict, then unmatched contracts.

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

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) 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

Every active project accounted for in the ledger

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