/
/
Pair Rillet overdue balances with Stripe payment health
For collections teams who want each overdue Rillet customer's Stripe card, charge and subscription status, with a suggested next action.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
The problem
Chasing overdue invoices without knowing why they are unpaid
A failed card, an expired payment method or a past due subscription needs a different response than silence. But that detail sits in Stripe while the overdue balance sits in Rillet, so every customer gets the same reminder.
Without PopdockAI
- Run an overdue report in Rillet
- Find each customer in Stripe
- Check failed charges, cards and subscriptions
- Guess at the right next step
With PopdockAI
- Overdue Rillet invoices totalled per customer
- Each matched in Stripe by email, then name
- Failed charges, expiring cards and past due subscriptions read
- A suggested next action per customer, nothing charged
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For customers with overdue invoices in Rillet (only those whose name contains {customer-name}, if given, and owing at least {min-amount-due}, default 0), show what Stripe knows about their ability to pay, and suggest a next action for each.
**Step 1: Find the overdue balances in Rillet**
Call `rillet-get-invoices` (no filters). Keep invoices where overdue is true, or where due-date is before today and amount-due is above zero. Call `rillet-get-customers` to name each customer-id, apply {customer-name} in memory, and total amount-due per customer. Drop customers owing less than {min-amount-due}.
**Step 2: Find each customer in Stripe**
Call `rillet-get-customer-emails` for the customer's emails, then `stripe-get-customer` with `email` = each email until one matches. If none match, try `stripe-get-customer` with `name` = the Rillet name. If still nothing, mark the customer Not in Stripe and move on.
**Step 3: Read their Stripe payment health**
For each matched Stripe customer-id:
* `stripe-get-customer`: delinquent and balance.
* `stripe-get-charge` with `customer-id` and `status` = failed, created in the last 90 days: the most recent failure-message and the count.
* `stripe-get-payment-method` with `customer-id`: whether any card has expired or expires within 30 days.
* `stripe-get-subscription` with `customer-id`: any subscription with status past_due or unpaid.
**Step 4: Report**
One row per customer, largest amount owed first: customer, Rillet overdue total, currency, oldest overdue due date, Stripe delinquent, failed charges in 90 days with the last failure reason, card status, past-due subscriptions, and a suggested next action (ask for a new card, retry the payment, or contact the customer). List Not in Stripe customers at the end.
**Rules & Guidelines:**
* `rillet-get-invoices`, `rillet-get-customers` and `rillet-get-customer-emails` are on the rillet server. The tools starting stripe- are on the stripe server.
* This prompt is read-only. Do not call `rillet-add-invoice-payment`, `rillet-setup-customer-auto-payment`, `rillet-update-customer` or `rillet-set-invoice-sent-status`.
**Validation:**
* If no invoices are overdue, say so and stop.
* Stripe amounts may be in the smallest currency unit; report Stripe balances divided by 100 when they are clearly in cents, and say so.
* If a tool cannot be found, name the server it belongs to (rillet or stripe) and stop.Who it's for
One answer, three teams that use it
Collections
Know why each customer has not paid
A failed card needs a new card request, not a stern reminder, and you can see which is which.
Which overdue Rillet customers have failed Stripe charges in the last 90 days?
AR managers
Start with the largest balances
One row per customer, largest balance first, with a suggested next action.
Review Rillet customers overdue by more than 5,000 against Stripe and suggest next steps.
Customer success
Fix payment problems before they escalate
Expiring cards and past due subscriptions show up early, so you can help the customer update them.
Is Contoso overdue because of a card problem in Stripe?
How it works
What PopdockAI does when you ask
You can filter by customer or amount and your AI assistant pairs each overdue Rillet balance with its Stripe payment health. It only reads, so nothing is charged or changed.
01
Ask
You optionally filter by customer name and minimum amount.
02
Read
It totals overdue Rillet invoices per customer.
03
Check
It finds each in Stripe and reads charges, cards and subscriptions.
04
Report
One row per customer, largest balance first, with a next action.
What PopdockAI provides
The tools behind the answer
Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.
rillet-get-invoices
rillet-get-customers
rillet-get-customer-emails
stripe-get-customer
stripe-get-charge
stripe-get-payment-method
stripe-get-subscription
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
The right fix for each overdue customer
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)
