Connectors

/

Procore

/

Match Procore requisitions to Ramp bills
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Match Procore requisitions to Ramp bills
For the Riverside Tower project, check every requisition billed since 1 January against Ramp bills and show where the amounts differ.
22 requisitions on Riverside Tower were checked, and 17 match a Ramp bill. - Amount differs: Fabrikam Concrete, 48,200.00 in Procore, 46,700.00 in Ramp - Invoice number differs: Contoso Steel, REQ-014 against 14-B - No Ramp bill: Northwind Electric, 31,500.00 due - Total gap between the systems: 33,000.00 Want the full table of all 22 requisitions?
Procore
Sample figures. Your results come from your own account.
procore-get-requisitions
ramp-get-bill

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Procore

Procore
Run it on your own Procore data.

Connect Procore, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It reads the project's requisitions with vendor, invoice number and payment due.

procore-get-requisitions
ramp-get-bill

Match

It finds the Ramp bill for each by vendor and amount and compares invoice numbers.

No items found.

Report

You get a verdict per requisition, counts per verdict and the total gap.

Your AI tool

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.

get-data

procore-get-requisitions

Returns Procore subcontractor requisitions (invoices), with vendor, vendor invoice number, status, total claimed, payment due and billing date. Filter by project name and billing date range.
get-data

ramp-get-bill

Returns Ramp bills as read from the Ramp connector. Filters include: vendor name, approval status, id, vendor name contains, due date to.
Read only.Nothing in Procore Changes

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.

How Popdock AI secures your data

The outcome

Bill gaps found before the vendor asks

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation