/
/
Find Procore projects with no matching Intacct project
For finance teams who want active Procore projects checked against Intacct projects, just by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
A mistyped project number leaves costs with nowhere to post
Procore and Intacct each hold their own project list, and the numbers are keyed separately. A missing or mistyped number is found only once costs fail to post.
Without PopdockAI
- Export the active projects from Procore
- Export the project list from Intacct
- Match numbers in a spreadsheet and chase near misses
- Compare start dates for the ones that match
With PopdockAI
- Active Procore projects are looked up in Intacct by number
- Name-only matches are marked, and conflicts are never counted
- Missing numbers, missing projects and start date gaps are listed
- Ids are compared as text and nothing is guessed or changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Check that Procore projects matching `{project-name}` (or, if it is empty, up to 25 active projects) each have an Intacct project, and report what is missing or differs.
**Servers:** this prompt uses tools from two servers, so both procore-core (Procore) and intacct (Intacct) must be connected. Tools whose names start with procore are on procore-core; tools whose names start with intacct are on intacct.
**Step 1: List the Procore projects**
Call `procore-get-projects` (Procore) with `project-name.contains` set to `{project-name}` if given, `company` set to `{company}` if given, and `max-records` 25. Keep only rows where `active` is true. Note `number`, `project-id`, `project-name`, `stage`, `actual-start-date` and `estimated-value`.
**Step 2: Look each project up in Intacct**
For each project with a non-empty `number`, call `intacct-get-project` (Intacct) with that value as `project-id`. If nothing comes back, call it again with the Procore `project-name` as `project-name`, and mark the match "by name only". Take `project-id`, `project-name`, `status`, `begin-date` and `contract-amount` from the Intacct row.
**Step 3: Report**
Give a table with one row per Procore project: Procore number, Procore name, Procore start date, Intacct project id, Intacct name, Intacct status, Intacct begin date, match type (id, name only, none). Then list three groups: projects with no number in Procore, projects with a number but no Intacct project, and matched projects whose start dates differ by more than 30 days.
**Rules & Guidelines:**
* This prompt is read-only. Never call any Procore tool that creates, updates or deletes, or `intacct-create-vendor`, `intacct-create-project`, `intacct-update-vendor`, `intacct-update-project` or any other Intacct tool that creates or updates.
* Compare ids as text after trimming spaces and ignoring case. Do not guess a match.
**Validation:**
* If Procore returns no active projects, say so and stop.
* If a name-only match has a different Intacct project id from the Procore number, report it as a conflict and do not count it as matched.
* If either server is not connected, name it and stop.Who it's for
One answer, three teams that use it
Project accountants
Catch setup gaps early
See which active projects have no Intacct project or no project number before costs start to arrive.
Match the active Procore projects with Riverside in the name to Intacct projects.
Finance controllers
Check the project list ahead of close
Confirm every active Procore project exists in Intacct and the start dates agree.
Which active Procore projects have no Intacct project, and which start dates differ by more than 30 days?
Project administrators
Fix numbers at the source
Find projects with no number in Procore, or a number that Intacct does not recognise.
List Procore projects for Fabrikam Construction that have no project number or a number missing from Intacct.
How it works
What PopdockAI does when you ask
You can narrow by name or company. Your AI assistant reads both systems and reports, and it never guesses a match or changes a record.
Ask
You can name a project or company, or leave it open for up to 25 active projects.
Read Procore
It lists the active projects with their number, stage, start date and value.
Look up
It finds each project in Intacct by number, then by name, marking name-only matches.
Report
A table shows match type per project, then missing numbers, missing projects and start date gaps.
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-projects
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
Every active project has its counterpart, or a reason why not
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)
