Connectors

/

Procore

/

Reconcile Procore requisitions with Rillet bills
Report
Cross-Connector

Find requisitions missing from Rillet before month end

For accounts payable teams who want Procore subcontractor requisitions checked against Rillet bills by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Procore requisitions with Rillet bills
Reconcile the Procore requisitions on Riverside Tower with Rillet bills, billed in the last 90 days.
Of 12 Riverside Tower requisitions, 9 match Rillet and 3 need attention. - INV-0417: amount differs, claimed 24,500, Rillet bill 22,050 - INV-0422: not in Rillet, Fabrikam Concrete, 18,300 - INV-0430: vendor differs, billed under Contoso Steel Ltd Want the Rillet only bills for the same period?
Procore
Sample figures. Your results come from your own account.
procore-get-requisitions
rillet-get-bills
rillet-get-bill-lines
rillet-get-vendors

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

Requisitions and bills are checked line by line in spreadsheets

Subcontractor requisitions sit in Procore and bills sit in Rillet, compared in spreadsheets. Invoices that were never posted or were keyed wrongly slip through to month end.

Without PopdockAI

  • Export requisitions from Procore
  • Export bills from Rillet
  • Match invoice numbers and totals in a spreadsheet
  • Chase the ones that do not line up

With PopdockAI

  • Requisitions are read, with drafts and voids set aside
  • Bills are matched by invoice number and totalled from lines
  • Missing, differing and Rillet only bills are reported
  • Unmatchable and duplicate numbers are listed, not guessed

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 Procore subcontractor requisitions against Rillet bills and report the ones that are missing from the ledger or carry a different amount. Only look at requisitions billed on or after `{billing-date-from}` (default: the last 90 days).

**Step 1: Read the requisitions (Procore)**

Call `procore-get-requisitions` filtered by `project-name` and `billing-date.from`. Keep `vendor-invoice-number`, `vendor`, `status`, `total-claimed-amount`, `current-payment-due` and `billing-date`. Ignore requisitions in a draft or void status, and say how many you ignored. If no requisitions come back, say so and stop.

**Step 2: Find the matching bills (Rillet)**

Call `rillet-get-bills` with `bill-date.from` set to the earliest billing date from Step 1. Match each requisition to a bill where the bill's `expense-number` equals the requisition's `vendor-invoice-number` (ignore case, spaces and leading zeros). Then call `rillet-get-bill-lines` with `expense-number` for each matched bill and add up the line `amount` values to get the bill total.

To check the vendor, call `rillet-get-vendors` once and compare the bill's `vendor-id` to the vendor whose `name` is closest to the Procore `vendor`. Treat a name difference as a warning, not a mismatch.

**Step 3: Report**

A table with one row per requisition: Procore invoice number, vendor, Procore total claimed, Procore payment due, Rillet bill id, Rillet bill total, difference, and a verdict (matched, amount differs, vendor differs, not in Rillet). Then list the Rillet bills in the same period that have no Procore requisition, labelled Rillet only. End with counts per verdict and the total value of the gaps.

**Rules & Guidelines:**

* `procore-get-requisitions` is on the Procore server. `rillet-get-bills`, `rillet-get-bill-lines` and `rillet-get-vendors` are on the Rillet server.
* Read-only. Do not call `rillet-add-bill`, `rillet-update-bill`, `rillet-add-vendor` or any Procore create, update or delete tool.
* Compare total claimed amount to the bill total, and say which of the two Procore amounts you used if the bill matches payment due instead. Rillet bills can be net of retainage.

**Validation:**

* If a requisition has no `vendor-invoice-number`, list it as unmatchable rather than guessing.
* If two bills share an expense number, list both and do not pick one.
* If either server returns no records for the period, state which one and stop.
* Treat a difference of less than one currency unit as rounding.

Who it's for

One answer, three teams that use it

Accounts payable

Find invoices that were never posted

See requisitions with no bill in Rillet, so they can be posted before the period closes.

Which Northwind Plaza requisitions from the last 90 days have no bill in Rillet?

Project accountants

Catch mis-keyed amounts

Compare what the subcontractor claimed with what was booked, requisition by requisition.

On Riverside Tower, show requisitions where the Rillet bill total differs from the amount claimed.

Finance controllers

Close the month with fewer surprises

Get counts and the total value of each kind of gap in one pass before sign off.

Reconcile Contoso Warehouse requisitions with Rillet bills and give me the total value of the gaps.

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 requisitions from Procore and ignores drafts and voids.

procore-get-requisitions
rillet-get-bills
rillet-get-bill-lines
rillet-get-vendors

Match

It finds each bill in Rillet by invoice number, totals the lines and checks the vendor.

No items found.

Report

You get a verdict per requisition, Rillet only bills, 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-requisitions

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
get-data

rillet-get-bills

Returns vendor bills (expense number, vendor, dates, status) from Rillet.
get-data

rillet-get-bill-lines

Returns vendor bill line items with account codes, amounts and service periods from Rillet.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 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 requisition accounted for in 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