Connectors

/

Procore

/

Reconcile Procore projects with Intacct projects
Report
Cross-Connector

Find Procore projects with no matching Intacct project

For finance teams who want Procore projects checked against Intacct projects by accounting number, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Reconcile Procore projects with Intacct projects
Check the Procore projects with open work items against Intacct and tell me which have no Intacct project or a closed one.
Of 25 Procore projects checked, 20 match an Intacct project by id, 3 have no Intacct project and 2 are closed in Intacct with open Procore items. - No accounting number: Fabrikam Depot Phase 2 - No Intacct project: 2026-114 Northwind Plaza, 2026-121, 2026-130 - Closed in Intacct, open in Procore: Contoso Warehouse, Riverside Tower Fit-out - Name-only match: Harbour Annex, reported as a conflict Shall I show the full table of 25?
Procore
Sample figures. Your results come from your own account.
procore-get-correspondence-type-items
procore-get-generic-tools-generic-tool-items
sage-intacct-get-project

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

Missing Intacct projects surface when a bill will not post

The Procore project list and the Intacct project list are compared by eye. A project whose accounting number never reached Intacct is found only when a bill fails to post.

Without PopdockAI

  • List the Procore projects that have work items
  • Find each accounting project number
  • Search Intacct for each number one at a time
  • Spot closed projects that still have open work

With PopdockAI

  • Projects and accounting numbers are collected in one read
  • Each number is matched to Intacct on exact id first
  • Name-only matches are flagged as conflicts, not counted
  • Missing numbers, missing projects and status clashes are grouped

The prompt

Use this prompt

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

Prompt
**Objective:** Reconcile the Procore projects that have work items against the Intacct project list, for `{project-number}` or, if it is empty, for up to 25 projects found in Procore. Only Intacct projects with status `{intacct-status}` are treated as a match if it is given.

**Servers:** this prompt uses tools from two servers, so both procore-company-admin (Procore) and intacct (Intacct) must be connected. Tools whose names start with procore are on procore-company-admin; tools whose names start with intacct are on intacct.

**Step 1: Collect Procore projects and their accounting numbers**

Call `procore-get-correspondence-type-items` (Procore), filtered by `project-number` if `{project-number}` is given, with `max-records` 200. Then call `procore-get-generic-tools-generic-tool-items` (Procore) the same way. From both results collect the distinct combinations of project number, project name and project accounting project number. Stop after 25 distinct projects.

**Step 2: Look each one up in Intacct**

For each project with a non-empty accounting project number, call `intacct-get-project` (Intacct) with that value as `project-id`. If nothing comes back, retry once with the Procore project name as `project-name`, and mark the match as "by name only".

**Step 3: Report**

Give a table with one row per Procore project: Procore project number, Procore name, accounting project number, Intacct project id, Intacct project name, Intacct project status, match type (id, name only, none). Then list three groups: projects with no accounting number in Procore, projects with an accounting number that has no Intacct project, and projects whose Intacct status is closed or inactive while Procore still has open items.

**Rules & Guidelines:**

* This prompt is read-only. Never call any Procore tool that creates, updates or deletes, or `intacct-create-project`, `intacct-update-project` or any other Intacct tool that creates or updates.
* Treat project ids as text and compare them after trimming spaces and ignoring case. Do not guess a match.

**Validation:**

* If Procore returns no items, say so and stop; there is nothing to reconcile.
* If a name-only match disagrees with the accounting number, report it as a conflict and do not count it as matched.
* If one side is unavailable, report that server as not connected and stop.

Who it's for

One answer, three teams that use it

Accounts payable

Stop bills failing to post

Find the Procore projects that have no Intacct project before a vendor bill cannot be coded to them.

Which Procore projects with open items have no matching Intacct project?

Project controllers

Align project status

See where Intacct shows a project closed while Procore still has open work, and decide which side is right.

Show me projects that are closed in Intacct but still have open items in Procore.

Finance systems analysts

Audit accounting numbers

Check that every Procore project carries an accounting number that resolves to one Intacct project.

Run the project number check for 2026-114 and tell me how it matched in Intacct.

How it works

What PopdockAI does when you ask

You ask in plain words, with an optional project number. Your AI assistant checks each project in Intacct and reports the gaps without changing either system.

Ask

You give a project number, or leave it open to check up to 25 projects.

Your AI tool

Collect

It reads the Procore projects with work items and the accounting project number on each.

procore-get-correspondence-type-items
procore-get-generic-tools-generic-tool-items
sage-intacct-get-project

Look up

It looks each number up in Intacct by exact id, and flags name-only matches as conflicts.

No items found.

Report

You get a row per project and three groups of problems to fix.

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-correspondence-type-items

Procore: Returns correspondence type items records from the Procore connector.
get-data

procore-get-generic-tools-generic-tool-items

Returns generic tool items from Procore, including project number and accounting project number, with filters such as project number. Read-only.
get-data

sage-intacct-get-project

Returns projects from Sage Intacct.
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

Project gaps found before a bill fails to post

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