/
/
Find Chargebee payments missing from Wave
For finance teams who ask their AI assistant whether every Chargebee payment has a matching Wave invoice payment.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
A missing payment shows up only when the bank does not balance
Cash collected in Chargebee has to be recorded in Wave, so you export one list and tick it against the other. A payment that was missed or recorded twice stays hidden until the bank balance does not agree.
Without PopdockAI
- Export successful payments from Chargebee
- Open the Wave payments for the same dates
- Tick each one off by amount and date
- Find the gaps when the bank does not balance
With PopdockAI
- Both payment lists are read for the period
- Matches use amount, a 3 day date window and the customer name
- Unrecorded and unmatched payments are listed separately
- Read-only, so nothing in Wave is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Check that each successful Chargebee payment from {date-from} to {date-to} (default: the last 30 days) is recorded as a Wave invoice payment, optionally for customer {customer-id} only.
**Step 1: Read Chargebee payments**
Call `chargebee-get-transaction` (chargebee server) with `type` payment, `status` success, `date.from`, `date.to`, and `customer-id` when {customer-id} is given. Keep `id`, `date`, `amount`, `customer-id`, `payment-method`, `reference-number`.
**Step 2: Read Wave payments**
Call `wave-get-invoice-payment` (wave-ai server) with `payment-date.from` and `payment-date.to` widened by 3 days each side. Keep `payment-date`, `amount`, `invoice-invoice-number`, `invoice-customer-name`, `payment-method`.
**Step 3: Match**
Match each Chargebee payment to a Wave payment with the same `amount` and a date within 3 days. Where several Wave payments fit, prefer the one whose customer name matches the Chargebee customer (call `chargebee-get-customer` with `id` to get the name, once per distinct customer).
**Step 4: Report**
List: matched payments, Chargebee payments with no Wave payment ("not recorded in Wave"), and Wave payments in the period with no Chargebee payment ("not in Chargebee"). Show amount, date, customer and both references for each, and totals per list.
**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 Chargebee returns no payments, say so and stop. If more than 200 payments come back, say the list is capped and ask for a narrower range.
* Wave payments recorded by other routes (cash, cheque) are expected in the "not in Chargebee" list; say so rather than calling them errors.
* Report currency differences without converting.Who it's for
One answer, three teams that use it
Accounts receivable
Confirm each payment reached the books
Check a month of Chargebee payments against Wave in one request instead of ticking off two exports.
Have all successful Chargebee payments in September been recorded in Wave? Show me any that are missing.
Finance managers
Know the books are complete before close
See missing and unmatched payments with totals, so the cash side is clean before month end.
Compare Chargebee payments and Wave invoice payments for the last 30 days and give me the totals of each gap.
Bookkeepers
Trace one customer's payments
Limit the check to a single Chargebee customer when a client asks where a payment went.
Did Fabrikam's Chargebee payments this quarter all land in Wave? Check customer cus_Fabrikam01.
How it works
What PopdockAI does when you ask
You name the period and your AI assistant reads Chargebee and Wave for you. It only reads, and it never records or deletes a Wave payment.
Ask
You give a date range and, if you want, one Chargebee customer.
Read
It pulls the successful Chargebee payments and the Wave invoice payments for the period.
Match
It pairs them on amount and a date within 3 days, using the customer name to choose between close fits.
Report
It lists matched, not recorded in Wave and not in Chargebee, with totals for each list.
What PopdockAI provides
The tools behind the answer
Ready made tools for Chargebee and one secure connection to your AI tool. No code, no exports.
chargebee-get-transaction
wave-get-invoice-payment
chargebee-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
Every Chargebee payment accounted for in Wave
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)
