/
/
Find bid board customers missing from Rillet
For finance teams who want Procore bid board customers checked against Rillet customers by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Spelling hides customers missing from the ledger
Bid board customer names are compared with the Rillet customer list by eye. A small spelling difference hides a customer who was never set up, until the first invoice has nowhere to go.
Without PopdockAI
- Export the bid board and the Rillet customer list
- Sort both and compare names by eye
- Guess whether Northwind Trader is Northwind Traders
- Lose track of which missing customer matters most
With PopdockAI
- Both lists are read and matched for you
- Case, punctuation and endings are ignored
- Close matches are shown, never merged
- Missing customers are ranked by pipeline value
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For bid board projects with status `{status}` (default: every status), confirm each project's customer exists as a customer in Rillet and report the ones that do not.
**Step 1: Read the bid board (Procore Preconstruction server)**
Call `procore-get-estimating-bid-board-projects`, passing `status` as `{status}` when it is not empty. Keep `name`, `status`, `customer-company-name` and `stats-total` for each project. If nothing comes back, say so and stop.
**Step 2: Read the ledger customers (Rillet server)**
Call `rillet-get-customers`. It has no filters, so read the whole list and match locally.
**Step 3: Match by customer name**
Compare `customer-company-name` with the Rillet customer `name` and `invoicing-name`. Ignore case, punctuation and suffixes such as Inc, LLC and Ltd. Classify each distinct customer as exact match, close match (list the Rillet candidate), or missing from Rillet.
**Step 4: Report**
A table of distinct customers with: Procore customer name, number of projects, total of `stats-total`, Rillet `customer-id`, and the match class. List the missing customers first, largest `stats-total` first.
**Rules & Guidelines:**
* `procore-get-estimating-bid-board-projects` is on the Procore Preconstruction server; `rillet-get-customers` is on the Rillet server.
* This prompt is read-only. Do not call `rillet-add-customer`, `rillet-update-customer` or any Procore create, update or delete tool.
* Never merge two customers because their names are similar; report close matches and let the user decide.
**Validation:**
* If Rillet returns no customers, report that the Rillet side is empty and stop.
* If a project has no `customer-company-name`, list it under projects with no customer.Who it's for
One answer, three teams that use it
Accounts receivable
Set up customers before invoicing
See which bid board customers have no Rillet record so they can be created before the first invoice.
List the Procore bid board customers with won projects that are not in Rillet.
Finance controllers
Prioritise by pipeline
Start with the missing customers that carry the most pipeline value.
Which missing Rillet customers have the largest bid board pipeline?
Estimating managers
Check customer names are consistent
Find where a customer is spelled differently in Procore and the ledger so the names can be aligned.
Which Procore bid board customers are only a close match to a Rillet customer?
How it works
What PopdockAI does when you ask
You choose a status and your AI assistant reads Procore and Rillet. Close matches are shown for you to decide and nothing is merged or changed.
Ask
You give a bid board status, or leave it open for every status.
Read
It reads the bid board projects in Procore and the full customer list in Rillet.
Match
It compares names ignoring case, punctuation and endings and classes each as exact, close or missing.
Report
You get the customers table with missing ones first, largest pipeline first.
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-estimating-bid-board-projects
rillet-get-customers
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 bid board customer set up before it is needed
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)
