/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Collect
It lists the distinct days the vendor appears in Procore manpower and equipment logs.
Match
It finds the vendor in Rillet and reads its bills, lines and service periods.
Report
You get the site dates, the bills and flags for gaps, unpaid bills and bills with no service period.
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.
procore-get-manpower-logs
procore-get-equipment-logs
rillet-get-vendors
rillet-get-bills
rillet-get-bill-lines
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.
The outcome
Bills checked against real days on site
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.

.webp)
