/
/
Reconcile Procore and Intacct vendor lists in one request
For finance teams who want Procore vendors compared with Intacct vendors, just by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Vendor lists drift apart in two systems
Procore and Intacct vendors are entered separately and compared in spreadsheets, where spellings and suffixes rarely line up. Duplicates, missing vendors and status differences stay hidden for months.
Without PopdockAI
- Export the vendors from Procore
- Export the vendor list from Intacct
- Clean up names and suffixes to line them up
- Compare status and email by hand
With PopdockAI
- Procore vendors are matched to Intacct by normalised name
- Vendors on one side only and status differences are listed
- Email conflicts show both values without deciding which is right
- Partial matches are never confirmed, and ambiguous ones are listed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare Procore vendors matching `{vendor-name}` (or, if it is empty, the first 40 vendors) with the Intacct vendor list and report the differences.
**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: Read the Procore vendors**
Call `procore-get-vendors` (Procore) with `name.contains` set to `{vendor-name}` if given, `company` set to `{company}` if given, and `max-records` 40. Note `vendor-id`, `name`, `active`, `email-address`, `city` and `state`.
**Step 2: Find each vendor in Intacct**
For each Procore vendor call `intacct-get-vendor` (Intacct) with `vendor-name` set to the Procore `name`. If nothing comes back, retry with `vendor-name.contains` set to the first two words of the name. Take `vendor-id`, `vendor-name`, `status`, `email`, `total-due` and `last-payment-made-on`. If more than one Intacct vendor comes back, list them and do not pick one.
**Step 3: Report**
Give a table with one row per Procore vendor: Procore name, Procore active, Intacct vendor id, Intacct name, Intacct status, email match (yes, no, missing), match type (exact, partial, none, ambiguous). Then list: Procore vendors with no Intacct vendor, vendors active in Procore but inactive in Intacct, and Intacct vendors with a balance (`total-due` above 0) that are inactive in Procore.
**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 names after trimming spaces, ignoring case and dropping punctuation and suffixes such as Inc, LLC and Ltd. Do not treat a partial match as confirmed.
**Validation:**
* If Procore returns no vendors, say so and stop.
* If the two systems disagree on a vendor's email, report both values and do not decide which is right.
* If either server is not connected, name it and stop.Who it's for
One answer, three teams that use it
Accounts payable
Clean up vendor records
Find vendors that exist in Procore and not in Intacct, and duplicates waiting to cause a wrong payment.
Compare the Procore vendors matching Fabrikam with the Intacct vendor list.
Procurement teams
Check status before you award
See vendors that are active in Procore but inactive in Intacct, so a purchase order is not raised against a blocked vendor.
Which Procore vendors are active but inactive in Intacct? Check the first 40.
Finance controllers
Find balances owed to inactive vendors
See Intacct vendors with an amount due that are inactive in Procore, before they surface in an audit.
Compare Procore and Intacct vendors and list any Intacct vendor with a balance that is inactive in Procore.
How it works
What PopdockAI does when you ask
You can name a vendor or leave it open. Your AI assistant matches both lists and reports the differences, and changes nothing.
Ask
You give a vendor name to focus on, or leave it open for the first 40.
Read Procore
It reads the vendors with their status, email and location.
Find in Intacct
It looks each one up by name, normalising suffixes and listing ambiguous matches.
Report
A table shows match type and status, then the vendors missing, inactive or owed money.
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-vendors
sage-intacct-get-vendor
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
One reliable view of vendor differences
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)
