Connectors

/

Procore

/

Reconcile Procore company entities and currency with Rillet
Report
Cross-Connector

Check Procore company setup against Rillet entities

For finance leads who want the Procore company, currency and offices compared with Rillet subsidiaries and bank accounts by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Procore company entities and currency with Rillet
Check that our Procore company and its offices line up with the entities, currencies and bank accounts in Rillet.
Northwind Construction matches a Rillet subsidiary, but 2 gaps need a look. - Company status: matched to Northwind Construction Ltd, a proposed name match - Currency: Procore shows USD, the Rillet subsidiary shows GBP, a mismatch - Offices: the Toronto office is in a country no subsidiary appears to cover Want the subsidiaries with no bank account in their currency listed?
Procore
Sample figures. Your results come from your own account.
procore-get-companies
procore-get-company-configuration
procore-get-offices
rillet-get-subsidiaries
rillet-get-bank-accounts

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

Entity mismatches only surface at consolidation

The construction company setup in Procore and the entities in Rillet are maintained separately, under different names. Currency differences and offices with no entity behind them stay hidden until consolidation.

Without PopdockAI

  • Read the company, currency and offices in Procore
  • List subsidiaries and bank accounts in Rillet
  • Compare names and currencies side by side
  • Work out which offices have no entity behind them

With PopdockAI

  • Both sides are read for you
  • Company, currency and office countries are compared
  • Subsidiaries with no matching bank account are listed
  • Name matches are labelled proposed and nothing is changed

The prompt

Use this prompt

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

Prompt
**Objective:** Check that the Procore company `{company-id}` and its offices line up with the legal entities, currencies and bank accounts in Rillet. Default to the first company Procore returns if no company id is given.

**Step 1: Read the Procore side**

Call `procore-get-companies` (Procore) filtered by id `{company-id}`; if empty, call it with no filter and use the first row. Record its `name`. Then call `procore-get-company-configuration` (Procore) for the same company and record `currency-iso-code`. Then call `procore-get-offices` (Procore) for the company and record each office's `name`, `city`, `state-code` and `country-code`.

**Step 2: Read the Rillet side**

Call `rillet-get-subsidiaries` (Rillet) and record each `trade-name`, `currency`, `timezone` and `subsidiary-id`. Then call `rillet-get-bank-accounts` (Rillet) and note each `bank-name`, `currency` and `subsidiary-id`.

**Step 3: Compare**

* Match the Procore company `name` to a Rillet `trade-name` (case-insensitive, ignoring Inc, LLC and punctuation). Report the match or "no subsidiary found".
* Compare `currency-iso-code` with the subsidiary `currency`. Flag a mismatch.
* Compare each office `country-code` with the countries implied by subsidiary currency and timezone. List offices in a country that no subsidiary appears to cover.
* List subsidiaries that have no bank account in their currency.

**Step 4: Report**

A table of Procore company, Rillet subsidiary, currency on each side, and a status of Match, Currency mismatch or No subsidiary. Under it, the uncovered offices and the subsidiaries without a matching bank account. Finish with the questions a finance lead should ask. Say clearly when a conclusion rests on a name match.

**Rules & Guidelines:**

* Tools whose names start with procore run on the procore-company-admin server; tools whose names start with rillet run on the rillet server. Both must be connected.
* Read-only. Do not call any write tool on either server, including `procore-create-office`, `procore-update-office`, `procore-delete-office`, `procore-update-role`, `procore-delete-role` on Procore and `rillet-add-vendor`, `rillet-update-vendor`, `rillet-add-customer`, `rillet-update-customer`, `rillet-add-bank-account`, `rillet-add-account` on Rillet.
* Procore is the construction system of record and Rillet is the accounting ledger. There is no shared id between them, so every match is made on names or codes and must be shown as a proposed match, never as a certainty.
* Do not use em dashes.

**Validation:**

* If `procore-get-company-configuration` returns no currency, report the currency as not set in Procore and skip the currency comparison.
* If `rillet-get-subsidiaries` returns nothing, report Rillet as having no entities and stop after Step 1.
* If a country cannot be inferred from the Rillet data, say so instead of guessing.

Who it's for

One answer, three teams that use it

Finance leads

Check entities before close

Confirm the Procore company, currency and offices have a Rillet entity and bank account behind them.

Compare Contoso Construction in Procore with the subsidiaries and bank accounts in Rillet.

Controllers

Catch currency mismatches

See where the currency on the Procore company differs from the Rillet subsidiary before it distorts reporting.

Does the currency on our Procore company match its Rillet subsidiary?

Treasury analysts

Find entities without bank accounts

Spot subsidiaries with no bank account in their currency alongside the offices they should serve.

Which Rillet subsidiaries have no bank account in their own currency, and which Procore offices do they cover?

How it works

What PopdockAI does when you ask

You name the company and your AI assistant reads the setup in Procore and Rillet. It stops if either side is empty and labels every match as proposed.

Ask

You name the Procore company, or use the first one Procore returns.

Your AI tool

Read

It reads the company, its currency and its offices in Procore, then the subsidiaries and bank accounts in Rillet.

procore-get-companies
procore-get-company-configuration
procore-get-offices
rillet-get-subsidiaries
rillet-get-bank-accounts

Compare

It matches the company to a subsidiary, compares currencies and checks office countries and bank accounts.

No items found.

Report

You get a status table, the uncovered offices and the questions to ask.

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

Returns the companies records from Procore, with an optional filter by company id. Read-only.
get-data

procore-get-company-configuration

Returns the Procore company configuration, including currency and timesheet settings such as rounding and week start.
get-data

procore-get-offices

Returns the offices set up in Procore, with address, city, state, country and phone. Used to compare company offices with other systems.
get-data

rillet-get-subsidiaries

Returns subsidiaries (trade name, type, currency, timezone) from Rillet.
get-data

rillet-get-bank-accounts

Returns bank accounts (bank name, currency, subsidiary) 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

Setup gaps found before consolidation

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