Connectors

/

Procore

/

Reconcile Procore subcontractor payments with Rillet
Report
Cross-Connector

Check subcontractor payments in Procore against Rillet

For accounts payable teams who want Procore commitment payments compared with Rillet bill payments by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Procore subcontractor payments with Rillet
Reconcile the commitment payments on Riverside Tower with Rillet bill payments dated in the last 60 days.
Of 15 Riverside Tower payments, 12 match Rillet and 3 differ. - Fabrikam Concrete INV-0417: amount differs, Procore 22,050, Rillet 22,500 - Contoso Steel INV-0431: bill exists in Rillet but is unpaid - Northwind Plant INV-0440: date differs by 2 days, a warning only Want the Rillet payments with no Procore payment listed?
Procore
Sample figures. Your results come from your own account.
procore-get-contract-payments
rillet-get-bill-payments
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

Payments released in Procore are not checked in the ledger

Subcontractor payments are recorded in Procore and again in Rillet, and checked against each other by hand. A payment never posted, or posted for another amount, can sit unnoticed for weeks.

Without PopdockAI

  • Export commitment payments from Procore
  • Export bill payments from Rillet
  • Match them by invoice number and compare amounts and dates
  • Look up the bill for each payment that does not match

With PopdockAI

  • Payments are read from both systems and matched
  • Missing bills and unpaid bills are told apart
  • Small date gaps are warnings, not mismatches
  • Gaps are totalled and nothing is recorded

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}`, compare the commitment payments recorded in Procore with the bill payments posted in Rillet for payments dated on or after `{payment-date-from}` (default: the last 60 days), and report every payment that is missing, differs in amount or differs in date.

**Step 1: Read the Procore payments**

Call `procore-get-contract-payments` filtered by `project-name` and `payment-date.from`. Keep `payment-id`, `commitment-number`, `invoice-number`, `payment-date`, `payment-funded-date`, `amount`, `status` and `check-number`. If nothing comes back, say so and stop.

**Step 2: Read the Rillet payments**

Call `rillet-get-bill-payments` with `payment-date.from` set to `{payment-date-from}`. Match each Procore payment to a Rillet payment where the Rillet `expense-number` equals the Procore `invoice-number` (ignore case and spaces). When one invoice has several payments on either side, match them in date order and compare the sums as well.

For each unmatched Procore payment, call `rillet-get-bills` with `expense-number` set to the invoice number and report whether the bill exists but is unpaid, or the bill does not exist at all.

**Step 3: Report**

A table with one row per Procore payment: commitment number, invoice number, Procore amount and date, Rillet payment id, Rillet amount and date, difference, and a verdict (matched, amount differs, date differs, bill unpaid in Rillet, no bill in Rillet). Then list Rillet payments in the period with no Procore payment, labelled Rillet only. End with counts and the total value of the gaps.

**Rules & Guidelines:**

* `procore-get-contract-payments` is on the Procore server. `rillet-get-bill-payments` and `rillet-get-bills` are on the Rillet server.
* Read-only. Do not call `rillet-add-bill-payment`, `rillet-add-bill`, `rillet-update-bill` or any Procore create, update or delete tool.
* Compare Procore `payment-funded-date` to the Rillet `payment-date` when the funded date is present, otherwise compare `payment-date`. State which one you used.

**Validation:**

* If a Procore payment has no `invoice-number`, list it as unmatchable.
* A date difference of up to 3 days is a warning, not a mismatch.
* If the two systems use different currencies, report both amounts and do not convert.

Who it's for

One answer, three teams that use it

Accounts payable

Confirm payments reached the ledger

See which payments released in Procore have no matching payment in Rillet.

Which Procore payments on Northwind Plaza in the last 60 days are missing from Rillet?

Project accountants

Catch amount and date differences

Compare the amount and date on each payment between systems and see the difference.

Reconcile Riverside Tower subcontractor payments with Rillet and show amount differences.

Finance controllers

Total what is unreconciled

Get the value of missing and differing payments in one list before cash is reported.

Give me the total value of Procore payments for Contoso Warehouse that do not match Rillet.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant reads both systems. It states which date it compared and never records or changes a payment.

Ask

You name the project and, optionally, the payment date to start from.

Your AI tool

Read

It reads the commitment payments from Procore and the bill payments from Rillet.

procore-get-contract-payments
rillet-get-bill-payments
rillet-get-bills

Match

It matches by invoice number and checks unmatched payments for an unpaid or missing bill.

No items found.

Report

You get a verdict per payment, Rillet only payments, counts and the value of the gaps.

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-contract-payments

Returns Procore commitment (contract) payments with payment number, check number, amount and date. Filter by date range.
get-data

rillet-get-bill-payments

Returns payments made against vendor bills 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

Every released payment checked against the ledger

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