/
/
See which overdue FreshBooks clients have been called
For finance teams who want call history next to overdue FreshBooks invoices, just by asking their AI assistant.
On this page
Connector
Connect Contivio, pick your AI tool and paste the prompt.
The problem
Aging reports do not show who has been called
An aging report shows who owes money but not who has been phoned. Matching each overdue client to the call log by hand is slow, and the clients nobody called are easy to miss.
Without PopdockAI
- Run the overdue invoice report in FreshBooks
- Total the balance owed by each client
- Search the Contivio call log for each client
- Spot by eye the clients with no call
With PopdockAI
- Overdue invoices are totalled per client for you
- The largest balances are checked, up to a cap
- Contivio calls and their latest result are shown
- Clients with no call are marked no contact
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find clients with invoices past due and check whether the contact center has spoken with them in the last `{lookback-days}` days (default 30), for up to `{max-clients}` clients (default 10).
**Step 1: Overdue invoices (freshbooks server)**
Call `freshbooks-get-invoice` with `due-date.to` set to today, `outstanding.min` set to 0.01 and `max-records` set to 100. Group the rows by `customer-id`, total the `outstanding` per client and keep the largest balances up to the client limit.
**Step 2: Calls per client (contivio server)**
For each kept client, call `contivio-get-call` with `customer-id` set to that `customer-id` and `start-time.from` set to `{lookback-days}` days ago.
**Step 3: Report**
A table ordered by outstanding balance: customer-id, organization, total outstanding, oldest due-date, number of calls, last call start-time, last call result. Mark clients with no calls as "no contact".
**Rules & Guidelines:**
* Contivio tools (`contivio-get-call`, `contivio-get-call-segment`, `contivio-get-activity`) are on the contivio server; FreshBooks tools (`freshbooks-get-client`, `freshbooks-get-invoice`, `freshbooks-get-payment`, `freshbooks-get-time-entry`) are on the freshbooks server. Both servers must be connected.
* Read-only: never call any `freshbooks-add-invoice`, `freshbooks-update-invoice`, `freshbooks-delete-invoice`, `freshbooks-add-payment`, `freshbooks-send-invoice-by-email` or `freshbooks-mark-invoice-as-sent` tool, or any other freshbooks add, update or delete tool.
* Do not expose call recordings or more customer detail than the question needs.
**Validation:**
* If no invoices are overdue, say so and stop.
* A client with no Contivio match is "no contact in Contivio", not an error. If no client matches at all, mention that the customer ID formats may differ.Who it's for
One answer, three teams that use it
Accounts receivable
Start collections with the right clients
See the largest overdue balances with the last call next to each, so you do not repeat a call or miss a client.
Which of my overdue FreshBooks clients have not had a Contivio call in 30 days?
Bookkeepers
Prepare for a collections review
Get one table of overdue clients and call contact in place of an aging report plus a call log.
Show overdue FreshBooks clients and whether Contivio has calls in the last 14 days, top 15.
Small business owners
Know who has been chased
See whether anyone has spoken with the clients who owe you most, without opening two systems.
Which of the clients who owe me the most in FreshBooks have had a call from the contact center this month?
How it works
What PopdockAI does when you ask
You set the size of the check. Your AI assistant reads FreshBooks and Contivio and compares them. It only reads, so no invoice is sent or changed.
Ask
You set how many clients to check and how many days of calls to look at.
Rank
It finds overdue FreshBooks invoices, totals them per client and keeps the largest balances.
Match
It checks Contivio for recent calls with each client.
Report
You get a table by balance, with clients that have no calls marked as no contact.
What PopdockAI provides
The tools behind the answer
Ready made tools for Contivio and one secure connection to your AI tool. No code, no exports.
freshbooks-get-invoice
contivio-get-call
contivio-get-call-segment
contivio-get-activity
freshbooks-get-client
freshbooks-get-payment
freshbooks-get-time-entry
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
Follow up first with the clients nobody called
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)
