/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Identify
It reads the project's name and accounting number in Procore and stops if either is missing.
Search
It searches Rillet invoices and bills for references to the accounting number or project number.
Report
You get the invoices and bills found, with the field each one matched on.
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-generic-tools-generic-tool-items
rillet-get-invoices
rillet-get-bills
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
A project's ledger trail in one search
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)
