Connectors

/

Chargebee

/

Reconcile Chargebee payments to Wave invoice payments
Report
Cross-Connector

Find Chargebee payments missing from Wave

For finance teams who ask their AI assistant whether every Chargebee payment has a matching Wave invoice payment.

Try PopdockAI free
Get a live demo
Reconcile Chargebee payments to Wave invoice payments
Check that every successful Chargebee payment from 1 October to 31 October has been recorded in Wave, and show me anything that does not match.
Two Chargebee payments from October have no Wave invoice payment. - Matched: 41 payments, USD 28,640.00 - Not recorded in Wave: Contoso, USD 1,250.00, 14 Oct - Not recorded in Wave: Northwind Traders, USD 480.00, 22 Oct - Not in Chargebee: 3 Wave payments, likely cash or cheque Want the full list of the 3 Wave payments with no Chargebee match?
Chargebee
Sample figures. Your results come from your own account.
chargebee-get-transaction
wave-get-invoice-payment
chargebee-get-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Chargebee

Chargebee
Run it on your own Chargebee data.

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

Try PopdockAI free

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.

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

Your AI tool

Read

It pulls the successful Chargebee payments and the Wave invoice payments for the period.

chargebee-get-transaction
wave-get-invoice-payment
chargebee-get-customer

Match

It pairs them on amount and a date within 3 days, using the customer name to choose between close fits.

No items found.

Report

It lists matched, not recorded in Wave and not in Chargebee, with totals for each list.

Your AI tool

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.

get-data

chargebee-get-transaction

Returns Chargebee payments and refunds with gateway, status and error details. Read-only.
get-data

wave-get-invoice-payment

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

chargebee-get-customer

Returns Chargebee customer records with contact, billing and balance details, filterable by id, email and other fields. Read-only.
Read only.Nothing in Chargebee 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

Every Chargebee payment accounted for in Wave

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