/
/
Compare signed-off hours with costed timesheets
For finance and project teams who want Procore time and material hours compared with Business Central timesheets, by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Hour differences reach the customer before you see them
Time and material hours are signed off in Procore and costed from timesheets in Business Central. Compared by hand, differences go unnoticed until a customer questions the invoice.
Without PopdockAI
- Export time and material timecards from Procore
- Export the Business Central timesheet lines for the job
- Total hours per person on each side
- Match names by hand, including Last, First order
With PopdockAI
- Hours totalled per person from both systems
- Deleted Procore timecards left out
- Names matched only when exact, the rest listed as unmatched
- Differences, posted status and net totals reported
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare the hours on Procore time and material timecards for project {project-id} against Business Central timesheet lines for job {job-number} from {date-from} to {date-to}, and report each person whose hours differ by more than 0.25.
**Step 1: Read Procore hours (procore-project-management server)**
Call `procore-get-time-and-material-timecards` with `project-id` {project-id}, `date-created.from` {date-from}, `date-created.to` {date-to} and `max-records` of 200. Skip rows where date-deleted is set. Add up hours-worked per login-information-name.
**Step 2: Read Business Central hours (business-central server)**
Call `business-central-get-timesheet` with `job-number` {job-number}, `date.from` {date-from}, `date.to` {date-to} and `max-records` of 200. Add up quantity per resource-name, and note chargeable and posted.
**Step 3: Match across**
Match a Procore login-information-name to a Business Central resource-name when they are the same after lower-casing and swapping "Last, First" to "First Last". Do not match on first name or initials alone. Anyone on one side only is listed as unmatched on that side.
**Step 4: Report**
Give a table with columns Person, Procore hours, Business Central hours, Difference, Posted in Business Central, Status (Matched, Hours differ, Only in Procore, Only in Business Central). Finish with total hours on each side and the net difference.
**Rules & Guidelines:**
* `procore-get-time-and-material-timecards` is on the procore-project-management server; `business-central-get-timesheet` is on the business-central server.
* This is read-only. Do not call any `procore-create-*`, `procore-update-*`, `procore-delete-*` or `procore-send-*` tool on the procore-project-management server, and do not call any `business-central-create-*` or `business-central-update-*` tool on the business-central server.
* Procore filters on the date the timecard was created, so say that the periods may not align exactly with the dates worked.
**Validation:**
* If Procore returns nothing, say so and stop.
* If Business Central returns nothing, report all Procore hours as Only in Procore and check that {job-number} is a Business Central job number, not a Procore project id.
* If hours-worked is empty on a row, list it under Missing hours.Who it's for
One answer, three teams that use it
Billing accountants
Check hours before invoicing
See where signed-off hours and costed timesheets disagree, so the invoice goes out with the right figure.
Compare Procore T&M hours with Business Central timesheets for job J00240 for October.
Project controllers
Find time costed to the wrong place
List people who appear on one side only, so missing timecards or timesheets are chased.
Who is in Procore time and material timecards for Northwind Plaza but not in the Business Central timesheets for job J00315?
Payroll teams
Reconcile posted time
See posted status next to hours, so time that is signed off but not posted is not missed.
For Contoso Warehouse, which people have Business Central hours that differ from Procore by more than a quarter hour?
How it works
What PopdockAI does when you ask
You give the project, job and dates and your AI assistant totals the hours on both sides. It only reads, and it says that Procore filters on the date created.
Ask
You give the Procore project, the Business Central job number and the dates.
Total
It adds up hours per person from the Procore timecards, skipping deleted ones, and from the Business Central timesheet lines.
Match
It matches people only on an exact name after tidying case and name order, and lists the rest as unmatched.
Report
You get each person's hours on both sides, the difference and posted status, with totals and the net difference.
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-time-and-material-timecards
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
Billable hours that agree before invoicing
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)
