/
/
Compare planned assignments with the hours people book
For project managers who want a person's Procore assignments checked against their Intacct hours, just by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Planned time and booked time are never seen together
Assignments live in Procore Resource Management and timesheets live in Intacct. Matching them project by project is manual, so over-booking and under-booking show up only after payroll.
Without PopdockAI
- Look up the person's assignments in Procore
- Pull their timesheet entries from Intacct
- Match projects by name in a spreadsheet
- Convert durations to hours and compare
With PopdockAI
- Assignments and timesheet hours are read in one request
- Projects are matched on exact name, never guessed
- Hours with no assignment and assignments with no hours are flagged
- It says which timesheet states are included and changes nothing
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For employee number `{employee-number}`, compare the project assignments planned in Procore Resource Management with the timesheet hours booked in Intacct between `{from-date}` and `{to-date}` (YYYY-MM-DD).
**Step 1: Read the planned assignments**
Call `procore-get-workforce-planning-reports-assignment-history` (Procore Resource Management server) with `employee-number` set to `{employee-number}`. Keep rows whose `start-day` and `end-day` overlap the date range. Keep `project-id`, `project-name`, `start-day`, `end-day` and `duration`. If no rows, say the person has no assignments in the range and stop.
**Step 2: Read the booked hours**
Call `intacct-get-timesheet-entry` (Intacct server) with `employee-id` set to `{employee-number}`, `entry-date.from` set to `{from-date}` and `entry-date.to` set to `{to-date}`. Keep `project-id`, `project-name`, `entry-date`, `hours`, `billable-hours` and `state`. If no rows come back, report the Procore side only and note that no Intacct hours exist for that employee id.
**Step 3: Match across**
Group both sides by project. Match the Procore project to the Intacct project by comparing the Procore `project-name` to the Intacct `project-name` (exact match ignoring case). If the Procore project id is not the Intacct project id, say so and do not guess.
**Step 4: Report**
A table by project: planned duration, Intacct hours booked, billable hours, difference. Flag projects with hours booked but no assignment, and assignments with no hours booked. Say which timesheet states are included (draft hours are not final).
**Rules & Guidelines:**
* `procore-get-workforce-planning-reports-assignment-history` is on the Procore Resource Management server. `intacct-get-timesheet-entry` is on the Intacct server.
* Convert the Procore `duration` to hours before comparing, and state the unit you assumed.
* This prompt is read-only. Do not call any create or update tool on either server (no `intacct-create-*`, no `intacct-update-*`).
**Validation:**
* If `{employee-number}` is not an employee id in Intacct, say so; do not retry with a name.
* If from-date is after to-date, stop and ask for a valid range.Who it's for
One answer, three teams that use it
Resource managers
Check plans against reality
See whether the people you planned onto a project actually booked time to it, and where they booked elsewhere.
Compare planned assignments with Intacct hours for employee 10482 in October.
Project managers
Find unplanned time on your job
Spot hours booked to your project by someone who has no assignment, before it surprises you at close.
Did employee 20931 book hours to Riverside Tower in Intacct without an assignment in Procore between 1 and 15 November?
Payroll administrators
Review hours before payroll
Check billable and total hours against the plan for one person, and see which timesheets are still draft.
For employee 10977, compare Procore assignments with Intacct billable hours for the last full month.
How it works
What PopdockAI does when you ask
You give the employee number and the dates. Your AI assistant reads both systems and compares by project, and it writes nothing.
Ask
You give the employee number and the date range.
Read plans
It reads the person's assignments in Procore that overlap those dates.
Read hours
It reads their Intacct timesheet entries for the same period.
Report
A table by project shows planned and booked time, flagging hours with no assignment and the reverse.
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-reports-assignment-history
sage-intacct-get-timesheet-entry
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
See over and under-booking before payroll runs
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)
