Connectors

/

Procore

/

Trace a Procore vendor to Rillet spend
Report
Cross-Connector

See what a vendor has billed and been paid, with insurance

For project managers who want a Procore vendor traced into Rillet spend by asking their AI assistant.

Try PopdockAI free
Get a live demo
Trace a Procore vendor to Rillet spend
What has Fabrikam Concrete billed and been paid in Rillet over the last 12 months, and is their insurance current?
Fabrikam Concrete is active in Procore and has 61,200 outstanding in Rillet. - Procore: active, insurance expired 28 February - Bills: 9 totalling 244,800, 2 unpaid - Payments: 7 totalling 183,600, last on 6 March - Flag: bill EXP-2240 is dated after the insurance expired Want the charges and bill line breakdown by account?
Procore
Sample figures. Your results come from your own account.
procore-get-vendors
procore-get-vendors-insurances
rillet-get-vendors
rillet-get-bills
rillet-get-bill-payments
rillet-get-charges
rillet-get-bill-lines

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

A vendor's record and its spend live in two systems

To answer what a vendor has been paid you check Procore for the record and insurance and Rillet for the money. Putting the two together by hand is slow and risky bills are missed.

Without PopdockAI

  • Find the vendor and its insurance in Procore
  • Find the same vendor in Rillet
  • Pull bills, payments and charges for the period
  • Total them and check dates against insurance

With PopdockAI

  • The vendor is found in both systems for you
  • Bills, payments and charges are totalled
  • Insurance and inactive dates are checked against bills
  • Missing data is reported as absent, never as zero

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 the vendor named `{vendor-name}`, show the Procore record, any insurance, and everything Rillet holds for that vendor: bills, payments and charges since `{date-from}` (default: the last 12 months).

**Step 1: Find the vendor in Procore**

Call `procore-get-vendors` with `name.contains` set to `{vendor-name}`. If more than one vendor matches, list them and stop. Keep `vendor-id`, `name`, `email-address`, `business-id`, `active`. Then call `procore-get-vendors-insurances` with `vendor-name` set to the matched name and keep the policies.

**Step 2: Find the vendor in Rillet**

Call `rillet-get-vendors`. Pick the vendor whose tax id equals `business-id`, else whose email equals `email-address`, else whose name matches after dropping case and suffixes. If none match, report the vendor as present in Procore and absent from Rillet, and stop after Step 4's Procore section. If several match, list them and stop.

**Step 3: Pull the ledger activity (Rillet)**

With the Rillet `vendor-id`, call `rillet-get-bills` with `bill-date.from` set to `{date-from}`, `rillet-get-bill-payments` with `payment-date.from` set to `{date-from}`, and `rillet-get-charges` with `charge-date.from` set to `{date-from}`. Use `rillet-get-bill-lines` for the bills if a breakdown by account code is useful.

**Step 4: Report**

Sections: Procore profile (status, insurance dates); Rillet bills (count, total, unpaid); payments (count, total, last date); charges (count); and an outstanding balance (bills less payments). Flag any bill dated while the vendor was inactive or its insurance had expired.

**Rules & Guidelines:**

* `procore-get-vendors` and `procore-get-vendors-insurances` are on the Procore server. The Rillet tools named here are all on the Rillet server.
* Read-only. Do not call `rillet-add-bill`, `rillet-update-bill`, `rillet-add-bill-payment` or any create, update or delete tool.

**Validation:**

* If a Rillet tool returns nothing, say none were found rather than assuming zero.
* Report amounts per currency and do not convert.

Who it's for

One answer, three teams that use it

Project managers

Know what a vendor has been paid

Get bills, payments and the balance outstanding for a vendor without asking accounts for a report.

What has Contoso Electrical billed and been paid in Rillet in the last 12 months?

Risk managers

Check insurance against billing

See whether a vendor was billing while its insurance had expired or it was inactive.

For Fabrikam Plant Hire, flag any Rillet bills dated after their Procore insurance expired.

Accounts payable

Check a vendor before paying

See the vendor's Procore status and Rillet position together before releasing a payment.

Show Northwind Steel's Procore status, insurance and unpaid Rillet bills.

How it works

What PopdockAI does when you ask

You name the vendor and your AI assistant reads Procore and Rillet. It stops if the vendor is ambiguous and reports absence rather than assuming zero.

Ask

You name the vendor and, optionally, the date to look from.

Your AI tool

Find

It finds the vendor in Procore with its insurance, and stops if more than one vendor matches.

procore-get-vendors
procore-get-vendors-insurances
rillet-get-vendors
rillet-get-bills
rillet-get-bill-payments
rillet-get-charges
rillet-get-bill-lines

Pull

It finds the vendor in Rillet and reads its bills, payments and charges.

No items found.

Report

You get the profile, totals, outstanding balance and flags for inactive or uninsured dates.

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-vendors

Returns the vendors in the Procore company directory, with name, email, business ID, city, state and active flag. Filter by name, state or other vendor fields.
get-data

procore-get-vendors-insurances

Returns the insurance policies recorded against Procore vendors, with policy type, effective and expiration dates and status.
get-data

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
get-data

rillet-get-bills

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

rillet-get-bill-payments

Returns payments made against vendor bills from Rillet.
get-data

rillet-get-charges

Returns charges (vendor, date, status, subsidiary) from Rillet.
get-data

rillet-get-bill-lines

Returns vendor bill line items with account codes, amounts and service periods 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

Vendor spend and risk in one view

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