/
/
Find Procore direct costs with no Ramp spend behind them
For job-cost accountants who ask their AI assistant to check a project's direct costs against Ramp bills and card transactions.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Direct costs get booked with no payment behind them
Checking Procore direct costs against Ramp means searching bills and card spend by vendor and amount, one cost at a time. A cost with no real payment behind it often waits for month-end close to surface.
Without PopdockAI
- Export the project's direct costs from Procore
- Search Ramp bills, then card transactions, for each vendor and amount
- Guess whether a trading name is the same vendor
- Find the gaps at month-end close
With PopdockAI
- Every direct cost is checked against Ramp bills, then card spend
- Card matches need the same amount and a date within 7 days
- Uncertain matches are marked Possible and several candidates are never picked between
- Nothing is changed in Procore or Ramp
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the Procore project matching `{project-name}`, confirm each direct cost has matching spend in Ramp. Only look at direct costs dated on or after `{date-from}` (default: 30 days ago).
**Step 1: Read the direct costs from Procore**
Call `procore-get-direct-costs` (Procore server) with `project-name.contains` set to `{project-name}` and `date.from` set to `{date-from}`. Keep `vendor`, `invoice-number`, `grand-total`, `date`, `paid-date`, `type` and `status`.
**Step 2: Look for the spend in Ramp**
For each direct cost, first call `ramp-get-bill` (Ramp server) with `vendor-name.contains` set to the `vendor`, and `amount.min` and `amount.max` set to `grand-total` minus and plus 0.01, and check the `invoice-number`. If there is no bill, call `ramp-get-transaction` (Ramp server) with `merchant-name.contains` set to the `vendor`, `amount.min` and `amount.max` set to the same range, and `transaction-time.from` set to `{date-from}`. Keep the Ramp `id`, `amount`, `state` or `payment-status`, and `sync-status`.
**Step 3: Report**
A table with a row per direct cost: vendor, invoice number, Procore `grand-total`, Procore `paid-date`, where it was found in Ramp (Bill, Card transaction or Nowhere), Ramp amount, Ramp status, and a verdict of Matched, Booked but no spend found, or Paid in Procore but not in Ramp. Finish with the total of the unmatched rows.
**Rules & Guidelines:**
* `procore-get-direct-costs` is on the Procore server. `ramp-get-bill` and `ramp-get-transaction` are on the Ramp server.
* Read only. Do not call `ramp-memo-add`, `ramp-bill-add` or any `procore-create-`, `procore-update-` or `procore-delete-` tool.
* Card merchants often carry a trading name that differs from the Procore vendor, so call a transaction a match only when the amount is the same and the date is within 7 days; otherwise mark it Possible.
**Validation:**
* If Procore returns no direct costs in the window, say so and stop.
* If an amount matches several Ramp items, list them as candidates and do not pick one.
* If Ramp returns nothing for a direct cost, report it as Nowhere and continue.Who it's for
One answer, three teams that use it
Job-cost accountants
Check a project's costs against real spend
Run the check for one project in a message and see which direct costs have no Ramp bill or card payment behind them.
Check the direct costs on Fabrikam Depot since 1 September against Ramp and total the ones with no match.
Controllers
Catch booked costs before close
Spot costs booked to a job that were never paid through Ramp while the month is still open and there is time to ask why.
Which direct costs on Contoso Warehouse in the last 30 days have no Ramp payment behind them?
Project accountants
Explain trading name differences
See card transactions that look like a match but carry a different merchant name, marked Possible for you to judge.
For Northwind Plaza, match direct costs to Ramp card transactions and flag any I should review by hand.
How it works
What PopdockAI does when you ask
You name a project and your AI assistant does the lookups in Procore and Ramp. It only reads, and it marks anything uncertain rather than forcing a match.
Ask
You name the Procore project and, if you want, the date to start from.
Read
It reads the project's direct costs with vendor, invoice number, amount and paid date.
Match
It looks for a Ramp bill, then a card transaction, by vendor and amount for each cost.
Report
You get a row per cost with a verdict and the total of the unmatched ones.
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-direct-costs
ramp-get-bill
ramp-get-transaction
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
Unpaid direct costs found before close, not at it
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)
