/
/
Get a full FreshBooks account summary for a client
For finance teams who want invoices, payments, credits and estimates for one client in one view, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
A client's balance takes four screens to work out
Understanding where a client stands means opening invoices, payments, credits and estimates separately and adding them up. One missed credit changes the balance you quote.
Without PopdockAI
- Open the client's invoices
- Add up payments and credits
- Check estimates not yet invoiced
- Miscount across currencies
With PopdockAI
- The client is found, or it stops on none or several
- Invoices, payments, credits and estimates are read
- Totals per currency, overdue invoices and open estimates are listed
- Payment behavior shown, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Produce an account summary for the client matching {client-name}, covering activity since {from-date} (default: the last 12 months).
**Step 1: Resolve the client**
If `{company}` is not empty, pass it as `company` on every call; otherwise omit `company`. Call `freshbooks-get-client` with `organization.contains` set to {client-name}. If nothing matches, stop. If several match, list them and stop.
**Step 2: Gather activity**
Using the client id as `customer-id` (or `client-id` where that is the filter name):
* `freshbooks-get-invoice` with `create-date.from` set to {from-date}.
* `freshbooks-get-payment` with `client-id` and `date.from`.
* `freshbooks-get-credit` with `customer-id` and `create-date.from`.
* `freshbooks-get-estimate` with `customer-id` and `create-date.from`.
**Step 3: Report**
* Billed total, paid total, outstanding total and unused credit, per currency.
* Overdue invoices with days late.
* Estimates not yet invoiced (`invoiced` is false).
* Payment behaviour: average days from invoice date to payment where it can be worked out.
**Rules & Guidelines:**
* This prompt is read-only. Never call any `freshbooks-add-*`, `freshbooks-update-*`, `freshbooks-delete-*`, `freshbooks-mark-invoice-as-sent` or `freshbooks-send-invoice-by-email` tool.
**Validation:**
* If there is no activity in the period, say so rather than reporting zeros.Who it's for
One answer, three teams that use it
Account managers
Quote the right balance
Every figure comes from FreshBooks, with unused credit and overdue invoices included.
What is Fabrikam's FreshBooks balance, including unused credits?
Collections specialists
See overdue invoices and pay habits
Get overdue invoices with days late and the client's average days to pay.
Which Northwind Traders invoices are overdue and how long do they usually take to pay?
Sales reps
Find estimates never invoiced
Estimates not yet invoiced are listed so accepted work gets billed.
Does Contoso have any FreshBooks estimates not yet invoiced since January?
How it works
What PopdockAI does when you ask
You name the client and optionally a start date, and your AI assistant builds a full account summary. It reads only.
01
Ask
You name the client and, optionally, a start date.
02
Resolve
It finds the client and stops if the name matches none or several.
03
Gather
It reads their invoices, payments, credits and estimates since the start date.
04
Report
You get totals per currency, overdue invoices, open estimates and payment behaviour.
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.
freshbooks-get-client
freshbooks-get-invoice
freshbooks-get-payment
freshbooks-get-credit
freshbooks-get-estimate
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
A client account summary in one request
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)
