/
/
See a vendor's net exposure across Procore and Ramp
For finance leaders who ask their AI assistant for one view of a vendor's Ramp spend, bills and credits next to their Procore claims.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
A vendor's exposure is split across two systems
Ramp holds a vendor's spend, bills and credits and Procore holds what they have claimed on a project, so working out what is owed means two searches and a manual sum. Figures lose their source on the way.
Without PopdockAI
- Look the vendor up in Ramp for spend and unpaid bills
- Find any unused vendor credits
- Dig through Procore requisitions for the project
- Add it up and hope you labelled each figure
With PopdockAI
- The vendor is established in Ramp, and several matches stop the job
- Spend, unpaid bills and unused credits are read together
- Their Procore requisitions on the project are added
- Every figure is labelled with its source system
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a single exposure view for the vendor `{vendor-name}`, combining what Ramp has paid and still owes with what the vendor has claimed on Procore project `{project-name}`.
**Step 1: Establish the vendor in Ramp**
Call `ramp-get-vendor` (Ramp server) with `name.contains` set to `{vendor-name}`. If it matches more than one vendor, list the names and ids and stop. Keep `id`, `name`, `total-spend-ytd`, `total-spend-last-365-days` and `active`.
**Step 2: Read the open money in Ramp**
Call `ramp-get-bill` (Ramp server) with `vendor-name` set to the vendor's exact Ramp `name`, and list bills whose `payment-status` is not paid. Then call `ramp-get-vendor-credit` (Ramp server) with `vendor-id` set to the vendor `id` and keep `remaining-amount` for each credit.
**Step 3: Read the vendor's claims in Procore**
Call `procore-get-requisitions` (Procore server) with `project-name.contains` set to `{project-name}`. Procore cannot filter requisitions by vendor, so keep only the rows whose `vendor` matches the Ramp vendor name once case and punctuation are ignored. Keep `total-claimed-amount`, `current-payment-due`, `status` and `billing-date`.
**Step 4: Report**
Sections: Vendor in Ramp (name, spend year to date, last 365 days); Open Ramp bills (count and total); Unused vendor credits (total remaining); Procore claims on the project (count, total claimed, total currently due, and how many are not yet approved). End with one sentence on net exposure: Procore amounts claimed but not yet billed in Ramp, plus open Ramp bills, less unused credits.
**Rules & Guidelines:**
* `ramp-get-vendor`, `ramp-get-bill` and `ramp-get-vendor-credit` are on the Ramp server. `procore-get-requisitions` is on the Procore server.
* Read only. Do not call `ramp-vendor-update`, `ramp-vendor-add`, `ramp-vendor-delete` or any `procore-create-`, `procore-update-` or `procore-delete-` tool.
* Show every figure with its source system so the reader can tell which is which.
**Validation:**
* If the vendor is not in Ramp, report that, still do Step 3, and mark the Ramp sections Not found.
* If the vendor has no requisitions on the project, say so and report the Ramp side only.
* If the vendor name matches under a different spelling in Procore, show both spellings and ask the user to confirm they are one vendor.Who it's for
One answer, three teams that use it
Finance directors
Judge vendor risk quickly
See what a vendor has claimed, what is open in Ramp and what credit they hold in one answer.
Trace Contoso Steel across Ramp and the Fabrikam Depot project and give me the net exposure.
Project executives
Prepare for a vendor conversation
Walk into a call knowing a vendor's open bills, credits and unapproved claims on your project.
What does Northwind Electric have outstanding in Ramp and claimed on Northwind Plaza?
Controllers
Check claims against billing
Spot Procore claims not yet billed in Ramp for a vendor, with figures labelled by system.
Show Fabrikam Lumber's Ramp bills and credits next to their Procore claims on Contoso Warehouse.
How it works
What PopdockAI does when you ask
You name the vendor and the project, and your AI assistant reads both systems. It only reads, and it asks before treating two spellings as one vendor.
Ask
You name the vendor and the Procore project.
Check
It finds the vendor in Ramp and reads spend, unpaid bills and unused credits.
Read
It reads that vendor's requisitions on the project in Procore.
Report
You get four sections and one sentence on net exposure, each figure labelled.
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.
ramp-get-vendor
ramp-get-bill
ramp-get-vendor-credit
procore-get-requisitions
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 page for what a vendor is owed
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)
