/
/
Find Procore requisitions with no matching Ramp bill
For accounts payable teams who ask their AI assistant to check a project's requisitions against the bills recorded in Ramp.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
A requisition without a bill is found too late
Checking every Procore requisition against Ramp means searching bills by vendor and amount and comparing invoice numbers by eye. A missing bill or a mistyped amount shows up when the vendor chases payment.
Without PopdockAI
- List the project's requisitions in Procore
- Search Ramp for each vendor's bill
- Compare amounts and invoice numbers by eye
- Learn about gaps when the vendor calls
With PopdockAI
- Each requisition is matched to a Ramp bill by vendor and amount
- Both amounts are shown when they differ, with the difference
- Unsure vendor matches are marked Possible, not Matched
- Nothing is created or changed in either system
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 every requisition has a matching Ramp bill with the same amount. Only look at requisitions billed on or after `{billing-date-from}` (default: the start of the current year).
**Step 1: Read the requisitions from Procore**
Call `procore-get-requisitions` (Procore server) with `project-name.contains` set to `{project-name}` and `billing-date.from` set to `{billing-date-from}`. If the results span more than one project name, list the project names and stop so the user can narrow it. Keep `vendor`, `vendor-invoice-number`, `invoice-number`, `total-claimed-amount`, `current-payment-due`, `billing-date` and `status` for each row.
**Step 2: Find the matching bill in Ramp**
For each requisition, call `ramp-get-bill` (Ramp server) with `vendor-name.contains` set to the requisition's `vendor`, and `amount.min` and `amount.max` set to `current-payment-due` minus and plus 1.00. Ramp bills cannot be filtered by invoice number, so compare the bill's `invoice-number` with the requisition's `vendor-invoice-number` yourself after the call. If several bills come back, prefer the one whose invoice number matches, then the one whose `invoice-date` is closest to `billing-date`. If nothing comes back, widen `amount.min` and `amount.max` to 10 percent either way and try once more.
**Step 3: Report**
One table with a row per requisition: project, vendor, requisition invoice number, Procore status, Procore `current-payment-due`, matched Ramp bill id, Ramp `amount`, Ramp `approval-status`, Ramp `payment-status`, and a verdict of Matched, Amount differs, Invoice number differs, or No Ramp bill. Finish with counts per verdict and the total dollar gap between the two systems.
**Rules & Guidelines:**
* `procore-get-requisitions` is on the Procore server. `ramp-get-bill` is on the Ramp server.
* Both servers must be connected. If either tool is unavailable, say which server is missing and stop.
* Read only. Do not call any tool whose name starts with `procore-create-`, `procore-update-` or `procore-delete-`, and do not call `ramp-bill-add`, `ramp-bill-update`, `ramp-bill-archive` or `ramp-bill-draft-add`.
* Vendor names rarely match exactly between the two systems. Treat case and punctuation differences (Inc., LLC, commas) as the same vendor, and flag a match you are unsure of as Possible rather than Matched.
**Validation:**
* If Procore returns no requisitions, say so and stop.
* If Ramp returns no bill for a requisition after the wider search, report No Ramp bill and continue with the next one.
* If the two amounts differ, show both and the difference; do not guess which is right.Who it's for
One answer, three teams that use it
Accounts payable
Check bills against requisitions
Run the comparison for one project and see which requisitions have no bill in Ramp or a bill for a different amount.
Match requisitions on Fabrikam Depot since 1 March to Ramp bills and list the ones with no bill.
Project accountants
Know the gap before a payment run
See the total dollar difference between what was claimed in Procore and what Ramp holds for a project.
What is the total gap between Procore requisitions and Ramp bills on Contoso Warehouse this year?
Finance managers
Review vendor billing issues
Spot invoice numbers that differ between the two systems so they can be corrected before payment.
On Northwind Plaza, which requisitions have a different invoice number in Ramp?
How it works
What PopdockAI does when you ask
You name the project and your AI assistant compares both systems. It reads only, stops if the project name is unclear, and shows both figures when they differ.
Ask
You name the Procore project and the billing date to start from.
Read
It reads the project's requisitions with vendor, invoice number and payment due.
Match
It finds the Ramp bill for each by vendor and amount and compares invoice numbers.
Report
You get a verdict per requisition, counts per verdict and the total gap.
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-requisitions
ramp-get-bill
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
Bill gaps found before the vendor asks
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)
