/
/
See which of an agent's callers owe money in FreshBooks
For supervisors who want to know which customers an agent spoke to recently have open FreshBooks invoices, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Callers who owe money are hard to spot
The phone system shows who an agent spoke to and FreshBooks shows who owes money, but nothing links them. Matching numbers and totalling invoices by hand is slow, so overdue balances are not raised.
Without PopdockAI
- List the agent's recent calls in Contivio
- Search FreshBooks clients by phone number
- Open each client's invoices and add them up
- Miss callers who owe money
With PopdockAI
- The agent's calls are read for the look-back period
- Numbers are matched to FreshBooks clients
- Open invoices are totalled with the oldest due date
- Ambiguous matches are listed 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:** For calls handled by agent `{agent}` in the last `{lookback-days}` days (default 14), show which called customers have outstanding FreshBooks invoices.
**Step 1: The agent's calls (contivio server)**
Call `contivio-get-call` with `agent` set to `{agent}`, `start-time.from` set to `{lookback-days}` days ago and `max-records` set to 100. Use the `from` and `to` phone numbers to identify customers. If the result gives no usable customer identifier, report that the calls cannot be linked and stop.
**Step 2: Match customers (freshbooks server)**
Call `freshbooks-get-client` with `max-records` set to 200 and match each customer phone number against `business-phone` and `mobile-phone` after stripping punctuation. Skip ambiguous matches and list them separately.
**Step 3: Their balances (freshbooks server)**
For each matched client call `freshbooks-get-invoice` with `customer-id` set to the client `id` and `outstanding.min` set to 0.01.
**Step 4: Report**
Per customer: number of calls by the agent, last call result, open invoice count, total outstanding, oldest due-date. Sort by total outstanding.
**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 the agent has no calls, say so and stop.
* Customers without a FreshBooks match are listed as "not in FreshBooks".Who it's for
One answer, three teams that use it
Contact center supervisors
Brief agents on balances owed
See which of an agent's recent callers carry overdue balances, so the agent can raise payment on the next conversation.
Show open FreshBooks balances for customers Tom Reyes spoke to in the last 14 days.
Accounts receivable
Find who is already talking to us
Check which customers with open invoices have recently been on the phone and what the last call result was.
Which customers called Dana Whitfield this month and have unpaid FreshBooks invoices, largest first?
Operations managers
Link calls to money owed
Get one view of call activity and outstanding invoices by customer without exporting from two systems.
For Priya Shah's calls over the last 30 days, list customers with outstanding invoices and the oldest due date.
How it works
What PopdockAI does when you ask
You name an agent and a period, and your AI assistant links Contivio callers to FreshBooks clients. It only reads, never exposes recordings and stops on ambiguous matches instead of guessing.
Ask
You name an agent and how many days to look back, which defaults to 14.
Read
It reads the agent's Contivio calls and identifies customers by phone number.
Match
It matches each number to a FreshBooks client and skips ambiguous matches.
Report
You get each customer's calls, last result, open invoices and total outstanding, largest first.
What PopdockAI provides
The tools behind the answer
Ready made tools for FreshBooks and one secure connection to your AI tool. No code, no exports.
contivio-get-call
freshbooks-get-client
freshbooks-get-invoice
contivio-get-call-segment
contivio-get-activity
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
Collections points ready before the next call
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)
