/
/
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.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
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.
**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.
Collect
It reads the Procore projects with work items and the accounting project number on each.
Look up
It looks each number up in Intacct by exact id, and flags name-only matches as conflicts.
Report
You get a row per project and three groups of problems to fix.
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-correspondence-type-items
procore-get-generic-tools-generic-tool-items
sage-intacct-get-project
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
Project gaps found before a bill fails to post
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)
