/
/
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.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
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.
**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.
Read
It reads the Chargebee and Wave customer lists.
Match
It matches on email, then company or full name, marking name-only matches as uncertain.
Report
It lists matched, name-only, Chargebee only and Wave only, with counts.
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.
chargebee-get-customer
wave-get-customer
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
Customer lists that agree across billing and books
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)
