Connectors

/

Procore

/

Trace a Procore project number to the Rillet ledger
Report
Cross-Connector

Find every Rillet invoice and bill that references a project

For project and finance teams who want a Procore project number traced to Rillet invoices and bills by asking their AI assistant.

Try PopdockAI free
Get a live demo
Trace a Procore project number to the Rillet ledger
Find the Rillet invoices and bills that reference Procore project number 2024-118, from the start of the year.
Project 2024-118, Riverside Tower, has an accounting number of RT-118, and Rillet references it on 5 records. - Invoices: 2, INV-5501 and INV-5517, matched on the memo field - Bills: 3, EXP-2210, EXP-2231 and EXP-2240, matched on expense number - INV-5517 is a substring match, so it is a proposed link Want the totals and statuses for each record?
Procore
Sample figures. Your results come from your own account.
procore-get-generic-tools-generic-tool-items
rillet-get-invoices
rillet-get-bills

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

A project's ledger trail is searched for by hand

To find a project's invoices and bills you copy its accounting number from Procore and search Rillet yourself. References buried in memo or purchase order fields are easy to miss.

Without PopdockAI

  • Look up the project's accounting number in Procore
  • Copy it into Rillet searches for invoices
  • Repeat the search for bills
  • Miss references that sit in memo text

With PopdockAI

  • The accounting number is read from Procore for you
  • Invoices and bills are searched on that number
  • The match field is shown for every row
  • Substring matches are labelled proposed 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:** Take the Procore project number `{project-number}` and find any Rillet invoices or bills that reference the project, using its accounting project number. Search bills dated from `{from-date}` (default: the start of the current year).

**Step 1: Identify the project**

Call `procore-get-generic-tools-generic-tool-items` (Procore) with `project-number` set to `{project-number}` and `max-records` 1. Record `project-name`, `project-number` and `project-accounting-project-number`. If no row comes back, report that the project has no items or does not exist, and stop. If `project-accounting-project-number` is empty, report that the project has no accounting number to search on, and stop.

**Step 2: Search the ledger**

Call `rillet-get-invoices` (Rillet) and keep rows where `memo`, `purchase-order-number` or `invoice-number` contains the accounting project number or the project number. Call `rillet-get-bills` (Rillet) with `expense-number` set to the accounting project number and `bill-date.from` set to `{from-date}`. If that returns nothing, call it again with only `bill-date.from` and keep rows whose `expense-number` contains the accounting number.

**Step 3: Report**

The project identity, then two lists: invoices (invoice number, customer id, total, amount due, status) and bills (expense number, vendor id, bill date, status). State the match field used for each row. If both lists are empty, say that the ledger carries no reference to this project and suggest the accounting number may be recorded in a field these tools do not expose.

**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:**

* A substring match is a proposed link; say so.
* Do not infer costs or margin from the rows; report only what is returned.
* If `rillet-get-bills` fails or returns an unexpected format, report the invoice results alone and name the failure.

Who it's for

One answer, three teams that use it

Project accountants

Find a project's invoices and bills

See everything in Rillet that references your project number without searching field by field.

Trace Procore project number 2024-118 to Rillet invoices and bills this year.

Finance controllers

Check a project is coded consistently

See where references are recorded in the memo or purchase order rather than a standard field.

Which Rillet invoices mention project number 2023-045, and in which field?

Project managers

Confirm that billing exists for your project

Check the ledger holds invoices and bills for a project before a cost review.

Does Rillet have any bills or invoices for Procore project 2024-092 since 1 January?

How it works

What PopdockAI does when you ask

You give the project number and your AI assistant finds its accounting number and searches Rillet. Every match is tied to the field it came from.

Ask

You give the Procore project number and, optionally, a date to search bills from.

Your AI tool

Identify

It reads the project's name and accounting number in Procore and stops if either is missing.

procore-get-generic-tools-generic-tool-items
rillet-get-invoices
rillet-get-bills

Search

It searches Rillet invoices and bills for references to the accounting number or project number.

No items found.

Report

You get the invoices and bills found, with the field each one matched on.

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-generic-tools-generic-tool-items

Returns generic tool items from Procore, including project number and accounting project number, with filters such as project number. Read-only.
get-data

rillet-get-invoices

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

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) 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

A project's ledger trail in one search

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