Connectors

/

FreshBooks

/

Find FreshBooks balances owed by an agent's Contivio callers
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find FreshBooks balances owed by an agent's Contivio callers
Which customers did Priya Shah speak to in the last 14 days who still owe us money in FreshBooks?
Priya Shah spoke to 19 customers, and 5 have open FreshBooks invoices. - Northwind Traders: 3 calls, last result answered, 2 invoices, 6,820.00 outstanding, oldest due 12 Sep - Contoso: 1 call, last result voicemail, 1 invoice, 2,150.00 outstanding - Fabrikam: 2 calls, 1 invoice, 940.00 outstanding - Not in FreshBooks: 4 callers. Ambiguous matches: 1 Want the details for the other 2 customers?
FreshBooks
Sample figures. Your results come from your own account.
contivio-get-call
freshbooks-get-client
freshbooks-get-invoice
contivio-get-call-segment
contivio-get-activity
freshbooks-get-payment
freshbooks-get-time-entry

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

FreshBooks

FreshBooks
Run it on your own FreshBooks data.

Connect FreshBooks, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

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

Your AI tool

Read

It reads the agent's Contivio calls and identifies customers by phone number.

contivio-get-call
freshbooks-get-client
freshbooks-get-invoice
contivio-get-call-segment
contivio-get-activity
freshbooks-get-payment
freshbooks-get-time-entry

Match

It matches each number to a FreshBooks client and skips ambiguous matches.

No items found.

Report

You get each customer's calls, last result, open invoices and total outstanding, largest first.

Your AI tool

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.

get-data

contivio-get-call

Returns Contivio call records with durations, results, direction, queue, agent and AI call summaries, filterable by date, agent, queue and customer.
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.
get-data

contivio-get-call-segment

Returns the segments of Contivio calls (queue, agent and handling steps), filterable by call, for tracing a call end to end.
get-data

contivio-get-activity

Returns agent activity records from the Contivio connector, by type, channel and contact center, for a date window or agent.
get-data

freshbooks-get-payment

Returns payments recorded against FreshBooks invoices, with amount, date and method. Filter by invoice, client or date range.
get-data

freshbooks-get-time-entry

Returns logged time entries from FreshBooks with project, hours and billed state. Filter by project, client or date range.
Read only.Nothing in FreshBooks 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

Collections points ready before the next call

Try PopdockAI free
Get a live demo

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.

Try PopdockAI Free
See Documentation