/
/
Explain the gap between Chargebee and Rillet MRR
For finance leaders who want billing and accounting revenue to agree, 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
Billing MRR and accounting MRR tell different stories
Recurring revenue from Chargebee and from Rillet drifts apart, and nobody can say which customers explain the gap. Comparing means summing subscription MRR by hand, then finding the customer in Rillet and reading its figures.
Without PopdockAI
- Sum a customer's active subscription MRR by hand
- Find the same customer in Rillet
- Read the MRR waterfall for the right month
- Guess at why the two numbers differ
With PopdockAI
- Chargebee MRR is summed with trials and non renewing shown apart
- The Rillet MRR waterfall is read for the month
- The difference comes with a likely reason
- Nothing is written and currencies are not subtracted
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}`, compare total MRR from active subscriptions with the MRR Rillet reports for month {year-month} (format YYYY-MM, default: the most recent month Rillet returns).
**Step 1: Chargebee MRR (chargebee server)**
Call `chargebee-get-customer` with `id` = {chargebee-customer-id} for `email` and `company`. Call `chargebee-get-subscription` with `customer-id` = {chargebee-customer-id}. Keep `id`, `status`, `mrr`, `currency-code`, `billing-period-unit` and `cancelled-at`. Sum `mrr` for subscriptions with status active (and in trial or non-renewing, shown separately).
**Step 2: Rillet MRR (rillet server)**
Call `rillet-get-customer-emails` and match `email` to get the Rillet `customer-id` (fall back to `rillet-get-customers` name match on `company`). Then call `rillet-get-mrr-waterfall` with `customer-id` set to it, and `year-month` = {year-month} if given. Keep `mrr`, `status`, `currency`, `year-month`.
**Step 3: Report**
Show Chargebee MRR by subscription and in total, Rillet MRR, and the difference with a likely reason (cancelled subscription, trial, missing contract in Rillet, currency difference). State the month compared.
**Rules & Guidelines:**
* `chargebee-get-customer` and `chargebee-get-subscription` are on the chargebee server. `rillet-get-customer-emails`, `rillet-get-customers` and `rillet-get-mrr-waterfall` are on the rillet server.
* Read-only. Do not call `rillet-update-product`, `rillet-record-contract-usage` or any other Rillet write tool.
**Validation:**
* If currencies differ, report both figures and do not compute a difference.
* If Rillet has no waterfall row for the customer, report Chargebee MRR as not reflected in Rillet.
* If the customer is not in Rillet, say so and stop after reporting the Chargebee side.Who it's for
One answer, three teams that use it
Finance leaders
Trust the MRR you report
See why billing and accounting MRR differ for a customer before the number goes in a board pack.
Why does Contoso's MRR in Chargebee differ from Rillet for October?
Revenue accountants
Trace an MRR difference to its cause
A likely reason such as a trial, a cancellation or a missing contract points you to the fix.
Compare Chargebee and Rillet MRR for customer fabrikam-022 for September and tell me the likely reason for any gap.
FP and A analysts
Check a customer before modelling it
Confirm a large customer's MRR agrees in both systems before you build it into the forecast.
Does Northwind Traders have the same MRR in Chargebee and Rillet for the latest month?
How it works
What PopdockAI does when you ask
You give a Chargebee customer id and your AI assistant compares their MRR with Rillet. It never writes to Rillet and never subtracts across currencies.
01
Ask
You give a Chargebee customer id and optionally a month.
02
Chargebee
It sums the MRR of the customer's active subscriptions.
03
Rillet
It finds the customer and reads the MRR waterfall for that month.
04
Report
You get both figures, the difference and a likely reason.
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-customer
chargebee-get-subscription
rillet-get-customer-emails
rillet-get-customers
rillet-get-mrr-waterfall
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
Know which customers explain the MRR gap
Related use cases
More ways to put this data to work
Check Chargebee subscriptions against Rillet contracts
Ask your AI to compare one customer's Chargebee subscriptions with their Rillet contracts. It reports missing pairs and status, date and value differences.
Learn More
Match Chargebee customers to Rillet
Ask your AI to match Chargebee customers to Rillet by email, then name. It lists the unmatched customers and any duplicates, and never writes to Rillet.
Learn More
Reconcile Chargebee invoices to Rillet invoices
Ask your AI to compare a customer's Chargebee invoices with their Rillet invoices. It lists missing and different ones and the amount due gap, read-only.
Learn More
Reconcile Chargebee credit notes to Rillet credit memos
Ask your AI to match a customer's Chargebee credit notes to Rillet credit memos. It lists the gaps and the net amount not reflected, read-only.
Learn More
Reconcile Chargebee payments to Rillet
Ask your AI to match a customer's successful Chargebee payments to Rillet invoice payments. It lists unrecorded cash and never adds a payment.
Learn More
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.