/
/
Know which overdue FreshBooks invoices to chase first
For finance teams who want late invoices ranked by amount and days overdue, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Big overdue invoices get buried among small ones
Chasing late payers means scanning invoices and working out days late by hand. Large or very late invoices get buried, and a customer with several overdue invoices is easy to underestimate.
Without PopdockAI
- Scan the invoice list for past due items
- Work out days late for each
- Add up per customer by hand
- Guess who to call first
With PopdockAI
- Past due invoices with money owing are pulled
- Customers are ranked by amount, then oldest invoice
- The top three to chase are named with reasons
- Totals per currency, read-only, nothing sent
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find the invoices that are past due as of {as-of-date} (default: today) with money still outstanding, and rank them for collection.
**Step 1: Pull the overdue set**
If `{company}` is not empty, pass it as `company` on every call; otherwise omit `company`. Call `freshbooks-get-invoice` with `due-date.to` set to {as-of-date} (today if empty) and `outstanding.min` set to 0.01. Ignore invoices whose `display-status` shows draft or paid.
**Step 2: Rank**
* Compute days late from `due-date` to {as-of-date}.
* Group by `organization` (fall back to `customer-id`) and total `outstanding` per customer.
* Rank customers by total outstanding, then by oldest invoice.
**Step 3: Report**
A table of customer, invoices late, total outstanding, oldest days late, currency. Then bullets for the top three to chase and why. Do not mix currencies in one total; show one total per `currency-code`.
**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.
* Only report what `freshbooks-get-invoice` returns; do not guess contact details.
**Validation:**
* If nothing is overdue, say so and stop.
* If the result hits the record limit, say the list may be truncated and suggest narrowing the date.Who it's for
One answer, three teams that use it
Collections specialists
Start the day with a call list
Get customers ranked by amount owed and age, with the top three to chase.
Who owes us the most on overdue FreshBooks invoices right now?
Business owners
See total overdue at a glance
Know how much is overdue per currency and who owes it.
How much is overdue in FreshBooks as of the end of last month?
AR managers
Spot customers with several late invoices
Grouping by customer shows when one account has several overdue invoices.
Which customers have more than one overdue FreshBooks invoice?
How it works
What PopdockAI does when you ask
You give an as-of date and your AI assistant ranks overdue customers. It sends nothing and changes no invoice.
01
Ask
You give an as-of date, or leave it as today.
02
Pull
It finds FreshBooks invoices past due with money outstanding, skipping drafts and paid ones.
03
Rank
It totals what each customer owes and orders them by amount, then oldest invoice.
04
Report
It shows a table and the top three to chase, with totals per currency.
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-invoice
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
Know which late payers to call first
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)
