Connectors

/

Harvest

/

Chase overdue Harvest invoices with Nutshell context
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Chase overdue Harvest invoices with Nutshell context
Show me Harvest invoices more than 45 days overdue and tell me who owns each client in Nutshell and whether they have open deals.
Three clients have invoices more than 45 days overdue, and one has a large open deal. - Contoso: 9,600.00 overdue, oldest INV-1042 at 61 days, owner Sam Patel, last contacted 12 days ago - Northwind Traders: 4,200.00 overdue, owner Priya Shah, 1 open lead worth 30,000.00, handle with care - Fabrikam: not in Nutshell - Matching: Contoso exact, Northwind Traders partial name match Want me to list the open leads for Northwind Traders?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices
nutshell-get-account
nutshell-get-lead

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Harvest

Harvest
Run it on your own Harvest data.

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

Try PopdockAI free

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.

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

Your AI tool

Read

It lists open Harvest invoices past that date, grouped by client.

harvest-get-invoices
nutshell-get-account
nutshell-get-lead

Match

It finds each client as a Nutshell company by name and reads the owner, last contact and open leads.

No items found.

Report

You get one row per client, largest overdue first, with handle with care flags.

Your AI tool

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.

get-data

harvest-get-invoices

Returns invoices from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

nutshell-get-account

Returns Nutshell companies (accounts) with their contact details, owner and related fields. Filter by name, owner and other company fields.
get-data

nutshell-get-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
Read only.Nothing in Harvest 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

Collect payment while protecting the relationship

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