Connectors

/

Procore

/

Compare Procore project progress to Rillet invoicing
Report
Cross-Connector

See whether invoicing keeps pace with project progress

For project and finance teams who want Procore percent complete compared with Rillet invoicing by asking their AI assistant.

Try PopdockAI free
Get a live demo
Compare Procore project progress to Rillet invoicing
Is invoicing on Riverside Tower keeping up with progress? Count Rillet invoices from 1 January.
Invoicing on Riverside Tower is behind progress: 40% invoiced against 55% complete. - Procore: Active, Construction stage, 55% complete - Rillet contract: Riverside Tower Build, total value 2,000,000 - Invoiced to date: 800,000 across 3 invoices, 1 overdue Is Riverside Tower Build the right contract to compare against?
Procore
Sample figures. Your results come from your own account.
procore-get-workforce-planning-projects
rillet-get-contracts
rillet-get-invoices

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

Billing and progress are measured in different systems

Percent complete sits in Procore while invoices and contract values sit in Rillet. Tallying one against the other by hand means lagging or premature billing goes unseen.

Without PopdockAI

  • Look up the project's percent complete in Procore
  • Find its contract in the Rillet ledger
  • Add up the invoices dated in the period
  • Judge the gap by eye and hope the match was right

With PopdockAI

  • Percent complete and the invoices are read for you
  • The contract match is shown by name and number for you to confirm
  • A 10 point band decides ahead, behind or in line
  • Nothing is changed in either system

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 project matching `{project-name}` in Procore workforce planning, compare how far the project says it has progressed with how much has been invoiced against the matching Rillet contract, looking at invoices dated on or after `{invoice-date-from}` (default: the start of the current year).

**Step 1: Find the project (Procore resource management)**

Call `procore-get-workforce-planning-projects` with `name.contains` set to `{project-name}`. If more than one matches, list them (name, project number, status, stage) and stop. If none match, say so and stop. Keep `name`, `project-number`, `status`, `stage`, `bid-rate` and `percent-complete`.

**Step 2: Find the contract (Rillet)**

Call `rillet-get-contracts` with `name` set to the project name. If nothing matches, retry with the project number. Keep `contract-id`, `customer-id`, `status`, `start-date`, `end-date` and `total-value`. If no contract matches, report the project as present in Procore and absent from Rillet and stop.

**Step 3: Read the invoices (Rillet)**

Call `rillet-get-invoices` and keep the invoices whose `contract-id` equals the contract's id and whose `invoice-date` is on or after `{invoice-date-from}`. Sum `total` for the invoiced value and note any with `overdue` set.

**Step 4: Report**

The project line (stage, status, percent complete, bid rate) next to the contract line (customer, dates, total value, invoiced to date, percent invoiced). State whether invoicing is ahead of, behind or in line with percent complete, using a 10 point band as in line. List the invoices (number, date, total, status).

**Rules & Guidelines:**

* `procore-get-workforce-planning-projects` is on the Procore resource management server. `rillet-get-contracts` and `rillet-get-invoices` are on the Rillet server.
* Read-only. Do not call any Rillet `rillet-add-*`, `rillet-update-*`, `rillet-apply-*`, `rillet-unapply-*`, `rillet-record-*`, `rillet-set-*` or `rillet-setup-*` tool, and do not call any Procore create, update, delete, sync or bulk tool.

**Validation:**

* If `percent-complete` is empty, report the invoiced figures only and say progress is unknown.
* If the contract currency differs from the invoice currency, show both and do not convert.
* Matching a project to a contract is by name or number, so show both names and let the user confirm the match.

Who it's for

One answer, three teams that use it

Project managers

Check billing against progress

See whether the invoices raised match the work you report as complete, without asking accounts to run a report.

Is invoicing on Harbour Depot in line with its percent complete? Count invoices from the start of the year.

Finance controllers

Spot early or late billing

Find projects billed ahead of progress or lagging behind it, with the invoices that make up the total and any that are overdue.

Compare progress and invoicing for Westgate Fit-out and tell me if we are over or under billed.

Operations directors

Review a project at a glance

Get one line on stage, status, progress and invoiced value for a project before a review meeting.

Give me progress against invoicing for Contoso Warehouse, with the invoice list.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant reads Procore and Rillet. The name based contract match is shown so you can confirm it before relying on the verdict.

Ask

You name the project and, optionally, the date to count invoices from.

Your AI tool

Find

It reads the project's percent complete in Procore and stops if the name matches more than one project.

procore-get-workforce-planning-projects
rillet-get-contracts
rillet-get-invoices

Match

It finds the Rillet contract by name or number and shows both so you can confirm the link.

No items found.

Compare

It totals the invoices and says whether billing is ahead, behind or in line with progress.

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-workforce-planning-projects

Returns Procore Resource Management (workforce planning) projects with their number, name, status and stage. Filter by name and status.
get-data

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) 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

Know if billing is ahead of the work or behind it

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