/
/
Match planned Procore people to Intacct employees
For operations teams who want Procore workforce people checked against Intacct employees by number, just by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Planned staff go unchecked against the employee list
People planned in Procore Resource Management are compared with the Intacct employee list by eye. Missing records and wrong statuses slip through until time cannot be booked.
Without PopdockAI
- Export the planned people from Procore
- Export the employee list from Intacct
- Match employee numbers in a spreadsheet
- Compare status and dates for each pair
With PopdockAI
- Planned people are matched to employees by employee number
- Gaps on both sides and status or date mismatches are listed
- People with no employee number are reported separately
- Wages are never repeated, and nothing is 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 people in Procore Resource Management with status `{status}` (default Active) hired on or after `{hired-from}` (optional, YYYY-MM-DD) have a matching employee in Intacct.
**Step 1: Read the Procore people**
Call `procore-get-workforce-planning-people` (Procore Resource Management server) with `status` set to `{status}` and, if given, `hired-date.from` set to `{hired-from}`. Keep `employee-number`, `status`, `hired-date` and `hourly-wage`. Set aside people with an empty `employee-number` and report them separately.
**Step 2: Read the Intacct employees**
Call `intacct-get-employee` (Intacct server). Keep `employee-id`, `employee-name`, `status`, `start-date`, `end-date` and `department-id`. If the Procore list is short (under 20), call it once per person with `employee-id` set to the employee number instead.
**Step 3: Match across**
Match Procore `employee-number` to Intacct `employee-id`, ignoring case and spaces. Never match on name.
**Step 4: Report**
List: people with no Intacct employee, Intacct employees with no Procore person (only those whose Intacct status is active), and matched pairs whose status or dates disagree (for example active in Procore but inactive or ended in Intacct, or the hire date differing from the start date by more than 7 days). End with counts.
**Rules & Guidelines:**
* `procore-get-workforce-planning-people` is on the Procore Resource Management server. `intacct-get-employee` is on the Intacct server.
* This prompt is read-only. Do not call any create or update tool on either server (no `intacct-create-*`, no `intacct-update-*`).
* Do not repeat hourly wage values from Procore in the report; only note when one is missing.
**Validation:**
* If either side returns nothing, report that and stop.
* If an employee number matches more than one Intacct employee, list them and do not choose one.Who it's for
One answer, three teams that use it
Resource managers
Check plans only name real employees
Find planned people without an Intacct employee before you commit them to a project.
Match active people in Resource Management to Intacct employees and list any without a match.
HR coordinators
Catch status and date mismatches
See people active in Procore who have ended in Intacct, or whose hire date and start date disagree.
Which people hired since June are active in Procore but ended or missing in Intacct?
Payroll administrators
Check new starters are set up
Confirm new hires planned in Procore already have an Intacct employee, so their time can be booked.
Check Procore people hired in the last 30 days against Intacct employees by employee number.
How it works
What PopdockAI does when you ask
You can limit by status and hire date. Your AI assistant matches on employee number and reports, and it never matches on name or changes a record.
Ask
You can set a status and a hire date to limit who is checked.
Read people
It reads the planned people from Procore and sets aside anyone with no employee number.
Match
It reads the Intacct employees and matches on employee number, never on name.
Report
It lists people with no employee, employees with no person and pairs that disagree, with counts.
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-workforce-planning-people
sage-intacct-get-employee
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 planned person has a valid employee record
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)
