Connectors

/

Chargebee

/

Combine overdue Chargebee and FreshBooks balances
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Combine overdue Chargebee and FreshBooks balances
Build a collections list of customers overdue in Chargebee by more than 14 days, with their open FreshBooks invoices.
7 customers are overdue in Chargebee and 3 also owe money in FreshBooks. - Northwind Traders: Chargebee 900.00 (dunning), FreshBooks 480.00, combined 1,380.00 USD - Contoso: Chargebee 450.00, FreshBooks 0.00, combined 450.00 USD - No FreshBooks record: 2 customers Want all 7 rows?
Chargebee
Sample figures. Your results come from your own account.
chargebee-get-invoice
chargebee-get-customer
freshbooks-get-client
freshbooks-get-invoice

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

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.

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

Your AI tool

02

Read

It reads overdue Chargebee invoices and groups them by customer.

chargebee-get-invoice
chargebee-get-customer

03

Match

It finds each customer in FreshBooks and reads their open invoices.

freshbooks-get-client
freshbooks-get-invoice

04

Report

You get one row per customer sorted by combined exposure.

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-invoice

Returns Chargebee invoices with status, amounts, amount due and due date, filterable by customer and status. 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

freshbooks-get-client

Returns clients from FreshBooks with contact details, currency and outstanding balance. Filter by name or email.
get-data

freshbooks-get-invoice

Returns invoices from FreshBooks, including client, amounts, status and due date. Filter by client, status or date range.
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

One collections list with each customer's full exposure

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