Connectors

/

Procore

/

Reconcile Procore owner billing with Dynamics 365 Business Central sales invoices
Report
Cross-Connector

See where owner billing differs between systems

For finance teams who want Procore prime contracts compared with Business Central sales invoices, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Procore owner billing with Dynamics 365 Business Central sales invoices
Compare the owner billing on the Riverside Tower prime contract in Procore with the posted sales invoices in Business Central.
The Riverside Tower prime contract is under-billed in Business Central by 84,500.00. - Procore owner invoices: 1,240,000.00 - Business Central invoiced: 1,155,500.00 across 9 referenced invoices - Open balance in Business Central: 212,300.00 - Unreferenced: 2 invoices for Fabrikam Developments carry no contract or project reference Want the table for all contracts on the project?
Procore
Sample figures. Your results come from your own account.
procore-get-prime-contracts

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

Owner billing is tracked in one system and issued in another

Prime contracts live in Procore but the invoices are posted from Business Central. Comparing the totals by hand misses contracts that are under-billed and invoices that reference no contract.

Without PopdockAI

  • Export the prime contracts from Procore
  • Pull the posted sales invoices for each owner
  • Work out which invoice belongs to which contract
  • Total and compare each contract by hand

With PopdockAI

  • Prime contracts are read from Procore with owner invoices
  • Invoices attach to a contract only when they reference it
  • Differences and open balances are shown per contract
  • Unreferenced invoices are listed separately

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 Procore prime contracts on {project-name} (all projects if empty), compare the total invoiced to the owner with the posted sales invoices for the matching customer in Business Central, and say where billing is missing or different.

**Step 1: Read the prime contracts (procore-construction-financials server)**

Call `procore-get-prime-contracts`. If {project-name} is not empty, pass it as `project-name.contains`. Pass `max-records` of 100. Keep number, title, project-name, owner-client, status, revised-contract-amount, owner-invoices and payments-received.

**Step 2: Read the customer invoices (business-central server)**

For each distinct owner-client, call `business-central-get-posted-sales-invoice` with `sell-to-customer-name.contains` set to the owner-client and `max-records` of 200. If {from-date} is not empty, pass it as `posting-date.from`. Keep invoice-number, external-document-number, your-reference, total-amount, remaining-amount and posting-date. Stop after 20 customers and say how many were left unchecked.

**Step 3: Match across**

Attach an invoice to a prime contract when external-document-number or your-reference contains the prime contract number or the project name. Invoices for the customer that carry neither are Unreferenced; list them but do not assign them to a contract. Add up total-amount per contract and compare it with owner-invoices. If a customer name returns more than one customer in the results, say so rather than combining them.

**Step 4: Report**

Give a table with columns Project, Contract, Owner, Procore owner invoices, Business Central invoiced, Difference, Open balance in Business Central, Procore payments received, Status (Matched, Under-billed in Business Central, Over-billed in Business Central, No customer found). Then the Unreferenced invoices and counts of each status.

**Rules & Guidelines:**

* `procore-get-prime-contracts` is on the procore-construction-financials server; `business-central-get-posted-sales-invoice` is on the business-central server.
* This is read-only. Do not call any `procore-create-*`, `procore-update-*` or `procore-delete-*` tool, and do not call any `business-central-create-*` or `business-central-update-*` tool.
* Owner names rarely match exactly; show the name you matched on.

**Validation:**

* If `procore-get-prime-contracts` returns nothing, say so and stop.
* If a customer search returns nothing, mark the contract No customer found and continue.
* If owner-client is empty on a contract, list it under Cannot match.

Who it's for

One answer, three teams that use it

Accounts receivable

Find contracts you have under-billed

See which prime contracts have less invoiced in Business Central than Procore shows, so billing can catch up.

Which Procore prime contracts on Contoso Warehouse are under-billed compared with Business Central sales invoices?

Finance controllers

Review open balances per owner

Check what each owner still owes in Business Central beside the contract value and payments in Procore.

Show owner billing and open balances for all Fabrikam Developments prime contracts since 1 July.

Billing administrators

Clean up unreferenced invoices

List posted invoices that carry no contract number or project name, so they can be corrected at source.

Which posted sales invoices for Northwind Properties in Business Central do not reference a Procore prime contract?

How it works

What PopdockAI does when you ask

You name a project in plain words and your AI assistant reads the prime contracts, then the owner invoices in Business Central. It never assigns an invoice without a reference and only reads.

Ask

You name a project, or leave it blank for all, and optionally a from date.

Your AI tool

Read

It reads the Procore prime contracts with owner invoices and payments received.

procore-get-prime-contracts

Match

It finds posted sales invoices per owner and attaches them only when they reference the contract or project.

No items found.

Report

You get a table with differences and open balances, plus the unreferenced invoices.

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-prime-contracts

Returns Procore prime contracts with the owner, contract number, status and contract amounts. Filter by project or status.
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

Billing gaps found before the owner finds them

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