/
/
Chase overdue invoices without upsetting a live deal
For finance teams who ask their AI assistant to list overdue Harvest invoices together with each client Nutshell owner and open leads.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Collections calls land in the middle of a deal
Overdue invoices live in Harvest and the customer relationship lives in Nutshell. Chasing without checking can upset a customer who is negotiating a new deal.
Without PopdockAI
- List overdue invoices in Harvest
- Search each client as a company in Nutshell
- Find the owner and open leads one by one
- Call before knowing about the deal
With PopdockAI
- Overdue invoices are grouped by client
- Each client is matched to a Nutshell company by name
- Owner, last contact and open leads are added
- Deals worth more than the overdue amount are flagged
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find Harvest invoices overdue by at least `{days-overdue}` days (default 30) and show, for each client, who owns the relationship in Nutshell and what else is open, so the right person chases and sensitive deals are handled carefully.
**Step 1: Read overdue invoices (Harvest server)**
Call `harvest-get-invoices` with `state` set to open and `due-date.to` set to today minus `{days-overdue}` days. Keep `number`, `client-name`, `due-date`, `due-amount` and `currency`. Group by `client-name`.
**Step 2: Look up each client in Nutshell (Nutshell server)**
For each client call `nutshell-get-account` with `name.contains` set to the client name. If there is no match, mark the client "not in Nutshell". Otherwise keep `owner`, `last-contacted`, `open-leads` and `id`, and call `nutshell-get-lead` with `company-id` set to that `id` to list open leads with `name`, `value` and `anticipated-close-time`.
**Step 3: Report**
Give one row per client: total overdue, oldest invoice and days overdue, Nutshell owner, last contacted, number and value of open leads. Sort by total overdue, largest first. Flag clients with open leads over the overdue total as "handle with care".
**Rules & Guidelines:**
* Harvest tools (names starting harvest-) come from the harvest server and Nutshell tools (names starting nutshell-) come from the nutshell server. Both servers must be connected.
* Nutshell calls customers companies or accounts and Harvest calls them clients. There is no shared id, so match on name: exact (ignoring case, punctuation and suffixes such as Inc, LLC, Ltd) first, then one name containing the other, and always show which kind of match was used.
* This is read-only. Do NOT call any Harvest create, update, delete, stop or restart tool (for example `harvest-clients-create`, `harvest-contacts-create`, `harvest-invoices-create`, `harvest-estimates-create`, `harvest-time-entries-update`) and do NOT call `nutshell-add-company`, `nutshell-add-person`, `nutshell-add-lead`, `nutshell-add-activity`, `nutshell-update-person`, `nutshell-update-lead`, `nutshell-update-company`, `nutshell-delete-person`, `nutshell-delete-company` or `nutshell-delete-lead`.
* Hourly rates, cost rates and invoice amounts are sensitive: show them only because the user asked for billing context.
**Validation:**
* If there are no overdue invoices, say so and stop.
* If a client name matches more than one Nutshell company, list the candidates and leave that row unresolved.
* Compute days overdue from today's date and say which date you used.Who it's for
One answer, three teams that use it
Collections staff
Know who to talk to before you chase
Each overdue client comes with its Nutshell owner and last contact, so you contact the right person first.
Which clients have invoices more than 30 days overdue in Harvest, and who owns them in Nutshell?
Sales owners
Hear about collections before the customer calls
You can see which of your companies have overdue invoices, so you can warm up the conversation yourself.
Which of my Nutshell companies have overdue Harvest invoices over 60 days?
Finance managers
Prioritise by amount and deal risk
Rows sorted by overdue amount with handle with care flags help you decide which accounts to escalate and which to leave to sales.
Rank overdue Harvest invoices by client and flag any with open Nutshell deals worth more than the overdue total.
How it works
What PopdockAI does when you ask
You set how overdue counts and your AI assistant reads Harvest and Nutshell. It never sends messages or records payments.
Ask
You say how many days overdue to look for.
Read
It lists open Harvest invoices past that date, grouped by client.
Match
It finds each client as a Nutshell company by name and reads the owner, last contact and open leads.
Report
You get one row per client, largest overdue first, with handle with care flags.
What PopdockAI provides
The tools behind the answer
Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.
harvest-get-invoices
nutshell-get-account
nutshell-get-lead
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
Collect payment while protecting the relationship
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)
