Connectors

/

Procore

/

Match Procore programs to Rillet customers
Report
Cross-Connector

See what each Procore program owes in Rillet

For finance teams who want Procore programs matched to Rillet customers and their balances by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Procore programs to Rillet customers
Match our first 10 Procore programs to their Rillet customers and show who has overdue invoices.
8 of 10 programs matched a Rillet customer, 1 is ambiguous and 1 is not in Rillet. - Northwind Traders: 5 projects, overdue 42,000, other open 96,500 (proposed match) - Contoso Holdings: 2 projects, no overdue invoices, other open 30,000 - Fabrikam Group: ambiguous, 2 Rillet customers fit, none chosen Want the full table of all 10 programs?
Procore
Sample figures. Your results come from your own account.
procore-get-programs
rillet-get-customers
rillet-get-invoices
rillet-get-arr-waterfall

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

Programs and customers share no common key

Owners are programs in Procore and customers in Rillet, with no shared identifier. Matching them by name to see who owes what is slow and misses variants of the same name.

Without PopdockAI

  • List the programs in Procore
  • Search Rillet for a customer with a similar name
  • Pull each customer's invoices and total them
  • Lose time on names that almost match

With PopdockAI

  • Programs are read and matched to customers by name
  • Ambiguous matches are listed, never chosen
  • Overdue and open invoices are totalled per customer
  • Every match is labelled proposed and currencies stay separate

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 programs whose name contains `{program-name}` (default: all programs), check the first `{max-programs}` (default 10), find the matching Rillet customer and report its open invoices.

**Step 1: Read the programs**

Call `procore-get-programs` (Procore) with `name.contains` set to `{program-name}` when given, and `max-records` set to `{max-programs}`. Record each program's `name`, `address-freeform` and `project-count`. If nothing comes back, say so and stop.

**Step 2: Find the customer**

Call `rillet-get-customers` (Rillet) once. For each program, look for a customer whose `name` or `invoicing-name` matches the program name (case-insensitive, ignoring Inc, LLC and punctuation). When several customers fit, list them and mark the program Ambiguous. When none fit, mark it Not in Rillet and continue.

**Step 3: Pull the balance**

For each matched customer, call `rillet-get-invoices` (Rillet) once and keep rows whose `customer-id` equals the customer's `customer-id`. Total `amount-due` where `overdue` is true and where it is not. Optionally call `rillet-get-arr-waterfall` (Rillet) with `customer-id` for the same customer and report the latest `arr`.

**Step 4: Report**

A table of program, project count, matched Rillet customer, status (Matched, Ambiguous, Not in Rillet), overdue amount, other open amount and currency. End with the count of programs that have no customer record.

**Rules & Guidelines:**

* Tools whose names start with procore run on the procore-company-admin server; tools whose names start with rillet run on the rillet server. Both must be connected.
* Read-only. Do not call any write tool on either server, including `procore-create-office`, `procore-update-office`, `procore-delete-office`, `procore-update-role`, `procore-delete-role` on Procore and `rillet-add-vendor`, `rillet-update-vendor`, `rillet-add-customer`, `rillet-update-customer`, `rillet-add-bank-account`, `rillet-add-account` on Rillet.
* Procore is the construction system of record and Rillet is the accounting ledger. There is no shared id between them, so every match is made on names or codes and must be shown as a proposed match, never as a certainty.
* Do not use em dashes.

**Validation:**

* Never merge amounts across currencies; show one row per currency.
* If a program name matches a customer only loosely, label the match as proposed.
* If `rillet-get-invoices` returns no rows for a matched customer, report zero balance rather than an error.

Who it's for

One answer, three teams that use it

Credit controllers

Chase the right owner

See the overdue amount for each program's customer before you make the call.

For Procore programs containing Northwind, show their Rillet customers and overdue invoices.

Finance controllers

Find programs with no ledger record

Spot owners who exist as programs in Procore but not as customers in Rillet.

Which of our first 10 Procore programs are not in Rillet?

Portfolio managers

See exposure by owner

Understand the open balance behind each program alongside how many projects it has.

Show project counts and open invoice totals for the Contoso programs.

How it works

What PopdockAI does when you ask

You choose which programs to check and your AI assistant matches them to Rillet customers by name. Every match is shown as proposed and nothing is changed.

Ask

You give part of a program name, or leave it open, and a limit.

Your AI tool

Read

It reads the programs in Procore with their project counts.

procore-get-programs
rillet-get-customers
rillet-get-invoices
rillet-get-arr-waterfall

Match

It matches each program to a Rillet customer by name and marks it matched, ambiguous or not in Rillet.

No items found.

Total

It totals overdue and other open invoices per customer and reports one row per currency.

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

Returns programs records from Procore (name, address, project count), with an optional name filter. Read-only.
get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

rillet-get-arr-waterfall

Returns annual recurring revenue by customer and month 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

Each program tied to what it owes

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