Connectors

/

Wave

/

Find Wave customers who are Ramp vendors
Report
Cross-Connector

See which Wave customers are also your Ramp vendors

For leaders who want to see what a company owes against what you spend with them, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Wave customers who are Ramp vendors
Are any of the Wave customers who owe us money also vendors we pay in Ramp?
2 of 31 customers checked are also Ramp vendors. - Contoso Ltd: owes 5,400.00 USD (1,200.00 overdue), Ramp spend last 365 days 8,900.00 USD, spend exceeds what they owe - Fabrikam Studio: owes 2,150.00 USD, Ramp spend 640.00 USD, possible match - Checked: 31 customers, none skipped Want the other 29 customers with no Ramp match listed?
Wave
Sample figures. Your results come from your own account.
wave-get-customer
ramp-get-vendor

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Wave

Wave
Run it on your own Wave data.

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

Try PopdockAI free

The problem

Customers who are also vendors go unseen

A business can owe you money and be paid by you at the same time, but with two systems nobody sees both sides. Finding the overlap means searching Ramp for every Wave customer with a balance.

Without PopdockAI

  • List Wave customers with a balance
  • Search Ramp for each name in turn
  • Pull the spend figures for any match
  • Guess whether near names are the same company

With PopdockAI

  • Customers with a balance are checked in Ramp by name
  • Owed and spend amounts sit side by side
  • Near matches are marked possible, and skipped names are counted
  • Nothing is netted and currencies are never compared

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find Wave customers (company `{company}`, optional) with an outstanding balance of at least `{min-outstanding}` (default 1) that also appear as vendors in Ramp, so you can see what they owe against what you spend with them.

**Step 1: Read Wave customers with a balance**

Call `wave-get-customer` (Wave server) with `outstanding-amount.min` set to `{min-outstanding}` (use 1 when empty), `is-archived` false and `max-records` 200. Pass `company` only if `{company}` is not empty. Keep name, email, outstanding-amount, overdue-amount and currency-code.

**Step 2: Check each name in Ramp**

For each customer, call `ramp-get-vendor` (Ramp server) with `name` set to the customer name; if nothing comes back, use `name.contains` with the customer name. If there are more than 40 customers, check the 40 with the largest outstanding-amount and say how many were not checked. Keep id, name, active, total-spend-ytd and total-spend-last-365-days.

**Step 3: Report**

Table of overlaps: customer name, Wave outstanding, Wave overdue, Ramp vendor name, Ramp spend in the last 365 days, and a note when Ramp spend exceeds what they owe. Mark name-contains matches as "possible match". Finish with counts: customers checked, overlaps found.

**Rules & Guidelines:**

* `wave-get-customer` is on the Wave server; `ramp-get-vendor` is on the Ramp server.
* This is a view only. Do not suggest netting or settling amounts.
* Do not call any write tool on either server: no `wave-add-*`, `wave-update-*`, `wave-delete-*`, `wave-send-*`, `wave-mark-*`, `wave-approve-*`, `wave-archive-*` or `wave-clone-*` tools, and no `ramp-*-add`, `ramp-*-update`, `ramp-*-delete`, `ramp-*-archive`, `ramp-*-suspend` or `ramp-*-terminate` tools.

**Validation:**

* If no customers have a balance, say so and stop.
* Do not compare amounts across currencies; show each currency as returned.

Who it's for

One answer, three teams that use it

CFOs

See exposure and spend together

Know where a company that owes you money is also paid by you, before the next conversation with them.

Which of our Wave customers with an outstanding balance are also Ramp vendors, and what do we spend with them?

Controllers

Review the biggest overlaps

Focus on larger balances and see where your spend with a company is bigger than what they owe you.

Check Wave customers owing at least 500 against Ramp vendors and flag where our spend is bigger than their balance.

Procurement leads

Know which suppliers owe you

Before a supplier conversation, see whether the vendor is also a customer with an unpaid balance.

Which of our vendors in Ramp also owe us money in Wave for Northwind Traders?

How it works

What PopdockAI does when you ask

You ask, and your AI assistant reads Wave and checks each customer with a balance in Ramp. It only reads, says what it skipped and does not suggest netting amounts.

Ask

You optionally give a Wave company and a minimum balance.

Your AI tool

Match

It reads Wave customers with a balance and looks each name up in Ramp, checking up to 40 of the largest.

wave-get-customer
ramp-get-vendor

Report

You get overlaps with owed, overdue and spend side by side, plus counts of what was checked.

No items found.

What PopdockAI provides

The tools behind the answer

Ready made tools for Wave and one secure connection to your AI tool. No code, no exports.

get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
get-data

ramp-get-vendor

Returns Ramp vendors as read from the Ramp connector. Filters include: name contains, created at to, legal name contains, vendor owner id, maximum records.
Read only.Nothing in Wave 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

Both sides of the relationship in one view

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