/
/
Find Chargebee payments that are not recorded in Rillet
For finance teams who want cash recorded in accounting, just by asking their AI assistant about a customer.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Cash received but never recorded in Rillet
Cash received in Chargebee is not always recorded as an invoice payment in Rillet, and finding the gap by hand is slow. Rillet cannot filter its payments, so each one has to be traced through the customer's invoices.
Without PopdockAI
- List the customer's Chargebee payments
- Open each Rillet invoice for the customer
- Read the payments recorded against it
- Match amounts and dates by hand
With PopdockAI
- Successful Chargebee payments are read
- Rillet invoices and their payments are read for the customer
- Payments match on amount, currency and three days, used once
- Unrecorded cash is totalled and no payment is added
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Chargebee customer `{chargebee-customer-id}`, check that each successful payment on or after {date-from} (default: the last 60 days) is recorded as an invoice payment in Rillet.
**Step 1: Read Chargebee payments (chargebee server)**
Call `chargebee-get-transaction` with `customer-id` = {chargebee-customer-id}, `type` set to payment, `status` set to success, and `date.from` = {date-from}. Keep `id`, `date`, `amount`, `currency-code`, `payment-method`, `gateway` and `subscription-id`. Also call `chargebee-get-customer` with `id` = {chargebee-customer-id} for the `email`.
**Step 2: Find the Rillet customer and its invoices (rillet server)**
Call `rillet-get-customer-emails` and match `email` to the Chargebee email to get the Rillet `customer-id`. Call `rillet-get-invoices` and keep that customer's invoices (`invoice-id`, `invoice-number`, `total`, `amount-due`).
**Step 3: Read Rillet payments (rillet server)**
Call `rillet-get-invoice-payments` (no filters) and keep rows whose `invoice-id` belongs to one of that customer's invoices. Keep `payment-id`, `date`, `amount`, `currency`, `status`.
**Step 4: Match**
Match each Chargebee payment to a Rillet payment with the same amount and currency and a date within 3 days. Each Rillet payment can match only one Chargebee payment.
**Step 5: Report**
List Chargebee payments with no Rillet payment (these are unrecorded cash), Rillet payments with no Chargebee payment, and matched pairs. End with the total unrecorded amount per currency.
**Rules & Guidelines:**
* `chargebee-get-transaction` and `chargebee-get-customer` are on the chargebee server. `rillet-get-customer-emails`, `rillet-get-invoices` and `rillet-get-invoice-payments` are on the rillet server.
* Read-only. Do not call `rillet-add-invoice-payment` or `rillet-update-invoice-payment`; recommend the entry in the report instead.
**Validation:**
* If the customer is not found in Rillet, report that and stop.
* If Chargebee has no payments in the window, say so and stop.
* If the same amount appears more than once on one side, flag the match as ambiguous.Who it's for
One answer, three teams that use it
Revenue accountants
Record the cash Rillet is missing
Chargebee payments with no Rillet payment are listed as unrecorded cash, ready to record.
Which Chargebee payments from contoso-014 since October are not in Rillet?
AR accountants
Investigate payments with no source
Rillet payments with no Chargebee payment are listed for follow up.
Are there Rillet payments for Fabrikam with no matching Chargebee payment?
Finance controllers
Size unrecorded cash
The unrecorded total per currency tells you how far the ledger is behind billing.
Total the unrecorded Chargebee cash for northwind-001 in Rillet over the last 90 days.
How it works
What PopdockAI does when you ask
You give a Chargebee customer id and your AI assistant traces their payments into Rillet. Same amount matches are flagged as ambiguous.
01
Ask
You give a Chargebee customer id and optionally a start date.
02
Read
It reads the Chargebee payments and the customer's Rillet invoices and payments.
03
Match
It matches by amount, currency and date and flags ambiguous matches.
04
Report
You get unrecorded cash, unmatched Rillet payments and matched pairs.
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
chargebee-get-customer
rillet-get-customer-emails
rillet-get-invoices
rillet-get-invoice-payments
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
Unrecorded cash found and totalled per currency
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)
