/
/
Reconcile owner pay applications with Rillet receivables
For finance teams who want Procore owner billings and receipts checked against Rillet invoices and payments by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Owner billings are tracked twice and drift apart
Pay applications and receipts are recorded in Procore, and invoices and payments are recorded again in Rillet. Comparing them by hand is slow, so unbilled and unpaid items go unseen.
Without PopdockAI
- Export pay applications and receipts from Procore
- Export invoices and payments from Rillet
- Match them by invoice number in a spreadsheet
- Total each kind of gap by hand
With PopdockAI
- Pay applications and receipts are read for you
- Each is matched to a Rillet invoice and its payments
- Drafts are kept apart from real gaps
- Duplicate invoice numbers are listed, never chosen
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For project `{project-name}`, reconcile the owner pay applications in Procore with the customer invoices and invoice payments in Rillet, for billing dates on or after `{billing-date-from}` (default: the last 6 months).
**Step 1: Read the owner billings (Procore)**
Call `procore-get-prime-contracts-payment-applications` filtered by `project-name` and `billing-date.from`. Keep `invoice-number`, `billing-date`, `status`, `amount-this-period` and `amount-paid`. Then call `procore-get-nested-prime-contract-payments-received` filtered by `project-name` to get the payments received (`invoice-number`, `date`, `amount`, `check-number`). If there are no pay applications, say so and stop.
**Step 2: Read the receivables (Rillet)**
Call `rillet-get-invoices` (it has no filters, so filter the result yourself by `invoice-date`). Match each pay application to an invoice where Rillet `invoice-number` equals the Procore `invoice-number`; if none match, try Rillet `purchase-order-number`. Then call `rillet-get-invoice-payments` and total the payments for each matched invoice by `invoice-id`.
**Step 3: Report**
A table with one row per pay application: invoice number, billing date, Procore status, Procore amount this period, Rillet invoice id, Rillet total, Rillet amount due, Procore amount paid, Rillet payments total, and a verdict (matched, amount differs, not invoiced in Rillet, paid in Procore but not in Rillet, paid in Rillet but not in Procore). End with the total of each gap.
**Rules & Guidelines:**
* `procore-get-prime-contracts-payment-applications` and `procore-get-nested-prime-contract-payments-received` are on the Procore server. `rillet-get-invoices` and `rillet-get-invoice-payments` are on the Rillet server.
* Read-only. Do not call `rillet-add-invoice`, `rillet-add-invoice-payment`, `rillet-update-invoice`, `rillet-update-invoice-payment` or any Procore create, update or delete tool.
* Pay applications still in a draft status are not expected in Rillet. List them separately instead of flagging them.
**Validation:**
* If a Rillet invoice has a tax amount, compare the Procore amount to the invoice subtotal and to the total, and say which one agreed.
* If an invoice number appears twice in Rillet, list both and do not choose.
* If Rillet returns no invoices, state it and stop.Who it's for
One answer, three teams that use it
Accounts receivable
Find unbilled pay applications
See which approved pay applications never reached Rillet as invoices, with the value of each.
Which Riverside Tower pay applications are not invoiced in Rillet?
Finance controllers
Total the gaps by type
Get the value of mismatched, unbilled and unrecorded receipts in one list before close.
Reconcile Northwind Plaza owner billings with Rillet since 1 January and total each gap.
Project accountants
Check receipts are recorded in both places
Confirm payments received against a pay application appear in both Procore and Rillet.
For Contoso Warehouse, which owner payments are in Procore but not in Rillet?
How it works
What PopdockAI does when you ask
You name the project and your AI assistant reads Procore and Rillet and matches by invoice number. Nothing is changed in either system.
Ask
You name the project and, optionally, the billing date to start from.
Read
It reads the pay applications and payments received for the project in Procore.
Match
It matches each to a Rillet invoice by number and totals the payments recorded against it.
Report
You get a verdict per pay application and the total of each type of gap.
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-prime-contracts-payment-applications
procore-get-nested-prime-contract-payments-received
rillet-get-invoices
rillet-get-invoice-payments
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
Owner billing gaps found and totalled
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)
