Connectors

/

Procore

/

Reconcile Procore owner billings with Rillet receivables
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile Procore owner billings with Rillet receivables
Reconcile the owner pay applications on Riverside Tower with the invoices and payments in Rillet for the last 6 months.
Of 8 Riverside Tower pay applications, 5 match Rillet and 3 have gaps. - Pay app 6: amount differs, Procore 120,000, Rillet 118,500 - Pay app 7: not invoiced in Rillet, 95,000 - Pay app 4: paid in Procore, no payment in Rillet, 80,000 Want the draft pay applications listed separately?
Procore
Sample figures. Your results come from your own account.
procore-get-prime-contracts-payment-applications
procore-get-nested-prime-contract-payments-received
rillet-get-invoices
rillet-get-invoice-payments

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

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.

Prompt
**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.

Your AI tool

Read

It reads the pay applications and payments received for the project in Procore.

procore-get-prime-contracts-payment-applications
procore-get-nested-prime-contract-payments-received
rillet-get-invoices
rillet-get-invoice-payments

Match

It matches each to a Rillet invoice by number and totals the payments recorded against it.

No items found.

Report

You get a verdict per pay application and the total of each type of gap.

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-prime-contracts-payment-applications

Returns owner invoices (pay applications) by prime contract from Procore. Read-only.
get-data

procore-get-nested-prime-contract-payments-received

Returns the payments received against a Procore prime contract. Read-only.
get-data

rillet-get-invoices

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

rillet-get-invoice-payments

Returns payments received against customer invoices 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

Owner billing gaps found and totalled

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