/
/
Chase overdue invoices with the account context ready
For finance and credit control teams who ask their AI assistant for overdue Harvest invoices with the HubSpot owner, contacts and deals alongside.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Collections stalls while you look up each account
Finance lists overdue invoices in Harvest, then opens the CRM for each client to find the owner, contact and open deals. The lookups repeat per client and delay the chase.
Without PopdockAI
- List overdue invoices in Harvest
- Search HubSpot for each client
- Find the owner, contacts and open deals
- Repeat one client at a time
With PopdockAI
- Overdue invoices grouped by client
- HubSpot owner, contacts and deals added
- Several matches listed, never picked for you
- Read-only, so no invoice or CRM record changes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List Harvest invoices still unpaid and past due as of `{as-of-date}` (default today), optionally only with a balance of at least `{min-due-amount}`, and add HubSpot context for each client so the right person can chase them.
**Step 1: Find overdue invoices (Harvest server)**
Call `harvest-get-invoices` with `state` set to open, `due-date.to` set to the day before `{as-of-date}`, and, if `{min-due-amount}` is not empty, `due-amount.min` set to it. Keep `number`, `client-name`, `due-date`, `amount` and `due-amount`. Group invoices by `client-name`.
**Step 2: Find each client in HubSpot (HubSpot server)**
For each client, call `hubspot-get-companies` with `company-name` set to the Harvest `client-name`. If nothing matches, retry with `company-name.contains`. If more than one matches, list the candidates for that client and do not pick one.
**Step 3: Add context**
For each matched company, using its `record-id`: call `hubspot-get-contacts` with `company-id`, call `hubspot-get-deals` with `company-id`, and call `hubspot-get-notes` with `company-id` limiting to the 3 most recent.
**Step 4: Report**
Per client, most overdue first: client name, total overdue, invoice list (number, due date, days overdue, balance), HubSpot owner (`company-owner`), up to 3 contacts with email, open deals with stage and amount, and the latest note summaries. For clients with no HubSpot company write "No HubSpot match".
**Rules & Guidelines:**
* `harvest-get-invoices` is on the Harvest server; the HubSpot tools (`hubspot-get-companies`, `hubspot-get-contacts`, `hubspot-get-deals`, `hubspot-get-notes`) are on the HubSpot server.
* Read-only. Do not call `harvest-invoices-update`, `hubspot-add-task`, `hubspot-add-company-note` or any other create or update tool.
**Validation:**
* If no invoices are overdue, say so and stop.
* Treat invoice amounts as sensitive; show them only in this report.Who it's for
One answer, three teams that use it
Credit controllers
Start each chase call prepared
See overdue amounts, the account owner and open deals before you pick up the phone.
List Harvest invoices overdue by more than 15 days with the HubSpot owner and contacts for each client.
Account owners
Know which of your clients are overdue
Find out when a client you manage has unpaid invoices and whether a deal is in play.
Which of my HubSpot accounts have overdue Harvest invoices, and is a deal open with them?
Finance managers
Prioritise by balance
Focus the chase on larger balances by setting a minimum amount due.
Show overdue Harvest invoices with at least 5,000 USD due and add HubSpot context for Contoso and Fabrikam.
How it works
What PopdockAI does when you ask
You set the date and your AI assistant combines Harvest and HubSpot. It only reads, and it says plainly when a client has no HubSpot match.
Ask
You set the as-of date and an optional minimum amount.
Find
It lists overdue Harvest invoices grouped by client.
Enrich
It matches each client to a HubSpot company and gathers owner, contacts, deals and notes.
Report
Clients appear most overdue first with the people to contact.
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
hubspot-get-companies
hubspot-get-contacts
hubspot-get-deals
hubspot-get-notes
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
Every overdue client with a name to 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)
