/
/
Build a ranked Chargebee collections worklist in one ask
For finance and collections teams who want the right accounts chased first, just by asking their AI assistant.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Collectors chase the wrong accounts first
Collectors comb through invoice lists by hand and start with whoever is at the top. Deciding who to call means finding unpaid invoices, working out how late they are, then checking each customer's terms and recent failures.
Without PopdockAI
- Filter unpaid invoices that are past due
- Work out days overdue by hand
- Look up terms and auto collection per customer
- Check recent payment failures one by one
With PopdockAI
- Due, unpaid invoices become a worklist
- The biggest debtors get terms, contacts and failure reasons
- Rows are ranked by amount due
- The three accounts to chase first are named, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a collections worklist of unpaid invoices due on or before {as-of-date} (default today), optionally limited to customer {customer-id}.
**Step 1: Pull the unpaid invoices**
Call chargebee-get-invoice with due-date.to set to {as-of-date} and mount-due.min set to 0.01. If {customer-id} is given, also pass customer-id. Keep only invoices whose mount-due is above zero and whose status is not paid or voided.
**Step 2: Add customer context**
For the 10 customers with the largest total due, call chargebee-get-customer by id to read company, email, uto-collection and
et-term-days. Then call chargebee-get-transaction with customer-id and status for failed payments to find recent error-text.
**Step 3: Report**
A table of customer, invoice id, due-date, days overdue, mount-due, dunning-status, and last payment failure reason. Rank by amount due. End with the three accounts to chase first and why.
**Rules & Guidelines:**
* This prompt is read-only. Only call the chargebee-get-* read tools. There are no write tools on this server; never claim to have changed anything in Chargebee.
* Quote amounts with their currency code and never add amounts in different currencies together.
* If a read returns nothing, say so plainly and stop rather than guessing.
**Validation:**
* If no invoices are overdue, report that.
* If max-records truncates results, say the list may be incomplete.Who it's for
One answer, three teams that use it
Collections specialists
Know who to call first
The worklist is ranked by amount and names three accounts to start with, so the first calls of the day count.
Who should I chase first for overdue Chargebee invoices today?
AR managers
See dunning status across the book
Days overdue, dunning status and last failure reason sit in one table for the whole team.
Build a Chargebee collections worklist as of October 31 with dunning status and last failure reason.
Account managers
Check one customer before a call
Limit the worklist to one customer to see their overdue invoices and recent failures.
Show me overdue Chargebee invoices for Contoso and any recent payment failures.
How it works
What PopdockAI does when you ask
You give an as of date and your AI assistant builds a ranked collections worklist from Chargebee. It names the three accounts to chase first and only reads.
01
Ask
You give an as of date and optionally one customer.
02
Pull
It reads the unpaid Chargebee invoices that are due.
03
Add context
It adds terms, contact details and recent payment failures for the biggest debtors.
04
Report
You get a ranked table and the three accounts to chase first.
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-invoice
chargebee-get-customer
chargebee-get-transaction
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
Start the day with the accounts most worth chasing
Related use cases
More ways to put this data to work
Chargebee customer account review
Ask your AI to review one Chargebee customer. It pulls subscriptions, invoices, payment failures, cards and credits into a single health verdict.
Learn More
.webp){kind=logo}
Compare Chargebee and Dynamics 365 Business Central customer balance
Ask your AI to compare a customer's open balance in Chargebee and Dynamics 365 Business Central. It shows both totals and the invoices that explain any gap.
Learn More
Note Chargebee billing status on a Dynamics GP customer
Ask your AI to summarise a customer's Chargebee billing status and append it to their Dynamics GP note, saved only after you approve the exact text.
Learn More
Reconcile Chargebee invoices to Dynamics 365 Business Central
Ask your AI to match Chargebee invoices to posted sales invoices in Dynamics 365 Business Central. It lists the missing and different ones, read-only.
Learn More
Reconcile Chargebee invoices to Intacct invoices
Ask your AI to compare a customer's Chargebee invoices with their Intacct invoices. It lists missing and mismatched invoices with the difference per currency.
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.