Connectors

/

Chargebee

/

Reconcile Chargebee payments to Rillet
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile Chargebee payments to Rillet
Which Chargebee payments from northwind-001 in the last 60 days are not recorded in Rillet?
5 successful Chargebee payments in the last 60 days: 4 recorded in Rillet and 1 not. - Unrecorded: USD 450 received on 22 Sep - Rillet payments with no Chargebee payment: none - Ambiguous: 2 payments of USD 300 on the same week, flagged - Unrecorded total: USD 450 Want the matched pairs listed?
Chargebee
Sample figures. Your results come from your own account.
chargebee-get-transaction
chargebee-get-customer
rillet-get-customer-emails
rillet-get-invoices
rillet-get-invoice-payments

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

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.

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

Your AI tool

02

Read

It reads the Chargebee payments and the customer's Rillet invoices and payments.

chargebee-get-transaction
chargebee-get-customer
rillet-get-customer-emails
rillet-get-invoices
rillet-get-invoice-payments

03

Match

It matches by amount, currency and date and flags ambiguous matches.

No items found.

04

Report

You get unrecorded cash, unmatched Rillet payments and matched pairs.

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

chargebee-get-customer

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

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

rillet-get-invoice-payments

Returns payments received against customer invoices from Rillet.
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

Unrecorded cash found and totalled per currency

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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