Connectors

/

Procore

/

Compare Procore vendor site days with Rillet bills
Report
Cross-Connector

Check vendor bills against the days they were on site

For project teams who want Procore site logs compared with Rillet bills and service periods by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Procore vendor site days with Rillet bills
Compare Fabrikam Concrete's days on Riverside Tower in the last 60 days with what Rillet has billed for them.
Fabrikam Concrete was on site 11 days, and one bill covers days with no site presence. - Site days: 3 to 7 March and 10 to 14 March, plus 21 March - Bill EXP-2210: service period 3 to 14 March, unpaid - Bill EXP-2231: service period 24 to 28 March, no site days in that window Want the bills with no service period listed separately?
Procore
Sample figures. Your results come from your own account.
procore-get-manpower-logs
procore-get-equipment-logs
rillet-get-vendors
rillet-get-bills
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

Nobody checks bills against days actually on site

A vendor's presence is recorded in Procore logs while its bills and service periods sit in Rillet. Reading them side by side is slow, so billing for days with no site presence gets through.

Without PopdockAI

  • Read the manpower and equipment logs for the vendor
  • Write down the dates it was on site
  • Open the vendor's bills and service periods in Rillet
  • Compare the two lists date by date

With PopdockAI

  • Site days are collected from both Procore log types
  • Bills, lines and service periods are read from Rillet
  • Gaps and unpaid bills are flagged for you
  • Bills with no service period are listed apart, not called mismatches

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 vendor `{vendor-name}` on project `{project-name}`, compare the days it was on site between `{date-from}` and `{date-to}` (default: the last 60 days) with the bills Rillet holds for it in the same period.

**Step 1: Site presence in Procore**

These tools are on the procore-project-management server. Call `procore-get-manpower-logs` and `procore-get-equipment-logs` for `project-name` and the date window, and keep only rows whose `vendor-name` matches `{vendor-name}` (ignore case). Build the list of distinct dates on site. If the vendor does not appear, say so and stop.

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

These tools are on the rillet server. Call `rillet-get-vendors` and match `name` to `{vendor-name}`. If there is more than one candidate, list them and stop. If there is none, report the vendor as on site in Procore and absent from Rillet, then stop.

**Step 3: Bills in Rillet**

Take `vendor-id` from the match and call `rillet-get-bills` with it as `vendor-id` and the window as `bill-date.from` / `bill-date.to`. Then call `rillet-get-bill-lines` with the same `vendor-id` and dates to read line descriptions, `amount`, `service-period-start` and `service-period-end`.

**Step 4: Report**

Show the site dates, the bills (`expense-number`, `bill-date`, `status`, total of lines) and the service periods. Flag: bills whose service period has no site days, site days in the window that no bill service period covers, and bills still unpaid.

**Rules & Guidelines:**

* procore-get tools tools are procore-project-management; rillet-get tools tools are rillet.
* Read only. Do not call `rillet-add-bill`, `rillet-update-bill`, `rillet-add-bill-payment` or any `procore-create-*`, `procore-update-*` or `procore-delete-*` tool.

**Validation:**

* If there are no bills in the window, report site presence with nothing billed and say nothing is wrong yet.
* Rillet bills may use a different currency; show the `currency` from the lines and do not convert.
* A missing service period is not a mismatch; list those bills separately.

Who it's for

One answer, three teams that use it

Project managers

Verify a vendor's billing before approval

See which bills line up with the days the vendor worked and which cover periods with nobody on site.

Check Contoso Electrical's bills against their days on Northwind Plaza for the last 60 days.

Accounts payable

Query a bill with evidence

Back a query to a vendor with the exact site days in Procore against the service period on the bill.

For Fabrikam Concrete on Riverside Tower, show bills whose service period has no site days.

Site superintendents

Confirm your logs support the invoices

Check the days you recorded in manpower and equipment logs are the days a vendor is billing for.

Which days was Harbour Scaffolding on Harbour Depot in March, and does Rillet bill for any other days?

How it works

What PopdockAI does when you ask

You name the vendor and project and your AI assistant reads both systems. It stops if the vendor is ambiguous and changes nothing.

Ask

You name the vendor, the project and, optionally, the date range.

Your AI tool

Collect

It lists the distinct days the vendor appears in Procore manpower and equipment logs.

procore-get-manpower-logs
procore-get-equipment-logs
rillet-get-vendors
rillet-get-bills
rillet-get-bill-lines

Match

It finds the vendor in Rillet and reads its bills, lines and service periods.

No items found.

Report

You get the site dates, the bills and flags for gaps, unpaid bills and bills with no service period.

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-manpower-logs

Returns Procore manpower log entries from daily logs, including the vendor and workers on site. Filter by project and date.
get-data

procore-get-equipment-logs

Returns equipment log records from Procore: the equipment, vendor and days logged on a project. Filter by project and date range.
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-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

Bills checked against real days on site

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