Connectors

/

Rillet

/

Flag Rillet bills from inactive Procore vendors
Report
Cross-Connector

Catch Rillet bills from vendors Procore has deactivated

For finance teams who want bills checked against inactive Procore vendors by asking their AI assistant.

Try PopdockAI free
Get a live demo
Flag Rillet bills from inactive Procore vendors
Which bills in Rillet from the last 90 days come from vendors we have made inactive in Procore?
4 bills from the last 90 days belong to 2 vendors that are inactive in Procore. - Contoso Scaffolding: 3 bills, matched by tax id, latest EXP-2310 - Fabrikam Plant Hire: 1 bill, matched by name only, so possible - No active Procore record exists under either name Want the full list with due dates and statuses?
Rillet
Sample figures. Your results come from your own account.
procore-get-vendors-inactive
rillet-get-bills
rillet-get-vendors
procore-get-vendors

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

Connect Rillet, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Deactivated vendors still send bills

A vendor is made inactive in Procore, but the ledger is not told and bills keep coming. The two vendor lists are rarely compared, so the bill is often paid before anyone notices.

Without PopdockAI

  • Export the inactive vendors from Procore
  • Pull recent bills and vendors from Rillet
  • Match names and tax ids in a spreadsheet
  • Miss the variants with a different suffix

With PopdockAI

  • Inactive vendors and recent bills are read for you
  • Matching uses tax id first, then name
  • Active records of the same name are ruled out
  • Weak matches are labelled and nothing is edited

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find bills dated on or after `{bill-date-from}` (default: the last 90 days) in Rillet whose vendor is inactive in Procore.

**Step 1: Read the inactive vendors (Procore)**

Call `procore-get-vendors-inactive`. Keep `id`, `name`, `business-id`, `parent-name` and `date-updated`. If none come back, say so and stop.

**Step 2: Read the Rillet bills**

Call `rillet-get-bills` with `bill-date.from` set to `{bill-date-from}`. Call `rillet-get-vendors` once and attach each vendor name, email and tax id to its bill.

**Step 3: Match across**

Match Rillet vendors to the inactive Procore vendors by tax id against `business-id`, then by name after dropping case, punctuation and suffixes such as LLC, Inc and Ltd. Keep only bills whose vendor matched. As a check, call `procore-get-vendors` with `name` set to the vendor name and drop the vendor if Procore also holds an active record of that name.

**Step 4: Report**

One row per bill: expense number, Rillet vendor, bill date, due date, status, the matched inactive Procore vendor and how you matched it. Group by vendor and end with counts and the vendors to review.

**Rules & Guidelines:**

* `procore-get-vendors-inactive` and `procore-get-vendors` are on the Procore server. `rillet-get-bills` and `rillet-get-vendors` are on the Rillet server.
* Read-only. Do not call `rillet-update-bill`, `rillet-add-bill-payment`, `procore-update-inactive-vendor` or any other create, update or delete tool.

**Validation:**

* A name-only match is possible, not confirmed; label it so.
* If no bills match an inactive vendor, say that rather than listing near misses.

Who it's for

One answer, three teams that use it

Accounts payable

Check bills before you pay them

See whether a bill in the queue comes from a vendor the project team has deactivated.

Flag any Rillet bills from the last 90 days where the vendor is inactive in Procore.

Finance controllers

Tighten vendor controls

Find where the vendor status in Procore and the ledger have drifted apart, vendor by vendor.

Which inactive Procore vendors have bills in Rillet since 1 February?

Procurement managers

Confirm a deactivation held

Check that a vendor you stopped using has not carried on billing.

Has Contoso Scaffolding billed us in Rillet since we made them inactive in Procore?

How it works

What PopdockAI does when you ask

You give a date range and your AI assistant compares the vendor lists across Procore and Rillet. Weak matches are labelled, and vendors and bills are never edited.

Ask

You give a start date, or use the last 90 days.

Your AI tool

Read

It reads the inactive vendors in Procore and the bills in Rillet since that date.

procore-get-vendors-inactive
rillet-get-bills
rillet-get-vendors
procore-get-vendors

Match

It matches vendors by tax id, then by name, and drops any that also have an active Procore record.

No items found.

Report

You get each bill with its match method, grouped by vendor with counts.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.

get-data

procore-get-vendors-inactive

Returns the vendors made inactive in the Procore company directory, with name, email, business ID and state.
get-data

rillet-get-bills

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

rillet-get-vendors

Returns vendors (name, contact, address, payment terms, 1099 status) from Rillet.
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.
Read only.Nothing in Rillet 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

Stop payment to vendors you deactivated

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