Connectors

/

Wave

/

Reconcile Wave and Chargebee customers
Report
Cross-Connector

Find customers missing between Chargebee and Wave

For finance teams who want their AI assistant to compare the Chargebee and Wave customer lists and show the gaps.

Try PopdockAI free
Get a live demo
Reconcile Wave and Chargebee customers
Reconcile our Chargebee customers against Wave and show me anyone who is in only one of them.
Most customers line up, but 9 need a look. - Matched on email: 87 - Name-only matches to verify: 3, for example Contoso Ltd - In Chargebee only: 4 - In Wave only: 2 Want me to narrow this to customers with a particular email domain?
Wave
Sample figures. Your results come from your own account.
chargebee-get-customer
wave-get-customer

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

Two customer lists that nobody compares

Billing and bookkeeping each hold their own customer list, so a customer can exist in one and not the other. You find out when an invoice or payment cannot be matched.

Without PopdockAI

  • Export customers from Chargebee
  • Export customers from Wave
  • Compare emails and names by eye
  • Miss the ones that are spelled differently

With PopdockAI

  • Both customer lists are read for you
  • Email is matched first, then company and full name
  • Name-only matches are flagged as uncertain
  • Gaps and conflicts are listed, Wave is not changed

The prompt

Use this prompt

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

Prompt
**Objective:** Reconcile Chargebee customers against Wave customers, narrowed to {search-text} (default: all customers, capped at 200 per side).

**Step 1: Read Chargebee customers**

Call `chargebee-get-customer` (chargebee server). If {search-text} is given, filter with `company.contains` or `email.contains` as fits the text; otherwise set `max-records` to 200. Keep `id`, `email`, `first-name`, `last-name`, `company`.

**Step 2: Read Wave customers**

Call `wave-get-customer` (wave-ai server) the same way: `email.contains` or `name.contains` when {search-text} is given, otherwise `max-records` 200. Keep `name`, `email`, `display-id`, `outstanding-amount`.

**Step 3: Match**

Match each Chargebee customer to a Wave customer on email, ignoring case. If there is no email match, try company name, then first plus last name, and mark these as "name-only match, verify". A Chargebee customer with no match is "in Chargebee only"; a Wave customer matched by nobody is "in Wave only".

**Step 4: Report**

Give four lists: matched, name-only matches, in Chargebee only, in Wave only. For matched pairs, note any difference in name or email. End with the counts.

**Rules & Guidelines:**

* Each tool named above is on the server named beside it (wave-ai or chargebee). Both servers must be connected.
* This prompt is read-only. Never call any Wave tool that adds, updates, deletes, sends, approves or marks anything (for example `wave-add-invoice-payment`, `wave-add-customer`, `wave-update-invoice`, `wave-delete-invoice`, `wave-send-invoice`). The chargebee server has only read tools.
* Pass the Wave business as `company` on every Wave call when {wave-company} is given.
* Do not repeat card numbers, bank details or full contact data beyond what the question needs.

**Validation:**

* If either side returns no customers, say which side is empty and stop.
* If a side returns 200 records, say the list may be truncated and suggest narrowing with {search-text}.
* A shared email on two Wave customers is a conflict: list it, do not choose one.

Who it's for

One answer, three teams that use it

Billing administrators

Keep billing and books in step

See who is in Chargebee but not yet in Wave before the first invoice or payment fails to match.

Which Chargebee customers are not in Wave yet? Compare both lists.

Bookkeepers

Check a segment of customers

Narrow the comparison to one company or email domain when you are tidying a specific group.

Compare Chargebee and Wave customers whose email contains fabrikam.com and show any differences.

Finance managers

Get counts before an audit

See how many customers match, need verifying or sit in only one system.

Give me counts of matched, name-only and one-sided customers between Chargebee and Wave.

How it works

What PopdockAI does when you ask

You ask for the comparison and your AI assistant reads both lists. It only reads, and a shared email is listed as a conflict rather than guessed.

Ask

You say which customers to check, or leave it open for all.

Your AI tool

Read

It reads the Chargebee and Wave customer lists.

chargebee-get-customer
wave-get-customer

Match

It matches on email, then company or full name, marking name-only matches as uncertain.

No items found.

Report

It lists matched, name-only, Chargebee only and Wave only, with counts.

Your AI tool

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

chargebee-get-customer

Returns Chargebee customer records with contact, billing and balance details, filterable by id, email and other fields. Read-only.
get-data

wave-get-customer

Returns customers from Wave. Wave connector tool; filter by the parameters it offers.
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

Customer lists that agree across billing and books

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