/
/
One collections list across Chargebee and FreshBooks
For finance teams who chase overdue customers and want Chargebee and FreshBooks balances together, just by asking their AI assistant.
On this page
Connector
Connect Chargebee, pick your AI tool and paste the prompt.
The problem
Overdue balances split across two systems
Chasing overdue customers means checking Chargebee dunning in one place and FreshBooks balances in another. Because the two are never side by side, nobody knows a customer's total exposure and the same person can be chased twice or not at all.
Without PopdockAI
- Pull overdue invoices from Chargebee
- Look up each customer's open invoices in FreshBooks
- Add up exposure by hand, mixing currencies
- Chase the same customer twice, or not at all
With PopdockAI
- Overdue Chargebee invoices are grouped by customer
- Each customer's open FreshBooks invoices are added
- Combined exposure per currency is sorted largest first
- Missing clients are flagged and nothing is 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 one collections list of customers who owe money in Chargebee, enriched with their open FreshBooks invoices (company `{company}`), for invoices more than `{days-overdue}` days past due (default 0).
**Step 1: Read Chargebee**
Call `chargebee-get-invoice` with `due-date.to` set to today minus `{days-overdue}` days and `amount-due.min` just above zero. Keep `customer-id`, `id`, `amount-due`, `due-date`, `dunning-status`, `currency-code`. Group by customer.
**Step 2: Resolve each customer**
Call `chargebee-get-customer` with `id` to get `email` and company. Then call `freshbooks-get-client` with that `email`.
**Step 3: Read FreshBooks**
For each matched client, call `freshbooks-get-invoice` with `customer-id` set to the client `id` and `outstanding.min` just above zero. Keep `invoice-number`, `outstanding`, `due-date`, `display-status`.
**Step 4: Report**
One row per customer: email, Chargebee amount due and oldest due date, dunning status, FreshBooks outstanding total and oldest due date, and combined exposure per currency. Sort by combined exposure, largest first. Customers not found in FreshBooks show "no FreshBooks record".
**Rules & Guidelines:**
* FreshBooks tools (named freshbooks-...) are on the freshbooks server; Chargebee tools (named chargebee-...) are on the chargebee server. Both servers must be connected.
* Pass `{company}` as the company parameter on every FreshBooks call when it is given; if FreshBooks reports more than one company and none was given, ask which one and stop.
* Match customers on email, case-insensitive and trimmed. Never match on name alone.
* Amounts may be in different currencies; compare only when `currency-code` matches and flag the rest.
* This prompt is read-only. Never call any FreshBooks add, update, delete, mark or send tool, for example `freshbooks-add-payment`, `freshbooks-add-client`, `freshbooks-add-invoice` or `freshbooks-send-invoice-by-email`.
**Validation:**
* If nobody is overdue in Chargebee, say so and stop.
* Never add the two systems' amounts together unless the currency matches.Who it's for
One answer, three teams that use it
Collections specialists
Work from one list
Each customer appears once with both balances, so nobody is chased twice.
Who is overdue by more than 30 days in Chargebee, and what do they also owe in FreshBooks?
AR managers
See total exposure per customer
Combined exposure per currency, sorted largest first, shows where the risk really sits.
Rank customers by combined overdue exposure across Chargebee and FreshBooks.
Finance controllers
Spot customers missing from the books
Overdue Chargebee customers with no FreshBooks client are flagged for follow up.
Which overdue Chargebee customers have no client in our Contoso FreshBooks company?
How it works
What PopdockAI does when you ask
You give a days overdue threshold and your AI assistant builds one collections list from Chargebee and FreshBooks. Amounts are never added across currencies.
01
Ask
You give a days overdue threshold and optionally the FreshBooks company.
02
Read
It reads overdue Chargebee invoices and groups them by customer.
03
Match
It finds each customer in FreshBooks and reads their open invoices.
04
Report
You get one row per customer sorted by combined exposure.
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
freshbooks-get-client
freshbooks-get-invoice
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
One collections list with each customer's full exposure
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)
