Connectors

/

Procore

/

Compare Procore bid board proposals with Rillet contracts
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Compare Procore bid board proposals with Rillet contracts
Compare the Procore bid board proposals for Northwind Traders with their contracts in Rillet, only for projects we have won.
2 of 3 Northwind Traders projects have a Rillet contract, and one differs from its proposal. - Riverside Tower: proposal 1,250,000, contract 1,200,000, difference 50,000 (Active) - Harbour Depot: proposal 480,000, contract 480,000, no difference (Active) - Westgate Fit-out: proposal 310,000, no contract in Rillet Want the contracts that match no project listed too?
Procore
Sample figures. Your results come from your own account.
procore-get-estimating-bid-board-projects
procore-get-estimating-bid-board-projects-proposals
rillet-get-customers
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

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.

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

Your AI tool

Find

It reads the customer's bid board projects and proposals in Procore and stops if the name matches more than one customer.

procore-get-estimating-bid-board-projects
procore-get-estimating-bid-board-projects-proposals
rillet-get-customers
rillet-get-contracts

Match

It finds the customer in Rillet and pairs each project with the contract carrying its name.

No items found.

Report

You get proposal total against contract value per project, with the difference and contract status.

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-estimating-bid-board-projects

Returns Procore Preconstruction bid board projects, with status and the assigned estimator.
get-data

procore-get-estimating-bid-board-projects-proposals

Returns the estimating proposals on Procore bid board projects, with their totals and status. Used to see how much work a customer has bid.
get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) from Rillet.
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 won project checked against its contract

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